Postgres DBA (Consultant/Lead/Architect)
Job Description
- Proficiency in writing complex SQL queries and PL/pgSQL procedures.
- Familiarity with Linux/Unix systems and shell scripting.
- Experience with monitoring tools like Prometheus, Grafana, or Nagios.
- Understanding of database security best practices and access control.
- 4+ years of PostgreSQL DBA experience in production environments.
- Strong knowledge of PostgreSQL architecture and performance tuning.
Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.
Job Description
- PostgreSQL Database Administrator with over 4+ years of hands-on experience to manage, maintain, and optimize our PostgreSQL database environments.
- The ideal candidate will be responsible for ensuring high availability, performance, and security of our databases while supporting development and operations teams.
- Install, configure, and upgrade PostgreSQL database systems.
- Monitor database performance and implement tuning strategies.
- Perform regular database maintenance tasks such as backups, restores, and indexing.
- Ensure database security, integrity, and compliance with internal and external standards.
- Automate routine tasks using scripting (e.g., Bash, Python).
- Troubleshoot and resolve database-related issues in a timely manner.
- Collaborate with development teams to optimize queries and database design.
- Implement and maintain high availability and disaster recovery solutions.
- Maintain documentation related to database configurations, procedures, and policies.
- Participate in on-call rotation and provide support during off-hours as needed.
Primary skills
- 4+ years of experience as a PostgreSQL DBA in production environments.
- Strong knowledge of PostgreSQL architecture, replication, and performance tuning.
Secondary skills
- Proficiency in writing complex SQL queries and PL/pgSQL procedures.
- Familiarity with Linux/Unix systems and shell scripting.
- Experience with monitoring tools like Prometheus, Grafana, or Nagios.
- Understanding of database security best practices and access control.
Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem.
