PostgreSQL Database Administrator

6-8 Years

Save

Early Applicant

Job Description

PostgreSQL Database Administration L3 JD

Location : fort Mumbai – 24X 7 onsite support

Education criteria: B.E./Diploma/BSC/BTech/BCA (No education gap, Full time)
6- 8 years as a PostgreSQL DBA relevant experience .
Deep expertise in Postgres Server internals + performance tuning.
Manage, configure, and optimize Postgres Server instances in production and non-production environments.
Manage High Availability & Disaster Recovery (HA/DR)
Hands-on experience with Postgres Replication.
Strong understanding of Postgres security and hardening.
Experience with DB monitoring tools (SolarWinds, etc.)
Ensure compliance with internal and external security standards.
Handle P1/P2 incidents, root cause analysis, and preventive action planning.
Guide L2/L1 teams on operational tasks, SOP improvements, and best practices.
Create and maintain technical documentation, runbooks, and knowledge base articles.
Manage security audits and cab activities as per compliance.
Manage and close offence raised by Security team.
Manage PostgreSQL clusters, users, files, roles, backups, recovery, and routine maintenance.
Perform query tuning, index optimization, and configuration adjustments in PostgreSQL.
Support Postgres migrations/version upgradations when required.
Knowledge on foreign data wrappers.
Knowledge on SSL, password less and TLS authentication.
Oversee backup & recovery strategies, RPO/RTO planning, and DR testing.
Conduct capacity planning, storage monitoring, and growth forecasting.
Provide Support in DC/DR drills as well as in weekend mock activities.