Oracle DBA Resume

SUMMARY

A results - driven, determined, and innovative senior database administrator with vast experience in applications management, website management, troubleshooting and testing, quality assurance, infrastructure operations, disaster recovery and backup, strategic planning, process improvement, performance management, and implementations and installations.
Additional proficiencies include programming, security management, and systems management.
A resourceful and dependable proven performer with strong problem-solving skills who enables an organization to deliver creative solutions in a fast-paced environment while overcoming challenges and ensuring top-performing and highly efficient workflow processes.

TECHNICAL SKILLS

Oracle DBA 12c, 11g, 10g, 9i, 8i, RMAN, TSM, RAC, DATAGUARD, GRID/Cloud CONTROL
GOLDEN GATE, STREAMS, RAC, Veridata, DataDomain, NetApp Snap Center,
SQL Server 2012, 2014, 2016, & 2017, DB2/UDB DBA 7.1, 8.2, 9 HA,11.5 MySQL 8.0, Solarwind

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

Managed Oracle databases using Oracle Enterprise Manager and performed DR test form primary data center and DR site.
Configure and setting up Oracle 11gR2 Data Guard, managing Data Guard using a Data Guard broker, and troubleshooting and resolving log gaps in Data Guard configurations.
Installed and configured Oracle Transparent Gateway for SQL servers and tables sync between Oracle and SQL server.
Performed tuning SQL statements utilize Solarwind and Oracle enterprise management to improve SQL execution.
Consolidated Monitoring Oracle database on Oracle Cloud, AWS, and Oracle managed services.
Administered Oracle Database Classic Cloud Service and PaaS (Platform as Service).
Supervised databases on premises and cloud databases utilize Oracle Hybrid cloud Gateway.
Migrated AGILE production database instance from to staging environment .

Confidential

SQL Server/DB2 DBA

Responsibilities:

Oversaw SQL server administration. Created new SQL server database, backup/restore SQL database troubleshoot turning queries, and monitored HA availability group and database jobs.
Setup Spotlight monitoring windows and SQL servers and managed database capacity and performance problems. Troubleshot applications blocking problem using spotlight historical record to recommend better databases or system parameter.
Created and maintained database management plan to clean up history, backup, reorg databases, and setup operators’ notifications.
Led pssdiag utility to gather system statistic and execution plan for developers for troubleshooting apps and recommended optimal SQL server configuration and indexes to achieve better performance.
Utilized IBM data manager directing DB2 databases setup backups, run stats, and blocking and developed customize reports alerting for failing jobs.
Performed test semi-annual DR databases recovery and coordinated with network and storage to archive DR success.

Confidential

Senior DBA

Responsibilities:

Setup and configured Goldengate to replicate multitera bytes databases and implemented bi-directional mult-sites replications.
Implemented and configured grid control monitoring databases problem and performance and user defined metric to monitor databases and middleware health.
Established grid control alerts to email and page dba group when metric condition meet requirement.
Pushed OEM plugins for different middlewares and clients performing monitor targets.
Installed and configured RAC databases.
Oversaw installations GoldenGate and Veridata replicating multi-DataCenter transactions and monitoring transactions.
Migrated execution plans from 11gr2 to 12c ensuring database performance.