Technology, Sr. PostgreSQL Database Engineer, Vice President at BTIG

New York, New York, United States

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years)Experience Level

Full TimeJob Type

UnknownVisa

Financial ServicesIndustries

Requirements

5+ years working as a PostgreSQL DBA
Hands-on and daily work experience 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
Proficiency in shell script, Python, and PowerShell
An engineering mindset – robustness, debugging, troubleshooting, root-cause analysis
Experience with other RDBMS/NoSQL technologies (SQL Server, MySQL, MongoDB, ClickHouse, Kafka)
Must be authorized to work full time in the U.S. (no sponsorship for work visas)

Responsibilities

Own/maintain various PostgreSQL clusters and instances across different environments (prod/dev/UAT) on Linux
Design and implement PostgreSQL database systems to meet business requirements (performance, HADR, etc.). Design/deploy/support appropriate data models and patterns
Optimize database performance: hardware, configuration, indexing, partitioning, etc
Write and optimize complex SQL queries for high-volume environments
Develop/deploy/support backup and disaster recovery procedures
Set up monitoring, alerting, and proactive measures to maintain database health and performance
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
Work closely with development and infrastructure teams to support database usage

Skills

PostgreSQL

Linux

Patroni

Docker

Kubernetes

Python

Shell Scripting

PowerShell

SQL Server

MySQL

MongoDB

ClickHouse

Kafka

Performance Tuning

Query Optimization

BTIG

Institutional sales, trading, and investment banking services

About BTIG

BTIG provides institutional sales and trading services, offering equity sales and trading, electronic trading, outsource trading, and corporate access. The firm's core capabilities include investment banking, global sales, electronic and outsource trading, prime brokerage, and research and strategy.

San Francisco, CaliforniaHeadquarters

2002Year Founded

VENTURE_UNKNOWNCompany Stage

Fintech, Financial ServicesIndustries

501-1,000Employees

Benefits

Hybrid Work Options

Flexible Work Hours

Risks

Intensifying competition from fintech companies could impact BTIG's market share and profitability.

Regulatory scrutiny may increase compliance costs for BTIG, affecting its financial performance.

Geopolitical tensions could disrupt BTIG's international operations and client relationships.

Differentiation

BTIG has a strong global presence with offices in the U.S., Europe, Asia, and Australia.

The firm offers a comprehensive range of services including trading, investment banking, and research.

BTIG's leadership team has been strengthened with recent strategic hires and promotions.

Upsides

BTIG is well-positioned to capitalize on the growing demand for personalized investment strategies.

The firm's expansion into energy and healthcare sectors enhances its investment banking capabilities.

BTIG's focus on ESG investing aligns with industry trends towards sustainable finance.

Land your dream remote job 3x faster with AI

Try Jobo Free