About Client :
Our Client is a global IT services company headquartered in Southborough, Massachusetts, USA. Founded in 1996, with a revenue of $1.8B, with 35,000+ associates worldwide, specializes in digital engineering, and IT services company helping clients modernize their technology infrastructure, adopt cloud and AI solutions, and accelerate innovation. It partners with major firms in banking, healthcare, telecom, and media.
Our Client is known for combining deep industry expertise with agile development practices, enabling scalable and cost-effective digital transformation. The company operates in over 50 locations across more than 25 countries, has delivery centers in Asia, Europe, and North America and is backed by Baring Private Equity Asia.
Job Title : Database Developer
Experience Level : 7-12 Years
Job Location : Pune
Budget : 15 LPA
Job Type : Contract
Work Mode : Hybrid
Notice Period : Immediate Joiners
Job Description : Requirements
- 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