20 Aug
|
I2b technologies
|
Hyderabad
20 Aug
I2b technologies
Hyderabad
- Experience: 6–9 years in production database administration / engineering
- Level: Senior Individual Contributor (hands-on)
- 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 workplace 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 OwnPostgreSQL 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 safe 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 expand–migrate–contract / 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;
📌 Senior Database Administrator (Hyderabad)
🏢 I2b technologies
📍 Hyderabad