Job Purpose:
BTIG is seeking a highly skilled and experienced Senior PostgreSQL Database Administrator to join our team. In this role, you will be responsible for managing and optimizing our PostgreSQL databases, ensuring their performance, security and reliability. All deployments are done on Linux, so the candidate must have hands-on daily work experience with Linux OS. You should be comfortable wearing multiple hats and supporting various aspects of our technology infrastructure as necessary.
Duties & Responsibilities:
- Administration: Own/maintain various PostgreSQL clusters and instances across different environments (prod/dev/UAT) on Linux (bare-metal, virtualized and containerized)
- Design: Design and implement PostgreSQL database systems to meet business requirements (performance, HADR, etc.). Design/deploy/support appropriate data models and patterns.
- Performance Tuning: Optimize database performance: hardware, configuration, indexing, partitioning, etc.
- Query Optimization: Write and optimize complex SQL queries for high-volume environments
- Backup and Recovery: Develop/deploy/support backup and disaster recovery procedures
- Monitoring and Alerting: Set up monitoring, alerting and proactive measures to maintain database health and performance
- Troubleshooting: Diagnose and resolve database-related issues and provide timely solutions. Be able to reach below the database tier and troubleshoot OS, hardware, and network issues as well.
- Collaboration: Work closely with development and infrastructure teams to support database usage
Requirements & Qualifications:
- 5+ years working as a PostgreSQL DBA
- Hand-on and daily work with Linux operating systems
- Expert knowledge of PostgreSQL management: high availability (esp. Patroni), CDC (Change Data Tracking), security, replication, maintenance (backups, restores, vacuum, re-indexing), version upgrades, disaster recovery, legacy migrations, configuration, monitoring, alerting, etc.
- Strong experience in PostgreSQL Performance Tuning and Query optimization
- PostgreSQL user best practices and the ability to evangelize/train
- Excellent communication and collaboration skills. The ability to work with developers as well as other infrastructure team members.
- Skill with containerization technologies (Docker, Kubernetes) and storage management
- Strong Linux skills
- An engineering mindset – robustness, debugging, troubleshooting, root-cause analysis
- Experience with other RDBMS/NoSQL technologies (SQL Server, MySQL, MongoDB, ClickHouse, Kafka)
- Scripting/coding: shell script, Python, PowerShell
Important Notes:
- Must be authorized to work full time in the U.S., BTIG does not offer sponsorship for work visas of any type
- No phone calls please, the applicant will be contacted within two weeks if successful
About BTIG:
BTIG is a global financial services firm specializing in institutional trading, investment banking, research and related brokerage services. With an extensive global footprint and more than 600 employees, BTIG, LLC and its affiliates operate out of 18 cities throughout the U.S., and in Europe, Asia and Australia. BTIG offers execution, expertise and insights for equities, equity derivatives, ETFs and fixed income, currency and commodities (futures, commodities, foreign exchange, interest rates, credit, and convertible and preferred securities). The firm’s core capabilities include global execution, portfolio, electronic and outsource trading, transition management, investment banking, prime brokerage, capital introduction, corporate access, research and strategy, commission management and more. https://www.btig.com/Disclosures.aspx
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status. BTIG is an equal opportunity employer Minorities/Females/People with Disabilities/Protected Veterans/Sexual Orientation/Gender Identity.
Compensation:
- BTIG offers a competitive compensation and benefits package. Salary range is based on a variety of factors including, but not limited to, location, years of applicable experience, skills, qualifications, licensure and certifications, and other business and organization needs.
- The current estimated base salary range for this role is $175,000 - $225,000 per year. Please note that certain positions are eligible for additional forms of compensation such as discretionary bonus or overtime.
Disclaimer: https://www.btig.com/disclaimer.aspx
What We Do
BTIG is a global financial services firm specializing in institutional trading, investment banking, research and related brokerage services. Located throughout the U.S., and in Europe, Asia and Australia, our professionals leverage their expertise to service clients at every stage of the investment lifecycle. Fueled by our passion to help maximize results for our institutional and corporate clients, BTIG offers personalized multi-asset class execution, expertise and insights worldwide across equities, equity derivatives, ETFs, fixed income, futures, commodities, foreign exchange, interest rates, credit, and convertible and preferred securities. The firm’s core capabilities include global sales, portfolio, electronic and outsource trading, transition management, investment banking, prime brokerage, capital introduction, corporate access, research and strategy, commission management and more.
With a team of seasoned industry experts, BTIG provides end-to-end solutions for a diverse global client base. As we look to unlock value and propel growth for clients, we are consistently capturing market share year after year. Committed to excellence, we are proud of our rich history of designing solutions that help our clients achieve their objectives.
For more information about BTIG, please visit www.btig.com.
Member of FINRA and SIPC.
