Job Description
Company: Allianz Technology
Location: Pune, Maharashtra
Workplace Type: Hybrid
Employment Type: Full-time
About the Role
Allianz Technology SE is seeking a Senior Database Administrator to join the Technology & Infrastructure team. The primary focus is on PostgreSQL across cloud (AWS RDS/Aurora, Azure Database) and on-premises Linux deployments. Experience with MongoDB Atlas is valued as part of the evolving database landscape. You will own the design, operation, and continuous improvement of both relational and document database estates, ensuring performance, resilience, and regulatory compliance.
What You’ll Do / Key Responsibilities
- Install, configure, and maintain PostgreSQL across AWS RDS/Aurora, Azure Database for PostgreSQL, and on-premises Linux hosts, covering version upgrades and patch management.
- Monitor database health using CloudWatch and Azure Monitor; proactively identify and resolve bottlenecks.
- Optimise query performance through indexing strategies, query rewriting, and execution plan analysis (EXPLAIN).
- Support data migrations using AWS Database Migration Service (DMS) or Azure Database Migration Service.
- Manage MongoDB Atlas clusters, including provisioning, scaling, and backup/restore procedures (point-in-time recovery).
- Implement Atlas network security controls (VPC/VNet peering, private endpoints) and manage X.509 certificate-based authentication.
- Automate routine operational tasks using Bash, Python, or SQL scripts and Terraform.
- Participate in the on-call rotation for database support and incident response.
Requirements & Qualifications
- 5+ years of hands-on experience as a PostgreSQL DBA in production environments.
- Deep understanding of PostgreSQL internals: MVCC, WAL, autovacuum, and replication.
- Proven experience managing PostgreSQL on cloud platforms (AWS RDS/Aurora and/or Azure Database for PostgreSQL), including high-availability configurations.
- Solid experience administering PostgreSQL on Linux hosts: OS-level tuning, storage configuration, and service management.
- Strong proficiency with performance tuning: EXPLAIN/EXPLAIN ANALYZE, index design (B-tree, GIN, GiST), and statistics management.
- Design, implement, and regularly test backup and disaster recovery strategies to meet defined RTO/RPO targets.
- Scripting proficiency in at least one of: Bash, Python, or SQL for automation.
- Familiarity with infrastructure-as-code principles (Terraform).
Preferred / Bonus Qualifications (if applicable)
- Experience managing MongoDB Atlas clusters across cloud providers (AWS, Azure, GCP).
- Familiarity with Atlas Data Federation, Atlas Search, Triggers, and App Services.
- Experience with the Atlas CLI and Terraform Atlas provider.
- A fundamental grasp of AI tools.
Benefits & Perks (if applicable)
- Allianz Group offers an inclusive workplace grounded in integrity, fairness, inclusion, and trust.
- Commitment to equal opportunities regardless of ethnicity, cultural background, age, gender, nationality, religion, social class, disability, or sexual orientation.
[We welcome applications regardless of ethnicity or cultural background, age, gender, nationality, religion, social class, disability or sexual orientation, or any other characteristics protected under applicable local laws and regulations.]