Senior Database Administrator

Broadway Global Services; Bengaluru; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

Broadway Global Services seeks a Senior Database Administrator to architect and manage high-availability PostgreSQL multi-master replication and MongoDB HA clusters.

The role emphasizes Linux administration, disaster recovery planning, and performance optimization to meet strict SLA requirements and 24/7 mission-critical database performance.

Qualifications

• 4+ years of database administration experience with PostgreSQL multi-master and MongoDB HA deployments.
• Proficiency in PostgreSQL replication (BDR, logical decoding) and Linux administration.
• Experience with performance troubleshooting using EXPLAIN ANALYZE and monitoring tools.

Responsibilities

• Design, implement, and maintain PostgreSQL multi-master replication leveraging streaming replication protocols
• Deploy and optimize MongoDB HA clusters with automated failover mechanisms and replica set governance
• Develop and enforce database security policies including RBAC controls and TDE encryption implementations
• Monitor and resolve performance bottlenecks via query tuning, index optimization, and Linux kernel parameter adjustments
• Conduct periodic backup restoration tests to validate recovery point objectives and disaster recovery readiness
• Generate detailed documentation for database architectures, operational procedures, and compliance audits

Skills

Linux administration

SQL performance tuning

Disaster recovery planning

Security best practices

RBAC

High availability design

Education

Bachelor's degree in Computer Science or equivalent

Tools

PostgreSQL

MongoDB

pgBackRest

RHEL/CentOS

BDR

Job description

Summary

We seek a Senior Database Administrator to architect and manage high-availability PostgreSQL multi-master replication and MongoDB HA clusters, ensuring 24/7 mission-critical database performance and enterprise-grade security. The role demands Linux administration expertise, disaster recovery planning, and performance optimization rigor to meet stringent SLA compliance in demanding transactional environments.

About The Role

You will safeguard continuous data availability by designing resilient systems that directly address operational downtime, security vulnerabilities, and scalability bottlenecks, aligning database operations with business continuity requirements and regulatory standards.

Key Responsibilities

• Design, implement, and maintain PostgreSQL multi-master replication leveraging streaming replication protocols


• Deploy and optimize MongoDB HA clusters with automated failover mechanisms and replica set governance


• Develop and enforce database security policies including RBAC controls and TDE encryption implementations


• Monitor and resolve performance bottlenecks via query tuning, index optimization, and Linux kernel parameter adjustments


• Conduct periodic backup restoration tests to validate recovery point objectives and disaster recovery readiness


• Generate detailed documentation for database architectures, operational procedures, and compliance audits

Required Qualifications

• 4+ years experience in database administration with PostgreSQL multi-master and MongoDB HA deployments


• Proficiency in PostgreSQL replication (BDR, logical decoding), backup strategies (pgBackRest), and Linux administration (RHEL/CentOS)


• Demonstrated SQL optimization expertise using EXPLAIN ANALYZE diagnostics and performance monitoring tools


• Bachelor's degree in Computer Science or equivalent technology discipline

Preferred Qualifications

• Multi-cloud database management experience (AWS RDS, Azure Database for PostgreSQL)


• Security compliance frameworks familiarity (GDPR, HIPAA, ISO 27001)


• Terraform/Ansible automation for infrastructure-as-code database provisioning

Team Context

This role operates within the Core Data Services team, responsible for sustaining foundational database platforms that drive global-scale applications across diverse industries.