Senior Database Administrator PostgreSQL & MongoDB

Job description

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/