Database Developer Lead MYSQL and PostgreSQL (Chennai)

Database Developer Lead MYSQL and PostgreSQL (Chennai)

17 Nov
|
Worktual Innovations
|
Chennai

17 Nov

Worktual Innovations

Chennai

Experience : 10 + Years and 5+ years

Work Location : Chennai

Interview : In Person @ Chennai Office

Notic Period : Immediate to 15 days

Database Developer (MySQL & PostgreSQL)

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.
- Positive 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.

📌 Database Developer Lead MYSQL and PostgreSQL (Chennai)
🏢 Worktual Innovations
📍 Chennai

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: database developer lead mysql and postgresql (chennai) / chennai

Subscribe to this job alert:

Get the latest job offers by email for: database developer lead mysql and postgresql (chennai) / chennai