PostgreSQL Developer
Job Description
About the Role
We are looking for a PostgreSQL Developer to design, optimize, and maintain data systems built on Schema Design & Normalization, Query Optimization, Partitioning & Sharding. This role combines technical depth in PostgreSQL with the ability to understand business context — you'll work with analysts, engineers, and stakeholders to ensure data is reliable, accessible, and useful. The ideal candidate has hands-on experience with pgAdmin and Patroni, can diagnose complex query performance issues, and understands both OLTP and OLAP patterns. You'll own data pipeline reliability, query performance, and schema evolution for systems handling millions of records.
Key Responsibilities
- Own Schema Design & Normalization implementation and optimization — configuration, customization, and ongoing enhancement based on business needs
- Manage Query Optimization workflows including setup, user training, and continuous improvement of processes
- Implement and maintain Partitioning & Sharding ensuring seamless integration with existing systems and workflows
- Design and maintain PostgreSQL schemas optimized for both operational and analytical workloads
- Write and optimize complex queries, stored procedures, and data transformation pipelines
- Monitor PostgreSQL performance — query execution plans, resource utilization, and capacity planning
- Build automated ETL/ELT pipelines for data integration from multiple source systems
- Create dashboards and reporting solutions that enable data-driven decision making
- Implement data quality checks, validation rules, and monitoring for data pipeline reliability
- Plan and execute database migrations with zero-downtime cutover strategies
Must-Have Qualifications
- Hands-on experience with Schema Design & Normalization — configuration, customization, and troubleshooting in production environments
- Proficiency with pgAdmin as part of the PostgreSQL development/operations workflow
- 3+ years of hands-on PostgreSQL experience in production environments
- Strong SQL skills — complex queries, window functions, CTEs, and query optimization
- Experience with data modeling — star schemas, normalization, and denormalization trade-offs
- Understanding of ETL/ELT pipeline design and data quality management
- Ability to communicate data insights to both technical and non-technical stakeholders
Nice-to-Have Skills
- EDB PostgreSQL Certified Associate certification or equivalent validated credential
- EDB PostgreSQL Certified Professional certification or equivalent validated credential
- Experience with advanced PostgreSQL features: Query Optimization, Partitioning & Sharding, Replication & HA
- Familiarity with the broader PostgreSQL ecosystem including Patroni and pgBouncer
- Experience with real-time streaming systems (Kafka, Kinesis, or Flink)
- Knowledge of data governance frameworks and data catalog tools
Interview Tips
Technical Coding Exercise
Give a small, realistic PostgreSQL coding challenge that tests fundamentals — clean code, edge case handling, and test writing. Time-box to 45-60 minutes.
Architecture Whiteboard
Present a system design problem relevant to PostgreSQL. Evaluate their approach to scalability, data modeling, and trade-off discussions.
Code Review Simulation
Show a PostgreSQL pull request with both good patterns and subtle issues. Assess what they catch, how they communicate feedback, and what they prioritize.
Past Project Deep-Dive
Have them walk through their most challenging PostgreSQL project. Ask probing questions about architecture decisions, obstacles, and what they learned.
Typical Team Structure
Team Size
2-5 PostgreSQL developers
Reports To
Engineering Manager, Tech Lead, or CTO
Collaborates With
Product Management, QA/Testing, DevOps, Design
Skip the JD — Get Matched Instead
Tell us your PostgreSQL requirements and we'll send pre-vetted profiles with video intros in 24-48 hours.
You're all set!
We'll send matched profiles within 24-48 hours. Check your email for next steps.