PostgreSQL Developer Intern

Technix-Technology Solutions Private Limited; Patna; On-site; INR 111,600 - 167,400; Full time

Benefits offered by this job

Certificate of Completion

Mentorship from experienced engineers

Potential full-time opportunity

Job summary

Technix-Technology Solutions Private Limited is seeking a PostgreSQL Developer Intern in Patna, Bihar. This 6-month full-time internship focuses on relational databases, query optimization, and collaboration with backend teams. Candidates should have strong PostgreSQL knowledge and be available for the entire duration. Responsibilities include optimizing database structures and documenting changes. A stipend starts after the third month, and successful interns may receive a full-time job offer based on performance.

Qualifications

• Understanding of relational database concepts.
• Experience with PostgreSQL through academic or personal projects.
• Ability to write complex SQL queries and optimize them.
• Must provide examples of work.

Responsibilities

• Design, maintain, and optimize PostgreSQL tables and schemas.
• Write efficient SQL queries, joins, and functions.
• Support developers in integrating PostgreSQL with applications.
• Assist in database backups and migration scripts.

Skills

PostgreSQL

SQL

Schema Design

Query Optimization

Documentation

Git

Problem Solving

Relational Database Fundamentals

Education

Bachelor’s / Master’s degree in Computer Science, IT, Data Engineering, Software Engineering, or related fields

Tools

pgAdmin

DBeaver

Job description

Skills Required: PostgreSQL, SQL, Schema Design, Joins & Subqueries, Stored Procedures, Functions, Indexing, Query Optimization, Relational Database Fundamentals, Git, Problem Solving, Documentation & Communication Skills

Educational Qualification: Bachelor’s / Master’s degree in Computer Science, IT, Data Engineering, Software Engineering, or related fields.

Internship Type: DEFERRED STIPEND

Stipend Policy: Starts after 3rd month

Workplace Options: Work From Office

Opening Summary

We are looking for a PostgreSQL Developer Intern who is passionate about relational databases, query optimization, and building efficient data structures. You will collaborate with backend and data engineering teams to design schemas, write SQL queries, optimize performance, and support data-driven application development.

Requirements

• Strong understanding of relational database concepts.
• Hands-on experience with PostgreSQL through academic or personal projects.
• Ability to design tables, relationships, and normalize database structures.
• Ability to write complex SQL queries and optimize them.
• Familiarity with tools like pgAdmin or DBeaver.
• Must be available full-time for the entire 6-month internship.
• Must provide GitHub, project links, or SQL script samples demonstrating work.

Responsibilities

• Design, maintain, and optimize PostgreSQL tables, schemas, and relational structures.
• Write efficient SQL queries, joins, functions, and stored procedures.
• Support backend developers in integrating PostgreSQL with application services.
• Work on query optimization, indexing strategies, and performance tuning.
• Assist in database backups, migration scripts, and version control of database changes.
• Participate in data modeling discussions for new features and product enhancements.
• Document database changes, schema designs, and performance improvements.

Preferred Qualification

Knowledge of advanced SQL concepts such as window functions, triggers, and transactions. Familiarity with stored procedures and PL/pgSQL scripting. Experience with database migration tools (Flyway, Liquibase). Understanding of query execution plans and performance tuning. Exposure to cloud databases (AWS RDS, Azure PostgreSQL, or GCP Cloud SQL).

• Hands-on experience working with production-grade PostgreSQL databases
• Mentorship from experienced database and backend engineers
• Certificate of Completion
• Potential full-time opportunity as Database Developer or Backend Developer based on performance

Stipend Eligibility Criteria

• Complete the entire 6-month internship duration.
• Maintain minimum 80% attendance (as per company policy).
• Meet assigned database deliverables, including queries, schema updates, and documentation.
• Participate actively in team meetings, sprint sessions, and technical discussions.
• Follow data security, confidentiality, and organizational standards.
• Early exit or termination due to poor performance or misconduct will void stipend eligibility.