PostgreSQL Database Specialist | 7+ years only | Bangalore

What impact will you make?

Every day, your work will make an impact that matters, while you thrive in a dynamic culture of inclusion, collaboration and high performance. As the undisputed leader in professional services

Deloitte is where you will find unrivaled opportunities to succeed and realize your full potential.

The Team

Deloittes Technology & Transformation practice can help you uncover and unlock the value buried deep inside vast amounts of data. Our global network provides strategic guidance and implementation services to help companies manage data from disparate sources and convert it into accurate, actionable information that can support fact-driven decision-making and generate an insight-driven advantage. Our practice addresses the continuum of opportunities in business intelligence & visualization, data management, performance management and next-generation analytics and technologies, including big data, cloud, cognitive and machine learning.

PostgreSQL Database Specialist (68 Years Experience)

Experience: 68 Years

Job Type: Fulltime

Important:

Candidates must read the Job Description and Screening Questions carefully and apply only if they meet the requirements.

Note: This is not a traditional DBA role. Pure DB Administrators are not suitable for this position.

Role Overview

We are seeking an experienced PostgreSQL Database Specialist with 68 years of industry experience to design, optimize, secure, and maintain PostgreSQL databases that support missioncritical applications. The ideal candidate brings strong handson PostgreSQL expertise, performance tuning skills, and experience working in cloud and enterprise environments. Collaboration with engineering, SRE, and application teams is essential.

Key Responsibilities

Database Design & Architecture

• Design scalable schemas, tables, indexes, views, and triggers.
• Align database models with application and business requirements.
• Utilize PostgreSQL features such as JSON/JSONB, window functions, partitioning, and extensions.

Performance Optimization

• Monitor and tune database performance using PostgreSQL native tools and APM platforms.
• Optimize SQL queries, indexing strategies, and execution plans (EXPLAIN).
• Identify and resolve performance bottlenecks.

Maintenance & Automation

• Automate maintenance tasks: backups, vacuuming, indexing, monitoring (pg_cron, Ansible, cloud schedulers).
• Support replication, clustering, and highavailability deployments.
• Manage patching, version upgrades, and lifecycle activities.

Security & Access Control

• Implement rolebased access controls, encryption, and database security standards.
• Ensure compliance with internal security and data governance protocols.
• Manage user access, permissions, and audit logs.

Backup & Recovery

• Configure automated backups and PITR (PointinTime Recovery).
• Validate backup integrity and conduct scheduled recovery tests.

Troubleshooting & Support

• Troubleshoot production and nonproduction database issues.
• Provide bestpractice guidance to developers and SRE teams.
• Maintain documentation for procedures, configs, and incident handling.

Collaboration & Continuous Improvement

• Support CI/CD and DevOps workflows involving database components.
• Participate in performance testing, capacity planning, and architectural reviews.
• Stay current with PostgreSQL advancements and contribute to tooling/process improvements.

Required Experience & Skills

Technical Skills

• 68 years total experience, with 35 years handson PostgreSQL experience in enterprise environments.
• Strong SQL, data modeling, and query tuning skills.
• Familiarity with monitoring tools (pg_stat_statements, pgAdmin, APM tools).
• Knowledge of HA, replication, clustering, backups, and DR strategies.
• Experience with automation (Ansible, Terraform, pg_cron).
• Experience with cloud DB platforms (AWS RDS, Azure PostgreSQL).
• Scripting ability in Python or Bash.

Soft Skills

• Strong analytical and problemsolving capabilities.
• Excellent communication and documentation skills.
• Ability to collaborate across engineering and platform teams.
• Highly detailoriented with strong focus on data reliability.
• Continuous learning mindset.

Preferred Skills

• Partitioning, logical replication, PostGIS.
• CI/CD and DevOps exposure.
• Docker/Kubernetes familiarity.
• PostgreSQL or cloud certifications.

How you will grow

At Deloitte, our professional development plan focuses on helping people at every level of their career to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe there is always room to learn. We offer opportunities to help build excellent skills in addition to hands-on experience in the global, fast-changing business world. From on-the-job learning experiences to formal development programs at Deloitte University, our professionals have a variety of opportunities to continue to grow throughout their career. Explore Deloitte University, The Leadership Centre.

Benefits

At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you.

Our purpose

Deloitte is led by a purpose: To make an impact that matters.

Every day, Deloitte people are making a real impact in the places they live and work. We pride ourselves on doing not only what is good for clients, but also what is good for our people and the

Communities in which we live and workalways striving to be an organization that is held up as a role model of quality, integrity, and positive change. Learn more about Deloitte's impact on the world

Recruiter tips

We want job seekers exploring opportunities at Deloitte to feel prepared and confident. To help you with your interview, we suggest that you do your research: know some background about the

organization and the business area you are applying to. Check out recruiting tips from Deloitte professionals.