Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in patna
>
TECHNIX TECHNOLOGY
>
PostgreSQL Developer

PostgreSQL Developer

TECHNIX TECHNOLOGY

8 years

0 Lacs

patna bihar india

Posted:2 days ago| Platform:

Apply

Skills Required

postgresql developer sql database design optimization query tuning indexing strategies data etl backup pgadmin logical replication postgis linux scripting engineering power development relational indexes clustering analyze versioning security controls olap restoration monitoring compliance support automation processing microservices kafka sqs rabbitmq saas analytics devops communication

Work Mode

On-site

Job Type

Full Time

Job Description

PATNAOpening: 02-Dec-2025Skills 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/CDExperience Required: 3 – 8 YearsEducational Qualification: Bachelor’s degree in CS / IT / Engineering or equivalent practical experience.Employment Type: Full TimeWorkplace Options: Work From OfficeOpening SummaryWe 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

Deep hands-on PostgreSQL development experience in production environments
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.
Write optimized, reusable SQL queries for high-volume data processing.
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 detectionNotes

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

More Jobs at TECHNIX TECHNOLOGY

Data Analyst with Advanced Tableau

karnataka

3.0 - 7.0 yrs

Salary: Not disclosed

Hands On AI Engineer (NLP)

karnataka

2.0 - 6.0 yrs

Salary: Not disclosed

Lead Acquisition Specialist

india

2.0 - 4.0 yrs

Salary: Not disclosed

Lead Acquisition Specialist

jharkhand

2.0 - 6.0 yrs

Salary: Not disclosed

Graphic Designer (CorelDRAW & Print Media Specialist)

dhanbad, jharkhand

3.0 - 7.0 yrs

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

TECHNIX TECHNOLOGY

Login to

Please Verify Your Phone or Email

Confirm Action

PostgreSQL Developer