Pari Khodayari

Summary

Over 14 years experience in IT as Oracle/Informix/PeopleSoft DBA, Architect, Designer, and experience in both Production/Development environments. Experience with system HW design/configuration, automation, scripting, replication, tuning, and backup/recovery of multiple versions of Oracles (Oracle 7.x- 10G), Informix (6.x-7.x) and PeopleSoft (5.x-9.x). Experience with the handle of 24x7 support, security, system monitoring, performance tuning, and analysis of multiple version of Oracle with different applications (PeopleSoft, Epiphany, Remedy, Toolkit, Web Logic, Documentum). Experience supporting a QA test environment (functional, regression, volume testing stress). Experience in 3tire configuration (application server, web servers, database servers), full software development life cycle (SDLC) implementation and methodologies, and project/resources management. Strong knowledge of application architectures and data modeling techniques. Experience with Planning/Testing Disaster Recovery for Production Oracle/Informix Databases. Experience in upgrading PeopleSoft Applications and Oracle Databases. Experience in the implementation and administration of large-scale information systems, including designing PeopleSoft batch processing solutions, experience in UNIX system administration and shell scripting. Install, configure, upgrade and patch 9i and 10g Oracle instances, RAC and Enterprise Manager. Implemented various replication solutions using Oracle Data Guard, Oracle Streams and Shareplex.Experience creating formal requirements and design specifications. Demonstrated project lead or management experience. Experience in building and releasing medium to large scale, complex product or system development projects.Support application and technical architecture, ensuring business needs are met. Apply patches and upgrades; manage network connections; provide production support, disaster recovery, system performance. Coordinate OS and database support activities with ITC/DBCT. Assist with ESAS, SOX Work with the support group to determine how the application is supported in production, including backups, disaster recovery, system performance, and project management.Lead / assist with projects from inception to delivery while partnering with project sponsors, IT partners, and cross-functional project team members.

Work History

Work History

PeopleSoft/Oracle DBA

PeopleSoft/Oracle Corp

•Installing new versions of PeopleSoft tools and applications and reporting any problem to development before Software release to public.

•Install Peoplesoft HR/Fin on different Platforms Oracle/Informix/DB2 and setup appserver/webserver’s. •Create, load and performance tune Oracle databases for system and platform testing with setting up different PeopleSoft applications.•Create and maintain databases for development and testing of PeopleSoft's business application software.

•Refreshing the databases from regularly scheduled drop-offs.

•Configuring, troubleshooting, starting and stopping Application Server, Web Servers and PeopleSoft Process Scheduler utilities.

•Installing new versions of PeopleSoft tools and Applications to test the install process and upgrade process and reporting to development team any problem.•Refreshing the Informix databases from regularly scheduled drop-offs for PeopleSoft new release testing.•Configuring, troubleshooting, starting and stopping Application Server, Web Servers and Process Scheduler utilities, 3tire configuration.•Responsible for customer assistance regarding the operation and problems associated with the PeopleTools software. (PeopleSoft 5.x-6.x)

Sr.Oracle/PeopleSoft DBA

Providian Financial/Washington Mutual Corp

•Responsible for all implementation planning and Production Upgrade from Oracle 7.3 to Oracle 8I.•Responsible for capacity planning, space management, problem resolution, database monitoring and performance tuning of Production Underwriting Databases.

•Designed and lead a comprehensive evaluation of Oracle 9I Database.

•Evaluate and recommend performance monitoring tools (Toad, Precise, Quest, OEM4.0, EZSQL, Patrol)•Support application development teams in tuning SQL, work closely with data modelers to design logical and physical databases, and install/configure Oracle products.•Setup and maintenance of Oracle bi-directional master-to-master replication (not snapshot), and replication conflict resolution.•Implement security standards, naming standards and maintain data dictionary or other metadata repositories, as well as perform change management for production underwriting databases.

•Setup Purge Criteria, cleaning data for production databases after move to data warehouse databases.•Responsible for Planning/Testing Disaster Recovery for all Production Oracle Databases.•Assist Data warehouse group with developing routines for data extractions, transformation, loading into operational data stores (ODS), data warehouse (DW), and data mart (DM).

•Prepare short and long term plans to address infrastructure projects as well as support to and technical leadership for internally/externally sponsored company projects.

•Responsible for planning and implementation for datacenter move for production databases.

•Design and Creation of Database, Capacity Planning, Design and Management of Database Recovery Strategies.

SR.Oracle/PeopleSoft DBA

Calpine Corp

•Responsible for all implementation, planning andPSOFT FIN,HR Production database Upgrade from Oracle 7.34 to Oracle 8I.

•Responsible for all implementation, planning and Corp Production database Upgrade from Oracle 7.34 to Oracle 9I.

•Responsible for all implementation, planning and Psoft FIN,HR Production Upgrade to People Tool 7.63

•Primary DBA for PeopleSoft HR and Finance, CRM databases.

•Ensure the development, implementation and maintenance of high-availability solutions for the systems, setting up clusters.

•Responsible for development, testing and implementation of a disaster recovery plan.

•Responsible for Implementing taxupdates on Sales and Nuws tax database using Sabrix Software.

•Responsible for implementing PeopleSoft taxupdate on Corporate HR Database.

•Responsible for automating cloning and refreshing development, test databases with production data.

•Provided technical leadership to facilitate planning, design, installation, modification and operational capabilities of the corporate database.

SR.Oracle DBA Consultant

SBC/AT&T Corp

• Ensure 24x7 database uptime for Remedy Web/OVPI/NetForensics Oracle DataBases. • Provide Oracle DBA support and technical support for multiple applications in development, test, QA and production environments • Install, configure and maintain database instances, creates various database objects, creates users with appropriate roles and levels of security • Work with the data services team to design and maintain database schema and related infrastructure for real-time data access for customers, end-users and distribution partners.• Play a lead role in NOC data services management, multi-node cluster management, and distributed data center management • Design corporate data warehouse and develop additional reporting systems as requested.• Design, Implement, and Participates in the disaster recovery process and database backups

• Responsible for capacity planning, space management, problem resolution, database monitoring and performance tuning of Production DataBases.

• Responsible for Upgrading OVPI databases from Oracle 8i to Oracle 9i.

Sr.Oracle DBA Consultant

U.C Berkeley

• Responsible for migration of PeopleSoft applications from DB2 on MVS to Oracle on AIX. • Provided database expertise for improving the speed of the migration/data type migration.• Assisted with scripting and monitoring interfaces between DB2 and Oracle. • Monitored the performance and proactively identify issues that may occur in Oracle using monitoring software or database administration scripts. 

• Regularly developed and review performance reports with the PeopleSoft Application Developers. 

• Reviewed selected application code, recommend changes, and adjust tuning parameters in the Oracle to enhance its performance. 

Principal DBA

Oracle Corp

•Implemented various replication solutions using Oracle Data Guard, Oracle Streams and Shareplex.

•Troubleshoot and optimize performance on databases in high availability production environments.

• Provide technical expertise and recommendations for physical database design, architecture, testing,performance tuning, backup and recovery for online transaction and Operational data store database environments.

•As a member of the Infrastructure Management and Automation team, responsible for managing Business critical Production Databases associated with installation, configuration, patching, upgrade, automation development with Perl, shell, SQL and debugging of software applications or operating systems.

•Leading contributor individually and as a team member, providing direction and mentoring to other DBA.

•Provide Sr. level Database administration support on 9i Database with RAC

•Installation / Upgrade/Patching of Oracle Database, iAS and EM 10g

•Critical assistance, either as a result of P1 service requests or at customer request

•Researching product features · Knowledge transfer to end-users and technical staff

Platform Engineer Consultant

Wellsfargo Corp

•Responsible/ lead implementing corporate website database upgrade to Oracle 10g.

•Setting up Stream replication between two production oracle 10g Database.

•Setting up Shareplex replication between 8i production database to 10g Database.

•Implemented various replication solutions using Oracle Data Guard, Oracle Streams and Shareplex.

•Troubleshoot and optimize performance on databases in high availability production environments.

• Provide technical expertise and recommendations for physical database design, architecture, testing,performance tuning, backup and recovery for online transaction and Operational data store database environments.

•Troubleshoot and optimize performance on databases in high availability production environments.

• Provide technical expertise and recommendations for physical database design, architecture, testing,performance tuning, backup and recovery for online transaction and Operational data store database environments.

•Provide technical leadership to production dba’s and developers

•Prepare and review functional and technical specifications for development projects.

Sr.Oracle DBA Consultant

Kaiser Permanente Insurance Co. Ventures

•Responsible for all implementation, planningSCM database Upgrade from Oracle 8ito Oracle 10g.

•Responsible for all implementation, planning production data archiving and purging.

•Setup partitioning for large tables within SCM databases.

•Ensure the development, implementation and maintenance of high-availability solutions for the systems, setting up backup.

•Responsible for automating cloning and refreshing development, test databases with production data.

•Provided technical leadership to facilitate planning, design, installation, modification and operational capabilities of the SCM database.

•Assist in setting up RMAN scripts for backup.

.Assist in performance tunning for different databases.

Sr.Oracle DBA Consultant

Intuit

•Responsible for design of estore migration database.

•Responsible for migration of estore database from sqlserver to Oracle 10g.

•Responsible for setting up backup and recovery for new estore migrated database.

•Responsible for ETL design and scripting for data migration from OLTP to dataware house.

•Provide technical leadership to production dba’s and developers

• Provide technical expertise and recommendations for physical database design, architecture, testing,performance tuning, backup and recovery for online transaction and Operational data store database environments.

Education

Education

B.S.

Call State EastBay

Skills

Skills

Computer Information Technology

Languages: JAVA, KSH, CSH, SQL, SQR, PL/SQL, HTML, Perl, PeopleCode Hardware/OS: Linux, SUN, HP, AIX ,IBM, NT servers. Storage Device: EMC, Hitachi,SAN Technology,Netapp vmware. Database: ORACLE: V6.x- 11G, INFORMIX 5.x-7.x, SQL Server 6.5 Applications: Peoplesoft  V5.x-V9.x,ORACLE Developer2000, ORACLE Designer2000, BEA Tuxedo, SQL Secure, SQA Automated, TaxWare, Vertex, Veritias, Epiphany ,BMC Patrol, Apache, Toolkit, Legato, Net backup, Vantive, Informatica, Crystal, Nvision, Remedy,  Erwin, Quest Database Tools, Sabrix, WebLogic, Maximo,Sabrix