NBBL Senior Associate Database Administrator

National Payments Corporation of India (NPCI); Hyderabad, Chennai District, Mumbai; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

National Payments Corporation of India is seeking an Associate/Senior Associate DBA to manage critical data systems in a fintech environment. The role requires hands-on experience with PostgreSQL, Cassandra or ClickHouse, strong data modeling skills, and the ability to ensure high availability through replication, DR, and PITR.

You will work across Linux/Unix environments, scripting in Shell/Python, and collaborate with engineering teams to optimize performance.

Qualifications

• Graduation (BE/B.Tech) or equivalent is required.
• 3–7 years of relevant DBA experience.
• Experience with PostgreSQL, Cassandra or ClickHouse in fintech contexts.
• Strong SQL and PL/pgSQL / CQL skills.
• Experience in Linux/Unix and scripting with Shell/Python.

Responsibilities

• Install, configure, and maintain PostgreSQL, Cassandra or ClickHouse databases for performance and security.
• Design schemas, indexing, and partitioning for high-volume fintech workloads.
• Set up replication, DR, and PITR to ensure business continuity.
• Monitor health, optimize queries, and plan capacity.
• Develop automation scripts (Shell/Python) for DB ops and alerts.
• Manage access control, roles, and security/compliance.
• Troubleshoot incidents and document RCA.
• Collaborate with apps/engineering teams to optimize DB interactions.
• Maintain architecture docs and SOPs.
• Provide 24x7 production support with on-call rotations.

Skills

PostgreSQL

Cassandra

ClickHouse

SQL

PL/pgSQL

CQL

Shell scripting

Python

Data modeling

Replication

Education

BE/B.Tech

Job description

The opportunity:

This role combines strong data engineering capability with product thinking - translating customer journeys and business goals into scalable, reliable, and decision-ready data systems.

Job details:

Job Title: Associate /Senior Associate DBA

Years of Experience: 3-7 Years

Education: Graduation (preferably BE/B.Tech)

Full-time Location: Chennai/Hyderabad/Mumbai

Key responsibilities:

• Database Administration Install, configure, and maintain database systems (PostgreSQL / Cassandra / ClickHouse) ensuring high performance, scalability, and security.
• Data Modeling & Design Design efficient schemas, indexing, and partitioning strategies for high-volume fintech workloads.
• Replication & High Availability Set up and manage replication (streaming, logical, cluster-based) and ensure business continuity through DR and PITR strategies.
• Performance Tuning Monitor database health, optimize queries, and perform capacity planning to sustain peak performance.
• Automation & Scripting Develop automation scripts (Shell/Python) for database operations, monitoring, and alerting.
• Security & Compliance Manage access control, user roles, and ensure adherence to security best practices and compliance standards.
• Incident Management Troubleshoot and resolve database issues and outages with structured RCA documentation.
• Collaboration Work closely with application and engineering teams to optimize database interactions and system performance.
• Documentation Maintain clear documentation of architecture, configurations, and SOPs.
• 247 Support 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 247 production support environment.