Senior Database Administrator
HyderabadFull-timeMid levelPosted 1 week ago
Mid-level software engineering role at IC in Hyderabad.
About the role
IC Markets is hiring a Senior Database Administrator to own the reliability, performance, and security of the PostgreSQL estate behind our trading platform. You will be the person we trust to keep this platform fast, safe, and audit-ready as transaction volumes grow. This is a hands-on engineering role, not a pure operations seat.
What you'll do
- Own connection management strategy end to end — introduce and operate connection pooling (RDS Proxy or PgBouncer)
- Establish query-level observability: enable and maintain pg_stat_statements, define baselines, and drive down the slowest and most frequent queries
- Tune memory and planner parameters (work_mem, shared_buffers, effective_cache_size and related settings) against the actual instance profile and workload
- Review indexing strategy: identify redundant, duplicate, and unused indexes; recommend and validate new ones against production access patterns
- Plan capacity and scaling ahead of demand, including read-replica and Aurora scaling decisions
What you need
- SQL
- Python
- PostgreSQL
- AWS
- Terraform
- Bash
Good to have
- Grafana
- Prometheus