SUMMARY:

• Oracle Database Administrator skilled in Database Operations, including production support, build, installation and development, performance analysis and tuning, refresh cloning.
• ETL, backup and recovery, disaster recovery, security vulnerability remediation, database upgrades, patching and migrations.
• Quality minded professional dedicated to getting the job done while remaining calm under pressure.

TECHNICAL SKILLS:

RDBMS: Oracle 12c, 11g, 10g, 9i, 8, 7

Languages: SQL, PLSQL, Korn Shell, Cobol, Fortran, C, Basica, HTML

Platforms: UNIX RHEL Linux, Oracle Linux, AIX, HPUX, Solaris, Windows

Utilities: RMAN, Golden Gate, Data Guard, RAC, ASM, SQLnet, Data Pump, Export/Import, SQLloader

Applications: PeopleSoft, JDE, OBIEE, Siebel, MS Suite (Excel, PowerPoint, Word)

Concepts / Tools: HA, vi editor, vncserver, scp, ftp, topas, crontab, Slack, ETL extract, transform, load

Other: Security Vulnerability Remediation, Change/Issue Management, SME and Root Cause Analysis

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Senior Oracle Database Administrator

Responsibilities:

• Led US Shift over 5 DBAs for a period of 1.5years, collaborating with Apps Management and offshore team to split up customers so each DBA would have a primary and secondary set of environments to focus on; Developed team camaraderie during team meetings and allowed DBAs to suggest technical knowledge sharing projects and volunteer for focused assignments.
• Performed Database Health Checks to keep databases performance at peak level, addressing any issues, performing reorgs of tables and indexes, and working to tune problem SQL. Met with customers to review Database Health Check findings and worked to schedule Environment outages for maintenance as needed, ensuring all environments were performing at peak efficiency.
• Determined space needs and defined filesystem layouts, designed parameters used, installed and configured oracle software and SQLnet. Created shell scripts for database creation, including adding datafiles, tablespaces, security profiles, roles and users. Used oracle export / import and data pump tools to load databases. Setup scheduled crontab maintenance scripts, including refreshing statistics, automated performance checks, and RMAN backups for database and archive logs. DBA customer contact for the projects and key resource for the environment go - live and through stabilization to migrate new customers into IBM's hosting umbrella.
• Appointed as representative to the IBM Technology Leadership Team, enabling technical information to be shared across the company.
• Collaborated with Change Management to create, update change tickets with build plans, as well as test, backout and notification plans. Reviewed change tickets to ensure proper steps and added DBA resources to do the work by managing change tickets properly resulted in environment stability.
• Worked cross-functionally to get Golden Gate Replication configured and working, stabilizing replication flow and resolving crippling hang situations.
• Developed an expertise in the area of Performance Analysis looking at the top bottleneck issues of the multi-tier system by looking at each servers’ CPU and memory using tools such as topas and custom SQL scripts. Performance issue root causes varied from CPU consumption, memory starvation, and in other cases issue found long running SQL requiring tuning. Pulled AWR snapshot reports, analyzed details and put in fixes, including tuning long running SQL and rebuilding table and indexes.
• Performed all variation of database refreshes by exporting source and importing into target side using export, import data pump utilities. Identifying which method fit each situation and performing flawlessly led to stable environments and customer satisfaction.
• Upgraded databases through major version migration as well as performing more minor-level upgrades and patching of CPU, PSU, and minor issues using opatch.

Confidential, Phoenix, AZ

Senior Oracle Database Administrator

Responsibilities:

• Co-led Database Build Team with App Lead Admin. Developed Standards upon which all Environments would be built.
• Acted as primary DBA building new environments for new contracts building server out using OFA standards, configuring parameters, installing Oracle, creating shell DB, importing legacy.
• Source, and configuring SQLnet as well as transitioning stable environments to production support.
• Performed all facets of production support DBA, including physical database refreshing, performance issue troubleshooting and analysis, performed DB backups and recoveries
• Investigated database issues, applied patches, upgraded, migrated environments; Performed emergency recoveries when required.

Confidential, Phoenix, AZ

Oracle Database Administrator

Responsibilities:

• Supported Application development team as DBA on several internal Business and Engineering projects.
• Worked with entity relationship models in Erwin and the Data Modelers and Application Developers supporting development of Data Warehouse and other application databases.
• As DBA was an important member of the team enabling steady flow of Application development accomplishments. Involved in ETL process for Data Warehouse.
• Documented internal naming standards for database objects such as tables, indexes, procedures and functions which enabled design consistency and development speed.
• Worked with Oracle database and SQL Server