Application / Cloud Support Senior Analyst

Overview

Application / Cloud Support Senior Analyst | Full time | Experience : 2-5 years

Job No. ATCI-4998949-S1872850 | Gurugram | Required Skill : PostgreSQL Administration

Responsibilities

• Administer, monitor, and support PostgreSQL databases running on-prem and on cloud platforms like AWS RDS, Aurora, or Azure Database for PostgreSQL.
• Perform database installation, configuration, upgrades, patching, and security hardening.
• Handle backup and recovery using native PostgreSQL tools (pg_basebackup, pgBackRest, Barman).
• Tune and optimize SQL queries and database parameters to improve performance and resource usage.
• Design and implement high availability and disaster recovery (HA / DR) solutions such as Streaming Replication, Logical Replication, and Failover Clustering.
• Work with DevOps / Cloud teams on infrastructure automation using tools like Terraform, Ansible, or CloudFormation.
• Troubleshoot database issues, including corruption, lock contention, replication lag, and unexpected downtime.
• Manage storage, partitioning, archiving, and connection pooling for large-scale production databases.
• Develop automation for routine DBA tasks using shell scripts, Python, or PL / pgSQL.
• Participate in 24x7 on-call support rotation and P1 / P2 incident handling.
• Collaborate with development and operations teams for application onboarding and schema design.
• Monitor logs and metrics using tools like pg_stat_activity, pgBadger.

Technical Experience

Professional Attributes

Educational Qualification

16 years of full-time education. Preferably with a degree in Computer Science, IT, or a related field.

Additional Information

Should be flexible for a 24x7 environment and willing to handle P1 / P2 calls.

Equal Employment Opportunity Statement

All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.

J-18808-Ljbffr