SUMMARY

• An experienced Database Administrator, Analyst and Architect with in - depth knowledge of Oracle principles, practices and database operations.
• I have enjoyed my strong background in performance tuning, implementing data migrations, capacity planning, trending and predicting space requirements, backup and recovery.
• I am skilled in problem solving and systems integration, a visionary, mentor, and a proven leader.
• Experienced in cost effectively leveraging technology to achieve organizational objectives.
• I complete large-scale projects on time within budget.
• Proven experience in the installation and upgrade of Oracle databases and implementing security measures adhering to federal auditing requirements.
• I consistently maintain a close working relationship with Oracle support via MetaLink (MOS), when I don’t know how I can find out how.
• Proven ability to interact and communicate well with all levels of management, clients, and peers.
• My record proves I excel in autonomous roles, as team leader and as team member.
• I relish an environment where I can share my experience and learn from others.
• My past is the foundation of my limitless future.

TECHNICAL SKILLS

Database Activities: Database Performance Tuning, SQL, PL/SQL Tuning, System Optimization, Patching, Upgrades, Partitioning, Physical/Logical Modeling, Capacity Planning/Trending, Refreshes/Cloning, Security, Backup & Recovery Optimization, Migrations, Real Application Testing (RAT), Reorganizations and Space Reclamations

Oracle Tools/Utilities/Features: Exadata, CRS, RAC, ASM, DataGuard, GoldenGate, RMAN, Flashback, OCM, OEM Grid Control - 9i,10g,11g, 12c, AWR, ADDM, SQL Advisor, SPM, Segment Advisor, Memory Advisor, Optimizer, AMM, Data Pump, Export/Import, MV’s, DBMS Jobs, DBMS Scheduler, OWB, Discoverer

Scripting Languages: DDL, SQL, PL/SQL, BASH and KornShell

Operating Systems: AIX, HP-UX, Linux, Red Hat Linux (RHEL) Solaris, VMS, Windows

Additional Tools: TOAD, Spotlight, Erwin, Visio, MS Office, Putty, Exceed, Tivoli, Remedy

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA

Responsibilities:

• Lead DBA for the Pulse monitoring system.
• Successfully supported 7 Terabyte production database maintenance, partitioning, tuning, growth analysis and problem resolutions including testing databases and developer support.
• Identified database row contentions within Pulse application SQL.
• Completed 11.2.0.4 upgrade and created new Exadata based database for RAT testing.
• Migrated and converted 7 Terabytes of OS file systems to Exadata based ASM.
• Presented my well received evidence and analysis of performance solutions for database and Pulse system at Executive Management meeting.

Technical Environment: Oracle 11.2.0.3, 11.2.0.4, RHEL, Exadata, SQL, PL/SQL, ASM, DataGuard, Tivoli.

Confidential

Sr. Oracle DBA

Responsibilities:

• Oracle database support, maintenance, tuning, growth analysis, problem resolution.
• ASM disk space analysis and growth trending.
• Performance issue identification and resolutions.
• DataGuard support, issue identification and resolutions.
• Backup and recovery.
• Database Auditing.
• DBMS scheduling and Job automation.
• OEM 12c installation, support and maintenance.
• Spectrum application support and maintenance.

Technical Environment: Oracle 11.2.0.4, SQL, PL/SQL, ASM and shell scripting, IBM AIX 7.x.

Confidential

Sr. Oracle DBA

Responsibilities:

• Sole Oracle DBA on-site.
• Stabilization and performance tuning of development, testing and production Oracle databases.
• Analyzed and modified Linux environments in preparation for Disaster Recovery testing.
• Completed Oracle database, CRS and TNS upgrades.
• Optimized RMAN backup procedures.
• Added and updated OEM12c configurations and targets.
• Conducted DataGuard failover testing.
• Database support, maintenance, issue isolation and resolution.

Technical Environment: Oracle 11.2.0.3, 11.2.0.4, OEM12c, SQL, PL/SQL and shell scripting, Oracle Linux x86 64.

Confidential

Sr. Oracle DBA

Responsibilities:

• OEM12c Super Admin privileges across enterprise.
• Installed, configured and monitored OEM12c agents for over 1000 database targets across more than 4000 clustered hosts.
• Team liaison with new change management initiative.
• Created and maintained standards, install and upgrade documentation.
• DataGuard and GoldenGate installations, maintenance and support.
• Identified existing issues and provided resolutions for databases and environments.
• Performed SQL, PL/SQL tuning on existing production issues.
• Completed capacity planning and growth trending.
• Completed Oracle upgrades and patching across database platforms.
• Participated in production, testing and development database support.
• Participated in 24/7 on-call rotation.

Technical Environment: Oracle 10.1 to 12.1, OEM12c, SQL, PL/SQL and shell scripting, Oracle Linux x86 64.

Confidential

Sr. Oracle DBA

Responsibilities:

• Identified existing issues and provided resolutions.
• Performed SQL, PL/SQL tuning on existing production issues.
• Installed and configured OEM12c.
• Added and configured 120 targets monitored across 11 hosts including OCM configurations for patch support.
• Completed capacity planning and grow trending.
• Created k-Shell scripts for maintenance and automated common tasks.
• Created a 2-node standby cluster for production with a 3-node standby.
• Failed over production to standby1 using standby2 as standby then rebuilt 3-node production cluster from scratch after EMC drive enclosure replacement.
• Failed back to production 3-node cluster for each database, reset standby1 back to standby and added third node and instances to 2-node standby.

Technical Environment: Oracle 11.1 and 11.2, Cloud Control, SQL, PL/SQL and shell scripting, Oracle Linux x86 64.

Confidential

DBA Team Leader

Responsibilities:

• Consistently maintained 99.999% scheduled uptime on our assigned databases.
• Performed SQL, PL/SQL and k-Shell script maintenance on existing monitoring scripts and automated common tasks.
• Developed and implemented purging routines to archive unneeded data.
• Automated index analysis, rebuilds and statistics.
• Participated in Disaster Recovery planning, preparedness and exercise.
• Identified, performance tuned, and resolved problematic processes and areas needing improvement.
• Established quality standards and SOPs.
• Documented existing processes and created documentation for new processes.

Technical Environment: Oracle 7.3, 8.1, 9.2, 10.2 and 11.2 using in-house developed shell scripts, OEM, TOAD - DBA Edition, SQL, PL/SQL, shell scripting, AIX, Solaris.

Confidential

Oracle DBA

Responsibilities:

• Created backup scripts utilizing the latest Oracle RMAN functionality, improving reliability, and backup run times, and decreasing space needed for backups.
• Identified and provided solution for discrepancies in current backup strategy and SLA.
• Created and deployed automated RMAN maintenance processes via DBMS Scheduler.
• Created new RMAN catalog based backup reports.
• Provided troubleshooting and resolutions for RMAN and NetBackup failures.
• Provided level 2 Oracle Global support.

Technical Environment: Oracle 9.2, 10.1, 10.2, 11.1 and 11.2 using OEM Grid Control, SQL, PL/SQL and shell scripting on Linux and AIX.

Confidential

Sr. Oracle DBA

Responsibilities:

• I developed and implemented scripts with supporting documentation to perform PSU upgrades and completed quarterly upgrades for over 600 hosts, databases and listeners.
• Provided recommendations for Oracle utility installation, maintenance and use including GRID, Data Guard, gather statistics procedures, flashback, AWR, AMM, OCM, EMCLI, ASM, Agentca, command line blackout control and OEM target control.
• I performed OEM, OMS and agent troubleshooting and issue resolution, created reports, created and maintained jobs, and maintained targets.
• Monitored databases for performance issues and provided effective tuning recommendations.
• Created a PL/SQL procedure allowing inserts, updates and deletes on all authorized tables providing email notifications and before/after data snapshots to Management, Security personnel and DBAs with documentation.
• I designed and developed a process to migrate DBMS Jobs to DBMS Scheduler jobs.
• I also performed other standard DBA duties as needed including import/exports, peer support, problem analysis and troubleshooting, object creation and database performance analyses.
• Created documentation for standards and processes.

Technical Environment: Oracle 10.2 and 11.1 using OEM Grid Control, SQL, PL/SQL and shell scripting on AIX Power Servers.

Confidential

Sr. Oracle DBA

Responsibilities:

• Completed design, installation, configuration, and database migrations onto 11g RAC clusters in production and UAT environments utilizing ASM on a NetApps SAN including 6T and 4T databases.
• Performed extensive performance analysis and modifications to a 1T data distribution database and provided script improvements.
• Identified and provided solutions for database bottlenecks improving performance and reliability.
• Successfully analyzed and completed performance improvements of numerous SQL and PL/SQL scripts dramatically improving application performance.
• Mentored application developers on database and code performance principles and concepts.
• Effectively modified database objects and participated in application deployments.
• Installed, configured, patched, migrated, completed capacity plans, monitored and implemented performance improvements of 40 Oracle databases on versions 9.2, 10.2, or 11.1.
• Participated in OEM deployment; monitoring, established metrics, policies, and job automation.
• Gathered and analyzed requirements and produced capacity plan for disk drive layouts utilizing Oracle ASM.
• Completed test and development database and schema refreshes using export/import or data pump and manual cloning with RMAN.
• Implemented database changes into test from development databases and tested indexes to measure improvement levels.
• Conducted code reviews and improved code performance for the ETL, BI and application development teams.
• Participated on the team architecting the new RAC and SAN environments.
• Migrated jobs using shell scripts from Linux crontab to OEM job control.
• Gathered and analyzed IOPS statistics to determine number and speed of disks needed to support database performance levels to deploy 6 databases onto 6 ASM disk environments.
• Completed analysis and recommendations of backup and recovery procedures.
• Created RMAN and export jobs scheduled in OEM.
• Participated in establishing database standards for object naming conventions.
• Utilized SQL and PL/SQL scripts, OEM, TOAD and Spotlight to monitor and analyze performance, usage levels and database metadata and utilized Linux utilities; top, iostat, vmstat and mpstat.

Technical Environment: Oracle 9.2, 10.2 and 11.1 using Oracle Enterprise Manager Grid Control, TOAD - DBA Edition, SpotLight, SQL, PL/SQL and shell scripting, Red Hat Linux, Sun-Solaris.

Confidential

Oracle Database Architect and Team Leader

Responsibilities:

• Supervised and directed a 5 member team and worked with application development teams as Architect to improve automated application system upgrade quality. Success rates were improved from 40% to 93% in client hosted environments and to 99% in hosted environments.
• Designed and implemented a work plan to move a 9i RAC to new hardware without downtime. For creating and implementing this successful work plan I won an award and it became the company wide standard for new hardware implementation and maintaining our 99.99% uptime target.
• Analyzed and provided 8 major 9i database improvements to be implemented across the enterprise.
• Performed DBA mentoring, determined and implemented best practices, created departmental standards, created and approved change management plans, created capacity and space management plans, maintained disaster preparedness, and archival systems.
• Completed spring and fall 2007 Daylight Savings Time audits, isolated discrepancies, and completed patches or upgrades on 68 production databases.
• Personally maintained 99.99% uptime of 18 OLTP production databases, over 9 Terabytes in total size, for 20 months and migrated new database objects from over 72 test, UAT, and QA databases.
• Conducted performance tuning, troubleshooting, contention identification and resolution, performed backup and recovery audits and implementation, upgrades and migrations including 8i to 9i and 9i to 10g on both RAC and non-RAC databases.

Technical Environment: Oracle 8i, 9i, 10g, shell scripting, SQL, PL/SQL, CCL, AIX, VMS.

Confidential

Senior Consultant/DBA

Responsibilities:

• I led the ETL development team for this project and also designed and implemented a manufacturing metrics data warehouse migrating over 20 years of mainframe legacy data to an AIX environment on Oracle 8i using Oracle Warehouse Builder for work flow, data modeling, and some ETL generation.
• Analyzed and created over 2,300 database objects to improve referential integrity, enforce constraints, and improve performance of a PeopleSoft ERP system supporting 3,000 users on an Oracle 8i database. A $3.7M contractual bonus was awarded by resolving the performance issues on time and within budget.
• Analyzed system requirements, produced capacity and security plans, performed installations and configurations for 8 databases on Oracle 8i.
• Designed performance benchmark comparing IBM390 Oracle to a client-server Oracle 8i database
• Designed and implemented a financial data mart on Oracle 8i providing customized financial data to department heads, the C-level executives and members of the DOE/NNSA.
• I installed, supported, developed reports, and conducted Oracle Discoverer user training in developing specific reports.
• I automated over 180 jobs and metadata reports using OEM.
• Conducted advanced security audits and investigations providing improvement and product recommendations at a Top Secret level.

Technical Environment: Oracle 8i, 9.1, OEM Console, shell scripting, SQL, PL/SQL, Oracle Warehouse Builder, Oracle Discoverer, Erwin, AIX, Windows, Sun-Solaris.

Confidential

Database Analyst

Responsibilities:

• Primary DBA for 14 production databases performed tuning, backup/recovery, patches and upgrades, and participated on development teams for system improvements.
• Designed, created and implemented 5 data marts and a data hub used for data standardization and sterilization which then pushed data into the marts. Erwin was used for physical and logical data models. Established capacity plans and backup/recovery methods.
• Designed and established security procedures, backup/recovery plans, change management plans, capacity and space management plans, disaster preparedness and archival programs, and procedures to maintain data per legal department archival specifications.
• Functioned as a project leader, mentor and assigned tasks to four junior database analysts

Technical Environment: Oracle 7.1, 7.2, 8.0 and 8.1, shell scripting, SQL, PL/SQL, Erwin, AIX and Sun-Solaris.