Database Developer

Worktual Innovations

Chennai

On-site

INR 1,200,000 - 2,400,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Worktual Innovations in Chennai seeks an experienced Database Developer focused on MySQL and PostgreSQL to design, optimize, and maintain large-scale data systems. You will implement data models, performance improvements, and high-availability architectures, including CDC with Debezium and real-time streaming with Kafka.

Candidate should have 5+ years of hands-on DB experience, strong SQL skills, and the ability to work from office in Tamil Nadu Monday to Saturday. Cloud exposure is a plus.

Qualifications

  • Designing, developing, optimizing, and maintaining large-scale database systems using MySQL and PostgreSQL.
  • Strong experience in database architecture and data modeling.
  • Performance tuning, replication, high availability, and multi-tenancy with RLS.
  • Experience with cloud-based database solutions.

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

Skills

MySQL
PostgreSQL
SQL optimization
Data modeling
Performance tuning

Tools

Kafka
Debezium
ClickHouse

Job description

Immediate Joiners Only

Prefferd Candiates only from TamilNadu

Monday to Saturday Work from Office only


1Database Developer (MySQL & PostgreSQL) 5+ years

Job Summary
  • Designing, developing, optimizing, and maintaining large-scale database systems using MySQL , PostgreSQL and
  • 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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Developer Lead MYSQL and PostgreSQL
Database Developer Lead MYSQL and PostgreSQL

Worktual Innovations • Chennai

On-site
INR 1,500,000 - 2,400,000
Senior Database Administrator
Senior Database Administrator

Worktual Innovations • Chennai

On-site
INR 2,500,000 - 5,000,000
Database Administrator [MYSQL, PostgreSQL]
Database Administrator [MYSQL, PostgreSQL]

Tanla Platforms Limited • Hyderabad

On-site
INR 1,500,000 - 2,100,000
Database Administrator - Bengaluru Only (m/f/d)
Database Administrator - Bengaluru Only (m/f/d)

Cuculus • Bengaluru

On-site
INR 1,500,000 - 2,100,000
Senior Database Developer MySQL
Senior Database Developer MySQL

Softel Technologies Inc • Hyderabad

On-site
INR 900,000 - 1,500,000
Database Developer
Database Developer

Shashwath Solution • Dadri

On-site
INR 1,500,000 - 2,500,000
ClickHouse Database Administrator (DBA)
ClickHouse Database Administrator (DBA)

VMC Soft Technologies • Chennai District

On-site
INR 1,200,000 - 2,000,000
Database Administrator
Database Administrator

Weekday AI • Chennai

On-site
INR 1,400,000 - 2,000,000
Database Developer
Database Developer

Shashwath Solution • Pune District

On-site
INR 1,500,000 - 2,400,000
Database Engineer (PostgreSQL)
Database Engineer (PostgreSQL)

Fluentgrid • NTR

On-site
INR 1,400,000 - 2,000,000