Key ResponsibilitiesDatabase Administration

- Install, configure, upgrade, patch, and maintain PostgreSQL and/or MongoDB environments.
- Manage database health, availability, performance, and capacity planning.
- Perform database migrations, refreshes, and environment provisioning.
- Administer database users, roles, permissions, and security policies.
- Ensure compliance with organizational security and audit requirements.

High Availability & Disaster Recovery

- Configure and manage replication technologies.
- Manage clustering, failover, and disaster recovery solutions.
- Perform backup and recovery operations and conduct recovery drills.
- Ensure database resiliency and business continuity.

Performance & Optimization

- Monitor and optimize database performance.
- Analyze query execution plans and recommend tuning strategies.
- Optimize indexes, database objects, and configurations.
- Troubleshoot database bottlenecks and production incidents.

Monitoring & Automation

- Implement and maintain monitoring, alerting, and reporting solutions.
- Automate routine DBA tasks using scripts and tools.
- Develop operational runbooks and standard procedures.

Production Support

- Provide L2 support for production environments.
- Participate in on-call support and incident management.
- Ensure SLA adherence and timely issue resolution.

Mandatory SkillsPostgreSQL Administration

- Strong experience in PostgreSQL administration.

- Expertise in
- Replication (Streaming, Logical Replication)




- Backup and Recovery (pgBackRest, WAL management)

- Performance Tuning

- Partitioning
- HA solutions such as EDB EFM, Patroni, Pgpool-II, etc.
- Experience with Linux operating systems.

MongoDB administration(optional)

- Strong experience in MongoDB administration.

- Expertise in

- Replica Sets

- Sharding

- Backup and Recovery

- Query and Index Optimization

- Security and Authentication
- Performance Monitoring and Troubleshooting
- Experience with YugabyteDB administration.
- Understanding of distributed SQL architecture.
- Cluster deployment, scaling, replication, and troubleshooting.

SQL Development (Optional)

- Solid SQL and query optimization skills.
- Experience in developing stored procedures, functions, and database scripts.

DevOps & Automation (Optional)

- Experience with:

- CI/CD pipelines

- Git/GitHub/GitLab
- Jenkins, Azure DevOps

- Ansible or Terraform
- Infrastructure automation and configuration management.

Programming/Scripting (Optional)Knowledge of one or more:

- Python
- Shell Scripting
- PowerShell

Desired Skills

- Strong analytical and troubleshooting abilities.
- Experience managing databases in cloud environments (AWS/Azure/GCP).
- Knowledge of container technologies (Docker/Kubernetes) is a plus.
- Excellent communication and stakeholder management skills.
- Ability to work in a fast-paced production environment.

📌 PostgreSQL DBA / MongoDB DBA (Hyderabad)
🏢 KFin Technologies
📍 Hyderabad