PostgreSQL Developer – High-Performance Applications

Job Summary:

We are seeking an experienced PostgreSQL Developer who is highly skilled in designing, developing, and optimizing complex, high-scalability applications. The ideal candidate will have in-depth experience in PostgreSQL SQL and PL/pgSQL programming, a strong understanding of database architecture, and a passion for performance tuning, query optimization, and clean code.

Key Responsibilities:

Design and implement complex SQL queries, stored procedures, triggers, and user-defined functions using PostgreSQL and PL/pgSQL.

Optimize database performance through indexing, partitioning, and query tuning.

Develop high-performance, scalable database solutions for business-critical applications.

Ensure adherence to database best practices, including normalization, security, error handling, and data integrity.

Work closely with backend developers and DevOps teams to integrate PostgreSQL with application layers and deployment pipelines.

Monitor and troubleshoot production databases for performance and availability.

Review and refactor existing PL/pgSQL code to enhance maintainability and efficiency.

Maintain version control and proper documentation for database objects and logic.

Required Qualifications:

Strong proficiency in PostgreSQL, including SQL and PL/pgSQL.

Solid experience with database design, normalization, and data modeling.

Proven ability to optimize queries and troubleshoot performance bottlenecks.

Deep understanding of transaction management, locks, concurrency control, and execution plans.

Familiarity with PostgreSQL extensions is a plus.

Experience working in high-traffic and/or mission-critical environments.

Knowledge of unit testing and version control for database code.

Ability to write clean, modular, and maintainable database code following industry best practices.

At least 6 years or more in database development, design and change management.

Preferred Qualifications:

Familiarity with PostgreSQL internals and performance monitoring tools (e.g., pg_stat_statements, EXPLAIN ANALYZE).

Exposure to microservices, REST APIs, or event-driven architectures with PostgreSQL backends.

Experience with containerized deployments (Docker, Kubernetes) and CI/CD pipelines.

Knowledge of NoSQL, message queues, or data lakes is a plus.

Bachelor’s degree in Computer Science, Information Systems, or related field.

Soft Skills:

Strong analytical and problem-solving skills.

Attention to detail and commitment to quality.

Effective communication and teamwork.

Ability to work independently and deliver on deadlines.

Why Join Us:

Opportunity to work on scalable, high-impact systems.

Collaborative and flexible work environment.

Competitive salary and benefits.

Work with modern tooling and infrastructure.

Show more Show less