Senior Oracle Database Administrator Resume

SUMMARY

Manage complex technical projects from conceptualization to implementation within defined cost, scope, and timeline.
Identify opportunities to leverage solutions across technologies.
Initiate strategic and tactical planning for enterprise technologies in alignment with business goals.
18+ years of extensive experience in relational database system analysis, design, and implementation in data centers as well as cloud (AWS, Confidential Cloud).
Install, configure, upgrade, performance tune and test relational databases per organization’s requirements.
Identify total solutions for key business issues, evaluate and analyze root causes, and implement solutions in a structured and disciplined manner.
Leverage virtualization and cloud technologies to serve the needs of the enterprise.
Strong ability to grasp and debug issues while performing multiple tasks in fast - paced environments.
Outstanding experience in customer-oriented support and interaction.

CORE COMPETENCIES

TECHNICAL SKILLS

Coursework: Enterprise DBA Backup, Recovery, Performance and Tuning; SQL Tuning; & Data Modeling and Database Design

Skills: Database Management, Management Consultation, Data Warehouse Management, & Data Processing/Database Administration

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Database Administrator

Responsibilities:

As a passionate advocate of AWS within the project, I migrated Test and Dev database to AWS cloud, we tested RDS first, but to have a replica of Test and Dev that we can deploy as Database As A Service solution we chose EC2 with Ansible Playbook (a configuration management, application deployment, task automation).
Install and configure Oracle databases in Confidential, HPE, and AWS environments
Upgrade or patch Oracle databases to meet security requirements
Analyze vulnerability scan reports and resolve findings following DISA’s Security Technical Implementation Guides (STIG) requirements
Performance tune Oracle databases to support millions of concurrent transactions during peak Open Enrollment periods
Configure and manage Oracle Real Application Clusters (RAC) databases running in Oracle Exadata Database machine environments.
Tuned SQL queries to take advantage of Exadata smart scans, storage indexes, ESFC, parallelism and partitioning
Troubleshoot database performance for Alfresco application as well as in-house built java applications on Red Hat JBoss SOA-P/Fuse or Spring Batch Framework

Confidential, Virginia Beach, VA

Data Engineering Lead

Responsibilities:

Enterprise level database planning, analysis, design, development, and implementation.
Projected long-range requirements for database administration.
Planned and engineered database migration.
Researched, evaluated, and recommended new database technology.
Managed structured and unstructured data.
Lead integrated technical team with a number of key stakeholders (including federal employees, contractors, and subcontractors).
Evaluated work and prepared performance reports.
Evaluated and tested upgrades to current database structures and software.
Consulted with and advised users on various databases.

Confidential, Ashburn, VA

Sr. Database Administrator

Responsibilities:

Optimized performance of existing databases by reorganizing and restricting to meet Optimal Flexible Architecture (OFA) standards
Installed and configured Oracle Grid Control, which allowed central management and administration of all databases on various hosts.
Ensured database security by creating and assigning appropriate roles and privileges to users depending on user activity.
Identified resource-intensive SQL statements by illustrating time periods for database activity and high-load SQL statistics.
Diagnosed key issues and recommended solutions for problems such as expensive SQL statements, I/O performance issues, locking and concurrency issues, excessive parsing resource bottlenecks, etc.
Installation and configuration of real application clusters (RAC) databases.
Managed the installation and configuration of databases for development, testing, and production environments.
Utilized and maintained active Dataguard for standby databases disaster recovery, and HA using GoldenGate.
Created and configured new databases using DCBA and applied quarterly patches to non-RAC and RAC configured databases.
Oversaw the performance of backup and recovery.
Completed data migration