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

New York, New York, United States

BTIG Logo
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