Job Description - PostgreSQL DBA
Educational Qualifications :
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related technical field is required.
- Master's degree or relevant Postgraduate qualification is a plus.
- Industry certifications (preferred but not mandatory) :
- PostgreSQL Certified Professional
- Linux Administration Certifications (e.g., RHCE)
- Cloud Cloud certifications (i.e Azure,AWS)
Technical Expertise :
Expert-level experience in PostgreSQL administration, configuration, tuning, and troubleshooting.In-depth knowledge of PostgreSQL internals, query planner, execution strategies, and indexing techniques.Strong experience in replication methods (streaming replication, logical replication) and clustering / failover solutions.Familiarity with tools like pgAdmin, psql, pgBackRest, , and Patroni, AppdynamicsBackup and recovery planning, implementation, and testing in business-critical environments.Experience in PostgreSQL version upgrades, migrations, and capacity planningAdminister, maintain, tune, and troubleshoot PostgreSQL databases across development, testing, and production environments.Plan and implement database backup and recovery strategies.Monitor database performance, implement changes, and apply new patches and versions when required.Design and implement high-availability and disaster recovery strategies (e.g., replication, clustering, failover).Ensure database security and compliance with internal and external standards.Automate routine tasks using scripting (e.g., Bash, Python, Ansible).Work closely with software developers to optimize SQL queries and database schema design.Perform data migrations, upgrades, and capacity planning.Support CI / CD processes related to database deployments.ref : hirist.tech)