Sr. Oracle DBA Resume

SUMMARY

An exceptional Database Management Professional with notable expertise designing, coding, developing, and testing dynamic Oracle Database solutions to support operations for high profile clients and government agencies.
Highly skilled in assessing current environments, identifying underperforming areas, and implement technical solutions that increase productivity and performance, and enhance operational efficiency.
Adept in troubleshooting potential problems, bottlenecks, other database failures, and introducing improvements to automate processes to minimize production impact and system downtime.
Experienced in developing and implementing backup and recovery strategies

AREAS OF EXPERTISE

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA

Responsibilities:

Managed the development of strategic plans, frameworks, patterns, and best practices, while collaborating with other IT architects.
Installed Oracle database, Data Guard with Data Broker and Performed multiple Production switchovers using Data guard broker utility of Data guard
Installed and upgraded OEM cloud control from 13.2 to 13.3
Moved Oracle databases from legacy RH6 environment to a new data center RH7 environment
Performed Oracle Database upgrade from 11g to 12c on Linux environment
Performed Oracle Database upgrade from 12c to 19c on Linux environment
Performed Database refresh/cloning using RMAN to duplicate production data to development and testing.
Achieved Backup efficiencies with RMAN, Data Pump, AWS Cloud storage.
Saved a client $440K+ in operational expenses by consolidating server resources and migrating 11g database to 12c.
Successfully migrated all on-premise data and database functions to a cloud environment (AWS)

Confidential

Sr. Oracle DBA

Responsibilities:

Effectively coordinated efforts with application development and project management staff to govern project planning, resource allocation, devise task definitions and establish project schedules for high profile projects involving databases.
Led, planned and designed database changes for successful tool configuration, data refresh, data migration, and data conversion.
Successfully decrease the deliverable time by implementing efficient and accurate measurements.
Effectively monitored all testing, development, and production Oracle databases, including maintenance, upgrades, and issue resolution.

Confidential

Oracle DBA

Responsibilities:

Managed 24 X 7 Production Database Administration, providing ongoing support and monitoring to proactively address system errors and failures with minimal downtime and production impact. Installed and configured Oracle 11gR2 Data Guard, 11gR2 (RAC) on ASM storage, Oracle RAC Clusters, and Oracle RDBMS on UNIX and Windows environments.
Created and managed user accounts, granting and revoking required privileges, developing and managing user groups, and consulting with department managers to identify roles and access requirements.
Developed SQL code, DDL, and DML scripts, to implement new features, perform necessary maintenance and bug fixes, and install specified requirements.
Performed extensive code reviews for Software Development, Data Architects, and Business Intelligence teams. Consistently upgraded system functionality by installing and managing patches and system upgrades to maintain a bug-free environment and increase data integrity.
Designed hot, cold, and RMAN backup and recovery processes, and instituted logical backup script to automate and streamline procedures.

Confidential

Database Administrator

Responsibilities:

Operated as Subject Matter Expert in developing and designing database architectures.
Analyzed existing environments, and reviewed proposals to determine best-case scenarios to properly address business needs and objectives. Installed and maintained Oracle Internet Directory and Application servers and designed and configured database architectures to align with developer and user requirements.
Conducted database tuning to ensure optimal performance and system availability, and installed client-side Oracle on the developer and end-user PCs and ensured network connectivity. Collaborated with developers to build and institute PL/SQL procedures including troubleshooting database problems and failure and running test queries.
Consulted with customers to outline new database features, lead studies to evaluate the effectiveness and existing database methods, and processes, and thoroughly investigate data loss and data corruption immediately to minimize or eliminate production impact.