Lead DBA/Developer

Clarivate Analytics
Alexandria, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Alexandria, United States of America

Tech stack

Amazon Web Services (AWS)
Azure
Bioinformatics
Cloud Computing
Databases
Data Conversion
Data Integrity
ETL
Data Migration
Data Warehousing
Relational Databases
Database Design
Database Schema
Database Security
DevOps
Monitoring of Systems
PostgreSQL
Microsoft SQL Server
Performance Tuning
Query Optimization
Standard Sql
Software Engineering
SQL Stored Procedures
SQL Databases
Sql Optimization
Database Optimization
Database Performance
Pagerduty

Job description

We are seeking an experiencedLead DBA/Developer to join a small, highly technical team of database engineers globally. This team focuses on designing, developing,optimizing, andmaintainingcloud-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., * 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, andoptimizedatabase 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 professionalslocatedacross multiple time zones supporting mission-critical platforms and serviceswith 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. It is the policy of Clarivate to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, Clarivate will provide reasonable accommodations for qualified individuals with disabilities.

Requirements

  • 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.

  • Strongexpertisewith PostgreSQL in AWS environments.

  • Experience with MSSQL Server development and administration.

  • Experience with DevOps, automation, andCloudOpsprocesses.

  • Experience withDataDog, PagerDuty, or similar monitoring tools.

  • Experience with database security, backup/recovery, and high availability solutions.

Apply for this position