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 pg_stat_statements
- Track active sessions and connections using pg_stat_activity
- 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
- Strong 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
- Strong understanding of EXPLAIN/EXPLAIN ANALYZE for query plan analysis
- Experience using pg_stat_statements and pg_stat_activity 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,200,000.00 - ₹1,400,000.00 per year
Benefits:
Work Location: In person
