We are seeking a skilled and detail-oriented Database Administrator (DBA) with hands-on experience managing PostgreSQL databases. The ideal candidate will be responsible for the performance, integrity, security, and availability of our databases across development, staging, and production environments.

Key Responsibilities:
- Install, configure, upgrade, and maintain PostgreSQL database systems.
- Monitor database performance and implement changes to improve speed and efficiency.
- Perform regular database backups, restoration, and disaster recovery operations.
- Ensure data integrity, availability, and security.
- Optimize queries and indexing strategies to support high-performance applications.
- Collaborate with developers, DevOps, and infrastructure teams on database design and implementation.
- Automate routine tasks using scripts or tools.
- Manage user access and roles, ensuring proper database permissions and compliance.
- Set up and maintain database replication, clustering, and high availability solutions.
- Monitor and tune database configurations, storage,



and memory utilization.
- Stay updated with the latest database patches, features, and best practices.
- Create and maintain documentation related to database architecture, procedures, and policies.

Requirements
Postgres:
- Administer and perform database related activities, including upgrades, maintenance, backup, recovery and configuration management.
- Involve in setting up DB instances and part of day-to-day production issues resolution.
- Should be able to install, deploy and manage Prod/Test/QA DBs span across different data centers on virtual machines.
- Hands on in performing backup and restore of Postgres database instances improving recovery times.
- Configure and monitor numerous Postgres instances and replica sets across homogenous and heterogenous environments.
- Be able to trace the stress areas back to the queries causing them, proactively profiling such queries and suggest improvement

📌 Senior Associate (Bengaluru)
🏢 Esyasoft Technologies
📍 Bengaluru