Oracle Development

Pari Khodayari

Danville,CA

Cell: 925-***-****

**********@*********.***

Summary:

Over 17 years experience in IT as Oracle/Informix/PeopleSoft DBA, Database

Architect, Designer, with 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- 12C1), 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, full software development life cycle

(SDLC) implementation methodologies, and project/resources management.

Strong knowledge of application/database 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 Performance Tuning, Database and platform tuning as well as

UNIX system administration and shell scripting.

Experience in install, configure, upgrade and patch 8i-11g Oracle

instances, RAC and Enterprise Manager.

Experience in implementing various replication solutions using Snapshots,

Oracle Data Guard, Oracle Streams and Shareplex.

Assist with ESAS, SOX,ISO 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.

Skills:

Languages: KSH, CSH, SQL, SQR, PL/SQL

Hardware/OS: Linux, SUN, HP, AIX IBM, NT servers.

Storage Device: EMC, Hitachi,SAN Technology

Database: ORACLE: V6.x- 11G, INFORMIX 5.x-7.x,SqlServer 2000

Software: PeopleSoft V5.x-V9.x,(HR,Fin,CRM), ORACLE Designer2000, BEA

Tuxedo Appservers, VERITAS, BMC Patrol, Apache, Toolkit, Legato, Net

backup, Vantive, Informatica, Erwin, Web Logic, Maxima, Tobin

Professional Experience:

May2013-Present Wellsfargo Corp, SF,CA (Oracle Consultant, Inernet Services

Group, BillPay, OPS databases)

Setup CDC DataCapture for auditing Money Movement DataBase.

Setup AQ/MQ for messageing Queue Transfer Scheduling DataBase.

Implementing Workflow Desgin for C2T extract,Bill Pay Purge.

Implementing DataBase DataModel changes in development databases for new

OPS Release and tunning sql/plsql for production.

Checking in new release changes into SVN and using ANT creating Build for

new releases to move to QA,Stage,Production Databases.

Jan 2013-May2013 Ross Store. IT Consultant Oracle DBA

Upgrade ASM from 10g(10.2.0.5) to 11.2.0.3

Upgrade ASM from 11.1.0.1 to 11.2.0.3

Upgrade Oracle Database Vaults from 10g to 11g(11.2.0.0)

Upgrade Oracle TDE Encryption from 10g to 11.2.0.3

Upgrade Oracle Database Wallet from 10g to 11.2.0.3

Upgrade Peoplesoft HR,FIN from 10g to 11.2.0.3

2011-2013 Kaiser Permanente IT-DataBase Services (Oracle Consultant, KP

Claim Data Warehouse)

.Successfully performance tuned large scale environments, applying

improvement techniques across all processing layers (UI, Business Logic,

Data)

.Responsible for performance assessment of the database and design, plan

performance load testing.

.Effectively influences and collaborates cross-functionally with product

managers, architects, and product development as well as other engineering

teams and operations teams.

.Drive world-class design and development of database systems for

applications that support high volumes, are fast, simple, reliable,

distributed, and easy to extend & maintain.

.Work with engineers and architects to improve existing data models, ensure

high levels of data integrity, reduce costs, and increase the overall

performance.

. Responsible for schema design, analysis, development, troubleshooting of

database related issues.

. Provide and designs tools to assist in the management of the database and

transaction processing environment.

. Work to provide a working model of our transaction processing environment

for capacity assessment and planning.

. Develop a methodology for the ongoing assessment of database performance

and the identification of problem areas.

.Develop a security scheme for the database environment, as well as

assisting in disaster recovery if necessary.

.Provide leadership during the development and enhancement of the

authority's production applications including working with applications,

technical support and operations during the design, development and

implementation of applications.

.Develop data migration/conversion strategy using migration scripts/or

Golden Gateway to move data between swim lane.

2011-2011 Kaiser Permanente Division of research (Oracle Consultant, KP

National Research Database)

.Sql tuning working with development for ETL processes and tuning.

. Analyze performance problems in complex Java applications and suggest

remediation strategies.

.Responsible for performance assessment of the database and design, plan

performance load testing.

.Effectively influences and collaborates cross-functionally with product

managers, architects, and product development as well as other engineering

teams and operations teams.

.Monitor and report all performance matrics, analysis performance metrics

result and write final go/no go report and work with cross functional team

and attend all meetings.

. Responsible for schema design, analysis, development, troubleshooting of

database related issues.

. Assist in the development of and implements standards for database

maintenance and configuration.

.Successfully performance tuned large scale environments, applying

improvement techniques across all processing layers (UI, Business Logic,

Data)

2010-2011 U.C Berkeley, Lawrence Berkeley National Laboratory (Oracle

Consultant, LBNL Research DataBases)

.Responsible for all planning, implementation of oracle 10G databases

upgrade to 11g, Oracle 9i databases upgrade to 11g as well as RMAN

catalog databases from 10g to 11g.

.Responsible for all planning, implementing data move, cloning, backing up

11g environment.

.Responsible for all planning, implementing PeopleSoft CRM Tools Upgrade

from 8.45 to 8.49 as well as setting up Rman backup for CRM Oracle

Databases running on 11g.

.Supporting Development team with 11gR2 new releases to modify code and

.Providing technical leadership/expertise for database design,

architecture, testing and production support.

2008-2010 Kaiser Permanente, Pleasanton (Oracle Consultant, KP Pharmacy

Database)

.Responsible for all planning, implementing SCM database Upgrade from

Oracle 8i to Oracle 10g.

.Setup partitioning for large tables within SCM database and also

Responsible for all planning, implementing production data archiving and

purging from partition tables.

.Ensure the development, implementation and maintenance of high-

availability solutions for the systems, setting up backup.

.Provided technical leadership to facilitate planning, design,

installation, modification and operational capabilities of the SCM

database.

.Responsible for performance tuning on different production databases.

2006-2008 Wellsfargo Corp, SF,CA (Oracle Consultant, Internet Services

Group, Wellsfargo.com Database)

.Responsible/lead implementing corporate website database upgrade 8i to

Oracle 10g.

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

.Setting up Shareplex replication between 8i productions databases 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 leadership to production dba's and developers.

2006-2007 Oracle Corporation, On Demand Group, Redwood Shore (Principal

Oracle DBA- Responsible for outsourced customer databases to Oracle) .

.Troubleshoot and optimize performance on databases in high availability

production environments.

.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

.Responsible for 24x7 support of large 9i & 10g databases for mission

critical online customer applications.

.Critical assistance, either as a result of P1 service requests or at

customer request

.Implemented various replication solutions using Oracle Data Guard, Oracle

Streams and Shareplex.

.Troubleshoot and optimize performance on databases in high availability

production environments..

2005-2006 U.C Berkeley-Central Computing, Berkeley (Oracle Consultant- HR-

FIN PeopleSoft Database)

. 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.

2003-2007 Calpine Corp. San Jose, CA, (SR. PeopleSoft-Oracle DBA-Team Lead)

.Responsible for all implementation, planning of Oracle database Upgrade

from Oracle 7.34 to 8i.

.Responsible for all implementation, planning of PeopleSoft FIN, HR Upgrade

to People Tool 7.63

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

.Responsible for implementing PeopleSoft tax update on Corporate HR

Database and Sales, Nuws tax database using Sabrix Software.

.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.

2000-2003 Providian Financial/Washington Mutual Corp. Oakland, CA (Lead

Oracle DBA)

.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).

.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.

.Assist Data warehouse group with developing routines for data extractions,

transformation, loading into operational data stores (ODS), data warehouse

(DW), and data mart (DM).

1994-1999 PeopleSoft/Oracle Corp. Pleasanton, CA, ( PeopleSoft-Oracle

DBA/Engineer)

.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.

Education:

BS, Computer Information Systems

References available up on request.

http://www.linkedin.com/in/parikhodayari

Contact this candidate