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.
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.
National Payments Corporation Of India (NPCI) Chennai, Tamil Nadu, IND Office
8th Level, VBC Solitaire,, 47 & 49 Bazullah Road, T. Nagar, Chennai, Tamil Nadu, India, 600 017,
Similar Jobs
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Owns technical product execution for CareSelect Imaging by translating strategy and customer needs into capabilities, features, user stories, acceptance criteria, and prioritized backlogs. Partners with distributed Engineering, Architecture, QA, Product, and Operations teams to manage dependencies, risks, planning, development, testing, releases, and validation. Communicates priorities and delivery status while improving requirements quality and predictability.
Top Skills:
AhaAzure DevopsDevOpsFhirHl7JIRARally
Cloud • Fintech • Food • Information Technology • Software • Hospitality
Provides technical customer support to restaurant clients through chat, voice, and casework channels. Resolves hardware and software issues, explains technical concepts clearly, manages multiple interactions, meets SLA and KPI targets, collaborates with internal teams, and contributes to process improvements. Requires rotational 24/7 availability, including nights, weekends, and holidays, with initial office work in Chennai.
Top Skills:
Chat/Ticketing SystemsPos SystemsSaaS
Artificial Intelligence • Cloud • Information Technology • Consulting
Design and test engineering solutions for software, systems, and integrated products. Collaborate with internal and external development partners, validate technical specifications, and contribute to cross-functional teams delivering reliable, cost-effective solutions. The role requires basic knowledge of hardware design, electrical components, engineering tools, and material properties, along with strong analytical, communication, and teamwork skills.
Top Skills:
Electrical ComponentsEngineering Design SoftwareHardware Design
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
