We are looking for Lead Database Developer-Oracle to join our technology team at Clarivate.
The Lead Database Developer will be responsible for overseeing the design, development, and maintenance of high-performance databases using Oracle and PostgreSQL.
About You – experience, education, skills and accomplishments
Bachelor’s degree in computer science, Information Technology, or a related field, or equivalent experience
At least 7 years of experience in Oracle database environments and PostgreSQL.
Proficient in database performance tuning, query optimization and capacity planning.
Experience in cloud-based database services, such as AWS RDS
Solid understanding of data security, backup, and recovery procedures.
Strong understanding of relational database concepts including primary/foreign keys, many-to-many relationships, and complex joins operations.
Experience in system analysis and design, problem-solving, support and troubleshooting.
Experience with cloud database platforms (e.g., AWS RDS, Azure Cloud) is a plus.
It would be great if you also had…
In-depth understanding of database architecture and data modelling principles
Good knowledge of No-SQL database solutions, AWS and Azure Db solutions and services
What will you be doing in this role?
Database Design and Development: Collaborate with the development team to design and implement efficient database structures that meet the organization's requirements. Develop and maintain database schemas, tables, views, stored procedures, and functions.
Database Performance Tuning: Monitor and analyze database performance, identifying and resolving bottlenecks or other performance issues. Optimize queries, indexes, data schemas, and database configurations to enhance system performance. Build a proactive service engagement, understanding the data base workloads and data model, to evaluate ASH and AWR and other diagnostic tools to ensure a continued stable and performant database.
Data Security and Integrity: Working with DevOps, implement and maintain database security measures to protect sensitive data from unauthorized access or breaches.
Data Integration and ETL: Develop and maintain data integration processes, including Extract, Transform, and Load (ETL) workflows. Collaborate with developers to ensure accurate and timely data extraction, transformation, and loading across various systems.
Database Documentation and Reporting: Create and maintain comprehensive documentation for database environments, including data dictionaries, schemas, configurations, and standard operating procedures. Generate regular reports on database performance, capacity, and usage.
Database Backup, Recovery, and Disaster Planning: Working in collaboration with DBA's and DevOps, develop and maintain database backup and recovery strategies to ensure data integrity and availability. Ensure regular backups, test data recovery processes, and create disaster recovery plans.
Collaboration and Support: Work closely with cross-functional teams, including developers, system administrators, and business stakeholders, to understand their database requirements and provide technical support.
About the team
You will be part of a Database performance team that operate horizontally across the Intellectual Property pillar. We have a variety of databases genres, both in cloud and on-premise, and you would be expected to support and become deeply knowledgeable in other specialist Databases. We have a philosophy and open mindset to learning new technology that enhances the business objectives.
Hours of work
This is a full-time opportunity with Clarivate. 9 hours per day including lunch break.
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.
Skills Required
- Bachelor's degree in Computer Science, Information Technology, or equivalent experience
- At least 7 years of experience in Oracle database environments and PostgreSQL
- Proficient in database performance tuning, query optimization, and capacity planning
- Experience with cloud-based database services such as AWS RDS
- Solid understanding of data security, backup, and recovery procedures
- Strong understanding of relational database concepts (primary/foreign keys, many-to-many relationships, complex joins)
- Experience in system analysis, design, support and troubleshooting
- Experience using ASH, AWR and other database diagnostic/performance tools
- Develop and maintain ETL/data integration workflows
- Ability to implement and maintain database security measures in collaboration with DevOps
- In-depth understanding of database architecture and data modelling principles
- Knowledge of No-SQL database solutions and additional AWS/Azure database services
- Experience with Azure Cloud database platforms
Clarivate Analytics Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Clarivate Analytics and has not been reviewed or approved by Clarivate Analytics.
-
Strong & Reliable Incentives — Incentives in sales and select product/tech roles provide meaningful upside for high performers, with commission structures boosting total compensation when targets are exceeded. Role-linked variable pay is a clear strength in revenue-driving positions.
-
Leave & Time Off Breadth — PTO is ample in the U.S., with paid parental leave available, making time-off policies a notable part of the package. Generous vacation and holiday allowances stand out as positives.
-
Wellbeing & Lifestyle Benefits — Hybrid and remote options are common and paired with a formal wellbeing framework and EAP, supporting work–life balance. Core medical, dental, and vision coverage is broadly available in the U.S., reinforcing everyday wellbeing support.
Clarivate Analytics Insights
What We Do
Clarivate™ is a global leader in providing solutions to accelerate the lifecycle of innovation. Our bold mission is to help customers solve some of the world’s most complex problems by providing actionable information and insights that reduce the time from new ideas to life-changing inventions in the areas of science and intellectual property. We help customers discover, protect and commercialize their inventions using our trusted subscription and technology-based solutions coupled with deep domain expertise. For more information, please visit clarivate.com.
