Senior Associate DBA

National Payments Corporation of India; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Insurance & Wellness

Parental Leave

Relocation support

Mobile reimbursement

Car lease & salary advances

Reward & Recognition Program

IP rights policy

Provident Fund

Job summary

NPCI is seeking an experienced database administrator to install, configure, and maintain PostgreSQL, Cassandra, and ClickHouse systems in a high‑volume fintech environment. You will design schemas, manage replication, and ensure DR/PITR readiness while collaborating with application teams.

The role requires strong SQL skills, Linux/Unix proficiency, and scripting (Shell/Python). On‑call rotations and on‑site support in Hyderabad are part of the responsibilities, with a focus on security and

Qualifications

• Experience designing and maintaining high‑volume fintech databases.
• Support for DR and PITR strategies in production.
• Ability to optimize queries and data structures for performance and scale.
• Proficiency in Linux/Unix environments and scripting.

Responsibilities

• Install, configure, and maintain database systems (PostgreSQL, Cassandra, ClickHouse).
• Design schemas, indexing, and partitioning for high throughput workloads.
• Manage replication strategies and ensure business continuity.

Skills

Data modeling

Partitioning

Replication

SQL

PL/pgSQL

CQL

Backup & DR

Linux/Unix

Shell scripting

Python scripting

Security & RBAC

24x7 operations

Tools

PostgreSQL

Cassandra

ClickHouse

Job description

As an Equal Opportunity Employer, NPCI is committed to fostering an inclusive workplace culture, with zero tolerance for discrimination based on race, ethnicity, disability, gender identity, or sexual orientation, including support for the LGBTQ+ community.

Key Responsibilities

• Install, configure, and maintain database systems (PostgreSQL, Cassandra, ClickHouse) ensuring high performance, scalability, and security.
• Design efficient schemas, indexing, and partitioning strategies for high‑volume fintech workloads.
• Set up and manage replication (streaming, logical, cluster‑based) and ensure business continuity through DR and PITR strategies.
• Monitor database health, optimize queries, and perform capacity planning to sustain peak performance.
• Develop automation scripts (Shell/Python) for database operations, monitoring, and alerting.
• Manage access control, user roles, and ensure adherence to security best practices and compliance standards.
• Troubleshoot and resolve database issues and outages with structured RCA documentation.
• Work closely with application and engineering teams to optimize database interactions and system performance.
• Maintain clear documentation of architecture, configurations, and SOPs.
• Operate in a round‑the‑clock production support model with on‑call rotations.

Key Skills and Experience Required

• Proficiency in at least one of PostgreSQL, Cassandra, or ClickHouse (multiple is a plus).
• Strong knowledge of data modeling, partitioning, replication, and distributed database concepts.
• Hands‑on experience with SQL, PL/pgSQL, and/or CQL query writing and optimization.
• Familiarity with backup/restore, DR, and PITR strategies in production environments.
• Working experience in Linux/Unix environments with Shell/Python scripting skills.
• Understanding of database security, role‑based access control, and compliance frameworks.
• Strong analytical, troubleshooting, and communication skills.
• Ability to work in a 24×7 production support environment.

Employee Perks and Benefits

Insurance & Wellness:

• Comprehensive Coverage: Medical, accidental, and life insurance.
• Employee Assistance Program: Onsite medical center, financial/legal counselling, mental wellness.
• Annual Wellness Bouquet: Holistic wellbeing support.

Family & Childcare:

• Parental Leave: Inclusive maternity and paternity leave.
• Daycare Support: Assistance for working parents.

Mobility & Lifestyle:

• Mobility Benefits: Relocation, transfers, and travel support.
• Home Loan Interest Support: Up to 50% reimbursement.
• Mobile Reimbursement: New handset every 2 years.
• Car Lease, Salary Advance, Subsidized Meals.
• Reward & Recognition Program.
• Technology Innovation: Patents and IP rights policy.

Retirement Planning:

• Provident Fund (PF) and Gratuity Contributions.