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