30 Jul
|
ValueLabs
|
Hyderabad
30 Jul
ValueLabs
Hyderabad
8+ years of qualified 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 settings 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.
Solid analytical, troubleshooting, and problem-solving skills.
Excellent communication and stakeholder collaboration abilities.
📌 Senior Database Developer Hyderabad
🏢 ValueLabs
📍 Hyderabad