TECHNICAL SKILLS:

Operating Systems: Windows 2010/XP R2, HP - UX, Sun Solaris, AIX, RED-HAT Linux

Ancillary Skills: Business Tools: AWR & ADDM report, SQL Tuning Advisor, OEM 12C, TOAD, Oracle FailSafe, MS Failover Cluster, Cache, RAC, RMAN, Data Guard, SQL Diagnostic Manager

PROFESSIONAL EXPERIENCE:

Confidential - Birmingham, AL

Database Administrator

Responsibilities:

• Provide tech support on multiple platforms (AIX & Windows).
• Perform Oracle / SQL Server database administration, performance & SQL Tuning in Oracle11gR2 & 12c using OEM 13c, ASM, Oracle SpotLight, SQL Developer, TOAD, SQL Activity Monitor, and Idera SQL Diagnostic Manager.
• Created / maintain standard documents for Oracle & SQL Servers for varies maintenance and support tasks.
• Provide tech support for SQL Server databases.
• Create SQL Server backups jobs using Maintenance Plan via SQL Server Management Studio.
• Setup SQL Server Transactional Replication in cluster environment.
• Setup SQL 2017 Always-On for High Availability & Disaster Recovery.
• Setup SQL 2019 on a single server & two node cluster servers.
• Create GOLD agent image to push agent to multiple servers via OEM
• Perform imports & exports using Oracle Data Pump utility.
• Create Oracle backup jobs via OEM Scheduler to monitor backups using RMAN utilities.
• Duplicate databases from active DB using RMAN.
• Responsible for database environment DR testing.
• Setup Oracle Data Guard for Disaster Recovery.

Confidential, Atlanta, GA

Sr. Oracle Database Administrator

Responsibilities:

• Provide tech support on multiple platforms (LINUX, SUN, HP, AIX, & Windows).
• Provide support for Golden Gate databases.
• Perform database administration, performance & SQL Tuning in Oracle 10g &11gR2 using OEM 12c & TOAD.
• Perform imports & exports using Oracle Data Pump utility.
• Monitor backups using RMAN utilities.
• Provide support for databases with Materialized Views.

Confidential, Atlanta, GA

Sr. Oracle Database Administrator

Responsibilities:

• Provided tech support on multiple platforms (LINUX, SUN, HP, AIX, & Windows).
• Performed database administration, performance & SQL Tuning in Oracle 11gR2 using OEM 12c.
• Refreshed schemas from production to development using the Oracle Data Pump utility.
• Used RMAN for backup & disaster recovery.
• Installed & maintained Oracle 11gR2 software, create & troubleshoot oracle databases, & applied Oracle PSU Patches.

Confidential, Atlanta, GA

Sr. Oracle DBA / SQL Server DBA

Responsibilities:

• Provided technical support on multiple platforms (AIX & Windows 2008) for Oracle & SQL Server databases.
• Provided Oracle support for the ADP databases, which included payroll, investments, & Insurance applications. Setup the Cluster failover for these databases using Oracle FailSafe & MS Cluster.
• Provided Oracle support for the SIS (Surgical Information Systems) databases, which was used by the Surgeons to schedule their surgeries. I also, setup the Cluster failover for the SIS databases using Oracle FailSafe & MS Cluster.
• Provided SQL Server support for the Electronic Health Records (EHR) & Customer Relationship Management (CRM) databases.
• Worked on projects with the project managers & vendors to assist with the implementation of SQL Server databases.
• Mentored and cross-trained 4 SQL Server DBAs on Oracle database systems.
• Installed & maintained Oracle 10g & 11gR2 software, created databases, & applied Oracle PSU Patches.
• Installed OEM 12c to performed database administration, troubleshoots database & SQL performance issues.
• Performed schemas refresh using the Oracle Data Pump utility.
• Created & implemented backup & recovery procedures for all Oracle databases using the RMAN utility.
• Installed SQL-Server 2008 R2 & 2012 on Windows 2008 Cluster Servers.
• Created SQL-Server Maintenance Plans, Link servers, & Deployed SSIS packages.
• S etup & performed backup & recovery for SQL 2008 R2 & 2012.

Confidential, Atlanta, GA

Sr. Oracle Database Administrator

Responsibilities:

• Provided tech support on multiple platforms (LINUX, SUN, HP, AIX, & Windows).
• Installed & maintain Oracle 10g & 11gR2 software, created & troubleshoot oracle databases, & apply Oracle Security/CPU/DST/PSU Patches.
• Performed database administration, performance & SQL Tuning in Oracle 10g & 11gR2 using OEM 12c.
• Monitored & supported ASM & Oracle RAC databases.
• Performed imports & exports using Oracle Data Pump utility.
• M onitored backups using SQL-Backtrack & RMAN utilities.

Confidential, Atlanta, GA

Sr. Oracle Database Administrator

Responsibilities:

• Provided tech support for STEP application on LINUX, SUN, HP UNIX,
• & Windows OLTP database servers. The sizes ranged from 3.2GB to 5TB.
• Installed & maintained Oracle 10g & 11gR2 software, created & troubleshoot oracle databases, & applied Oracle Security/CPU/DST Patches manually & via GUI.
• Installed & maintained WebSphere, Apache, & STEP application.
• Performed database administration using Oracle 10g & 11g scripts.
• Monitored & supported ASM & Oracle RAC databases.
• Performed imports & exports using Oracle Data Pump utility.
• Setup backups using RMAN utility.

Confidential, Dubuque, IA

Oracle Database Administrator

Responsibilities:

• Provided 24x7 support as member of Confidential Global Services DBA team on LINUX, SUN & HP UNIX OLTP database servers. The sizes ranged from 3.2GB to 7TB.
• Used VERITAS HA Cluster for stopping & failing over the database clusters.
• Installed & configured oracle software, created & troubleshoot oracle databases, & applied Oracle Security/CPU/DST Patches.
• Monitored & supported ASM & Oracle RAC databases.
• Performed database administration & SQL Tuning using Oracle 9i, 10g OEM Grid, 11g, & cron scripts.
• Refreshed databases using RMAN & FlashCopy methods.

Confidential, Atlanta, GA

Production Oracle Database Administrator

Responsibilities:

• Provided 24x7 production support for Oracle OLTP databases on AIX, HP, & SUN Solaris (8, 9 & 10) environments (sizes .5GB-2TB).
• Monitored database performance using monitoring scripts.
• Performed database administration & performance tuning using OEM (10g).
• Used VERITAS HA Cluster for stopping & failing over the database clusters.
• Performed Oracle upgrades & apply CPU patches.
• Used Oracle Data Guard for Standby databases.
• Monitored backups using RMAN & SQL Backtrack.

Confidential - Atlanta, GA

Production Oracle Database Administrator

Responsibilities:

• Provided production support for PeopleSoft HR & Financial OLTP databases in a SUN Solaris environment (sizes 50GB-160GB).
• Installed & configured PeopleSoft database in development.
• Used Oracle Data Guard for PeopleSoft Standby databases.
• Monitored database performance using OEM (10g) & monitoring scripts.
• Performed database & SQL Tuning using 10g SQL Tuning Advisor.
• Monitored backups using RMAN utility.

Confidential, Atlanta, GA

Sr. Oracle Database Administrator

Responsibilities:

• Provided 24x7 support on SUN & HP UNIX for GM & Disney accounts as member of Confidential Global Services DBA team. The sizes ranged from 3.2GB to 2TB.
• Mentored 4 Jr. DBAs on Oracle database systems.
• Used VERITAS HA Cluster for stopping & failing over the database clusters.
• Installed & maintained oracle software, created & troubleshoot oracle databases & applied Oracle Security/CPU/DST Patches.
• Encrypted OLTP databases for PCI compliance using Protegrity (Omni Secure) software.
• Setup backup & recovery using RMAN utility for Oracle 9i databases.
• Performed database administration, performance & SQL Tuning using TOAD, Stats Pack & OEM (10g).
• Provided support for databases with Materialized Views & Partitions.