We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

4.00/5 (Submit Your Rating)

Herndon, VA

SUMMARY:

  • Over 20+ years of IT experience with 15+ years of experience as an Oracle Production DBA.
  • Profound experience in supporting mission critical and multiple types of production database environments.
  • Extensive experience in database monitoring, performance tuning, and troubleshooting.
  • Advanced knowledge and experience of Oracle Enterprise Manager (OEM) 13c, 12c, & 11g.
  • Strong background and excellent experience as a Unix System Administrator.

TECHNICAL SKILLS:

Database systems: Oracle 12c, Oracle 11g, and Oracle 10g/9i/8i/7. MySQL 5.x and Microsoft SQL Server 2005.

Database Software: Oracle RAC, Oracle Data Guard, Oracle GoldenGate Replication, Oracle Warehouse Builder,Oracle Business Intelligent/Publisher, RMAN, Data Pump, and SQL Loader.

Database Tools: Oracle Enterprise Manager (OEM) 12c Cloud Control, OEM 11g Grid Control, GoldenGate Veridata,GoldenGate Monitor, Toad for Oracle/MySQL/SQL Server, and MySQL Enterprise Monitor.

Operating Systems: Red Hat Enterprise Linux AS 6.x & 5.x., Red Hat Enterprise Linux OpenStack CentOS 6.x. IBM AIX 5L, SUN Solaris 10 & 9, Microsoft Windows Sever 2005 & 2003.

Hardware/Storage: Linux VMware servers & OpenStack Platform, IBM P Series Servers, Intel/AMD - based Linux servers, SUN Ultra Enterprise and Sparc Center series. EMC VMAX/Symmetrix series and VNX/CLARiiON series.

Programming Languages: Unix Shell, SQL, PL/SQL, AWK, Perl, C/C++, and HTML.

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

Senior Database Administrator

Responsibilities:
  • Provided operational support to critical production databases in Oracle 11g 4 - node/2-node RAC & Data Guard high availability environment which were used internally as well as externally by 15+ million customers. Part of a weekly rotating 24/7 on call schedule within the DBA team.
  • Implemented and deployed Oracle Enterprise Manager 12c Cloud Control which proactively monitored the production database performance by collecting DB statistics/metrics as well as sending an alert to the DBA team if the metric exceeded to the threshold setting.
  • Deployed Oracle GoldenGate unidirectional replication for feeding data from different OLTP database systems to data warehouse like reporting systems.
  • Proactively monitored GoldenGate instance processes by using GoldenGate plug-in of Oracle Enterprise Manager 12c and GoldenGate Monitor tools. Also compared data sets using GoldenGate Veridata to identify and repair any out of sync data.
  • Implemented and deployed MySQL Enterprise Monitor and MySQL plug-in of Oracle Enterprise Manager 12c for monitoring different versions of MySQL production databases and hosts.
  • Provided Oracle database administration including installation, upgrade, patching, tuning, deployment, backup/recovery, and documentation.
  • Provided MySQL database administration and performance tuning used by various Java-based applications.
  • Wrote Shell & AWK scripts along with scheduling cron jobs for monitoring database activities and maintaining housekeeping data.

Confidential, Sterling, VA

Senior Database Administrator

Responsibilities:
  • Installed, upgraded, configured, deployed, tuned, and maintained 30+ Oracle 11g and 10g production databases in Data Guard environment running on the IBM AIX, Red Hat Linux, and Windows Server platforms.
  • Monitored Oracle database performance, user activity, and resource usage to ensure that the database was running at optimal performance. Performed either Oracle RMAN or EMC BCVs for database backup/recovery.
  • Implemented database monitoring scripts combined with using Oracle Enterprise Manager 10g Grid Control to build a proactive monitoring environment to minimize database incidents.
  • Involved with daily activities of all production database systems, performed 24x7 on-call duties, communicated with customers, and performed effective troubleshooting for immediate production database issues.
  • Provided Oracle database administration for the Customer Call Center’s Internet domain name registration processes. Maintained the production database servers in a 24x7 environment which housed all critical interaction data between customers via phone, e-mail, fax, or internet.
  • Performed database tuning, troubleshooting, and resolved all immediate production database issues in a timely manner. Supported every application software release onto production databases.

We'd love your feedback!