Summary
Overview
Work History
Education
Skills
Affiliations
Websites
References
Timeline
Generic

Christopher Reid

Dayton

Summary

With a proven track record at Fortrea Inc., I excel in performance tuning, monitoring, and leading teams to success. My expertise in SQL High Availability Configuration and adept problem-solving skills have significantly enhanced database efficiency and security, underscoring my commitment to excellence and innovation in database administration.

Overview

17
17
years of professional experience

Work History

Sr. SQL Server AWS Cloud DBA

Fortrea Inc.
Princeton, NJ
11.2018 - Current
  • Proficiently managed installation, configuration, and maintenance of SQL Server 2016 and 2022 across clustered and standalone EC2 instances for (AWS) Amazon Web Services
  • 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
  • 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
Woodbridge, NJ
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
Cranbury, NJ
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
East Haven
09.2013 - 07.2016
  • 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
Waltham, MA
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
Franklin Lakes, NJ
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
Beverley, MA
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
Kingston, Jamaica
08.1996

Mongo DB Certification -

Mongo University
San Francisco, CA

Skills

  • Performance Tuning and Monitoring
  • Configuration and Troubleshooting
  • Communication
  • Team Leadership
  • Problem-Solving
  • Index Management
  • Backup and Disaster Recovery
  • Data Security and Automation
  • SQL High Availability Configuration
  • Automation Scripting

Affiliations

PASS - Professional Association for SQL Server, 01/01/99, 12/31/21

References

References available upon request.

Timeline

Sr. SQL Server AWS Cloud DBA

Fortrea Inc.
11.2018 - Current

Sr. SQL Server Database Administrator

Prudential Financial
01.2018 - 10.2018

SQL Server Database Administrator

NCR Corporation
09.2013 - 07.2016

Sr. SQL Server Database Administrator

Associated Press
01.2013 - 07.2017

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

Computer & Management Studies -

University of Technology

Mongo DB Certification -

Mongo University

Similar Profiles

CREATE PROFILE
Christopher Reid