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)