Lead DBA/Developer

Clarivate; Alexandria (VA); Hybrid; USD 140,000 - 190,000; Full time

Job summary

Clarivate is seeking an experienced Lead DBA/Developer to join a small, highly technical team of database engineers globally. You will design, develop, optimize, and maintain cloud-based database platforms across AWS, Azure, and on‑prem environments with a focus on PostgreSQL development, SQL coding, data conversion, and database optimization.

MSSQL support for US Government and commercial customers is included.

Qualifications

• 7+ years of experience as a SQL Developer, Database Developer, DBA Engineer, or similar database‑focused role.
• 7+ years of experience with relational database architecture, logical and physical database design, and performance optimization.
• 7+ years of experience developing and supporting PostgreSQL, MSSQL Server, or other enterprise database platforms.
• 7+ years of experience writing and optimizing SQL code, stored procedures, and database objects.
• 7+ years of experience working with AWS cloud infrastructure and database services.
• Must be a US Citizen or Green Card holder with an active Public Trust Clearance or the ability to obtain one.

Responsibilities

• Lead PostgreSQL development efforts, including SQL coding, query optimization, and data conversion initiatives.
• Partner with software engineering teams to support ETL processes, data warehousing, and database‑driven applications.
• Design, maintain, and optimize database structures to ensure scalability, performance, and data integrity.
• Support AWS‑hosted database environments supporting US Government and commercial customers.
• Troubleshoot database performance, data quality, and application‑related issues.
• Collaborate with development teams to define best practices for database design, deployment, and ongoing support.

Skills

PostgreSQL

MSSQL

AWS

SQL Development

Data Conversion

Performance Tuning

Data Modeling

Tools

DataDog

PagerDuty

Job description

We are seeking an experienced Lead DBA/Developer to join a small, highly technical team of database engineers globally. This team focuses on designing, developing, optimizing, and maintaining cloud-based database platforms across AWS, Azure, and on-prem environments. This is a hands‑on technical role focused on PostgreSQL development, SQL coding, data conversion, and database optimization, while continuing to support MSSQL environments serving US Government and commercial customers.

About You – Experience, Education, Skills, And Accomplishments

• 7+ years of experience as a SQL Developer, Database Developer, DBA Engineer, or similar database‑focused role.
• 7+ years of experience with relational database architecture, logical and physical database design, and performance optimization.
• 7+ years of experience developing and supporting PostgreSQL, MSSQL Server, or other enterprise database platforms.
• 7+ years of experience writing and optimizing SQL code, stored procedures, and database objects.
• 7+ years of experience working with AWS cloud infrastructure and database services.
• Must be a US Citizen or Green Card holder with an active Public Trust Clearance or the ability to obtain one.

It Would Be Great If You Also Had…

• Experience supporting ETL processes, data warehousing, and data migration/conversion projects.
• Strong understanding of table relationships, data modeling, and database performance tuning.
• Strong expertise with PostgreSQL in AWS environments.
• Experience with MSSQL Server development and administration.
• Experience with DevOps, automation, and CloudOps processes.
• Experience with DataDog, PagerDuty, or similar monitoring tools.
• Experience with database security, backup/recovery, and high availability solutions.

What Will You Be Doing in This Role?

• Lead PostgreSQL development efforts, including SQL coding, query optimization, and data conversion initiatives.
• Partner with software engineering teams to support ETL processes, data warehousing, and database‑driven applications.
• Design, maintain, and optimize database structures to ensure scalability, performance, and data integrity.
• Support AWS‑hosted database environments supporting US Government and commercial customers.
• Troubleshoot database performance, data quality, and application‑related issues.
• Collaborate with development teams to define best practices for database design, deployment, and ongoing support.

About The Team

This is an amazing opportunity to join a multidisciplinary team working across a wide range of database and cloud technologies. The team consists of database professionals located across multiple time zones supporting mission‑critical platforms and services with our Intellectual Property segment.

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 – Alexandria, VA highly preferred. Will also consider Philadelphia, PA

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.