Senior Associate DBA

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.