Clarivate

Lead Database Developer – Oracle

Clarivate

full-time

Posted on:

Location Type: Hybrid

Location: Bangalore • 🇮🇳 India

Visit company website
AI Apply
Apply

Job Level

Senior

Tech Stack

AWSAzureCloudETLOraclePostgres

About the role

  • 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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
database designdatabase schemasstored proceduresquery optimizationETL workflowsdatabase performance tuningdata integrationbackup and recovery strategiesdata securityrelational database concepts
Soft skills
collaborationproblem-solvingsupporttroubleshootingcommunication
Certifications
Bachelor’s degree in computer scienceBachelor’s degree in Information Technology
Salesforce

Mulesoft Technical Architect – Manager

Salesforce
Senior · Leadfull-time🇮🇳 India
Posted: 1 day agoSource: salesforce.wd12.myworkdayjobs.com
Cloud
Kyndryl

Python Developer

Kyndryl
Mid · Seniorfull-time🇮🇳 India
Posted: 5 days agoSource: kyndryl.wd5.myworkdayjobs.com
DockerJavaKubernetesMicroservicesNoSQLPython
qode.world

Senior Java Developer

qode.world
Seniorfull-time🇮🇳 India
Posted: 8 days agoSource: apply.workable.com
AngularGoJavaJavaScriptjQueryNode.jsPythonReactScala
Nextiva

Software Engineer, Java

Nextiva
Mid · Seniorfull-time🇮🇳 India
Posted: 11 days agoSource: boards.greenhouse.io
AWSAzureCloudDistributed SystemsDockerGoogle Cloud PlatformJavaKubernetesMicroservicesMySQLPostgresRedis+4 more