Database Developer & Administrator (PostgreSQL)

Skill: Database Developer & Administrator (PostgreSQL)
Location: Pune Hybrid

Job Description:
We are looking for a skilled Database Developer & Administrator (PostgreSQL)to design develop administer and optimize enterprise PostgreSQL databases supporting business critical applications. The ideal candidate should have hands on experience in SQL development database administration performance tuning high availability backup & recovery and automation. You will collaborate with application DevOps and architecture teams to deliver secure scalable and high performing database solutions.

Key Skills required:
Database Development
. Design and develop PostgreSQL database objects including tables views indexes functions triggers and stored procedures.
. Develop and optimize complex SQL queries for high performance applications.
. Support data modeling schema design and database migration activities.

Database Administration
. Install configure upgrade and administer PostgreSQL databases.
. Manage backup recovery (PITR) replication and disaster recovery.
. Monitor database health availability and capacity.

Performance & Monitoring
. Optimize SQL queries indexes and PostgreSQL configurations.
. Troubleshoot performance bottlenecks deadlocks replication and database issues.
. Perform database health checks root cause analysis (RCA) and implement preventive measures.

Security & Automation
. Manage users roles permissions and database security.
. Automate routine database tasks using Python or Shell scripting.
. Support CI/CD pipelines and Infrastructure as Code (IaC) initiatives.

Required Skills
. Strong experience with PostgreSQL Administration and Development
. Advanced SQL and PL/pgSQL
. Database Performance Tuning & Query Optimization
. Backup & Recovery (pgdump pgrestore PITR)
. Replication High Availability and Disaster Recovery
. Indexing Partitioning and Execution Plan Analysis
. Database Monitoring (Grafana Prometheus pgAdmin)
. Git and Linux administration
. Python or Shell scripting
. Basic knowledge of Docker Kubernetes and CI/CD pipelines
. Exposure to cloud platforms (Azure Database for PostgreSQL) is preferred.

Key Competencies
. PostgreSQL Administration
. SQL & PL/pgSQL Development
. Performance Tuning & Query Optimization
. High Availability & Replication
. Backup & Disaster Recovery
. Database Security & Governance
. Monitoring & Troubleshooting
. Automation & DevOps

• Continuous Integration
• DevOps
• Postgre SQL
• Shell Script
• Data Analysis

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.

Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

That same commitment to fairness extends to how we use technology. To support our recruitment team AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.

Come join our teamone of the largest IT and business consulting services firms in the world.