Job highlights
Identified by Google from the original job post
Qualifications
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
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
Ability to perform both MSSQL and operating system performance monitoring and the necessary adjustments
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
The DBA works closely with system administration
Benefits
Full time, permanent
Hybrid working schedule on-site 2-3 days/week
Responsibilities
As a Lead Database Administrator, you are responsible for developing, administering in a collaborative environment and supporting hosted and on-premises customers
Creates and maintains all databases required for development, testing, education, and production usage
Performs the capacity planning required to create and maintain the databases
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
Job description
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 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
• 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