Senior Database Administrator PostgreSQL & MongoDB

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 clear 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/