National Payments Corporation Of India (NPCI)

Senior Associate DBA

Posted 14 Days Ago

Be an Early Applicant

Chennai, Tamil Nadu, IND

In-Office

Senior level

Fintech • Payments • Financial Services

The Role

Administer PostgreSQL, Cassandra, and ClickHouse databases for high-volume fintech workloads. Design schemas, indexing, partitioning, replication, disaster recovery, and point-in-time recovery strategies. Tune queries and capacity, automate operations with Shell and Python, manage database security and compliance, and resolve production incidents with root-cause documentation. Collaborate with engineering teams, maintain technical documentation, and participate in 24/7 on-call support.

Summary Generated by Built In

Key responsibilities: 1. Database Administration — Install, configure, and maintain database systems (PostgreSQL / Cassandra / ClickHouse) ensuring high performance, scalability, and security. 2. Data Modeling & Design — Design efficient schemas, indexing, and partitioning strategies for high-volume fintech workloads. 3. Replication & High Availability — Set up and manage replication (streaming, logical, cluster-based) and ensure business continuity through DR and PITR strategies. 4. Performance Tuning — Monitor database health, optimize queries, and perform capacity planning to sustain peak performance. 5. Automation & Scripting — Develop automation scripts (Shell/Python) for database operations, monitoring, and alerting. 6. Security & Compliance — Manage access control, user roles, and ensure adherence to security best practices and compliance standards. 7. Incident Management — Troubleshoot and resolve database issues and outages with structured RCA documentation. 8. Collaboration — Work closely with application and engineering teams to optimize database interactions and system performance. 9. Documentation — Maintain clear documentation of architecture, configurations, and SOPs. 10. 24×7 Support — Operate in a round-the-clock production support model with on-call rotations. Key skills and experience required: 1. Proficiency in at least one of: PostgreSQL, Cassandra, or ClickHouse (multiple is a plus). 2. Strong knowledge of data modeling, partitioning, replication, and distributed database concepts. 3. Hands-on experience with SQL, PL/pgSQL, and/or CQL query writing and optimization. 4. Familiarity with backup/restore, DR, and PITR strategies in production environments. 5. Working experience in Linux/Unix environments with Shell/Python scripting skills. 6. Understanding of database security, role-based access control, and compliance frameworks. 7. Strong analytical, troubleshooting, and communication skills. 8. Ability to work in a 24×7 production support environment.

Skills Required

Proficiency in PostgreSQL, Cassandra, or ClickHouse
Knowledge of data modeling, partitioning, replication, and distributed database concepts
Hands-on experience with SQL, PL/pgSQL, or CQL query writing and optimization
Experience with backup and restore, disaster recovery, and point-in-time recovery strategies in production environments
Experience in Linux or Unix environments
Shell or 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

View all jobs at National Payments Corporation Of India (NPCI)

View National Payments Corporation Of India (NPCI) Profile

Report Job

Am I A Good Fit?

beta

Get Personalized Job Insights.

Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company

HQ: Mumbai, Maharashtra

2,124 Employees

Year Founded: 2005

What We Do

NPCI is an umbrella organisation for all retail payment systems in India. It was set up with the support & guidance from Reserve Bank of India (RBI) & Indian Banks Association (IBA). A registered company under Section 8 of the Companies Act, 2013. Watch the NPCI Corporate AV - https://youtu.be/RGl9YQ6CB20 Products & Services Unified Payments Interface Unique payment solution which empowers a recipient to initiate the payment request from a smartphone. It facilitates 'virtual payment address' as a payment identifier for sending & collecting money & works on single click 2 factor authentication. Immediate Payment Service A 24X7, real time, cost effective, independent channel, retail payment service, introduced by NPCI, empowering customers to transfer money instantly with banks & RBI authorised PPIs across India. RuPay Robust card scheme designed to offer payment products with superior features & processes specifically designed to cater to diverse consumer needs. *99# USSD based mobile banking platform that makes banking services accessible to all the bank account holders on their mobile phones. National Automated Clearing House Centralised payment system developed with an aim to consolidate multiple ECS systems running across the country & provide a framework for the removal of local barriers/inhibitors. Aadhaar Enabled Payment System Bank led model which allows online financial inclusion transactions at micro-ATMs through the business correspondent of any bank using the Aadhaar authentication. e-KYC Electronic way of conducting authentic & real time KYC of a customer using Aadhaar authentication. Cheque Truncation System Electronic image of the cheque is transmitted to the drawee bank by the clearing house, along with relevant information. National Financial Switch Facilitates routing of ATM transactions through inter-connectivity between its member institutions thereby enabling the citizens of the country to utilise any ATM of a connected entity