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 (Chennai)
🏢 Worktual
📍 Chennai