Senior Database Administrator (PostgreSQL)
Free to start · No card · 5 credits the moment you sign up
Job description
About BTSE:
About the Opportunity:
We are looking for an experienced Database Administrator with deep PostgreSQL expertise and hands-on experience automating database deployment, monitoring, and performance tuning on Data Center and AWS. You will be part of the core infrastructure team responsible for scaling and maintaining BTSE’s mission-critical database systems that power our trading and analytics platforms. This role offers the opportunity to design, automate, and optimize high-availability PostgreSQL clusters while ensuring reliability, minimal downtime, and strong observability across production environments operating 24/7.
Responsibilities
- Design, deploy, and maintain PostgreSQL clusters in AWS environments using Infrastructure as Code (IaC) tools.
- Develop automation for provisioning, configuration management, and monitoring of PostgreSQL databases.
- Perform regular database maintenance including vacuuming, reindexing, and analyzing statistics to ensure peak performance.
- Identify, analyze, and optimize slow SQL queries and workloads to improve efficiency and throughput.
- Build resilient, high-availability database architectures that minimize downtime during upgrades, maintenance, and failovers.
- Implement robust backup, recovery, and disaster recovery strategies to guarantee data integrity and uptime.
- Support and monitor 24/7 production systems, participating in incident response and root cause analysis when needed.
- Collaborate with SRE, DevOps, and engineering teams to improve scalability, performance, and CI/CD integration for database operations.
Requirement
- 4+ years of experience managing PostgreSQL databases in production environments.
- Strong knowledge of SQL query optimization, indexing strategies, and PostgreSQL performance tuning.
- Proven ability to design and maintain highly available, fault-tolerant systems with minimal or zero downtime.
- Experience supporting mission-critical 24/7 systems in production, with on-call or incident response participation.
- Hands-on experience with AWS services such as EC2, RDS, EBS, S3, and IAM.
- Solid understanding of PostgreSQL replication, PITR (Point-in-Time Recovery), and HA solutions (Repmgr,Patroni, ProxySQL, or similar).
- Experience automating infrastructure using Terraform, Ansible, or similar tools.
- Proficiency in Linux systems administration and scripting (Bash, Python, or Go).
Nice to Haves
- Familiarity with observability and alerting stacks (Prometheus, Loki, Grafana, CloudWatch).
- Exposure to additional database systems such as ClickHouse or TimeScale Postgres.
- Experience building internal automation or self-healing tools for query analysis and database management.
Perks & Benefits
- Competitive total compensation package
- Various team-building programs and company events
- And many more! Apply and let us tell you more!
Originally posted on Himalayas
Prepare your application
Use the description above to assess your fit for BTSE. This checklist is guidance from Resumize, rather than additional requirements from the employer. Imported listings can be shortened or change after collection, so confirm the complete description and current availability before sending an application.
Match requirements to evidence
Identify the responsibilities and skills the employer explicitly names. For each important requirement, choose one example from your work, education, training, or projects. Explain what you did, how you did it, and what changed as a result. Include a measurable outcome when you can support it. If you lack a requirement, describe related experience accurately instead of adding an unfamiliar skill to your resume.
Put the most relevant examples near the top of your resume. Keep job titles, dates, qualifications, and contact details consistent across your application materials. Use the employer’s terminology when it describes your experience accurately; a copied list of keywords does not explain your contribution. A short, specific bullet is easier to review than a paragraph that mixes several unrelated duties.
Check the working arrangement
Confirm the location, schedule, employment type, and any eligibility requirements on the employer’s site. A remote label does not establish worldwide eligibility or flexible hours. If compensation, benefits, equipment, travel, or contract duration are missing from this listing, write down your questions for the recruiter. Do not assume details from another opening at the same company apply to this role.
Review before submitting
Follow the employer’s requested file format and application instructions. Open your exported resume and check that its text is selectable, its sections read in order, and its links work. Proofread names, dates, and contact information. Share confidential work samples only when you have permission, and use an anonymized example when necessary.
Submit through a trusted employer or recruiting destination. If the original listing has disappeared, search the employer’s careers page for the title rather than assuming the vacancy remains open. Save the application date, job reference, and the version of your resume you sent. Those details help you prepare for a later conversation and avoid submitting conflicting information through several job boards.
Review your resume for writing and readability feedback, or browse other openings if this opportunity is unavailable.