Database Developer & Administrator (PostgreSQL)

We are seeking a highly skilled Database Developer & Administrator (PostgreSQL) with 5 years to 6 years of hands-on experience in designing, developing, administering, and optimizing PostgreSQL databases for enterprise applications. The ideal candidate will possess strong expertise in SQL development, PostgreSQL administration, performance tuning, high availability, backup and recovery, database security, and automation. This role requires close collaboration with application development, DevOps, and architecture teams to build secure, scalable, and high-performing database solutions.

Key Responsibilities:

Database Development:

• Design, develop, and maintain SQL, PostgreSQL database objects, including tables, views, indexes, sequences, functions, triggers, and stored procedures.
• Develop, optimize, and troubleshoot complex SQL and PL/pgSQL queries for high-performance applications.
• Participate in data modeling, schema design, database migration, and database version upgrades.
• Ensure database designs adhere to best practices for scalability, maintainability, and performance.

Database Administration:

• Install, configure, upgrade, and administer PostgreSQL database environments.
• Manage database backup, restore, Point-in-Time Recovery (PITR), replication, and disaster recovery strategies.
• Monitor database health, storage utilization, availability, and capacity planning.
• Ensure high availability through replication and failover mechanisms.

Performance Optimization & Monitoring:

• Analyze and optimize SQL queries, indexing strategies, partitioning, and PostgreSQL configurations.
• Monitor and troubleshoot performance bottlenecks, locking, deadlocks, replication issues, and database failures.
• Perform database health checks, root cause analysis (RCA), and implement preventive and corrective actions.
• Analyze execution plans and recommend performance improvements.

Security & Automation:

• Manage database users, roles, permissions, authentication, and security policies.
• Automate routine database administration tasks using Python or Shell scripting.
• Support CI/CD deployments and Infrastructure as Code (IaC) initiatives.
• Ensure compliance with database security and governance standards.

Required Skills:

• 5 years to 6 years of experience in PostgreSQL Database Administration and Development.
• Strong expertise in PostgreSQL Administration and SQL/PL/pgSQL.
• Experience with database performance tuning and query optimization.
• Hands-on experience with backup and recovery using pg_dump, pg_restore, and PITR.
• Experience implementing replication, high availability, and disaster recovery solutions.
• Strong understanding of indexing, partitioning, and execution plan analysis.
• Experience with database monitoring tools such as Grafana, Prometheus, and pgAdmin.
• Good knowledge of Linux administration and Git.
• Proficiency in Python or Shell scripting for automation.
• Basic understanding of Docker, Kubernetes, CI/CD pipelines, and DevOps practices.
• Exposure to Azure Database for PostgreSQL or other cloud database services is preferred.