17 Nov
|
Worktual Innovations
|
Chennai
17 Nov
Worktual Innovations
Chennai
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.
- 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 Innovations
📍 Chennai