Role Overview
Act as software detectives, provide a dynamic service identifying and solving issues within multiple components of critical business systems.
Responsibilities
- Install, configure, upgrade, and maintain PostgreSQL databases in production and non-production environments.
- Manage PostgreSQL databases on cloud platforms like AWS RDS/Aurora PostgreSQL, Azure Database for PostgreSQL, or Google Cloud SQL.
- Monitor database health, performance, availability, and security.
- Perform query optimization, indexing, vacuum tuning, and performance troubleshooting.
- Implement backup, recovery, replication, and disaster recovery strategies.
- Configure and manage High Availability (HA) and failover solutions.
- Handle database migrations from on-premise to cloud environments.
- Automate database administration tasks using Shell scripting, Python, or Ansible/Terraform.
- Work closely with DevOps, application, and infrastructure teams.
- Ensure database security, access control, and compliance standards.
- Troubleshoot production incidents and provide root cause analysis.
Requirements
- Minimum 2 years of experience in PostgreSQL Administration.
- 15 years full time education.
Skills
- PostgreSQL Administration
- AWS
- Python
- Shell scripting
- Azure