SUMMARY

• Senior Oracle database administrator with 13 years as Production database administrator. I am well - versed in maintaining large (GB/TB) databases supporting Oracle, MySQL, PostgreSQL Microsoft SQL server, Vertica and MongoDB in a hybrid environment.
• I have gained cross-functional experience by working with application developers, assisting with code review, and taking the role of release manager for enhancements to an existing product line in Jira/GitHub and team leading skills with overseas the DBA team.

TECHNICAL SKILLS

Operating Systems: Red Hat Enterprise Linux Release 7, Windows Server, Sun Solaris 8, 10 &11.

Databases: Oracle 11g,12c,19c, Vertica DB, PostgreSQL, MongoDB 3.6, MS SQL 2016, MySQL.

High Availability: Oracle 11g Real application clusters (RAC)Oracle Data Guard (Active & Passive) SQL Server Always On High Availability.

Replication: Materialized Views, MongoDB Replication, Sharding.

Backup & Recovery: RMAN, Data Pump, Mongo dump and restore, pg dump, pg restore, mysqldump and AWS snapshot restore.

Enterprise Management: Oracle Enterprise Management 12c Cloud Control

Programming Languages: SQL, PLSQL, Unix Shell

Configuration Management: BCFG2, Chef

Data Systems: OLTP, DSS

DevOps: Jenkins, JIRA, GitHub, Docker

Data Model: ERWIN

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead (DBA)

Responsibilities:

• Support transition by collaborated with business stakeholders to understand business requirements, process, and internal systems at NCI CBIIT.
• Served as escalation point of contact and proven hands on Technical Lead while performing day to day database tasks.
• Participated in conference calls with customers to discuss current environment issues and future projects.
• Proposed restructuring of DBA team with in CBIIT.
• Troubleshooting database issues reported via Service Now ticketing system.
• Refreshed all environments databases from production data set for Oracle, MYSQL, and PostgreSQL.
• Collaborate with business units and stakeholders to understand business requirements, process, and internal systems.
• Research and evaluate new oracle 19c features, products and technologies, conduct proof of concepts and submit pros/cons, reports to upper management with feedback.
• Participate in meetings, conferences and workshops to technical and Federal POC database upgrades, new features, and new technologies, including developing strategies for migrating to AWS cloud.
• Lead projects to migrate database to AWS and solutions driven by business requirements.
• Excellent oral and written communication skills.
• Independent and detailed oriented with analytical, organizational and creative skills.
• Ability to motivate and co-ordinate team to ensure service levels are met and quality is maintained.
• Experienced in the process of planning, organization and management of tasks, resources to accomplish a defined objective usually within the constraints of time, resource, and cost.
• Troubleshoot WebLogic user login issue.
• Maintained MYSQL, Postgres and MS SQL 2016 in an enterprise environment while establishing database policies.
• Refresh MSSQL 2016 AlwaysOn database using Production data set.
• Experience administering SQL Server 2016 AlwaysOn Availability database.
• Apply Oracle patches. knowledge and hands-on experience with core AWS services - EC2, ELB, LAMBDA, Route 53, IAM, S3, EBS, IAM, RDS, Glacier, Cloud Formation, Cloud Watch, Cloud Front, Cloud Trail, AWS Landing Zones, AWS Backup, Direct Connect, Redshift, Kinesis and EMR.

Senior DBA OSHA

Confidential

Responsibilities:

• Worked with JIRA Tool for Tracking of Release Items while deploying monthly production release(s).
• Performed QAT/UAT database refresh from production data set after a monthly production release.
• Assisted with SQL tuning, optimization, troubleshooting, and resolution.
• Evaluated Oracle upgrade path from 11g Enterprise Edition to AWS RDS service; deployed new features of Oracle 12c EE and SE.
• Presented and advised management about significant differences between 12cAWS Standard Edition and current Oracle Instance11g Enterprise Edition.
• Installed and configured Oracle DB Vault to ensure FISMA requirements are met at the database level.
• Installed and configured Talend administration database in Oracle 12c.
• Provided guidelines for Database Objects and Query comments in repository.
• Maintained Oracle RDBMS (Oracle 10g, 11g & 12c) in an enterprise environment while establishing database policies and standard operating procedures to enable consistent and repeatable execution.
• Installed Oracle 12c database for Talend ETL tool and Oracle OBIEE Fusion Middleware.
• Migrated Oracle database from Solaris 10 to AWS EC2 RHL 7 instance running Oracle 12c EE.
• Provided data model guidance to reports developer team in designing new 2.0 version reports, while supporting the legacy reporting system.
• Responsible for all the activities related to the development, implementation, administration and support for new ETL data warehouses using Talend.
• Created SOP documents for each database task and uploaded them to Confluence.
• Supported DR fail-over between data center activities and also tested RMAN restore and recovery of production database.

Confidential - Brooklyn, NY

Senior Oracle Database Administrator

Responsibilities:

• Rectified production problems and bugs.
• Liaised with Oracle support to coordinate/apply patch sets seamlessly.
• Performed database performance tuning, optimization, troubleshooting and problem resolution.
• Refreshed development/staging/integration databases from production dataset.
• Installed, configured, upgraded and migrated ORACLE server software.
• Installed, configured, maintained, and monitored Automatic Storage Management (ASM).
• Used database tool ERWIN for the logical and physical design of databases/systems.
• Collaborated in database design, creation, configuration, sizing, capacity growth planning, monitoring and auditing of GB/TB production database(s).
• Assisted with ETL SQL code tuning, optimization, rectification, and resolution.
• Interpreted ASH, ADDM, AWR and Stat pack reports for managers
• Supported issues relating to MongoDB, Vertica, and Postgres.
• Participated in disaster recovery testing using DG broker switchover operations between data centers.
• Implemented Oracle Data Guard, (Physical & Logical), Materialized Views and Oracle Golden Gate.
• Created Oracle instances in AWS RDS cloud and migrated databases <50GB using data pump exp/imp solution.
• Created Postgres instance in AWS RDS cloud and implemented streaming replication.