Lead Database Administrator

We are looking for a Lead Database Administrator to join our team in the US.
As a Lead Database Administrator, you are responsible for developing, administering in a collaborative environment and supporting hosted and on-premises customers. As a skilled DBA, you should have experience with on Cloud/On-premises platforms and AGILE methodologies to support our Intellectual property database team (IPDG DBA). This is an amazing opportunity to join a multidisciplinary team who works on a wide range of technologies.

About You – Experience, education, skills, and accomplishments

• 8 years minimum of experience managing MSSQL, as well as Windows operating systems.
• 8 years of experience of physical and logical MSSQL Server and database design knowledge.
• At least 8 years of experience with strong SQL DB architecture logical and physical understanding.
• At least 8 years of experience in database performance tuning and capacity planning.
• At least 8 years of experience with strong SQL Administration and MSSQL roles and features.
• At least 7 years of experience in cloud-based database services, such as AWS RDS, MS Azure.

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 working in AWS or any other cloud like Azure would be great.
• 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.
• Experience and knowledge in Database migrating and upgrade.
• Excellent knowledge business continuity and data integrity.

What will you be doing in this role?

• 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 as 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.
• 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 or Boston, MA.

Clarivate is an Equal Opportunity Employer Vets/Minorities/Women/Disabled