Allianz

1 week ago

DBA-PostgreSQL+Mongodb (Pune, MH, IN)

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI

Last checked: 11 hours agoStatus: Live

Job Summary

Design, operate, and continuously improve PostgreSQL and MongoDB database estates for Allianz. Own deployments across AWS and Azure cloud environments and on-premises Linux hosts, ensuring performance, resilience, and regulatory compliance. Drive database health monitoring, performance tuning, indexing, migrations, backup/DR, security controls, and capacity planning. Collaborate with application teams, cloud engineers, and security stakeholders, including on-call incident response.

Location: Pune

Workplace: Onsite

Employment Type: Full time

Job Function: Product Management

Seniority: Mid level

Key Responsibilities

•Install, configure, and maintain PostgreSQL databases across cloud (AWS RDS/Aurora, Azure Database for PostgreSQL) and on-premises Linux environments, including upgrades, patching, and parameter tuning.
•Monitor database health and performance using CloudWatch, Azure Monitor, and observability tools; identify and resolve performance bottlenecks in cloud and on-premises deployments.
•Optimize query performance using indexing strategies, query rewriting, and execution plan analysis (EXPLAIN / EXPLAIN ANALYZE).
•Manage PostgreSQL and MongoDB Atlas operations including clustering, scaling, backups/restores, network security controls, monitoring/alerting, and user/role management.
•Develop documentation and runbooks, automate routine tasks with Bash/Python/SQL and infrastructure-as-code tooling, and participate in on-call rotation and incident response.

Key Requirements

•5+ years of hands-on experience as a PostgreSQL DBA in production environments.
•Deep understanding of PostgreSQL internals, including MVCC, WAL, autovacuum, and logical/physical replication.
•Proven experience managing PostgreSQL on AWS (RDS/Aurora) and/or Azure (Azure Database for PostgreSQL), including HA and read replicas.
•Strong performance-tuning skills using EXPLAIN/EXPLAIN ANALYZE, index design (B-tree, GIN, GiST, partial indexes), and statistics management.
•Experience with backup and disaster recovery, including cloud-managed snapshots and point-in-time recovery (meeting RTO/RPO).

Experience:5+ years

Skills:CommunicationDocumentationTroubleshooting

Tech Stack:PostgreSQLMongoDB AtlasAWSAzureLinuxAWS RDSAWS AuroraAzure Database for PostgreSQLCloudWatchAzure MonitorEXPLAINEXPLAIN ANALYZEAWS Database Migration Service (DMS)Azure Database Migration Service (DMS)MongoDB Atlas backupVPC peeringVNet peeringPrivate endpointsEncryption at restEncryption in transit

Company Brief

Allianz

Global insurance and financial services group offering property-casualty insurance, life and health insurance, asset management, and corporate risk solutions to individuals, businesses, and institutions across more than 70 countries.

Industry: Insurance

Company Size: Enterprise (1,001+ employees)

Revenue: USD 1B+

Growth: Public Company

Valuation: Public Company (Market Cap in USD)

Funding: IPO / Publicly Listed

Headquarters: Munich, Germany

Founded: 1890

Website LinkedIn

Loading job details...

Preparing the role view and application actions.

Allianz

1 week ago

DBA-PostgreSQL+Mongodb (Pune, MH, IN)

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI

Last checked: 11 hours agoStatus: Live

Job Summary

Location: Pune

Workplace: Onsite

Employment Type: Full time

Job Function: Product Management

Seniority: Mid level

Key Responsibilities

•Install, configure, and maintain PostgreSQL databases across cloud (AWS RDS/Aurora, Azure Database for PostgreSQL) and on-premises Linux environments, including upgrades, patching, and parameter tuning.
•Monitor database health and performance using CloudWatch, Azure Monitor, and observability tools; identify and resolve performance bottlenecks in cloud and on-premises deployments.
•Optimize query performance using indexing strategies, query rewriting, and execution plan analysis (EXPLAIN / EXPLAIN ANALYZE).
•Manage PostgreSQL and MongoDB Atlas operations including clustering, scaling, backups/restores, network security controls, monitoring/alerting, and user/role management.
•Develop documentation and runbooks, automate routine tasks with Bash/Python/SQL and infrastructure-as-code tooling, and participate in on-call rotation and incident response.

Key Requirements

•5+ years of hands-on experience as a PostgreSQL DBA in production environments.
•Deep understanding of PostgreSQL internals, including MVCC, WAL, autovacuum, and logical/physical replication.
•Proven experience managing PostgreSQL on AWS (RDS/Aurora) and/or Azure (Azure Database for PostgreSQL), including HA and read replicas.
•Strong performance-tuning skills using EXPLAIN/EXPLAIN ANALYZE, index design (B-tree, GIN, GiST, partial indexes), and statistics management.
•Experience with backup and disaster recovery, including cloud-managed snapshots and point-in-time recovery (meeting RTO/RPO).

Experience:5+ years

Skills:CommunicationDocumentationTroubleshooting

Company Brief

Allianz

Industry: Insurance

Company Size: Enterprise (1,001+ employees)

Revenue: USD 1B+

Growth: Public Company

Valuation: Public Company (Market Cap in USD)

Funding: IPO / Publicly Listed

Headquarters: Munich, Germany

Founded: 1890

Website LinkedIn