Senior Oracle Dba Resume
2.00/5 (Submit Your Rating)
Irvine, CA
SUMMARY
- Oracle Certified Database Administrator with Seven plus Years of Experience in a wide variety of environments ranging from Oracle, MySQL, SQL Server, MongoDB and Hadoop Clusters. I Specialize in Oracle RAC, ASM, NOSQL, Data Guard, OEM Grid Control and high end performance tuning.
- Seven plus Years of Experience as Database Administrator, providing 24/7 production support for Oracle, SQL Server, MYSQL, Mongo DB, HBase and Hadoop Clusters.
- Database Administrator with hands - on experience in supporting Oracle 10g/11g/12c, SQL Server 2008 R2, MySQL, MongoDB and Hadoop Clusters.
- Experienced in Disaster Recovery Solutions using Oracle Data Guard (Physical and Logical Standby).
- Experienced in setting up MongoDB 3.0.5 Replication Sets/Sharded Cluster.
- Experienced in Managing Apache Hadoop 1.2 big technologies like HDFS/HIVE/PIG/Map-reduce jobs.
- Experienced in Managing MS SQL Server 2008 R2, MySQL 5.6 Databases.
TECHNICAL SKILLS
- Oracle 10g/11g/12c
- Real Application Clusters (RAC)
- Golden gate 12c replication
- MYSQL 5.6 - Replication/Cluster
- MongoDB 3.0.5 - Replication/Sharding
- Hadoop - HDFS/HIVE/Map-reduce jobs
- Physical and Logical Standby Databases
- Recovery Manager (RMAN) backups
- Oracle Enterprise Manager (OEM)
- Solaris, Linux, Windows
- MS SQL SERVER 2008 R2
- Shell/JavaScript/Java/C++/C
PROFESSIONAL EXPERIENCE
Confidential, Irvine, CA
Senior Oracle DBA
Responsibilities:
- Primary DBA for Verizonwireless.com multisite production system.
- Managing external facing web application that has more than 100 million customers.
- Experienced in managing application that is spread across two datacenters with 3 node 11gr2 RAC in each data center and data replication between two datacenters using GoldenGate.
- Worked SQL and PL/SQL scripts for task automations.
- Maintained database configurations in compliance with established best practices RequirementsSupported 11g active data guard setup.
- Extensive performance tuning experience, specializing in instance tuning, Oracle RAC tuning and SQL optimization
- Configured OEM and implemented OEM alerts for all the production and non production db's.
- Installation, configuration, managing, monitoring and troubleshoot of Oracle GOLDEN GATE 12c software in source and target systems.
- Created and managed OGG extracts, replicates, data pumps and trail files and error handling.
- Supported 24/7 on-call.
- Worked on setup of oracle 12c database.
- Worked on setting up Mongo db 3.0.5 Replication sets/Sharded Cluster.
- Experienced in Managing Apache Hadoop 1.2 big technologies like HDFS/HIVE/PIG/Map-reduce jobs.
Confidential, Tallahassee, FL
Senior Oracle DBA
Responsibilities:
- Primary DBA for 52 applications.
- Supported monthly application releases.
- Scheduled and implemented production change controls
- Supported Quarterly CPU patching for all the production and non production.
- Refreshed non production environments from production using RMAN and datapump.
- Reviewing development code for development teams.
- Configured OEM and implemented OEM alerts for all the production and non production db's.
- Configured and managed 10g and 11g RAC databases.
- Refreshed non-production databases with RMAN duplicate.
- Supported 24/7 on-call.
Confidential
Oracle DBA
Responsibilities:
- Worked on B2B application that supports business customers.
- Day to day maintenance of B2B application which has 5 production and 90 non-prod databases.
- Supported multi-site applications.
- Upgraded 9i and 10g databases with physical standby to 11gR2.
- Supported multi TB production databases
- Designed and Implemented Oracle 9i and 10g Physical standby’s
- Planned and upgraded 9i and 10g Databases with physical standby to 11gR2.
- Configured and managed 10g and 11g RAC databases.
- Developed and configured shell scripts for monitoring and alerting DB performances.
- Supported many production Change Controls.
- Configured OEM alerts for all production databases.
- Worked on implementing and maintenance of 11g grid infrastructure with ASM databases.
- Hand full of experience on RMAN restore and recovery scenarios.
- Supported OS upgrade from SOLARIS 9 to SOLARIS 10.
- Monthly maintenance of Partitioned tables.
- supported 24/7 on-call
Confidential
Oracle Developer & DBA
Responsibilities:
- Member of the database team that manages internal Ticketing system.
- Installation and creation of 9i and 10g databases for Testing and Development.
- Performed database Cloning to setup test and development database.
- Conducting sizing & capacity planning for Oracle databases.
- AWR Analysis to monitor health of database.
- Develop and tune reporting queries.
- Installed and Implemented Backup & Recovery procedures.
- Monitoring Growth of tables and undertaking necessary re-organization of database as and when required