Database Administrator Sql Server

Thomas Watson

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

DATABASE ADMINISTRATOR

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. Communicates and interacts with executives, management, and colleagues. Demonstrated expertise in merging technologies and personnel into team-centered business units. Core competencies include:

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. Support 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.

•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 application of quarterly Oracle security patches for Oracle products.

•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.

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

•Trained new employees on Oracle database administration.

ADDITIONAL EXPERIENCE

Hewlett Packard, Cincinnati, OH - Database Administrator

Oracle Corporation, Dayton, OH - Principal Consultant

EDUCATION

Master of Science, Management Information Technology - Florida Institute of Technology, Melbourne, FL

Bachelor of Science, Management Information Technology - Wright State University, Dayton, OH

CERTIFICATION

Big Data Hadoop Certification Course

Oracle 12c: Data Guard Administration

Contact this candidate