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
Digital Media • Information Technology • News + Entertainment
Independently leads data analytics and business intelligence initiatives, combining complex data sources to generate actionable insights. Performs exploratory analysis, hypothesis testing, forecasting, and LLM model development. Communicates findings through executive presentations and data visualizations while ensuring data integrity and compliance. Partners with business stakeholders to define technical requirements and applies emerging analytics, statistics, and machine learning techniques to business challenges.
Top Skills:
SparkDatabricksLarge Language ModelsMicrosoft PowerpointSQL
Digital Media • Information Technology • News + Entertainment
Leads Comcast’s India-based Residential Billing Strategy & Operations team, overseeing people leadership, billing configuration, pricing and promotional execution, testing, data quality, operational controls, automation, analytics, and release readiness. Partners with U.S. leaders to translate enterprise strategies into local plans, improve billing accuracy and resiliency, manage risk and capacity, drive transformation, and develop talent across a global, matrixed organization.
Top Skills:
AIAutomationBilling PlatformsDashboardsData AnalyticsData Governance
Digital Media • Information Technology • News + Entertainment
Develops and maintains Java enterprise software, designs applications and integrations, writes unit and integration tests, documents deployment processes, and troubleshoots performance issues. The role requires full-stack development with Spring, Angular, React, SQL databases, REST APIs, security architecture, and deployment platforms. It also involves collaboration with Quality Assurance, code quality and vulnerability remediation, database optimization, and occasional nights or weekends based on business needs.
Top Skills:
AngularApacheCSSGithub CopilotGrafanaHTMLJavaJestMavenMySQLOauth2OraclePl/SqlPrometheusReactReduxRestScssSftpSnykSonarqubeSplunkSpringSpring SecuritySQLSQL ServerSsoStompTomcatTypescriptVaultWebsocket
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.
