We are looking for a skilled PostgreSQL DBA to install, configure, monitor, and maintain PostgreSQL databases. You will be responsible for ensuring optimal performance, data integrity, backup/recovery, security, and high availability of PostgreSQL infrastructure in development, staging, and production environments.
Key Responsibilities:
- Install, configure, upgrade, and patch PostgreSQL database systems.
- Monitor database performance and proactively address performance bottlenecks.
- Design and implement database security strategies, access controls, and data encryption.
- Set up and maintain high availability and disaster recovery strategies (e.g., streaming replication, failover, backups).
- Perform capacity planning and storage management.
- Write and optimize SQL queries and stored procedures.
- Develop and maintain database automation scripts using Bash, Python, or similar tools.
- Implement and manage monitoring solutions (e.g., Prometheus, pg_stat_statements, Nagios).
- Support database changes through schema management and versioning tools.
- Perform root cause analysis of database-related incidents and outages.
- Work closely with developers, DevOps, and infrastructure teams to support deployments and troubleshoot issues.