SUMMARY:

Highly skilled Sr. Oracle Database Administrator with 10+ years of experience leading successful database migration projects to seamlessly move across software platforms, hardware & across datacenters. Demonstrated ability to handle difficult situations to help restore services with minimal impact to the customers thereby not only satisfying but also exceeding expectations. Strong track record of collaborating with cross - functional teams to execute key infrastructure projects and deliver on business commitments. Experience leading all key security initiatives for teams to improve the data security. Scrum Master / Green Belt Certified.

TECHNICAL SKILLS:

RDBMS: Oracle RAC 12c/11gR2-7.X, MySQL 5.X, PostgreSQL

High Availability Technologies: OGG, Shareplex 8.X/7.X, Streams

NoSQL / Big Data Technologies: Cassandra, MongoDB, Riak

Monitoring Tools: OEM grid control 12c/11g, DSE Ops Center, Ignite

Languages: Pl/SQL, Pro*C/Perl, Power Builder

ETL Technologies: Informatics Cincinnati, OH, SQL * loader

Operating Systems: RHEL, HP Unix, Windows NT/2000

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Sr. Oracle DBA

Responsibilities:

• Provide 24x7 on-call support for OLTP and DSS database.
• Leverage Data Guard technology to hardware/software tech refresh DB servers.
• Leverage features like Online Table Redefinition to convert non-partitioned tables to partitioned and re-org table using Basic Filed to Secure files.
• Leverage OEM 12c cloud control to automate provisioning new RAC cluster and applying PSU patches.
• Setting up High Availability Oracle Golden Gate (OGG) systems on Oracle 11gR2 RAC environments.
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Log dump / discard file analysis etc.
• Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM/OEM.
• Upgraded Oracle GRID, ASM and Database from 11g to 12c. Implement Oracle 12c new features in production environments.
• Application DBA leader for a large number of tuning projects. Working in DevOps model with engineering on reviewing SQL code.
• 12c (OEM), developing and maintaining the Korn shell based home-cooked monitoring scripts to monitor database instance status, tablespace usage etc.
• Participated in the Cassandra data modeling sessions to understand the queries needed and providing them inputs based on the existing data to make sure designed model is technically feasible.
• Implemented RMAN backups and other Crontab jobs.
• Scripting by using Korn shell.

Confidential, San Jose, CA / Austin, TX

Sr. Oracle DBA

Responsibilities:

• Significantly improved the security and scalability of the Cisco applications by implementing a 7 DC DSE Cassandra cluster and migrating 200+ Test & Production Databases from 10g to 11 gR2 RAC.
• Successfully lead a key Oracle RAC cluster consolidation project, saving approximately $1.3MM annually in license and support fees, and setting up scalable RAC clusters for future growth.
• Designed and implemented a new backup strategy, eliminating dedicated backup servers/catalog databases, and instead using control files for backup Meta data. Reduced Oracle licensing /support footprint by approximately 170 cores, saving $1.1MM in recurring costs.
• Lead successful project that scaled WebEx feature to grow meeting minutes by 30% without incurring any server infrastructure cost, by moving Oracle DB’s from AMM to ASMM and implementing Linux page.
• Improved the security posture of DB infrastructure by working with InfoSec team to configure Qualys scans to detect vulnerabilities and remediate them within reasonable timeframes.
• Lead many innovative and successful installation and configurations/performance tuning projects for Oracle 11/10G R2 RAC CRS/DB/ASM binaries, including subsequent upgrades using Export/Import, Add/Remove Nodes, Data Guard, and Storage LUN migrations.
• Review and quality control. Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, ASH, OEM Performance Manager and home cooked scripts by using Korn shell/Perl.
• Designing the production system monitoring framework, Configuring/Tuning Oracle Enterprise Management.
• Administering and setting up of 11g/12c RAC and clusterware and instances.
• Implemented and maintained load balancing for performance of Oracle servers in RAC cluster architecture.

Confidential

Oracle DBA

• Won Pioneer Award in 10/2011 for successfully leading database migration of 10+ 11g databases for an Infrastructure Data Center move of Cisco WebEx within 3 months.
• Received Cisco WebEx “Star of the Year” Award for outstanding contribution to the business.

Confidential

Senior Analyst

• As a Certified ITIL (BSM) Analyst, helped implement Managed Objects for infrastructure team.
• Chosen to participate in General Electric Leadership Development Program for high performers.
• Won GE’s Management Award for successful transition of production support for 15 oracle databases in a record time of 3 weeks.

Confidential

QA Engineer

Responsibilities:

• Responsible for developing test cases for new enhanced features of Designer 9i & ADA (American Disability Act) compliance, installing and configuring Oracle 9i database, Repository for Designer 9i.
• Designed Test Plans, Test Case List for Oracle SCM Version History Viewer & Diff/Merge Tools, installing and configuring Oracle 8i database on NT & Solaris systems.
• Tested Repository Version History Viewer, Diff/Merge tool.