We provide IT Staff Augmentation Services!

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

We'd love your feedback!