SUMMARY:

• Over 19 years’ experience in design, development, and administration of database and applications in the client server environment.
• Extensive experience in IT Architecture, Database Administration activities like Data Modeling, installation, configuration, performance tuning, and Logical/Physical Database Design.
• Strong in AWS/Oracle Cloud Operations, Data Warehousing experience using IBM Data Stage 8.x, Informatica Power Center 9.x/8.x, Oracle database 12c/11g/10g/9i using Oracle RAC 11g/12c, and Data Guard.
• Comprehensive experience in Gathering, Evaluating, and Providing technology requirements for complex business needs and developing technical recommendations as well as leading teams to implement such recommendations with minimum impact to customers.

SKILLS:

Hardware: HP 9000, COMPAQ PROLIANT 6500, MAGNUM 68030 (Motorola), U6000 (Unisys), PC Pentium II /AT/other IBM compatible PC

Operating Systems: AIX 6.1/5.3, HP - UX Release 11.00, Sun Solaris 10, UNIX SVR4, Linux, Windows NT 4.0, Windows 95, Windows 2000

Database: Oracle 12c/11g/10g/9i/8i, Oracle Exadata, Oracle RAC, ASM, Streams, Toad, Grid Control, Cloud Control, MySQL 5.x, Netezza N2001, Big Data/ NoSQL MongoDB 2.x/3.x, Hadoop 2.x

High Availability/DR: Data Guard physical and logical standbys, materialialized views.

Application Server: Oracle Application Server (Oracle 9i AS/AS 10g).

Software/Languages: Developer2000, Designer 2000, ERwin, Oracle Discoverer 3.1, SQL*FORMS 9i/6i/ 4.5/4.0/3.0/2.3 , SQL*Reportwriter 6i/2.5/2.0/1.1, PL/SQL, SQL*MENU 5.0, Pro*C, SQL*Plus, Powerbuilder 5.0/3.0, C, JAVA, JDK 1.1, ColdFusion 4.0.x, Brio report 6.2, IBM DataStage 8.x, Informatica 9.x/8.x/ 7.1/ 6.2.2/5.1.1 , Oracle GoldenGate 12.1.x, Apache Server & PHP, Perl, UC4 V8

EXPERIENCE:

Confidential, San Francisco, CA

Oracle DBA Expert

Responsibilities:

• Support and Maintain on site databases for production, development and QA as 24x7 support for SF IT/ USA.
• Database/Application migration, Installation, upgrade, validation and configuration of Oracle 12c/11g/10g/9i on Linux/AIX/HP-UX/Windows.
• Applied CPU security patches with National IT on all production, development and QA databases.
• Oracle Golden Gate 12.1.x installation and test on Oracle VM.
• Participated in the development coding/code review on a regular basis and help the FRB development team to improve the coding standard and performance.
• Data Generation to simulate performance impact for SCAR application.
• Business Reediness Testing (BRT) for IAM application/Database.
• Developed many scripts and tools to Improve database security maintenance and administration.
• Worked with National IT/SF IT of FRB teams to implement FRIT’s audit policy recommendations.
• Tuned IAM application/database performance and monitor/fix issues related to RMAN backup.
• DBA Team representation in Daily Scrum and Change Control meetings with higher management.
• Troubleshooting day to day issue related to IAM/Epass/FIT/FIA applications and databases.
• Worked on estimates, priorities and assignments. Co-ordinate with National IT DBAs, UNIX admins and Middleware team on refreshes, compliance, deployment/test issues and answer the questions from various parties on upgrade/patch outages.

Confidential, CA

Data Services Engineer Lead

Responsibilities:

• Support and Maintain 200+ on site databases for production, development and QA as 24x7 support for USA and UK.
• Database migration, Installation, upgrade and configuration of Oracle 12c/11g/10g/9i on Linux/AIX/HP-UX/Windows.
• Applied CPU security patches on all production, development and QA databases.
• Improved monitoring and developed many scripts and tools for database administration.
• Reorganized RMAN backups.
• Customized OEM Cloud Control to manage development/production databases.
• Tuned performance in production and staging with great results using ADDM, AWR, OEM Performance Manager, and custom scripts.
• Created and administered production physical standby databases.
• Developed Standard Operating Procedures for DBA tasks to insure consistent results.
• Automatic database health tracking using custom scripts for Gallo databases.
• Troubleshooting day to day issue related to Data Stage.
• Created and implemented Database Administration Standards, Guidelines and Procedures for smooth functioning of day to day DBA operation and Emergency need as Team lead.
• Worked on estimates, priorities and assignments. Co-ordinate with DBAs, UNIX admins, Storage team and WebLogic operations on refreshes, compliance issues, production deployments and answer the questions from various parties on outages.

Confidential, San Ramon, CA

Oracle Sr. DBA

Responsibilities:

• Support and Maintain 60+ on site databases for production, development and QA as 24x7 support.
• Primary DBA for SOX and NON-SOX databases: GTS, EAI, FFE, ECM, MASIS and InfoCenter.
• Database migration, Installation, upgrade and configuration of Oracle 11g/10g/9i/8i on AIX / Sun Solaris.
• Applied CPU security patches on all production, development and QA databases.
• Improved monitoring and developed many scripts and tools for database administration.
• Reorganized RMAN backups.
• Customized OEM Grid Control to manage production databases.
• Tuned performance in production and staging with great results using ADDM, AWR, Statspack, extended SQL trace (event 10046 trace files), OEM Performance Manager, and custom scripts.
• Created and administered production physical standby databases.
• Presented Oracle RAC 11gR2 on a Virtual Host at Confidential & Confidential DA Forum.
• Developed Standard Operating Procedures for DBA tasks to insure consistent results.
• Automatic database health tracking using custom scripts for Confidential & Confidential databases.
• Troubleshooting day to day issue related to Informatica - using PowerCenter tools.
• Flawless conversion from Oracle 8i/9i to Oracle 11g database as InfoCenter/MASIS/UC4 projects need.

Confidential, Brisbane, CA

Sr. DBA Team Lead

Responsibilities:

• Maintain 80+ on site databases for production, development and QA testing.
• Holiday readiness project implementation - involving multiple applications and database tuning for holiday smooth functioning.
• Tuning Reporting database using Oracle and Informatica.
• Implemented Grid based monitoring solution for Confidential databases.
• Conducted domain awareness and internal knowledge sharing training program for team members.
• Troubleshooting day to day issue related to Netezza, MySQL, Oracle and Informatica.
• Developed Standard Operating Procedures for DBA tasks to insure consistent results.
• Team representation in Daily Change Control meeting with higher management.

Confidential, Walnut Creek, CA

Sr. Oracle DBA/ Informatica Administrator

Responsibilities:

• Maintain 60+ on site databases for production, development and QA testing.
• Installed and configured Oracle 11g/10g/9i on UnixWare/AIX 5.3, HP-UX and Sun Solaris.
• Database migration from 9i to 10g.
• Installed Oracle RAC 10g/11g on Linux using SAN disk arrays.
• Implemented Oracle Streams 10g on HP-UX server.
• Installed, configured and administer more than 32 applications projects using Informatica 8.x/7.x under SCI project.
• Implemented Grid based monitoring solution for SCI databases.
• Installed and configure Backup and Recovery using RMAN.
• Automatic space tracking using custom scripts for Longs databases.
• Develop a security management system for automatic locking and removing unauthorized or no more needed users from database.
• Extensively worked on optimizing, partitioning, clustering of tables.