Senior Database Administrator

IC; Hyderabad; In loco; INR 4.000.000 - 7.000.000; Tempo pieno

Descrizione del lavoro

IC Markets is seeking a Senior Database Administrator to own the reliability, performance, and security of the PostgreSQL estate behind our trading platform. This hands-on role requires tuning real workloads, reviewing schema and query design with application teams, and setting standards to keep the data layer healthy under heavy load.

Responsibilities include capacity planning, backup strategies, high availability, auditing, and collaborating with DevOps and cloud teams on migrations.

Competenze

• 5+ years of production PostgreSQL experience at scale.
• Experience with AWS and Amazon Aurora / RDS.
• Proficient in reading EXPLAIN plans and diagnosing locks.
• Knowledge of connection pooling (RDS Proxy, PgBouncer).
• Backup, PITR, replication, and failover expertise.
• Security, access control, and audit-ready practices.
• Scripting in Python or Bash for automation.

Mansioni

• Own the PostgreSQL reliability, performance, and security.
• Tune memory and planner parameters to workloads.
• Review schema and query design with teams.
• Establish observability and monitor slow queries.
• Plan capacity with read replicas and scaling.
• Lead backup, PITR, and disaster recovery tests.
• Define HA/DR runbooks and RTO/RPO targets.
• Collaborate with DevOps and cloud teams on migrations.
• Write runbooks and mentor engineers.

Conoscenze

PostgreSQL administration

Performance tuning

Query optimization

AWS & Aurora/RDS

Backup & PITR

HA/DR planning

SQL scripting (Python/Bash)

Security & access control

Explain plans analysis

Strumenti

PgBouncer

RDS Proxy

pg_stat_statements

Terraform

CloudWatch

Descrizione del lavoro

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. You will tune real workloads,review schema and query design with application teams, and set the standards that keep ourdata layer healthy under intermittent heavy load.

Key responsibilities

Performance & capacity

• Own connection management strategy end to end — introduce and operate connectionpooling (RDS Proxy or PgBouncer).
• Establish query-level observability: enable and maintain pg_stat_statements, definebaselines, and drive down the slowest and most frequent queries.
• Tune memory and planner parameters (work_mem, shared_buffers, effective_cache_sizeand related settings) against the actual instance profile and workload.
• Review indexing strategy: identify redundant, duplicate, and unused indexes; recommendand validate new ones against production access patterns.
• Plan capacity and scaling ahead of demand, including read-replica and Aurora scalingdecisions.

Reliability & operations

• Own backup, restore, and point-in-time-recovery strategy, and prove it with regular restoretests.
• Monitor and manage vacuum/auto vacuum health, transaction-ID wraparound risk, replication lag, and locking/contention.
• Define and maintain high-availability and disaster-recovery posture, including failoverrunbooks and RTO/RPO targets.
• Build proactive monitoring and alerting (CloudWatch, Performance Insights, or equivalent)so issues are caught before users feel them.

Security & compliance

• Own database access control: role and privilege design, least-privilege enforcement, andcredential lifecycle including password expiry and rotation.
• Support the firm's regulatory obligations with auditable controls, access reviews, andchange records.
• Ensure client and account data is handled in line with data-protection and brokercompliance requirements.

Collaboration

• Partner with application, DevOps, and cloud teams on schema design, migrations, andrelease safety.
• Write clear runbooks and documentation, and mentor engineers on database bestpractices.

Required qualifications

• 5+ years administering production PostgreSQL at meaningful scale, ideally in a high-availability, transactional environment.
• Hands-on experience with PostgreSQL on AWS, especially Amazon Aurora / RDS.
• Demonstrable query tuning and troubleshooting skill: reading EXPLAIN plans, usingpg_stat_statements, diagnosing locks, bloat, and slow queries.
• Strong grasp of connection management and pooling (RDS Proxy, PgBouncer).
• Solid experience with backup/restore, PITR, replication, and failover.
• Working knowledge of database security and access control, and comfort operating in aregulated or audited environment.
• Proficiency with SQL and at least one scripting language (Python, Bash, or similar) forautomation.

Preferred / nice to have

• Experience in financial services, trading, brokerage, or another latency- and correctness-sensitive domain.
• Infrastructure-as-code and observability tooling (Terraform, CloudWatch, Grafana,Prometheus).
• Exposure to schema migration tooling and safe zero-downtime deployment practices.