Senior Database Developer

ValueLabs; Hyderabad; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

ValueLabs seeks a senior database developer with 8+ years of experience in enterprise database design, performance tuning, and analytics-focused solutions. You will design and optimize PostgreSQL/Aurora schemas for reporting workloads and create robust PL/pgSQL objects.

Beyond SQL optimization, you will lead Python-based ETL automation, Unix scripting, and KPI-driven analytics features, collaborating with analytics, DevOps, and infra teams to deliver scalable data platforms.

Qualifications

• 8+ years of professional experience in enterprise database development, performance tuning, and data solutions.
• Design, develop, and optimize PostgreSQL/Aurora PostgreSQL database schemas for reporting and analytics workloads.
• Develop and maintain PL/pgSQL procedures, functions, triggers, views, indexes, and other database objects.
• Write and optimize complex SQL queries utilizing joins, CTEs, window functions, analytical functions, and aggregations.
• Design and implement optimal indexing, partitioning, and materialized view strategies.
• Configure, monitor, and tune Aurora PostgreSQL environments for high performance and scalability.

Responsibilities

• Collaborate with application development, analytics, DevOps, and infrastructure teams to deliver scalable database solutions.
• Develop Python-based automation for ETL processes, reconciliation, operational support, and database administration activities.
• Create Unix/Linux shell scripts for automation, monitoring, deployment, and maintenance tasks.
• Design and implement complex KPI calculations, reporting logic, and analytical features.
• Troubleshoot production issues and provide operational support for critical database systems.
• Mentor junior developers and promote PostgreSQL development best practices.

Skills

PostgreSQL

Aurora PostgreSQL

SQL

Python

Unix/Linux scripting

Performance tuning

ETL

Tools

AWS Aurora PostgreSQL

AWS RDS

DMS

CloudWatch

Job description

• 8+ years of professional experience in enterprise database development, performance tuning, and data solutions.


• Design, develop, and optimize PostgreSQL/Aurora PostgreSQL database schemas for reporting and analytics workloads.


• Develop and maintain PL/pgSQL procedures, functions, triggers, views, indexes, and other database objects.


• Write and optimize complex SQL queries utilizing joins, CTEs, window functions, analytical functions, and aggregations.


• Design and implement optimal indexing, partitioning, and materialized view strategies.


• Configure, monitor, and tune Aurora PostgreSQL environments for high performance and scalability.


• Develop Python-based automation for ETL processes, reconciliation, operational support, and database administration activities.


• Create Unix/Linux shell scripts for automation, monitoring, deployment, and maintenance tasks.


• Design and implement complex KPI calculations, reporting logic, and analytical features.


• Analyze query execution plans and resolve database performance bottlenecks.


• Collaborate with application development, analytics, DevOps, and infrastructure teams to deliver scalable database solutions.


• Troubleshoot production issues and provide operational support for critical database systems.


• Mentor junior developers and promote PostgreSQL development best practices.


• Experience designing schemas for reporting and analytics platforms, including dimensional modeling and fact/dimension structures.


• Hands-on experience with materialized views and refresh strategies.


• Proficiency in Python for automation, ETL, reconciliation, and operational support.


• Proficiency in Unix/Linux shell scripting.


• Experience managing and optimizing AWS Aurora PostgreSQL databases.


• Familiarity with AWS database services such as Aurora PostgreSQL, RDS, DMS, and CloudWatch.


• Strong analytical, troubleshooting, and problem-solving skills.


• Excellent communication and stakeholder collaboration abilities.