Database Developer

Job Title: PostgreSQL Database Developer

Location:

Experience:

Employment Type:

Notice Period:

About the Company:

Our client is a trusted global innovator of IT and business services, present in 50+ countries. They specialize in digital & IT modernization, consulting, managed services, and industry-specific solutions. With a commitment to long-term success, they empower clients and society to move confidently into the digital future.

Must Have Skills:

• PostgreSQL (Production Experience)
• Advanced SQL
• Query Optimization & Performance Tuning
• PL/pgSQL
• PostgreSQL Internals & Explain Plans
• Indexes, Constraints & Transaction Isolation
• Data Migration (COPY, FDW, Data Loaders)
• ETL & Batch Processing

Minimum Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent practical experience).
• 7+ years of hands-on experience working with PostgreSQL in production environments.
• Strong experience in SQL query writing, optimization, and performance tuning.
• Proficiency in writing PL/pgSQL functions, procedures, and triggers.
• Solid understanding of PostgreSQL internals, indexing strategies, and execution plans.

Preferred Qualifications:

• Experience with data migration from Oracle, DB2, MySQL, or other RDBMS to PostgreSQL.
• Strong understanding of transaction isolation levels and concurrency control.
• Experience with schema design, table partitioning, and materialized views.
• Exposure to ETL processes, batch jobs, and data transformation pipelines.
• Ability to proactively identify and resolve slow queries and long-running processes.

Responsibilities:

• Design, develop, and maintain complex SQL queries, stored procedures, triggers, and functions in PostgreSQL.
• Perform PostgreSQL performance tuning, query optimization, and indexing improvements.
• Collaborate closely with application developers, data engineers, and architects to design efficient data models and access paths.
• Handle data migration from legacy systems or other RDBMS into PostgreSQL.
• Develop and maintain ETL scripts and batch jobs for data processing and transformation.
• Assist in schema design, table partitioning strategies, and creation of materialized views.
• Monitor database performance and proactively resolve slow-running queries and bottlenecks.

Important Note (Please Read Before Applying)

Do NOT apply if:

• You have less than 7 years of PostgreSQL experience
• You do not have hands-on PostgreSQL development in production environments
• You are on a notice period longer than immediate availability
• You are a fresher or from an unrelated background (e.g., support-only, testing-only roles)

Apply ONLY if you meet ALL criteria above.

Random or irrelevant applications will not be processed.