Apply on Employer Site

BTIG · 3 days ago

Technology, Sr. PostgreSQL Database Engineer, Vice President

New York, NY

Full-time

Onsite

Mid, Senior Level

$150K/yr - $200K/yr

5+ years exp

BTIG is a global financial services firm specializing in institutional trading, investment banking, research and related brokerage services. They are seeking a highly skilled Senior PostgreSQL Database Engineer to manage and optimize PostgreSQL databases, ensuring performance, security, and reliability.

Financial Services

No H1B

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

Qualification

PostgreSQL DBALinux OSPostgreSQL Performance TuningSQL Query OptimizationContainerization DockerContainerization KubernetesScripting shellScripting PythonScripting PowerShellRDBMS/NoSQL TechnologiesEngineering MindsetCommunication SkillsCollaboration Skills

Required

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

Benefits

Competitive compensation and benefits package

Discretionary bonus

Overtime

Company

BTIG

BTIG is a global financial services firm specializing in institutional trading, investment banking, research and related brokerage services. It is a sub-organization of VR Insurance Holdings.

Founded in 2002

San Francisco, California, USA

501-1000 employees