Lead DBA/Developer

Clarivate Analytics; Philadelphia (Philadelphia County); On-site; USD 90,000 - 120,000; Full time

Job summary

A global data solutions company is looking for an experienced MSSQL Developer (DBA Engineer) to join a highly technical SQL Server team. This position requires a expert in MSSQL technology with capabilities in database performance tuning and AWS infrastructure. The role offers a hybrid working schedule and a chance to contribute to the optimization of data platforms across various environments, supporting significant projects like vaccine delivery.

Qualifications

• 7+ years of experience as a MSSQL DBA and SQL Developer.
• Expertise in physical and logical MSSQL Server design.
• Strong SQL database architecture understanding.

Responsibilities

• Create and maintain databases for development and production.
• Perform database capacity planning and optimization.
• Monitor database performance and troubleshoot issues.

Skills

MSSQL performance tuning

Database design

AWS cloud infrastructure

SQL development

Database security management

Monitoring tools (Data Dog, Pager Duty)

DevOps and CloudOps processes

Backup and recovery planning

Tools

SSMS

SSRS

SSIS

PostgreSQL

MySQL

Job description

You can view our cookie policy**About You – Experience, education, skills, and accomplishments*** 7 years minimum of experience as a MSSQL RDBMS DBA and SQL Developer* 7 years of experience of physical and logical MSSQL Server and database design knowledge* At least 7 years of experience with strong SQL DB architecture logical and physical understanding.* At least 7 years of experience in database performance tuning and capacity planning.* At least 7 years of experience working with AWS cloud infrastructure.* Must be a US Citizen or Green Card holder who has an active Public Trust Clearance**It would be great if you also had...*** Ability to perform both MSSQL and operating system performance monitoring and the necessary adjustments.* Other DB engines like Oracle Server, MySQL and Postgres databases are a plus.* A good knowledge of the operating systems* 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.* Creates and maintains all databases required for development, testing, education, and production usage.* Performs the capacity planning required to create and maintain the databases. The DBA works closely with system administration.* Formulate and execute remediation plans where existing Database deployments fall short of industry and company standards.* Assist in troubleshooting efforts when data integrity or database performance is suspected is a possible cause of service issues.* Performs ongoing tuning of the database instances.* Install 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-organizations as required to assist performance and ensure maximum uptime of the database.* Support service delivery and development teams by refreshing non-production database environments.* Test patches to ensure compatibility with the database environment and participate in regular patching cycle.* Enforces and maintains database constraints to ensure 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.* Monitor Database alerts and respond to issues and errors.* Assess, develop, and improve database High Availability\Disaster Recovery strategy Implement maintenance plans and monitoring to ensure Database instances are running optimally and making best use of computing resources.* Contribute to the overall strategy for the Enterprise Solutions SQL Server estate supporting internal applications.* Supporting developers to ensure their applications query the DBs in the most efficient, possible way.* Assisting with your expertise to new projects in order to define the best technologies and approaches to use from the DBA perspective.* Assisting to resolve day to day incidents with our assets.**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.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.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.Clarivate is a global leader in trusted and transformative intelligence. We bring together enriched data, insights, analytics and workflow solutions, grounded in deep domain expertise across the spectrum of knowledge, research and innovation.Whether it’s providing insights to transform the water industry or accelerating the delivery of a critical vaccine, our aim is to fuel the world’s greatest breakthroughs by harnessing the power of human ingenuity.For more information, please visit