18 Nov
|
Worktual
|
Chennai
Database Developer (MySQL & PostgreSQL)
Experience: 10+ years
Work Location: Chennai [ work from office]
Interview: IN PERSON
Only relevant and Chennai candidates need to apply
Company Website: https://worktual.com/
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.
- Valuable 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 (MySQL & PostgreSQL) (Chennai)
🏢 Worktual
📍 Chennai