Senior Database Developer

• 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.

• 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.

• Excellent communication and stakeholder collaboration abilities.