AGM - Automation Lead

Role

Automation Lead - Database Specialist

Job Level/ Designation

M2/AGM

Function / Department

SNOC/APM

Location

Pune/Hyderabad

Job Purpose

To architect and maintain a high-availability PostgreSQL environment using the Patroni stack. Responsible for ensuring uptime, seamless automated failovers, and the overall health of distributed database clusters across multiple data centers, design of databases and performance enhancements.

Key Result Areas/Accountabilities

• 6+ years of core PostgreSQL administration and database engineering in high-traffic production environments.
• HA Stack: Expertise in Patroni, Etcd, and PgBouncer, pgPool for connection pooling, replication and routing.
• Network & Routing: Hands-on experience with HAProxy and Keepalived for database traffic management.
• Programming & Automation: Strong proficiency in Python for building automation tools and custom adapters.
• Infrastructure: Advanced knowledge of Linux/RHEL systems and experience with containerized PostgreSQL (Docker/Kubernetes).
• Database Internals: Deep understanding of SQL optimization, PL/SQL, and PostgreSQL internals (WAL, buffers, locking).
• DevOps Tools: Proficiency with Ansible, Terraform, Kafka, and Airflow for managing data pipelines and infrastructure.

Core Competencies, Knowledge, Experience

7+ years of experience

Hands-on experience on PostgreSQL, Patroni, HAProxy, ETCD/DCS, PostgreSQL extensions, PGbouncer, Database design and Python

Telecom domain knowledge is an added advantage

Must have technical / professional qualifications

BE, B.Tech in Computer Science or IT or relevant field