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
Cloud • Fintech • Food • Information Technology • Software • Hospitality
Manage and develop a Chennai-based Customer Care team supporting Toast Payroll & Tax. Coach agents, handle escalations, monitor CSAT, QA, productivity and SLAs, collaborate with cross-functional teams to resolve issues, drive process improvements, ensure compliance, and support adoption of new tools including AI-enabled support capabilities.
Top Skills:
Ai-Enabled Support ToolsCrm PlatformsKnowledge Management ToolsTicketing Systems
Digital Media • Information Technology • News + Entertainment
Leads software platform operations and implementation while coordinating team activities, coaching engineers, supporting customers, troubleshooting distributed systems, ensuring quality, and maintaining cybersecurity compliance. The role develops and debugs server-side applications, manages cloud and infrastructure technologies, supports capacity planning and launch readiness, and participates in weekend on-call rotations.
Top Skills:
AnsibleAWSCC++ChefContainersDockerEc2GitGoHTMLIamJavaJavaScriptJenkinsKubernetesLambdaLinuxNetwork Access Control ListsPuppetPythonRestRoute 53Ruby On RailsS3SaltSecurity GroupsSQLSubnetsVpc
Digital Media • Information Technology • News + Entertainment
Leads a platform engineering team responsible for cloud infrastructure, Kubernetes, automation, Infrastructure as Code, CI/CD, and developer enablement. Sets technical priorities and roadmaps, drives platform reliability, incident response, observability, security, and operational excellence, and partners across engineering, product, architecture, infrastructure, and security teams. Coaches engineers, manages resources and delivery, establishes engineering standards and metrics, and advances DevOps, GitOps, and cloud-native practices.
Top Skills:
ArgocdAWSCi/CdDatadogDevOpsDockerElkGithub ActionsGitopsGoGrafanaInfrastructure As CodeJenkinsKubernetesOpensearchOpentelemetryPrometheusPythonSite Reliability EngineeringTerraform
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.
