PostgreSQL Database Specialist

About Company :

Our client is a global technology cons,ulting and digital solutions company, resulting from the merger. It focuses on helping businesses leverage digital technologies to reimagine business models, accelerate innovation, and drive growth. The company provides services across various industries, including digital transformation, consulting, and application development.

Role : Postgre sDatabase Developer

Location : Pune,

I nterview Mode : virtual

Work mode : Hybrid

Job type : C2H

Immediate Joiner's : 15 Day's

Experience : 7-12

JD :

Proven experience as a Database Developer with a strong focus on PostgreSQL .

• Proficiency in writing complex SQL queries, stored procedures, and functions .
• Experience with database design, normalization, and schema creation .
• Strong understanding of indexing, query optimization, and performance tuning .
• Familiarity with PostgreSQL extensions (e.G., PostGIS, pg_stat_statements ).
• Knowledge of database security best practices.
• Experience with database backup, recovery, and replication strategies.
• Familiarity with tools like pgAdmin, psql, and other PostgreSQL utilities.
• Experience with version control systems (e.G., Git) and CI / CD pipelines.
• Strong problem-solving skills and attention to detail.
• Experience with cloud-based PostgreSQL solutions
• Good understanding of PostgreSQL – Architecture, security, operational knowledge
• Deep understanding of how PostgreSQL manages data, including tablespaces, data files, indexes, WAL (Write-Ahead Logging), and key processes like Postmaster and bgwriter
• Proficiency in installing, configuring, and upgrading PostgreSQL instances.
• Expertise in identifying and resolving performance bottlenecks, including SQL query optimization, index tuning, and server parameter adjustments.
• Proficiency in scripting languages (e.G., Bash, Python) for automating routine tasks, deployments, and maintenance