Hybrid Lead Database Developer – Oracle

at Clarivate

• Job title: Lead Database Developer – Oracle
• Job type: Full Time
• Experience level: Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: AWS, Azure, Cloud, ETL, Oracle, Postgres
• Location requirements: Hybrid, Bangalore, India

About the role

• Lead Database Developer responsible for high-performance databases using Oracle and PostgreSQL at Clarivate. Collaborates with teams for design, performance tuning, and database security.

Responsibilities

• 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
• 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 database workloads and data model, to evaluate ASH and AWR and other diagnostic tools to ensure a continued stable and performant database
• Working with DevOps, implement and maintain database security measures to protect sensitive data from unauthorized access or breaches
• Develop and maintain data integration processes, including Extract, Transform, and Load (ETL) workflows
• 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
• Working in collaboration with DBA's and DevOps, develop and maintain database backup and recovery strategies to ensure data integrity and availability

Requirements

• Bachelor’s degree in computer science, Information Technology, or a related field, or equivalent experience
• At least 8 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

Benefits

• Health insurance
• Flexible working hours
• Professional development opportunities