Summary
Overview
Work History
Education
Skills
Affiliations
Linkedin Profile
Timeline
Generic

Christopher Reid

Dayton

Summary

Seasoned SQL Server AWS Cloud DBA with over two decades of experience in enhancing database efficiency and security for high-profile companies. Specialized in SQL High Availability Configuration, performance tuning, and automating database maintenance tasks. Known for leading teams to success and employing innovative problem-solving techniques to tackle complex database issues. Adept at ensuring data compliance and improving system reliability across various testing and production environments.

Overview

17
17
years of professional experience

Work History

Sr. SQL Server AWS Cloud DBA

Fortrea Inc.
11.2018 - Current
  • Led the setup and ongoing management of SQL Server on AWS, ensuring robust, scalable database solutions for critical business applications
  • Enhanced query performance through strategic application of T-SQL and various third-party utilities, leading to significant efficiency gains
  • Oversaw comprehensive database maintenance activities, including patching, migrations, upgrades, performance tuning, and ensuring high availability
  • Implemented and managed a High Availability Always on Failover Cluster for SQL Server 2016 and 2022 guaranteeing zero downtime and uninterrupted access to business-critical data
  • Led End-to-End management of diverse database environments, including Development (DEV), System Integration Testing (SIT), User Acceptance Testing (UAT), and Production (PROD)
  • Provided 24/7 on-call support and troubleshooting for SQL Server in AWS environments, along with the development of an automated failure alert system
  • Ensured HIPAA compliance by implementing Transparent Data Encryption (TDE) on sensitive databases, conducting database auditing, and encrypting login credentials and passwords
  • Contributed to improved data management processes through the implementation of effective backup strategies utilizing AWS EC2 and S3 bucket systems
  • Facilitated enhanced delivery efficiency and resolved technical issues across multiple ongoing projects, ensuring timely project execution
  • Collaborated with developers to implement index recommendations, optimizing database performance
  • Developed automation scripts to streamline routine administrative tasks, increasing operational efficiency

Sr. SQL Server Database Administrator

Prudential Financial
01.2018 - 10.2018
  • Successfully led multiple SQL Server migration projects, ensuring smooth transitions and minimal downtime
  • Executed key tasks such as SQL Server version upgrades, migration processes, and deployment changes with precision and efficiency
  • Developed comprehensive implementation plans and ticketing workflows for system deployments, including Dry Runs, Business Continuity Tests, and Cutovers
  • Enhanced query performance through targeted performance tuning activities, resulting in significant efficiency improvements
  • Implemented best practices for database monitoring, backups, and restores, ensuring data integrity and availability
  • Successfully deployed and provided ongoing support for SQL Server Clustering, Replication, Log Shipping, and Mirroring across multiple servers
  • Managed technical documentation and enforced database-related policies, promoting consistency and compliance
  • Utilized DBCC commands, Database Tuning Advisors (DTAs), and indexing strategies to optimize SQL query performance, enhancing overall system responsiveness

Sr. SQL Server Database Administrator

Associated Press
01.2013 - 07.2017
  • Established a robust SQL Server database environment on EC2 instances within AWS, ensuring optimal performance and reliability
  • Delivered exceptional database solutions that consistently met stability, reliability, and performance metrics
  • Maintained server functionality and proactively resolved database issues to ensure efficient database performance
  • Facilitated the timely completion of multiple concurrent projects through effective support and strategic problem-solving
  • Optimized query performance through targeted tuning initiatives, resulting in enhanced efficiency
  • Streamlined system operations by automating routine maintenance tasks, including database backups, replication, integrity checks, and regular index updates
  • Provided round-the-clock production support, ensuring continuous availability and quick resolution of issues
  • Ensured compliance with best practices during updates across development, testing, and deployment environments, while offering technological guidance aligned with business objectives

SQL Server Database Administrator

NCR Corporation
09.2011 - 01.2013
  • Successfully installed and configured the SQL Database for the Dubai Airport Kiosks Implementation Project, ensuring seamless integration and functionality
  • Proactively addressed a range of database challenges, including integrity issues, performance bottlenecks, blocking and deadlocking scenarios, as well as replication and connectivity complications
  • Maintained expert-level proficiency in DBCC commands, utilizing them to ensure optimal database performance and health
  • Conducted thorough reviews of database changes to optimize performance prior to production deployment, ensuring reliability and efficiency

SQL Server Database Administrator

Wolters Kluwer
01.2011 - 08.2011
  • Successfully upgraded the SQL Cluster from legacy versions (SQL 2000/2005) to SQL 2008 R2, ensuring a smooth transition and minimal disruption
  • Implemented effective backup strategies and schedules, ensuring efficient execution of both database and transaction log backups
  • Conducted daily monitoring of database performance, swiftly resolving network issues to maintain optimal functionality
  • Established and maintained user security privileges, ensuring robust access control and data protection

SQL Server Database Administrator

Medco Health Solutions
11.2008 - 12.2010
  • Directed all activities related to database backups, restores, and recovery models, ensuring data integrity and reliability
  • Orchestrated databases shrink operations while overseeing the execution of DBCC commands, clustering, database mirroring, and replication
  • Spearheaded performance optimization initiatives, ensuring the operational efficiency of both servers and databases
  • Successfully identified and resolved database integrity issues and addressed performance challenges, including blocking and deadlocking, through effective troubleshooting and replication methods

SQL Server Database Administrator

General Electric Insurance Company
07.2008 - 10.2008
  • Leveraged SQL Server Integration Services (SSIS) to effectively transform and manage data workflows
  • Oversaw the tracking of SQL Server and application logs, ensuring comprehensive monitoring and reporting
  • Analyzed logs, database performance, and network issues, identifying opportunities for enhancements in Transaction Time Cycles (TTCs)
  • Successfully migrated databases from the Datacom mainframe to SQL Server, ensuring data integrity and minimal downtime
  • Evaluated and implemented stored procedures to optimize operational efficiency and improve performance

Education

Computer & Management Studies -

University of Technology
08.1996

Mongo DB Certification -

Mongo University
San Francisco, CA

Skills

  • Database Administration: Performance Tuning, Installation & Configuration, SQL High Availability, Disaster Recovery
  • Security & Compliance: Database Encryption (TDE, Always Encrypted), Data Security, Compliance (HIPAA, GDPR)
  • Automation & Cloud: AWS RDS, EC2, S3, PowerShell, Terraform, Automation Scripting
  • Monitoring & Troubleshooting: Query Optimization, Index Management, Backup & Recovery, Replication
  • Leadership & Collaboration: Team Leadership, Communication, Problem-Solving

Affiliations

PASS - Professional Association for SQL Server

Linkedin Profile

www.linkedin.com/in/christopher-r-a63a963a

Timeline

Sr. SQL Server AWS Cloud DBA

Fortrea Inc.
11.2018 - Current

Sr. SQL Server Database Administrator

Prudential Financial
01.2018 - 10.2018

Sr. SQL Server Database Administrator

Associated Press
01.2013 - 07.2017

SQL Server Database Administrator

NCR Corporation
09.2011 - 01.2013

SQL Server Database Administrator

Wolters Kluwer
01.2011 - 08.2011

SQL Server Database Administrator

Medco Health Solutions
11.2008 - 12.2010

SQL Server Database Administrator

General Electric Insurance Company
07.2008 - 10.2008

Mongo DB Certification -

Mongo University

Computer & Management Studies -

University of Technology

Similar Profiles

CREATE PROFILE
Christopher Reid