Technology, Sr. PostgreSQL Database Engineer, Vice President

BTIG Limited; New York (NY); On-site; USD 175,000 - 225,000; Full time

Job summary

Join a dynamic team as a Senior PostgreSQL Database Engineer at a leading financial services firm. In this pivotal role, you will manage and optimize PostgreSQL databases, ensuring their performance, security, and reliability. You will work in a collaborative environment, wearing multiple hats to support various aspects of technology infrastructure. With a strong focus on performance tuning and query optimization, your expertise will drive the success of critical database systems. This is an exciting opportunity to make a significant impact in a global firm known for its innovative solutions and commitment to excellence. If you are passionate about database management and thrive in a fast-paced environment, this role is perfect for you.

Qualifications

• 5+ years of experience as a PostgreSQL DBA with hands-on Linux skills.
• Expertise in PostgreSQL management, performance tuning, and query optimization.

Responsibilities

• Manage PostgreSQL clusters on Linux, ensuring performance and reliability.
• Design and implement database systems to meet business requirements.

Skills

PostgreSQL Management

Performance Tuning

Query Optimization

Linux OS

Communication Skills

Containerization (Docker, Kubernetes)

Scripting (Shell, Python, PowerShell)

Tools

PostgreSQL

SQL Server

MySQL

MongoDB

ClickHouse

Kafka

Job description

Technology, Sr. PostgreSQL Database Engineer, Vice President

at BTIG New York, New York, United States

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
• Hands-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
• Experience with other RDBMS/NoSQL technologies (SQL Server, MySQL, MongoDB, ClickHouse, Kafka)
• Scripting/coding: shell script, Python, PowerShell
• Must be authorized to work full time in the U.S., BTIG does not offer sponsorship for work visas of any type

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.

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.