Lead DBA (MSSQL)

Clarivate Analytics; Alexandria (VA); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Clarivate Analytics is seeking an experienced MSSQL Developer (DBA Engineer) to join a small, highly technical SQL Server team. This hands-on role focuses on designing, developing, optimizing, and maintaining MSSQL data platforms across AWS, Azure, and on‑prem environments, with autonomy and collaboration with global stakeholders.

You will contribute to performance, security, backup/recovery, and high availability, while mentoring developers and guiding deployments.

Qualifications

• 7+ years of MSSQL DBA and SQL development experience.
• Strong MSSQL Server architecture, logical/physical design knowledge.
• Experience with AWS cloud infrastructure.
• US Citizen or Green Card holder with active Public Trust.
• PostgreSQL/MySQL knowledge is a plus.
• Backup, recovery, security, and high availability expertise.

Responsibilities

• Create and maintain databases for development, testing, education, and production.
• Plan capacity and optimize database performance and reliability.
• Collaborate with system administration on remediation and standards.
• Troubleshoot data integrity and performance issues.
• Perform ongoing tuning and patching of MSSQL instances.
• Plan backup/recovery strategies and security configurations.
• Advise developers on deployment and database server config.
• Monitor alerts and ensure uptime and resource efficiency.

Skills

MSSQL DBA

SQL Developer

AWS

Azure

Performance tuning

Backup and recovery

Security management

Tools

SSMS

SSRS

SSIS

DataDog

PagerDuty

Job description

Overview

We are seeking an experienced MSSQL Developer (DBA Engineer) to join a small, highly technical team of SQL Server engineers globally. This team focuses on designing, developing, optimizing, and maintaining MSSQL based data platforms across all environments (AWS, Azure, On-Prem). This role requires an MSSQL engineer/developer who can operate with a high degree of autonomy while maintaining strong technical and architectural alignment with global stakeholders. This is a hands‑on technical role that combines deep system level understanding, strong SQL Server development expertise, and direct contribution to the design, performance, and reliability of our MSSQL platform. Knowledge of PostgreSQL and MySQL is considered a strong asset.

Responsibilities

• Creates and maintains all databases required for development, testing, education, and production usage.
• Performs capacity planning required to create and maintain the databases.
• Works closely with system administration to formulate and execute remediation plans where existing database deployments fall short of industry and company standards.
• Assists in troubleshooting efforts when data integrity or database performance is suspected to be a possible cause of service issues.
• Performs ongoing tuning of the database instances.
• Installs new versions of the MSSQL and its tools and any other tools that access the SQL database.
• Plans and implements backup and recovery of the MSSQL database.
• Advise development teams on appropriate database server deployment and configuration.
• Implements and enforces security for all the SQL Databases.
• Performs database re‑organisations as required to assist performance and ensure maximum uptime of the database.
• Supports service delivery and development teams by refreshing non‑production database environments.
• Tests patches to ensure compatibility with the database environment and participates in regular patching cycle.
• Enforces and maintains database constraints to ensure the integrity of the database.
• Administers all database objects, including tables, clusters, indexes, views, sequences, packages, and procedures.
• Assists with impact analysis of any changes made to the database objects.
• Monitors database alerts and responds to issues and errors.
• Assesses, develops, and improves database high availability / disaster recovery strategy.
• Implements maintenance plans and monitoring to ensure database instances are running optimally and making best use of computing resources.
• Contributes to the overall strategy for the Enterprise Solutions SQL Server estate supporting internal applications.
• Supports developers to ensure their applications query the database in the most efficient, possible way.
• Assists with expertise to new projects in order to define the best technologies and approaches to use from the DBA perspective.
• Assists to resolve day‑to‑day incidents with our assets.

Qualifications

• Minimum 7 years of experience as an MSSQL DBA and SQL Developer.
• 7 years of experience with physical and logical MSSQL Server and database design knowledge.
• 7 years of experience with strong SQL DB architecture logical and physical understanding.
• 7 years of experience in database performance tuning and capacity planning.
• 7 years of experience working with AWS cloud infrastructure.
• At least 7 years of experience with strong SQL DB architecture logical and physical understanding.
• Must be a US Citizen or Green Card holder who has an active Public Trust Clearance.
• Ability to perform both MSSQL and operating system performance monitoring and the necessary adjustments.
• Other DB engines like Oracle, MySQL and Postgres databases are a plus.
• Good knowledge of operating systems and experience/understanding with DevOps and automation tools and basic knowledge about CloudOps processes.
• Monitoring tools and alerting like Data Dog and Pager Duty.
• Excellent knowledge of MSSQL backup and recovery scenarios.
• Excellent skills in all Microsoft tools: SSMS, SSRS, SSIS.
• Excellent knowledge of MSSQL security management.

About the Team

This is an amazing opportunity to join a multidisciplinary team who works on a wide range of technologies. The team consists of 8 DBA colleagues across 3 different time zones (EMEA, US, India).

Hours of Work

Full time, permanent position. Hybrid working schedule on‑site 2‑3 days/week. Must live within a commutable distance to one of our US office locations – Philadelphia, PA highly preferred. Will also consider Alexandria, VA.

Equal Employment Opportunity Statement

At Clarivate, we are committed to providing equal employment opportunities for all qualified persons with respect to hiring, compensation, promotion, training, and other terms, conditions, and privileges of employment. We comply with applicable laws and regulations governing non‑discrimination in all locations.