JOHN MCGARVEY

PO Box ****, Oakwood, Georgia ***** H: 770-***-**** aczwdv@r.postjobfree.com

Sr. SQL Server Database Administrator

Retail – HealthCare – Banking - Insurance

Experienced Sr. Database Administrator with over a decade of wide technology experience. Firm grasp of technology in 24x7 environments, banking, retail, insurance and healthcare. Broad exposure across multiple operating systems. Extensive experience in development, performance, storage, disaster recovery, VLDBs, Business Intelligence, security, governance, process improvement, efficiency and high availability. Introduced and implemented server and database standards insuring consistency across all platforms and processes.

Core Strengths

Problem-solving • Database tuning and optimization • Website and portal monitoring • SQL data conditioning • SQL version upgrades • SQL data import/export • Very large database support(3+TeraByte) • Data backup and retrieval • Always-On Technology • Multi-server data replication and synchronization • Log Shipping • Database Mirroring • Technical specifications • Database clustering • Linked servers • Diagnostic • Database design • Disaster Recovery • Developing Database standards • Create/Support automated processes • DTS • SSIS • SSRS • FogLight • SQL 2000 • SQL 2005 • SQL 2008R2 • SQL 2012 • SQL 2014 • SQL 2016 • Oracle •Erwin • Toad • RedGate Tools • ApexSQL Tools • PGP • SourceSafe • Sysbase • Microsoft Office • Prioritize personal workflow

Professional Overview

Murphy USA

American petroleum and downstream retail gas company

Sr. Database Administrator Oct 2013 – Jan 2017

Responsible for daily support to users, developers and vendors for SQL Server databases across all environments comprised of 100+ servers and 1200 databases. Provide database performance monitoring and tuning using system and third party tools. Lead DBA and technical advisor to enterprise wide data integration and reporting initiative. Implemented financial data reporting systems using SQL Always-On and SQL replication. Performed production SQL version upgrades and directed SQL licensing true up process for dev/test environment. Developed and implemented SQL standard build and maintenance processes. Provided documentation standards and processes covering all database environments. Successfully implemented Disaster Recovery protocols working with the server maintenance team. Ensured system and data availability and integrity through preventative maintenance and upgrades.

Created processes to document and standardize SQL server environments

Implemented advanced database monitoring insuring a stable environment

Provided training to junior DBA and developers

Migrated existing database instances to latest SQL version

Supported SOX/PCI Compliance issues

Assisted in definition and implementation of coding standards and practices

Standardized SQL Server installation and platforms

Worked closely with Development to establish clear upgrade and code deployment paths

M*Modal

Medical Records Management

Sr. Database Administrator Aug 2011 – June 2013

Responsible for daily support of all corporate SQL Server databases and servers. Provide support to developers and QA department. Provided performance monitoring and tuning. Responsible for SQL code review and migration from development through QA and Production environments.

Define and configure Database Mirroring to backup production site.

Migrated database environment from SQL 2000 to SQL 2008R2.

Designed and implemented replication from SQL 2005 to Oracle 11.

Built and implemented SQL cluster supporting data center migration project.

Documentation of server environments and back end processes.

Developed processes to for standardization of code deployment.

eSecuritel Holdings LLC

Cell Phone Insurance

Sr. Database Administrator Aug 2009 – Aug 2011

Responsible for daily support of all corporate databases and servers. Provide support to developers, QA department and third party vendors. Provide performance monitoring and tuning. Responsible for SQL code review and migration through all environments (Test, QA, Production). Support corporate PCI audit.

Implemented data archive process targeted to keep production databases at a more efficient size.

Implemented table partitions thus improving large table performance.

Assisted with documentation of server environments and back end processes.

Virtual Premise Inc

Corporate Property Management

Sr. Database Administrator Team Lead Sept 2007 – July 2008

Coordinated projects for database team members in regards to both internal and external clients. Responsible for SQL code review, optimization and migration. Mentored junior associates in daily task and group training sessions. Participated in corporate workflow restructuring in developing QA and testing processes and data quality verification.

Database Architect July 2008 – July 2009

Supported 350 databases. Enhanced overall database performance through extensive tuning and process controls. Defined and implemented database monitoring and client data integration processes. Created documentation of existing and new processes.

Instrumental in retaining second largest client by identifying root cause of poor database performance and correcting in a timely manner. Applied learned lessons to all other client databases.

Implemented SQL coding standards.

Extensive database performance tuning.

HomeBanc Mortgage

Retail Home Mortgage Provider

Sr. Database Administrator May 2006 – Aug 2007

Responsible for maintaining daily availability of all database environments in standalone and clustered environments. Ensured that all processes ran successfully and efficiently to provide current data for user and executive teams. Acted as primary liaison to SOX audit teams. Charter member on the Architecture Review Committee providing technical guidance on database and networking matters.

Redefined corporate SQL security model for enhanced operation and administration.

Documented current SQL environments focusing on disaster recovery.

Mentor and cross train junior team members.

Championed the migration to SQL 2005 Integration Services (SSIS)

WorldTravel BTI

Corporate Travel Management Services

Sr. Database Administrator Sept 2003 – May 2006

Supported both stand alone and clustered environments. Support AS400 interface to SQL Server. Primary support for Oracle8i databases. Provided extensive support for all types of SQL replication. Able to define project scope and steps required to successfully complete the project on time and within budget.

Developed database maintenance and documentation standards.

Optimized existing SQL processes and TSQL coding standards.

Established Log Shipping process to provide warm backup databases at remote site

Converted Oracle database to SQL Server

Rewrite of corporate billing process to eliminate manual interaction. This enhanced man power and process efficiency in a rapidly expanding environment.

Provided support for PeopleSoft databases

ADP Benefits Services

Benefits Administration Division

Sr. Lead Production Database Administrator Jan 2000 – May 2003

Responsible for production database environments insuring data integrity, accuracy, availability and security. Continuous monitoring and performance tuning of database and server platforms. Supported corporate Electronic Data Transfer (EDT) Automatic Clearing House (ACH). Insured security of production environments while working closely with development and QA departments. Demonstrated ability to meet or exceed Service Level Agreements in fast moving environment. Able to respond to multiple user request and prioritize personal workflow and that of team members.

Professional Credentials

EDUCATION

SQL Server 2005 Upgrade and Administration

System Administration for Microsoft SQL Server 7.0

Implementing a Database on Microsoft SQL Server 7.0.

Optimizing Microsoft SQL Server 7.0

Advanced Transact-SQL Workshop

Additional off site training in Visual Basic 5.0, LabView.

Extensive corporate-sponsored training in computer-related product applications.

Extensive U.S. Navy Technical Schools

* References available upon request.

Contact this candidate