Sr. PostgreSQL Database Engineer

⭐ - Featured Role | Apply direct with Data Freelance Hub

This role is for a Sr. Postgre

SQL Database Engineer in New York, offering a contract of over 6 months with a pay rate of $175k - $225k. Requires 5+ years Postgre

SQL DBA experience, strong Linux skills, and expertise in performance tuning and query optimization.

Sr. Postgre

SQL Database Engineer

VP

Technology

New York, NY

Linux Systems Director

$175k - $225k

BTIG is seeking a highly skilled and experienced Senior Postgre

SQL Database Administrator to join our team. In this role, you will be responsible for managing and optimizing our Postgre

SQL 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.

• Administration:
  Own/maintain various Postgre
  
  SQL clusters and instances across different environments (prod/dev/UAT) on Linux (bare‑metal, virtualized and containerized).
• Design:
  Design and implement Postgre
  
  SQL 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.

• 5+ years working as a Postgre
  
  SQL DBA.
• Hand‑on and daily work with Linux operating systems.
• Expert knowledge of Postgre
  
  SQL 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 Postgre
  
  SQL performance tuning and query optimization.
• Postgre
  
  SQL 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/No
  
  SQL technologies (SQL Server, MySQL, Mongo
  
  DB, Click House, Kafka).
• Scripting/coding: shell script, Python, Power Shell.