Role & responsibilities

PostgreSQL (Mandatory)

- 5+ years of hands-on experience as a PostgreSQL DBA in production environments.
- Deep understanding of PostgreSQL internals: MVCC, WAL, autovacuum, logical and physical replication.
- Proven experience managing PostgreSQL on cloud platforms AWS (RDS, Aurora) and/or Azure (Azure Database for PostgreSQL) including parameter groups, high-availability configurations, and read replicas.
- Solid experience administering PostgreSQL on Linux hosts: OS-level tuning, storage configuration, service management, and integration with enterprise backup solutions.
- Strong proficiency with performance tuning: EXPLAIN/EXPLAIN ANALYZE, index design (B-tree, GIN, GiST, partial indexes), and statistics management.
- Experience designing and testing HA/DR solutions across both cloud-managed and self-hosted PostgreSQL deployments.
- Practical experience with cloud database migration services (AWS DMS or Azure DMS) for homogeneous and heterogeneous migrations.
- Scripting proficiency in at least one of: Bash, Python, or SQL for automation and operational tooling.
- Familiarity with infrastructure-as-code principles (Terraform or equivalent).




- Strong understanding of database security controls: encryption, RBAC, audit logging, and network isolation.
- Excellent written and verbal communication skills; ability to produce explicit technical documentation.

MongoDB Atlas (Advantageous)

- Experience managing MongoDB Atlas clusters across cloud providers (AWS, Azure, GCP).
- Familiarity with Atlas backup strategies, network security controls, monitoring, and alerting configuration.
- Ability to manage Atlas users, roles, and certificate-based authentication in line with least-privilege principles.
- Exposure to Atlas Data Federation, Atlas Search, Triggers, and App Services.
- Experience with the Atlas CLI and Terraform Atlas provider for infrastructure-as-code provisioning.

Kindly share details below :-

Total Experience

Relevant Experinece

CTC

Expected CTC

Preferred Location - Pune/ Trivandrum

Notice Period

Are you available for an interview 26Aug-29st Aug

Apply Here -https://internal-careers.allianz.com/job-invite/102509/

📌 Senior Database Administrator PostgreSQL & MongoDB (Pune)
🏢 Allianz Technology
📍 Pune