Sr. PostgreSQL Database Engineer

Job Title: Sr. PostgreSQL Database Engineer Corporate Title: VP Department: Technology Location: New York Reporting To: Linux Systems Director Base Salary Range: $175k - $225k 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 And 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 Qualifications and Desirable Experience: • 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