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 servicesDeloitte is where you will find unrivaled opportunities to succeed and realize your full potential.The TeamDeloitte’s 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 (6–8 Years Experience)Experience: 6–8 Years Job Type: Full‑time 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 6–8 years of industry experience to design, optimize, secure, and maintain PostgreSQL databases that support mission‑critical applications. The ideal candidate brings strong hands‑on PostgreSQL expertise, performance tuning skills, and experience working in cloud and enterprise environments. Collaboration with engineering, SRE, and application teams is essential.Key ResponsibilitiesDatabase Design & ArchitectureDesign 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 OptimizationMonitor 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 & AutomationAutomate maintenance tasks: backups, vacuuming, indexing, monitoring (pg_cron, Ansible, cloud schedulers).Support replication, clustering, and high‑availability deployments.Manage patching, version upgrades, and lifecycle activities.Security & Access ControlImplement role‑based access controls, encryption, and database security standards.Ensure compliance with internal security and data governance protocols.Manage user access, permissions, and audit logs.Backup & RecoveryConfigure automated backups and PITR (Point‑in‑Time Recovery).Validate backup integrity and conduct scheduled recovery tests.Troubleshooting & SupportTroubleshoot production and non‑production database issues.Provide best‑practice guidance to developers and SRE teams.Maintain documentation for procedures, configs, and incident handling.Collaboration & Continuous ImprovementSupport 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 & SkillsTechnical Skills6–8 years total experience, with 3–5 years hands‑on 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 SkillsStrong analytical and problem‑solving capabilities.Excellent communication and documentation skills.Ability to collaborate across engineering and platform teams.Highly detail‑oriented with strong focus on data reliability.Continuous learning mindset.Preferred SkillsPartitioning, logical replication, PostGIS.CI/CD and DevOps exposure.Docker/Kubernetes familiarity.PostgreSQL or cloud certifications.How you will growAt 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.BenefitsAt 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 purposeDeloitte 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 theCommunities in which we live and work—always 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 worldRecruiter tipsWe 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 theorganization and the business area you are applying to. Check out recruiting tips from Deloitte professionals.