Role Overview
We are looking for an experienced Senior PostgreSQL Developer with strong expertise in database design, query optimization, and performance tuning. The ideal candidate will be responsible for designing scalable database solutions, writing efficient queries, and ensuring high availability and performance of PostgreSQL systems.
Key Responsibilities
- Design, develop, and maintain robust and scalable PostgreSQL database schemas.
- Write, optimize, and troubleshoot complex SQL queries for high-performance applications.
- Perform query tuning, indexing strategies, and execution plan analysis.
- Manage database performance, identify bottlenecks, and implement improvements.
- Develop and maintain stored procedures and functions.
- Handle database migrations, upgrades, and version control.
- Ensure data integrity, security, and compliance standards are maintained.
- Work closely with application developers to design efficient data models.
- Monitor database health, backups, replication, and disaster recovery processes.
- Implement and manage high availability solutions (replication, clustering).
- Troubleshoot production issues and provide timely resolutions.
- Contribute to CI/CD pipelines for database deployments.
Required Skills & Qualifications
- 6–8 years of hands-on experience with PostgreSQL.
- Strong expertise in database design, normalization, and data modeling.
- Advanced knowledge of SQL and query optimization techniques.
- Experience with performance tuning, indexing, and query planning.
- Familiarity with PostgreSQL internals (vacuuming, indexing, WAL, etc.).
- Experience in backup and recovery strategies.
- Knowledge of replication techniques (streaming, logical replication).
- Proficiency in scripting languages (e.g., Python, Bash) for automation.
- Understanding of transaction management and concurrency control.
Good to Have
- Experience with cloud platforms (AWS RDS, Azure Database for PostgreSQL, GCP).
- Knowledge of partitioning and sharding strategies.
- Exposure to NoSQL databases is a plus.
- Experience working in Linux/Unix environments.
- Experience with monitoring tools (Prometheus, Grafana, pgAdmin, etc.).
- Familiarity with DevOps practices and CI/CD pipelines.
- Understanding of microservices architecture.
Soft Skills
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration abilities.
- Ability to mentor junior team members.
- Proactive approach to identifying and solving performance issues.