Oracle Database Administrator

THOMAS WATSON

Moraine, OH ***** 513-***-**** ***********@*****.*** linkedin.com/pub/tom-watson/13/3a7/394cust

DATABASE ADMINISTRATION

Results-driven Database Administrator with a proven track record of success optimizing database performance, automating processes, and ensuring data integrity. Exceptional presentation, negotiation, communication and interpersonal skills with the ability to quickly develop positive rapport with colleagues and management. Effectively communicates and interacts with executives, management, and colleagues. Demonstrated expertise in merging technologies and personnel into team-centered business units.

CORE COMPETENCIES

Database Management Root Cause Analysis Customer Service Data Modelling Team Leadership

Programming Configuration Management

TECHNICAL SKILLS

SQL Server 2012-2022. SSMS Amazon RDS/EC2 Power shell Ansible Tower

Oracle 11G and 12C Database Administration Oracle PL/SQL RMAN Backup and Recovery Oracle Replication Oracle Streams Oracle Goldengate Oracle Enterprise Manager Oracle Data Guard SQL Server PostgreSQL

Sybase Hadoop Spark Scala UNIX Linux CA Erwin UNIX Shell Programming CA Model Mart

Systems Analysis Facets Support

EXPERIENCE

Blue Cross Blue Shield, North Carolina, Durham, NC 04/2019 - Present

Senior Infrastructure Design Engineer

Support SQL Server and Oracle environments, including automation of processes and ensuring database reliability and performance. Provides comprehensive support for Amazon Aurora on AWS RDS and facilitates Facets Database upgrades.

•Support SQL Server.

•Provide 24x7 support for SQL Server.

•Support Oracle, SQL Server, PostgreSQL.

•Automated install of SQL Server using PowerShell.

•Automated Data Load into SQL server using PowerShell and Ansible Tower.

•Automated database refresh with PowerShell.

•Support Amazon Aurora on AWS RDS.

•Support Facets, performing all Facets Database upgrades.

Ingles Markets, Asheville, NC 04/2018 - 04/2019

Lead Database Administrator

•Led a team of three DBAs.

•Provided 24x7 support for Oracle databases, PostgreSQL databases and SQL Server.

•Supported Oracle, SQL Server, PostgreSQL.

•Part of disaster recovery team.

•Upgraded SAP databases to 12c.

•Applied Patches to databases.

•Built up Wiki documentation.

•Tuned queries.

•Supported SAP.

•Organized projects and scheduling of DBA resources.

Fujitsu America, Sr. Oracle DBA, Durham, NC 08/2016 - 03/2018

•Provided 24x7 support for 120 Oracle databases.

•Part of disaster recovery team.

•Upgraded databases to 12c.

•Worked with offshore team to schedule off hour changes and to transfer knowledge of current issues.

•Tuned queries.

•Supported Data Guard standby databases.

•Deployed PL/SQL packages and procedures to production.

•Monitored Service call queue.

•Primary on project to move Oracle 12c database from HPUX to Red Hat Linux.

Nityo Infotech, Sr. Oracle DBA, Raleigh, NC 01/2016 - 08/2016

Contracting to Cigna

•Supported development teams.

•Tuned queries.

•Assisted with writing PL/SQL.

•Deployed PL/SQL packages and procedures to production.

•Scheduled Oracle jobs.

•Advised on new Oracle features in Oracle 12c.

•Provided 2nd level 24X7 support for production databases.

Marriott Vacations Worldwide, Lakeland, FL 06/2014 - 01/2016

Lead Oracle Database Analyst

•Provided 24x7 Oracle database administration support for hundreds of development and production databases running on Windows and Linux Red Hat 6/7 operating systems.

•Migrated Oracle databases from Windows to Linux Red Hat 7.

•Managed the application of quarterly Oracle security patches for Oracle Databases.

•Spearhead the upgrade of databases from 11.1.0.7 to 12.1.0.2

•Member of disaster recovery team.

•Proactively monitored databases using Precise and DB Artisan.

•Actively attend to service calls and provide root cause analysis for them.

•Researched moving Oracle databases to the cloud. Amazon and Oracle were both considered.

•Documented Oracle 12c features for the DBA team.

Northrop Grumman Corporation, Beavercreek, OH 01/2005 - 06/2014

Database Architect IV

•Provided Oracle database administration support for eighteen development databases and 24x7 support for one production database running on Oracle Solaris Sparc 10 and Linux Red Hat 5 operating systems.

•Managed the application of quarterly Oracle security patches for Oracle products (Database, WebLogic, Goldengate).

•Spearheaded the upgrade of databases from 10.2.1 to 11.1.0.7 and then to 11.2.0.3 and cloned databases.

•Proactively monitored databases using Oracle Enterprise Manager and provided timely support for Oracle RAC running on a two-node Linux operating system.

•Actively attended to service calls and provided root cause analysis for them, support Oracle Goldengate replication, Oracle Streams, Oracle WebLogic.

•Imparted training to newly recruited employees on Oracle database administration.

ADDITIONAL RELEVANT EXPERIENCE

Hewlett Packard, Cincinnati, OH

Database Administrator

Oracle Corporation, Dayton, OH

Principal Consultant

EDUCATION

Florida Institute of Technology, Melbourne, FL

Master of Science, Management Information Technology

Wright State University, Dayton, OH

Bachelor of Science, Management Information Technology

CERTIFICATION

•Big Data Hadoop Certification Course Current

•Oracle 12c: Data Guard Administration 12/2016

Excellent references available upon request

Contact this candidate