We use cookies to run the site and count visits. "Got it" also allows session recording.
IC Markets
Hyderabad, India16 days ago
Grade
Senior
Experience
from 5 years
English level
B2, upper-intermediate
An email or a Telegram message to the recruiter
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 our data layer healthy under intermittent heavy load.
Performance & capacity • 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 Reliability & operations • Own backup, restore, and point-in-time-recovery strategy, and prove it with regular restore tests • 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 failover runbooks 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, and credential lifecycle including password expiry and rotation • Support the firm's regulatory obligations with auditable controls, access reviews, and change records • Ensure client and account data is handled in line with data-protection and broker compliance requirements Collaboration • Partner with application, DevOps, and cloud teams on schema design, migrations, and release safety • Write clear runbooks and documentation, and mentor engineers on database best practices
• 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, using pg_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 a regulated or audited environment • Proficiency with SQL and at least one scripting language (Python, Bash, or similar) for automation • 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
Preferred / nice to have
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 our data layer healthy under intermittent heavy load. Key responsibilities Performance & capacity • 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. Reliability & operations • Own backup, restore, and point-in-time-recovery strategy, and prove it with regular restore tests. • 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 failover runbooks 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, and credential lifecycle including password expiry and rotation. • Support the firm's regulatory obligations with auditable controls, access reviews, and change records. • Ensure client and account data is handled in line with data-protection and broker compliance requirements. Collaboration • Partner with application, DevOps, and cloud teams on schema design, migrations, and release safety. • Write clear runbooks and documentation, and mentor engineers on database best practices. 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, using pg_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 a regulated or audited environment. • Proficiency with SQL and at least one scripting language (Python, Bash, or similar) for automation. 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.
We compare skills, grade, work format and salary
Most often 2,740,000 to 4,690,000