PostgreSQL Developer

Technix-Technology Solutions Private Limited; Patna; On-site; INR 700,000 - 1,200,000; Full time

Job summary

Technix-Technology Solutions Private Limited is seeking a PostgreSQL Developer in Patna, India. This role requires designing and optimizing high-performance databases for critical applications, with responsibilities including writing complex SQL queries and performance tuning. The ideal candidate will have 3-8 years of experience, a Bachelor's degree in a related field, and strong collaboration skills with backend teams. Knowledge of CI/CD and database security is a plus. The position is full-time, with a work-from-office requirement.

Qualifications

• 3-8 years of experience as a PostgreSQL Developer.
• Ability to write and optimize complex SQL queries and stored procedures.
• Strong understanding of relational data modeling and normalization.

Responsibilities

• Design, develop, and maintain PostgreSQL databases, schemas, tables, indexes, triggers, functions, and stored procedures.
• Analyze and tune slow queries, indexing strategies, memory configurations, and execution plans.
• Implement data models for scalable OLTP / OLAP systems depending on business needs.

Skills

PostgreSQL

SQL

PL/pgSQL

Database Design

Database Optimization

Query Performance Tuning

Stored Procedures

Functions

Triggers

Indexing Strategies

Partitioning

Execution Plans

Data Modeling

ETL

Backup and Recovery

pgAdmin

Linux

Shell Scripting

CI/CD

Education

Bachelor’s degree in CS / IT / Engineering

Job description

Skills Required: PostgreSQL, SQL, PL/pgSQL, Database Design, Database Optimization, Query Performance Tuning, Stored Procedures, Functions, Triggers, Indexing Strategies, Partitioning, Execution Plans, Data Modeling, ETL, Backup and Recovery, pgAdmin, pgBouncer, Logical Replication, High Availability, JSONB, PostGIS (optional), Linux, Shell Scripting, CI/CD

Experience Required: 3 – 8 Years

Educational Qualification: Bachelor’s degree in CS / IT / Engineering or equivalent practical experience.

Employment Type: Full Time

Workplace Options: Work From Office

Opening Summary

We are looking for a PostgreSQL Developer who can design, optimize, and maintain high-performance databases that power mission-critical applications. The role demands deep SQL expertise, performance tuning skills, and the ability to collaborate closely with backend teams to translate business requirements into efficient database logic.

Requirements

• Ability to write and optimize complex SQL queries and stored procedures
• Strong understanding of relational data modeling and normalization
• Experience with performance tuning (indexes, partitioning, vacuum strategies, caching)
• Familiarity with PostgreSQL replication, clustering, and high availability
• Ability to debug and analyze query execution plans
• Experience with schema versioning and database migrations
• Strong understanding of database security and access controls

Responsibilities

• Design, develop, and maintain PostgreSQL databases, schemas, tables, indexes, triggers, functions, and stored procedures.
• Analyze and tune slow queries, indexing strategies, memory configurations, and execution plans.
• Implement data models for scalable OLTP / OLAP systems depending on business needs.
• Manage database migrations, version control, and data transformation scripts.
• Work closely with application teams to optimize database-backed business logic.
• Configure backup, restoration, and disaster-recovery strategies.
• Maintain database performance monitoring dashboards and alerts.
• Ensure security, compliance, and least-privilege access policies for all data layers.
• Support CI/CD pipelines with database automation and change management.

Preferred Qualification

Experience with TimescaleDB, CitusDB, or Amazon Aurora PostgreSQL. Exposure to ETL pipelines and large-scale data processing. Experience integrating PostgreSQL with microservices architectures. Familiarity with message queues (Kafka/SQS/RabbitMQ) and transactional sagas. Experience with Data Warehouse / OLAP workloads. Experience supporting BFSI, SaaS, fintech, or analytics-heavy applications. Experience using APM tools for query monitoring and anomaly detection.

Notes

• Strong analytical and problem-solving ability
• Ability to collaborate effectively with backend engineers, architects, and DevOps teams
• Ownership mindset and attention to detail
• Clear and structured communication style