09 Oct
|
i2b Technologies
|
Hyderabad
09 Oct
i2b Technologies
Hyderabad
Function: Data Platform reliability, performance, and governance across relational and distributed SQL & NoSQL DBs.
About the Role:
- We are hiring a Senior Database Administrator to own the health, performance, and reliability of the data layer behind a high-scale, multi-tenant platform. Our environment spans several independent PostgreSQL database instances, a cache-first read tier, change-data-capture pipeline, analytics and archival stores. Should be capable of implementing NoSQL stores (Cassandra / ScyllaDB) & MySQL end to end as we scale.
- This is a hands-on senior IC role for someone who has run demanding production databases and wants full ownership: partitioning and maintenance, performance tuning, monitoring, uptime, disaster recovery, and the security and data-governance documentation that keeps a regulated, multi-tenant platform audit-ready. You will work closely with, and take direction from, engineering leadership translating priorities into a well-run, well-documented data platform.
What You'll Own:
PostgreSQL Depth:
- Administer multiple production PostgreSQL instances (v16+), including schema/DDL review, migrations, and release coordination.
- Design and maintain table partitioning strategies (range/hash/time-based) and automate partition lifecycle creation, retention windows, and secure drops.
- Own query and instance performance tuning: EXPLAIN/ANALYZE, indexing strategy, autovacuum/bloat management, connection pooling (e.g. PgBouncer), and parameter-group tuning.
- Execute zero-downtime schema changes using expandmigratecontract / blue-green patterns; assess lock impact and avoid long ACCESS EXCLUSIVE locks on hot tables.
- Manage replica topology (writer/reader endpoints), replication lag, and read-scaling as load grows.
- Partner with app teams on migration tooling (e.g. Flyway) and paired forward/rollback scripts; enforce idempotent, reviewed, tested DDL.
NoSQL & Scale:
- Data-model, deploy, and operate distributed NoSQL clusters Cassandra
📌 Data Platform Engineer (Hyderabad)
🏢 i2b Technologies
📍 Hyderabad