SUMMARY

• Over 30 years’ experience as a Database Architect/Administrator with Financials, Engineering, Manufacturing and Human Resources and Payroll systems implementation and development.
• Project experience includes setup, installation, deployment, implementation and development of both HRMS/Payroll, Financials and Engineering applications as well as project management.
• Fit/Gap Analysis and baseline creations. Data modeling and database administration of Oracle databases is an area of expertise.
• Oracle Applications Developer and DBA for versions 3.0 to 10.7. I have upgraded every major version of PeopleSoft HRMS from version 1.0 to version 9.X. and every release of PeopleTools from version 1.1 to 8.5X.
• I have upgraded Oracle RDBMS versions from version 2 to 12C. Installed, deployed and upgraded SCT Banner ERP collegiate administrative system version 6X and 7.X. Use of Oracle techniques such as Standby Databases, Real Application Clusters, Data Guard and RMAN, and Oracle Partitions.
• Installed SAP XI, BI, MDM and Netweaver applications. Set up User security. I have expert knowledge of Apache, Tomcat and MySQL web applications.

TECHNICAL SKILLS

Data Modeling Methodologies and Frameworks: ERD’s, ER Modeling, Dimensional Modeling, Model Driven Architecture, Zachman Framework and Agile Modeling

Languages: JAVA, C, C++, Pearl, PHP

Operating Systems: AIX, HP/UX, Solaris, VAX/VMS, WIN NT, Linux (Redhat, SUSE, Enterprize Linux 5).

Ancillary Skills: Remedy, APACHE CASSANDRA, TOMCAT, JIRO, SPLUNK, PeopleTools, ORACLE, PeopleCode, PEOPLESOFT, SYBASE, MYSQL, Oracle Fusion Middleware

PROFESSIONAL EXPERIENCE

Senior Oracle Consultant

Confidential

Responsibilities:

• As Lead Oracle DBA for Confidential ’s onshore EAS Database services group, I have provided consulting and production support for major petroleum companies ( Baker Hughes, ExxonMobil, BHP Billiton).
• I am the direct interface to the offshore DBA’s and secondary interface to developers in India. The primary Applications supported are Well Link RT, Beacon, Documentum, PLM Team center and GIS Rig Count databases.
• I am responsible for the installation, configuration and maintenance of all Oracle Databases and Software that are part of the EAS Database services group. (200+ production databases,600 development and QA databases)
• Setup OEM12C to monitor core engineering applications and provide alerts to the appropriate support groups.
• Set up custom Emails in OEM12C to create Solv tickets for Incidences.
• Wrote documentation on how to use OEM12C to monitor and be proactive for our supported applications. Upgraded OEM12C to OEM13C
• Drove the requirements for the new architecture for the Linux Team center Environment. Added separate drives and controllers for data and index mount points to reduce I/O contention. Took advantage of Linux huge pages to utilize Memory more efficiently. Added faster network controllers.
• Upgraded and migrated OS platforms from windows server 2008 to Redhat linux for Team center enterprise databases.
• Ran extensive tuning analysis on Team center applications that resulted in creation of over 100 new custom indexes. This increased database performance by 90 percent on certain queries.
• Set up daily jobs that checked that Team center Indexes. If they have gone stale then the statistics were updated
• Set up tuning baselines for Team center and run continuous monitoring and tuning analysis looking for opportunities to increase performance.
• Clone production Team center databases to QA on request
• Used Oracle’s tuning pack to optimize databases and developer’s code, created SQL tuning sets and used SQL performance analyzer to tune and predict system performance.
• Implemented Golden Gate for Active - Active Replication between drilling rig data feeds to Baker Hughes Data Centers and to Major Oil Companies.
• Used OEM12C to monitor SAP instances and EXADATA Machines.
• Provided tuning and application support for Well link RT Enterprise Project
• Used Application Replay to simulate changes to the Infrastructure and make suggestions.
• Direct interface to Baker Hughes’s internal and external auditors and responsible for implementing recommendations.
• Experience in Oracle Golden Gate, Streams and Advance Replication
• Installed and supported Oracle RAC clusters and Data guard for High availability applications.
• Supported and made tuning suggestions for Weblogic application Tier.
• Troubleshoot and monitor in-house written Java applications
• Plan, Implement and test disaster recovery system, using RMAN and custom written shell scripts. Create and maintain Oracle Data Guard configurations.
• Design, implement and support Oracle advanced replication using Oracle streams or Golden Gate to provide a replicated database environment to support internal business needs.
• Wrote scripts to monitor OS and database events. Operating systems are Linux, Aix, Solaris and Win.
• Used Oracle’s tuning pack to optimize databases and developer’s code.
• Created SQL tuning sets and used SQL performance analyzer to tune and predict system performance.
• Created Gold build documents for newly deployed systems to be hosted at well sites worldwide.
• Provided SQL Server monitoring and basic database support.
• Assisted and management and database administration of Oracle Applications on Exadata platforms.
• Set up container and pluggable databases in 12C databases
• Continuous adherence and monitoring of Security and database standards
• Provide support to other Confidential clients as called upon.