People Prime Worldwide
Website:
people-prime.com
Job details:
About Company :
Our client LTI Mindtree is a trusted global innovator of IT and business services. They help clients transform through consulting, industry solutions, business process services, digital & IT modernization and managed services. Our client enables them, as well as society, to move confidently into the digital future. We are committed to our clients’ long-term success and combine global reach with local client attention to serve them in over 50 countries around the globe.
· Job Title: PostgreSQL DBA
· Location: PAN INDIA
· Experience: 4+ yrs
· Job Type : Contract to hire.
· Notice Period:- Immediate joiners.
Mandatory Skills:
Senior (On-Premises) PostgreSQL core administrator . (On premises exp is must)
Shift: 24×7 (Rotational)
Role Summary
Provide L2 operational support for PostgreSQL database environments, ensuring availability, performance, and stability of production and non‑production systems. The role also supports basic new database builds, deployments, and version upgrades under standard procedures and L3 guidance.
Key Responsibilities
· L2 support for PostgreSQL databases across production and non‑production environments
- Incident, service request, and problem management as per ITIL processes
- Daily health checks, monitoring, and proactive issue identification
· Backup, restore, and recovery support (pg_dump / pg_restore / WAL)
- Basic performance troubleshooting (slow queries, locks, connections)
· User, role, and access management
- Support new PostgreSQL database builds and deployments using approved templates and SOPs
- Assist with minor version upgrades and patching activities under L3 guidance
- Support DR drills, replication checks, and failover readiness
- Coordinate with L1, L3, application, and infrastructure teams
- Maintain SOPs, runbooks, and shift handover documentation
Required Skills
· PostgreSQL Administration (L2 Support)
- Backup & recovery operations
- Basic build, deployment, and upgrade support
- Performance monitoring & troubleshooting
- Linux/Unix fundamentals
ITIL‑aligned support processes
Click on Apply to know more.