07 Aug
|
National Payments Corporation Of India (NPCI)
|
Hyderabad
07 Aug
National Payments Corporation Of India (NPCI)
Hyderabad
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. Solid 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.
Disclaimer : This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
📌 Senior Associate Database (Hyderabad)
🏢 National Payments Corporation Of India (NPCI)
📍 Hyderabad