SUMMARY:

• Targeting Positions with Cloud and Database technologies
• Over 10 years of professional work experience
• Proficient in Oracle 10g, 11g, 12c, 18c, 19c Database Administration
• Proficient in MySQL 5.x, 8.x Database Administration
• Experienced in configuring and managing Real Application Clusters (RAC) on ASM
• Experienced in configuring and managing MySQL Master - Slave replication
• Experienced in performing RMAN Backup and Recovery, MySQL Enterprise backups, and MySQL dumps
• Proficient in database administration using Oracle Enterprise Manager, OEM Cloud Control 12c and 13c, MySQL Enterprise Manager, MySQL Workbench
• Experience monitoring Goldengate groups and extracts
• Proficient in Database Migration, Upgrade and Patch Application
• Proficient in Performance Tuning
• Experienced in configuring and managing Data Guard
• Experienced in manually gathering optimizer statistics and configuring AWR
• Experienced in recovering database from corrupt control and parameter files
• Experience in migrating databases to AWS using Schema Conversion Tool (SCT) and Database Management System (DMS)
• Completed training in PostgreSQL
• A self-motivated, responsible and reliable team player with a set of strong technical skills.
• Strong in solving problems of diverse scope where technical analysis and evaluation is required
• Results-driven IT personnel with skills in team building and problem-solving with an established reputation for effectively working with diverse groups of people and adaptability to changing environments.

TECHNICAL SKILLS:

Relational Databases: Oracle 10g/11g/12c/18c/19c, MySQL 5.x/8, PostgreSQL 10.x

Operating Systems: Windows 10/8/7/XP, RedHat, Linux (various distros), Windows Server 2012/2008R2, VMWare/Vcenter, Mac OS

Cloud: Amazon Web Services (AWS), Microsoft Azure

Networking Topologies and Protocols: Ethernet, TCP/IP

Applications, Tools, and Utilities: SQL*Plus, Oracle Enterprise Manager (OEM), Real Application Clusters (RAC), Data Guard, Goldengate, SQL*Loader, Data Migration (Export and Import), Procedures, RMAN Backup and Recovery, Performance Tuning, AWR, ADDM, NETCA, NETMGR, DBCA, DBUA, Automatic Storage Management (ASM), MySQL, MyISAM, Innodb

Cloud & DevOps: EC2, VPC, EBS, RDS, Autoscaling, Docker, Route53, Jenkins, Puppet

Software: ServiceNow, JIRA, Confluence, Toad, PL/SQL Developer, Oracle SQL Developer

WORK EXPERIENCE:

Confidential, Arlington, VA

Oracle/MySQL Database Administrator

Responsibilities:

• Working as an Oracle and MySQL Database administrator for a federal client
• Successfully performed Oracle Database Upgrades from 12.1.0.2 to 12.2.0, 12.2.0 to 18c
• Successfully installed and created 19c instances
• Successfully applied quarterly Oracle patches standalone databases
• Successfully migrated on-prem databases to Azure and Amazon cloud providers
• Successfully worked on a process to manage and organize application user password changes across different lifecycles
• Successfully ensured RMAN backups were successful and healthy
• Monitored OEM alerts and resolved
• Worked on MySQL versions 5.6, 5.7 and 8.0
• Successfully manage Development and Test databases built on AWS cloud services
• Successfully built databases for project specified Self-Hosted Instances, in the Staging and Production environments
• Successfully designed and implemented a disaster recovery database environment
• Successfully configured replication for Staging and Production databases utilizing Global Transaction Identifiers (GTIDs)
• Successfully tested failover process
• Created shell scripts for daily database health checks, backups and monitoring
• Successfully installed and configured mysqlrpladmin to aid with the switchover exercise of the MySQL databases
• Resolved DB performance issues related to the InnoDB engine and parameters including as high memory usage and CPU
• Created detailed documentation of processes and standards
• Ensured backups of the databases were taken daily and retained for the allocated retention period
• Successfully managed migration of production databases to cloud environment. Provided solutions to rectify transfer speeds and firewall rules to allow connectivity
• Worked on data migrations to refresh the lower environments
• Successfully applied DISA Security Technical Implementation Guide (STIGs) for the database to ensure security standards are met
• Successfully provided technical inputs to satisfy Assessment and Authorization (A&A) to validate our environment meets all information system policies following NIST standards are met
• Worked closely with Linux Administrators to open ports, re-ip servers, extend partitions and implement firewall rules

Confidential, Fairfax, VA

Oracle Database Administrator

Responsibilities:

• Worked with a team of oracle database administrators responsible for managing 31 development and test Oracle databases and 6 production database
• Database versions range from 11.2.0.4 to 12.1.0.2
• Applied bug fixes/patches to databases
• Applied quarterly Critical Patch Updates on databases
• Refreshed schema/database baseline from production databases to test and development databases
• Performed daily checks to ensure space availability on file systems, load on each server, and successful daily backups
• Verified Goldengate extracts and groups are all running, and resolved any abended or stopped issues
• Monitored alert logs for ORA errors, failures, and warnings
• Managed Dataguard using Dataguard broker to ensure logs were being shipped from primary to standby databases, and resolve log gap issues when necessary
• Responsible for database and SQL query performance tuning
• Created additional cronjobs for daily database checks, RMAN backups to disk and tape
• Gained experience writing PL/SQL scripts
• Performed upgrade to OEM 13c Cloud Control on test and development databases
• Responding to daily tickets on JIRA to create/drop users, databases refreshes, dropping objects, datapump exports/imports, and space management
• Work closely with developers, system administrators, and the configuration management teams to plan patches, maintenance windows, and updates to SQL queries
• Worked on database migrations as part of the Data Center Consolidation project
• Successfully migrated Development and Production Oracle and MySQL databases between data centers across the country
• Successfully created Oracle databases using response files on RHEL6
• Successfully duplicated Oracle databases using the following methods:
• Successfully installed various versions of MySQL 5 on RHEL6 using yum install
• Successfully installed Oracle Enterprise Manager Agents on Oracle Databases

Confidential, Ashburn, VA

Oracle Database Administrator

Responsibilities:

• Responsible for managing Oracle 11g databases across production, QA, and development
• Design and implement 2 node RAC database on Linux
• Managed 11gR2 Grid Infrastructure (ASM, Clusterware)
• Managed all RAC databases on ASM storage
• Managed RAC databases using CRSCTL, SRVCTL and Grid Control
• Managed Oracle 11gR2 database using Oracle Enterprise Manager
• Successfully configured and setup Oracle 11gR2 Data Guard
• Managed Data Guard using Data Guard broker
• Troubleshoot and resolved log gap in Data Guard Configuration
• Ran database backups using RMAN
• Responsible for applying quarterly Oracle critical patch updates (CPU)
• Performed database refreshes from production to test
• Used Datapump to export data from production to test servers
• Creating and rebuilding indexes as necessary
• Performing database cloning and duplication using RMAN and Datapump
• Responsible for performance tuning and system wide optimization
• Performance Management by running Automatic Workload Repository (AWR), Automatic Database Diagnostic Management (ADDM)
• Created knowledge base containing database structure, changes, common issues and resolutions

Confidential, Manassas, VA

Database Administrator

Responsibilities:

• Part of a team responsible for database administration for large and complex database systems ranging from Oracle 10g - Oracle 11gR2
• Performed database upgrades from 10g to 11g
• Configured databases to use Oracle Enterprise Manager
• Managed Data Guard using Data Broker and verified shipment of logs from primary to standby
• Resolved daily tickets using ServiceNow
• Successfully applied quarterly database patching
• Responsible for ensuring database, listener, and space availability
• Ensured full and incremental RMAN backups were successful
• Managed and updated knowledge base containing database structure, changes, common issues and resolutions

Confidential, Washington, DC

Oracle Database Consultant

Responsibilities:

• Provided support of Oracle RDBMS products including Oracle Database, Oracle Grid Control, Dataguard, Real Application Clusters (RAC), and ASM
• Managed RAC databases using CRSCTL, SRVCTL and Grid Control
• Enhanced database performance by query and process optimization
• Worked closely with application developers closely to make the RDBMS perform at its best
• Perform RMAN Database Backup and Restore activities in close coordination with Backup team
• Assisted with the planning, design, implementation, and support of large scale Oracle database upgrade from 10g to 11g
• Performed database refresh and cloning between production and test
• Performed database tuning
• Installed Oracle critical patch updates to databases
• Monitored scripts and RMAN backup procedures
• Monitored alert logs to ensure database processes were available
• Maintain operational documentation, technical diagrams and business continuity/disaster recovery procedures
• Created and maintained technical documents as per standards followed in the Confidential Group