Allianz - 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.

Total Experience : 4 - 8 years

(ref:hirist.tech)