Database Developer Lead MYSQL and PostgreSQL

Worktual Innovations

Chennai

Sur place

INR 1 500 000 - 2 400 000

Plein temps

Il y a 6 jours
Soyez parmi les premiers à postuler

Une candidature complète en une minute

Un CV et une lettre de motivation personnalisés, prêts à envoyer.

Passez les filtres ATS

Résumé du poste

Worktual Innovations in Chennai is seeking a seasoned Database Developer to design, implement, and optimize large-scale database systems using MySQL, PostgreSQL, and ClickHouse. The role emphasizes database architecture, performance tuning, data modeling, replication, and high availability.

You will collaborate with application teams to optimize data access patterns, implement CDC with Debezium and Kafka, and manage ETL processes and data integration. Immediate joining for Chennai candidates.

Qualifications

  • 10+ years of database development experience.
  • Strong architecture and design skills for large-scale databases.
  • Experience with MySQL, PostgreSQL and ClickHouse in production.
  • Familiarity with CDC, real‑time streaming, and data integration.

Responsabilités

  • Design and develop scalable database architectures for enterprise applications.
  • Create and maintain schemas, indexes, views, procedures, and triggers.
  • Optimize complex SQL queries and improve performance.
  • Analyze bottlenecks and ensure SLA-driven production support.
  • Implement backup, recovery, and disaster recovery strategies.
  • Design replication and high availability solutions.
  • Collaborate with dev teams to optimize data access patterns.
  • Perform migrations and upgrades of database systems.
  • Monitor health, capacity planning, and resource utilization.
  • Develop ETL processes and data integration pipelines.
  • Handle partitioning, pruning, and tuning for long-running jobs.
  • Write queries for business reporting and analytics.
  • Understand semantic layer, graph databases, and structured/unstructured data.

Connaissances

MySQL
PostgreSQL
ClickHouse
SQL
Data modeling
Performance tuning
Replication
High availability
RLS
AI awareness

Outils

Debezium
Kafka
ETL
Kafka Connect

Description du poste

Database Developer (MySQL & PostgreSQL)

Experience : 10 + Years

Work Location : Chennai

Interview : In Person @ Chennai Office

Notic Period : Immediate to 15 days

ONLY CHENNAI CANDIDATES NEED TO APPLY


Job Summary
  • Designing, developing, optimizing, and maintaining large-scale database systems using MySQL , PostgreSQL and Click House
  • The ideal candidate should have strong experience in database architecture
  • Performance tuning, query optimization, data modeling, replication, high availability, Multi Tenancy, RLS
  • Cloud-based database solutions.
Key Responsibilities
  • Design and develop scalable database architectures for enterprise applications.
  • Create and maintain database schemas, tables, indexes, views, functions, stored procedures, and triggers.
  • Optimize complex SQL queries and improve database performance.
  • Analyze and troubleshoot database bottlenecks and capable of handling production issues within SLA.
  • Implement database security, backup, recovery, and disaster recovery strategies.
  • Design and maintain database replication and high-availability solutions.
  • Work closely with application development teams to optimize data access patterns.
  • Perform database migrations and version upgrades.
  • Monitor database health, capacity planning, and resource utilization.
  • Develop ETL processes and data integration solutions.
  • Partitioning, Pruning, Tuning during the production long running jobs.
  • Writing complex queries to cater to Business reports.
  • Understanding of semantic layer and Graph databases.
  • Good understanding on structured, unstructured, and semi structured storage.
  • Entity relationship digrams and Knowledge base maintenance.
  • Ensure data integrity, consistency, and compliance with security standards.
  • Participate in architecture discussions and technical design reviews.
  • Good understanding of AI,LLM, Multi tenancy and RLS.
CDC, Debezium & Kafka
  • Implement and maintain Change Data Capture (CDC) solutions using Debezium.
  • Design and manage real-time data streaming and event-driven data integration using Apache Kafka.
  • Configure and maintain Debezium connectors for MySQL and PostgreSQL to capture database changes.
  • Integrate CDC pipelines with Kafka topics to enable real-time data synchronization and downstream data processing.
ClickHouse
  • Good understanding of ClickHouse, including query optimization, and analytical workload performance tuning.
Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Database Developer
Database Developer

Worktual Innovations • Chennai

Sur place
INR 1 200 000 - 2 400 000
Senior Database Administrator
Senior Database Administrator

Worktual Innovations • Chennai

Sur place
INR 2 500 000 - 5 000 000
Senior Database Developer MySQL
Senior Database Developer MySQL

Softel Technologies Inc • Hyderabad

Sur place
INR 900 000 - 1 500 000
Database Administrator
Database Administrator

Weekday AI • Chennai

Sur place
INR 1 400 000 - 2 000 000
Database Developer
Database Developer

Alacriti • Hyderabad

Sur place
INR 600 000 - 1 000 000
Database Administrator (PostgreSQL & MS SQL)
Database Administrator (PostgreSQL & MS SQL)

Sapizon Technologies • Hyderabad, Bengaluru

À distance
INR 1 500 000 - 2 500 000
Database Developer
Database Developer

Dataflow • Dadri

Sur place
INR 2 000 000 - 3 600 000
PostgreSQL Developer
PostgreSQL Developer

Technix-Technology Solutions Private Limited • Patna

Sur place
INR 700 000 - 1 200 000
Database Developer
Database Developer

Ornate Technoservices • Hyderabad

Sur place
INR 700 000 - 1 100 000
Lead – Database Administrator (DBA)
Lead – Database Administrator (DBA)

Delta6Labs • Dadri

Sur place
INR 4 000 000 - 7 000 000