8+ years of skilled 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.
• Support database migration initiatives,



including Oracle-to-PostgreSQL migrations.
• 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.
• Exc

📌 Senior Database Developer (Hyderabad)
🏢 ValueLabs
📍 Hyderabad