PostgreSQL DBA

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 basisWrite and manage database commands across DDL, DML, DCL, and TCL categoriesPerform database backups and restores using tools like pg_dump and psqlTroubleshoot database issues including connectivity, performance, and data integrity problemsPerform database tuning to improve query performance and overall system efficiencyIdentify, analyze, and resolve slow-running queriesUse EXPLAIN (and EXPLAIN ANALYZE) to review query execution plans and optimize accordinglyMonitor query performance using pg_stat_statementsTrack active sessions and connections using pg_stat_activityManage database users and roles, including creating, modifying, and assigning permissionsGrant and revoke access privileges in line with security and compliance requirementsPerform query optimization to improve application performanceHandle database restarts/reboots as part of maintenance or issue resolutionDocument troubleshooting steps, fixes, and standard operating proceduresRequired Skills & Experience Minimum 5 years of hands-on experience administering PostgreSQL databasesStrong command of SQL command types: DDL, DML, DCL, and TCLProficiency with psql and pg_dump for database interaction and backup/restoreSolid troubleshooting skills for production database issuesExperience with database performance tuning and query optimizationStrong understanding of EXPLAIN/EXPLAIN ANALYZE for query plan analysisExperience using pg_stat_statements and pg_stat_activity for monitoring and diagnosticsExperience managing users, roles, and grants/permissions in PostgreSQLComfortable performing database restarts and routine maintenance tasksEducation & Certifications Bachelor's degree in Computer Science, Information Technology, or a related fieldPostgreSQL certification is a plusPay: 1,000,000.00 - 1,500,000.00 per year Benefits: Paid sick timeProvident FundWork Location: In person .