About the Role

We are looking for an experienced PostgreSQL Database Administrator to manage, monitor, and optimize our database environments. The role involves day-to-day administration, performance tuning, troubleshooting, and ensuring high availability and security of PostgreSQL databases.

Key Responsibilities
Monitor PostgreSQL database health, performance, and availability on an ongoing basis
Write and manage database commands across DDL, DML, DCL, and TCL categories
Perform database backups and restores using tools like pg_dump and psql
Troubleshoot database issues including connectivity, performance, and data integrity problems
Perform database tuning to improve query performance and overall system efficiency
Identify, analyze, and resolve slow-running queries
Use EXPLAIN (and EXPLAIN ANALYZE) to review query execution plans and optimize accordingly
Monitor query performance using pgstatstatements
Track active sessions and connections using pgstatactivity
Manage database users and roles, including creating, modifying, and assigning permissions
Grant and revoke access privileges in line with security and compliance requirements
Perform query optimization to improve application performance




Handle database restarts/reboots as part of maintenance or issue resolution
Document troubleshooting steps, fixes, and standard operating procedures

Required Skills & Experience
Minimum 5 years of hands-on experience administering PostgreSQL databases
Solid command of SQL command types: DDL, DML, DCL, and TCL
Proficiency with psql and pg_dump for database interaction and backup/restore
Solid troubleshooting skills for production database issues
Experience with database performance tuning and query optimization
Robust understanding of EXPLAIN/EXPLAIN ANALYZE for query plan analysis
Experience using pgstatstatements and pgstatactivity for monitoring and diagnostics
Experience managing users, roles, and grants/permissions in PostgreSQL
Comfortable performing database restarts and routine maintenance tasks

Education & Certifications
Bachelor's degree in Computer Science, Information Technology, or a related field
PostgreSQL certification is a plus

Pay: ₹1,000,000.00 - ₹1,500,000.00 per year

Advantages
Paid sick time
Provident Fund

Work Location: In person

📌 Postgresql Dba Delhi (India)
🏢 Quantorus 365
📍 India