Data Freelance Hub
Job Overview
This role is for a Sr. PostgreSQL Database Engineer in New York, with a contract duration of over 6 months and a pay rate of $175k - $225k. Requires 5+ years PostgreSQL DBA experience, strong Linux skills, and expertise in performance tuning and query optimization. Job Details
Title: Sr. PostgreSQL Database Engineer Department: Technology Location: New York, NY Reporting To: Linux Systems Director Base Salary Range: $175k - $225k 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. 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 Hands‑on and daily work with Linux operating systems Expert knowledge of PostgreSQL management: high availability (esp. Patroni), CDC, security, replication, maintenance, 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 evangelise/training Excellent communication and collaboration skills. Ability to work with developers as well as other infrastructure team members. Skills with containerization technologies (Docker, Kubernetes) and storage management Strong Linux skills 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
#J-18808-Ljbffr
This role is for a Sr. PostgreSQL Database Engineer in New York, with a contract duration of over 6 months and a pay rate of $175k - $225k. Requires 5+ years PostgreSQL DBA experience, strong Linux skills, and expertise in performance tuning and query optimization. Job Details
Title: Sr. PostgreSQL Database Engineer Department: Technology Location: New York, NY Reporting To: Linux Systems Director Base Salary Range: $175k - $225k 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. 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 Hands‑on and daily work with Linux operating systems Expert knowledge of PostgreSQL management: high availability (esp. Patroni), CDC, security, replication, maintenance, 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 evangelise/training Excellent communication and collaboration skills. Ability to work with developers as well as other infrastructure team members. Skills with containerization technologies (Docker, Kubernetes) and storage management Strong Linux skills 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
#J-18808-Ljbffr