Job Opening Name: Senior Associate DBA

Job Type: Full Time

Location: Chennai, Mumbai, Hyderabad

Key responsibilities:
- Database Administration: Install, configure, and maintain database systems (PostgreSQL / Cassandra / ClickHouse) ensuring high performance, scalability, and security.
- Data Modeling Design: Design efficient schemas, indexing, and partitioning strategies for high-volume fintech workloads.
- Replication High Availability: Set up and manage replication (streaming, logical, cluster-based) and ensure business continuity through DR and PITR strategies.
- Performance Tuning: Monitor database health, optimize queries, and perform capacity planning to sustain peak performance.
- Automation Scripting: Develop automation scripts (Shell/Python) for database operations, monitoring, and alerting.
- Security Compliance: Manage access control, user roles, and ensure adherence to security best practices and compliance standards.
- Incident Management: Troubleshoot and resolve database issues and outages with structured RCA documentation.
- Collaboration:



Work closely with application and engineering teams to optimize database interactions and system performance.
- Documentation: Maintain explicit documentation of architecture, configurations, and SOPs.
- 24 7 Support: Operate in a round-the-clock production support model with on-call rotations.

Key skills and experience required:
- Proficiency in at least one of: PostgreSQL, Cassandra, or ClickHouse (multiple is a plus).
- Strong knowledge of data modeling, partitioning, replication, and distributed database concepts.
- Hands-on experience with SQL, PL/pgSQL, and/or CQL query writing and optimization.
- Familiarity with backup/restore, DR, and PITR strategies in production environments.
- Working experience in Linux/Unix environments with Shell/Python scripting skills.
- Understanding of database security, role-based access control, and compliance frameworks.
- Strong analytical, troubleshooting, and communicatio

📌 Senior Associate DBA (Hyderabad)
🏢 National Payments Corporation Of India (NPCI)
📍 Hyderabad