SUMMARY:

• An accomplished Oracle DBA who is an Oracle Certified Professional (OCP) with 12 years of professional experience in Database Administration across multiple Fortune 500 clients and varied technical environments.
• Experienced in architecting and supporting high availability production Oracle databases which are critical to client’s core business.
• Implementation expertise with Oracle RAC 11gR2; skilled at administrating Oracle 10g and 11g RAC and ASM.
• Experienced in installation and configuration of Oracle 9i, 10g, 11g, and 12c databases as well as patching and upgrading.
• Skilled in troubleshooting performance and tuning problems in Oracle databases using Oracle Grid Control, Oracle Cloud Control, AWR, StatsPack, Explain Plan, tkprof, and Metalink research.
• Thorough knowledge of backup strategies, including the use of RMAN, Data Guard, Import/Export as well as physical and logical backups.
• Well versed in implementing and enforcing database security consistent with organization controls and audit requirements.
• Precise and effective communicator able to convey complex technical ideas and execute detailed project plans.

TECHNICAL SKILLS:

DBMSs: Oracle 12c, Oracle 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 10gR1, Oracle 9i

Programming Languages: SQL, PL/SQL, Shell

Operating Systems: Oracle Linux, Redhat Linux, AIX, Confidential /UX, Sun Solaris, Windows Products

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA

Responsibilities:

• Successfully architect, implement, and support a 2 - node 11gR2 Oracle cluster for Confidential ’s primary well management application (Avocet) running on a 3TB database.
• Enforce database security standardization effort to implement profiles and security change control procedures for sensitive data stores.
• Help development and application support teams in resolving performance issues by reviewing queries, tracing sessions, and recommending improvements.
• Register regular and Severity One SRs with Oracle Support to resolve critical production support issues.
• Lead data refreshes and migrations utilizing RMAN, datapump, and SAN snapshot technology.
• Successfully lead database upgrade and platform migration of Confidential ’s Endur platform from 10g Solaris to 11g on Linux.
• Upgrade, migrate, consolidate and patch 9i, 10g, 11g, and 12c databases from Solaris standardizing on Linux.
• Build and deploy standard RMAN and datapump scripts used to backup all production environments to 300TB EMC DataDomain.
• Author significant original documentation of DBA standards and practices for Confidential ’s Sharepoint library.
• Develop and coordinate detailed project plans for large-scale upgrade and migration projects.
• Participate in production Oracle database 24x7 on call support. Provide rotation support for Confidential ’s international divisions in Scotland, Canada, Argentina, Australia and Egypt.

Confidential

Oracle 10g and 11g RAC DBA

Responsibilities:

• Coordinated LUN configuration and executed ASM standards for all environments running ASM
• Built standby database in Victoria, TX to receive log-shipping from primary oracle cluster.
• Wrote the standard RMAN backup job now in place on all University Oracle databases and directed numerous RMAN activities such as cloning, standby creation, and restore testing. Installed and configure the 11g RMAN repository database.
• Tuned and optimized long running queries in several environments.
• Lead several upgrades and migrations including Oracle 10g to 11g, Solaris to RedHat Linux, non-RAC to RAC.

Confidential

9i and 10g DBA

Responsibilities:

• Performed server migrations of test and production databases.
• Developed and documented the team’s standard procedures for testing RMAN backups across the entire organization
• Patched instances from 9.2.0.3 to 9.2.0.8
• Engaged Oracle Support to resolve several issues
• Performed query and system tuning and troubleshooting with application developers
• Enforced strict change control procedures of PL/SQL code from test to production environments.

Confidential

Lead Database Administrator

Responsibilities:

• Performed detailed database tuning activities in the warehouse management system leading to significant improvement in user response time.
• Resolved issues with RAC configuration.
• Implemented standard backup strategy across all production databases
• Provided to junior DBAs.
• Built new Oracle environments, cloned oracle databases and restored backups.

Oracle 10g DBA

Confidential

Responsibilities:

• Interviewed technical resources including developers, vendors, end-users and management to gain insight into performance issues.
• Analyzed data from Oracle StatsPack to pinpoint performance issues.
• Developed recommendations to improve database performance and maximize throughput.
• Recommend a long-term strategy to ensure system sustainability.
• Tought a seminar for developers on SQL tuning methodology and best practices.

9i and 10g DBA

Confidential

Responsibilities:

• Write and tune PL/SQL Packages.
• Installed and configured Oracle 9.2.0.5 instances.
• Migrated 9i databases to 10g.
• Assisted in developing and instituting a backup strategy and ensured high availability through the use of Oracle Dataguard.
• Performed imports and exports of production data to development and testing instances.

Oracle DBA

Confidential

Responsibilities:

• Wrote Perl scripts and PL/SQL packages to gather and report system metrics.
• Monitored production systems during first and second shift.
• Monitored and investigated alert log errors, tkprof and examined trace files.
• Assisted in patching and cloning of Oracle Applications instances.
• Coordinated with Oracle Support to resolve service requests from level-1 to level-4.