Postgresql DBA

Your potential, unleashed.India’s impact on the global economy has increased at an exponential rate and Deloitte presents an opportunity to unleash and realise your potential amongst cutting edge leaders, and organisations shaping the future of the region, and indeed, the world beyond.At Deloitte, your whole self to work, every day. Combine that with our drive to propel with purpose and you have the perfect playground to collaborate, innovate, grow, and make an impact that matters.The teamAs a member of the Operations Transformations team you will embark on an exciting and fulfilling journey with a group of intelligent and innovative globally aware individuals.We work in conjuncture with various institutions solving key business problems across a broad-spectrum roles and functions, all set against the backdrop of constant industry change.Your work profileJob Title: Database Architect (DBA) – PostgreSQL Expert Location: Delhi Experience Level: 10+ Years Education Qualifications: BE/B.Tech/MCA/M.TechJob Role10 years in database design, optimization, backup strategies, security, and administration of databases like MySQL, PostgreSQL, Oracle, or MS SQL Server.Certifications : Relevant certificationResponsibilities:Looking for highly skilled Database Architect (DBA) with deep expertise in PostgreSQL to design, manage, and optimize our database infrastructure. The ideal candidate will be responsible for ensuring high availability, performance, and scalability of PostgreSQL databases. This role involves working closely with development teams to design database solutions that meet both application requirements and best practices for data management and security.Key Responsibilities :Design, implement, and manage high-performance, scalable PostgreSQL database systems.Optimize database performance through indexing, query tuning, and other optimization techniques.Ensure data integrity, security, and disaster recovery through effective backup strategies, replication, and failover mechanisms.Monitor database performance and proactively resolve performance bottlenecks.Implement best practices for database architecture, including partitioning, sharing, and clustering.Perform regular database health checks, patching, and version upgrades.Manage users, roles, and database access permissions to ensure data security.Troubleshoot database issues and provide timely resolution.Stay updated with the latest PostgreSQL features and advancements to improve database performance and scalabilityProven experience as a Database Architect or DBA, with expertise in PostgreSQL.Strong proficiency in designing and optimizing PostgreSQL databases.Experience with database replication, partitioning, clustering, and sharding.Proficiency in query tuning, performance optimization, and indexing strategies.Strong knowledge of SQL and PostgreSQL-specific features such as PL/pgSQL, triggers, and stored procedures.Experience with PostgreSQL backup and restore processes, including logical and physical backups.Knowledge of database monitoring tools and techniquesExperience with database migration strategies and toolsHow you’ll growConnect for impactOur exceptional team of professionals across the globe are solving some of the world’s most complex business problems, as well as directly supporting our communities, the planet, and each other. Know more in our Global Impact Report and our India Impact Report.Empower to leadYou can be a leader irrespective of your career level. Our colleagues are characterised by their ability to inspire, support, and provide opportunities for people to deliver their best and grow both as professionals and human beings. Know more about Deloitte and our One Young World partnership.Inclusion for allAt Deloitte, people are valued and respected for who they are and are trusted to add value to their clients, teams and communities in a way that reflects their own unique capabilities. Know more about everyday steps that you can take to be more inclusive. At Deloitte, we believe in the unique skills, attitude and potential each and every one of us brings to the table to make an impact that matters.Drive your careerAt Deloitte, you are encouraged to take ownership of your career. We recognise there is no one size fits all career path, and global, cross-business mobility and up / re-skilling are all within the range of possibilities to shape a unique and fulfilling career. Know more about Life at Deloitte.Everyone’s welcome… entrust your happiness to usOur workspaces and initiatives are geared towards your 360-degree happiness. This includes specific needs you may have in terms of accessibility, flexibility, safety and security, and caregiving. Here’s a glimpse of things that are in store for you.Interview tipsWe want job seekers exploring opportunities at Deloitte to feel prepared, confident and comfortable. To help you with your interview, we suggest that you do your research, know some background about the organisation and the business area you’re applying to. Check out recruiting tips from Deloitte professionals.