Senior Associate DBA
Confirmed on the employer's own hiring board on Nov 8, 2026. First seen by Alion on Jun 29, 2026. NPCI scores A on the Alion truth index.
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.