Administrator Oracle

Professional Summary

Result oriented, analytical and self-driven professional seasoned in a dual role of design/architecture and production support.

Experience in Installation/Administering MySQL 5-8 including Innodb Cluster, Oracle 12C, 11gr2,10g Databases of varying landscapes and sizes

Excellent hands-on in database administration over Dedicated Servers, Data Guard Servers, Distributed Servers and Very Large Databases (VLDB) of sizes over 30TB on multiple instances which includes tuning, backup & recovery procedures.

Extensive experience in data center configuration and migration.

Extensive experience with Oracle patching/ cloning and configuration.

Experience of an implementation of DR (Disaster Recovery) plan with different approach like Dataguard and Physical standby

Experience with implementation of Audit and security implementation on oracle databases.

Extensive experience in Database Upgrades & Migration from oracle 10g to oracle 11gr2, Oracle 11g to 12c with cross-platform migrations.

Experience using OEM, Grid control, Erwin, Toad for database administration, monitoring and design.

Worked extensively on Backup & Recovery online/offline using RMAN & User-Managed physical/logical backups using Import/Export.

Experience on Performance Tuning & Capacity Planning pro-active and re-active actions for optimal performance complying with business SLA’s.

Excellent communication, interpersonal and leadership skills along with very good understanding and experience working in a highly qualified environment.

Experience managing AWS cloud solutions including Postgres RDS, Redshift, EC2, S3 and etc

Work experience:

SAIC

Sr. Principal Database Engineer

10/18 - Current

Reston, VA

Provide Database engineering support for DOT FMCSA

Maintain Oracle databases running on Amazon EC2-instances

Migrate On-Premises Applications and Databases to AWS cloud including Oracle, Postgres, Aurora and MySQL

Provision AWS RDS including Postgres, Aurora, MySQL as needed

Provide POCs and analysis on all AWS services

Evaluate existing databases and system infrastructure setup and provide recommendations for high Availability and fault tolerance based on the finding

Database systems design, architect the full SDLC complaint database infrastructure.

Setup and manage and monitor multi-tier MySQL DB running on RHEL EC2 instances including (M/M Replication, 3-Node Innodb Cluster)

Configured and managed various AWS Services including EC2, RDS, VPC, S3 and Cloud Watch etc.

Federal National Mortgage Associations

Lead Database Administrator

09/14 - 10/18 11600 American Dream Way, Reston, VA 20190 Reston, VA

Database systems design, architect the full SDLC complaint database infrastructure

Designed AWS infrastructure to migrate On-Premises Applications and Databases to AWS cloud including setup and provisioning Postgres/Aurora RDS instances and Redshift cluster

Manage, administrate and maintained over 2000 Oracle database instances in AIX/Linux Cluster and non-cluster environment

Play lead DBA role in maintaining or modifying database(s) in production and Track system availability, uptime, and performance.

Managed and Performed database upgrades and patching project as needed.

Responsible for Planning and designing database changes necessary for data conversion, tool configuration, data refresh or migration or other initiatives related to large application development project.

Troubleshoot or confer with others troubleshooting errors or production problems involving databases to determine causes and proposed solutions.

Communicate with managers in networking, systems operations, applications, and client/user community to maintain stable and efficient operating environment for database(s).

3M 11/12 - 09/14 1881 Campus Commons Dr, Reston, VA 20191 Reston, VA

Sr.Database Administrator

Responsible Supporting the Department of Homeland Security’s Office of Biometric Identity Management and Automated Biometrics Identification Systems

Managed, administrated and maintained over 20 multi-terabyte Oracle 10gr2/11gr2 RAC production databases in an AIX/UNIX Clustered environment

Mentored junior DBAs as required

Ensured the availability, performance, recovery and security of the databases.

Designed and implemented database infrastructure, including performance monitoring, capacity planning, and automation of database related processes

Installed and configured Oracle Enterprise Clued Control 12c to manage the Oracle Cluster infrastructure

Setup and configured Oracle Active Data Guard to manage data replication and to protect

enterprise data from failures, disasters, errors, and corruptions.

Verizon wireless 08/04 - 11/12 51 ImClone Dr. Branchburg, NJ 08876

Sr.Database Administrator

Created and managed Oracle database in Unix and Linux Environments (9i,10g, 11g)

Setup and configured oracle Data Guard and Oracle Streams to protect enterprise data from failures, disasters, errors, and corruptions.

Worked in a ten-member DBA team providing support for 400+ Oracle instances with database sizes ranging from 10GB to 5TB.

Installed and configure Oracle Enterprise Manager Grid Control to monitor over 400+ databases

Applied all required patches including Oracle PSU and critical CPU patches as needed

Proficient in large RDBMS Administration, Installation & Performance Tuning, & Security Management, Backup & Recovery, Data Guard / Standby database

Responsible for maintenance and 24x7 Support of multi-terabyte databases (Oracle 9i, 10g,11gr2) in production, testing and development environments hosted on Unix and Linux environment

Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump and imp/exp

Led the DBA team in upgrading databases from 9i to 10g, 11g

Provided Engineering, implementation and support for high availability solutions using Oracle Data Guard, Oracle Streams, VCS clustering and load balancing solutions for all mission critical applications

Created and managed new databases for load testing and synchronize changes between dev and testing environments

Setup and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments

Environment:

Oracle 10g, 11gr2,12c, RAC ASM, HP-UX, Redhat Linux, Sun Solaris, IBM AIX,OEM (Grid Control), SQL,PL/SQL, java, SQL Server,Toad, Netbackup, RMAN, Explain Plan, Data Pump, SQL*Loader, AWR, ADDM,Netezza, AWS Solutions: RDS Oracle, Postgres, MySQL, Aurora, DynamoDB, EC2, DMS, S3,. Redshift, Ansible and Docker etc.

Education:

Bachelor of Science in Mathematics and Computer Information Systems

University of Cumberland, Williamsburg, KY

Training:

AWS Architecture Solution

Oracle Database Administration

Oracle Backup and recovery

Oracle Performance and Tuning

Oracle Application Server

Advanced Backup and Recovery using RMAN

Oracle Real Application Cluster

UNIX System Administration – Solaris

Perl Programming

Linux Red Hat system administrator

MS SQL Server 2008

Certified Oracle DBA (OCP)

Contact this candidate