Postgres DBA Admin
Job Location:
Monthly Salary:
Posted on:
6 hours ago
Posted on:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
Job Summary
We are looking for an experienced Database Administrator (DBA) with strong expertise in PostgreSQL and MySQL database administration. The ideal candidate will be responsible for managing maintaining optimizing securing and supporting highly available database environments across production and non-production systems. The role requires strong troubleshooting skills performance tuning expertise backup/recovery management and collaboration with application and infrastructure teams.
Key Responsibilities
We are looking for an experienced Database Administrator (DBA) with strong expertise in PostgreSQL and MySQL database administration. The ideal candidate will be responsible for managing maintaining optimizing securing and supporting highly available database environments across production and non-production systems. The role requires strong troubleshooting skills performance tuning expertise backup/recovery management and collaboration with application and infrastructure teams.
Key Responsibilities
- Install configure administer and maintain PostgreSQL and MySQL databases across multiple environments.
- Monitor database health performance and availability to ensure optimal system reliability.
- Perform database performance tuning query optimization indexing and capacity planning.
- Manage backup restore disaster recovery and high availability solutions.
- Implement database security standards user access controls and compliance requirements.
- Troubleshoot database-related issues incidents and production outages with quick resolution.
- Support database migration upgrade patching and replication activities.
- Collaborate with development DevOps cloud and application teams for database integration and deployment support.
- Automate routine DBA tasks using scripting and monitoring tools.
- Analyze slow queries locking issues deadlocks and resource bottlenecks.
- Maintain documentation for database architecture processes standards and operational procedures.
- Support cloud-based database environments on AWS/Azure/GCP where applicable.
- 5 8 years of hands-on experience as a Database Administrator.
- Strong expertise in PostgreSQL and MySQL administration.
- Experience with database replication clustering failover and high availability configurations.
- Strong knowledge of SQL query optimization and database performance tuning.
- Experience in backup/recovery tools and disaster recovery planning.
- Familiarity with Linux/Unix administration and shell scripting.
- Experience with monitoring tools such as Grafana Prometheus CloudWatch or equivalent.
- Knowledge of database security best practices and vulnerability management.
- Experience supporting production-critical applications and 24x7 environments.
- Understanding of cloud database services such as AWS RDS/Aurora is preferred.
- Strong problem-solving analytical and communication skills.
- Experience with DevOps tools and CI/CD pipelines.
- Knowledge of automation using Python Bash or Ansible.
- Exposure to Kubernetes and containerized database deployments is a plus.
- Relevant certifications in PostgreSQL MySQL AWS or cloud technologies are preferred.
- Database Performance Optimization
- Incident & Problem Management
- High Availability & Disaster Recovery
- Production Support & Troubleshooting
- Automation & Operational Excellence
