Lead DBA/Developer

Clarivate Analytics US LLC; Alexandria (VA); Hybrid; USD 130,000 - 170,000; Full time

Benefits offered by this job

Hybrid working

Job summary

Clarivate Analytics US LLC is seeking an experienced Lead DBA/Developer to join a small, highly technical team of database engineers.

The role focuses on PostgreSQL development, SQL coding, data conversion, and database optimization across AWS, Azure, and on-prem environments, while supporting MSSQL environments serving US Government and commercial customers.

Qualifications

• 7+ years as SQL/DBA-focused role.
• 7+ years relational DB design and performance optimization.
• 7+ years PostgreSQL/MSSQL development or similar.
• 7+ years SQL coding and optimization.
• 7+ years AWS cloud infrastructure experience.
• US Citizenship or Green Card with active Public Trust Clearance or ability to obtain.

Responsibilities

• Lead PostgreSQL development, including SQL coding, optimization, and data conversion.
• Partner with software teams to support ETL, data warehousing, and DB-driven apps.
• Design and optimize DB structures for scalability and integrity.
• Support AWS-hosted DB environments serving US gov. and commercial customers.
• Troubleshoot DB performance, data quality, and app issues.
• Collaborate to define best practices for DB design, deployment, and ongoing support.

Skills

SQL

PostgreSQL

AWS

Data modeling

Performance tuning

Tools

PostgreSQL

MSSQL Server

AWS

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 serving 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 per week.
• Must live within commuting distance to one of our US office locations – Alexandria, VA highly preferred; 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.