Overview
Remote
On Site
Full Time
Skills
Scalability
Stored Procedures
Binary Trees
Data Integrity
Regulatory Compliance
HIPAA
Encryption
Database Performance Tuning
Query Optimization
Failover
Clustering
Collaboration
DevOps
Extract
Transform
Load
Mentorship
Computer Science
Writing
Profit And Loss
Performance Tuning
High Availability
Streaming
Replication
Database Security
Access Control
RBAC
SSL
TLS
Backup
Recovery
Cloud Computing
Amazon RDS
Remote Desktop Services
Google Cloud
Google Cloud Platform
SQL Azure
Conflict Resolution
Problem Solving
Communication
Articulate
MySQL
Oracle
MongoDB
Data Migration
Docker
Kubernetes
Continuous Integration
Continuous Delivery
Terraform
Ansible
Open Source
PostgreSQL
Database
SQL
PostGIS
Amazon Web Services
Finance
Accounting
Marketing
Legal
Customer Support
Online Training
Artificial Intelligence
Insurance
.NET
Job Details
Description
We are seeking an experienced Senior PostgreSQL Database Developer to design, develop, and optimize complex database systems. The ideal candidate will have deep expertise in PostgreSQL, with a proven track record of building scalable, high-performance database solutions to support enterprise-level applications.
Key Responsibilities
Design, develop, and maintain PostgreSQL database schemas, ensuring optimal performance, scalability, and reliability.
Write and optimize complex SQL queries, stored procedures, triggers, and functions to support business applications.
Implement advanced PostgreSQL features, including indexing strategies (e.g., B-tree, GIN, GiST), partitioning, and full-text search.
Ensure data integrity, security, and compliance with industry standards (e.g., GDPR, HIPAA) through robust access controls and encryption.
Perform database performance tuning, query optimization, and monitoring to minimize latency and maximize throughput.
Design and implement high-availability solutions, including replication (logical and physical), failover, and clustering.
Collaborate with software engineers, data architects, and DevOps teams to integrate databases with application ecosystems.
Develop and maintain ETL pipelines for data migration and integration with external systems.
Troubleshoot and resolve database-related issues, including performance bottlenecks and data inconsistencies.
Mentor junior developers and provide technical guidance on PostgreSQL best practices.
Required Skills and Qualifications
Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent experience).
7+ years of experience in database development, with at least 5 years focused on PostgreSQL.
Expert-level knowledge of PostgreSQL architecture, including query planning, MVCC, and WAL.
Proficiency in writing complex SQL queries, PL/pgSQL, and optimizing query execution plans.
Strong experience with PostgreSQL extensions (e.g., PostGIS, TimescaleDB) and advanced features like JSONB and window functions.
In-depth understanding of database indexing, partitioning, and performance tuning techniques.
Experience with high-availability setups, such as streaming replication, logical replication, and PgBouncer.
Familiarity with database security practices, including role-based access control (RBAC), SSL/TLS, and row-level security.
Hands-on experience with database monitoring tools (e.g., pg_stat_statements, Prometheus) and backup/recovery solutions (e.g., pgBackRest, Barman).
Knowledge of cloud-based PostgreSQL deployments (e.g., AWS RDS, Google Cloud SQL, Azure PostgreSQL).
Strong problem-solving skills and the ability to work in a fast-paced, collaborative environment.
Excellent communication skills to articulate technical concepts to non-technical stakeholders.
Preferred Qualifications
Experience with other databases (e.g., MySQL, Oracle, MongoDB) and data migration to PostgreSQL.
Familiarity with containerized database deployments using Docker or Kubernetes.
Knowledge of CI/CD pipelines and infrastructure-as-code tools (e.g., Terraform, Ansible).
Contributions to PostgreSQL open-source projects or community involvement.
Certifications such as PostgreSQL Certified Professional or AWS Certified Database Specialty.
Requirements
PostgreSQL, Database Development, SQL Queries, PostGIS, Amazon Web Services (AWS)
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use.
We are seeking an experienced Senior PostgreSQL Database Developer to design, develop, and optimize complex database systems. The ideal candidate will have deep expertise in PostgreSQL, with a proven track record of building scalable, high-performance database solutions to support enterprise-level applications.
Key Responsibilities
Design, develop, and maintain PostgreSQL database schemas, ensuring optimal performance, scalability, and reliability.
Write and optimize complex SQL queries, stored procedures, triggers, and functions to support business applications.
Implement advanced PostgreSQL features, including indexing strategies (e.g., B-tree, GIN, GiST), partitioning, and full-text search.
Ensure data integrity, security, and compliance with industry standards (e.g., GDPR, HIPAA) through robust access controls and encryption.
Perform database performance tuning, query optimization, and monitoring to minimize latency and maximize throughput.
Design and implement high-availability solutions, including replication (logical and physical), failover, and clustering.
Collaborate with software engineers, data architects, and DevOps teams to integrate databases with application ecosystems.
Develop and maintain ETL pipelines for data migration and integration with external systems.
Troubleshoot and resolve database-related issues, including performance bottlenecks and data inconsistencies.
Mentor junior developers and provide technical guidance on PostgreSQL best practices.
Required Skills and Qualifications
Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent experience).
7+ years of experience in database development, with at least 5 years focused on PostgreSQL.
Expert-level knowledge of PostgreSQL architecture, including query planning, MVCC, and WAL.
Proficiency in writing complex SQL queries, PL/pgSQL, and optimizing query execution plans.
Strong experience with PostgreSQL extensions (e.g., PostGIS, TimescaleDB) and advanced features like JSONB and window functions.
In-depth understanding of database indexing, partitioning, and performance tuning techniques.
Experience with high-availability setups, such as streaming replication, logical replication, and PgBouncer.
Familiarity with database security practices, including role-based access control (RBAC), SSL/TLS, and row-level security.
Hands-on experience with database monitoring tools (e.g., pg_stat_statements, Prometheus) and backup/recovery solutions (e.g., pgBackRest, Barman).
Knowledge of cloud-based PostgreSQL deployments (e.g., AWS RDS, Google Cloud SQL, Azure PostgreSQL).
Strong problem-solving skills and the ability to work in a fast-paced, collaborative environment.
Excellent communication skills to articulate technical concepts to non-technical stakeholders.
Preferred Qualifications
Experience with other databases (e.g., MySQL, Oracle, MongoDB) and data migration to PostgreSQL.
Familiarity with containerized database deployments using Docker or Kubernetes.
Knowledge of CI/CD pipelines and infrastructure-as-code tools (e.g., Terraform, Ansible).
Contributions to PostgreSQL open-source projects or community involvement.
Certifications such as PostgreSQL Certified Professional or AWS Certified Database Specialty.
Requirements
PostgreSQL, Database Development, SQL Queries, PostGIS, Amazon Web Services (AWS)
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.