Our Opportunity.

We are expanding our team and looking for an PostgreSQL Database Administrator (DBA) who shares our passion for technological challenges.
If you're seeking a collaborative environment and growth opportunities, this could be your chance! Join us!

Responsibilities:
* Database Installation & Configuration: Install, configure, and maintain PostgreSQL databases across various platforms, ensuring optimal configuration and performance.
* Performance Tuning: Continuously monitor database performance, analyze slow queries, and optimize indexing, queries, and schema to improve system efficiency and response times.
* Backup & Recovery: Design and implement backup and disaster recovery strategies, ensuring regular, reliable backups and rapid recovery in the event of failure.
* Security Management: Administer user access control, implement encryption techniques, and ensure the integrity of the database by applying security patches and monitoring for vulnerabilities.
* Replication & High Availability: Set up and manage PostgreSQL replication (e.g., streaming replication, logical replication) and clustering solutions (e.g., Patroni, PgBouncer) for high availability and scalability.
* Database Maintenance: Perform routine database maintenance such as upgrades, patches, reorganization, and data purging to keep the database environment healthy and secure.
* Troubleshooting & Issue Resolution: Identify and resolve database-related issues, including performance bottlenecks, corruption, and outages. Provide quick resolutions to ensure minimal system downtime.
* Capacity Planning: Monitor database growth and performance metrics, planning and implementing strategies to handle increased database load and scale for future growth.
* Automation & Scripting: Write and maintain automation scripts to streamline routine tasks like backups, performance monitoring, and database health checks.
* Collaboration: Work with developers and system administrators to optimize database schema design, queries, and ensure efficient integration with applications.
* Documentation: Maintain detailed documentation on database configurations, procedures, and troubleshooting guidelines for team members and future reference.

Descrição longa

- Preferred Skills:
Advanced English required for conversation; international project.
PostgreSQL certification (e.g., PostgreSQL Certified DBA) is a plus.
Familiarity with NoSQL databases (e.g., MongoDB) and their integration with PostgreSQL.
Experience with database migration and version control systems
Knowledge of DevOps practices and automation tools is a plus.
Ensure database security, manage user roles, and control access.
Automate routine maintenance tasks using scripts and tools (e.g., pg_ctl, psql, cron).
Database Migration:
Plan and execute database migrations (on-prem to cloud, version upgrades, cross-platform).
Perform data extraction, transformation, and loading (ETL) with minimal downtime.
Validate data integrity and consistency post-migration.
Collaborate with application and infrastructure teams to ensure smooth transitions.
Monitoring & Optimization:
Use monitoring tools to track performance metrics and proactively resolve issues.
Tune PostgreSQL configurations for optimal performance and scalability.
Maintain logs, audit trails, and compliance with data governance policies.
Collaboration & Documentation:
Work closely with developers, DevOps, and business analysts.
Document database architecture, migration plans, and standard operating procedures.
Required Skills & Qualifications:
Bachelor's degree in Computer Science, Information Systems, or related field.
3+ years of experience in PostgreSQL administration and database migrations.
Strong knowledge of PostgreSQL internals, replication, and partitioning.
Experience with tools like pgAdmin, pg_dump, pg_restore, and logical/physical replication.
Familiarity with cloud platforms (AWS RDS, Azure Database for PostgreSQL, GCP).
Proficiency in scripting (Bash, Python, or PowerShell).

- Preferred Qualifications:

Experience with CI/CD pipelines and DevOps practices.
Knowledge of other RDBMS (MySQL, Oracle, SQL Server) is a plus.
PostgreSQL certification or relevant cloud certifications.

Descrição longa

Development and Benefits

Here, you are the protagonist of your career! We offer:

• Structured career plan and personalized learning paths.
• Corporate University with access to Harvard, Coursera, Udemy, Pluralsight.
• Official certifications with partners such as SAP, AWS, Microsoft, Salesforce.
• Language courses with EF Education First (English, Spanish, French, and German).

Comprehensive Well-being:

• Medical and dental assistance.
• Gympass and Equilibrium (physical and mental health).
• Private pension plan and life insurance.
• Family Care Program: extended maternity and paternity leave, fertility support, personalized health and wellness guidance.
• Meal vouchers, home office allowance, benefits club, and much more!

Descrição longa

Diversity, Inclusion, and Belonging

At Capgemini, you can be yourself. We value diversity in all its forms and promote an inclusive environment through committees such as:

Women@Capgemini – Female empowerment and gender equity.

Capgemini Black – Representation and appreciation of Black culture.

LGBTQIA+@Capgemini, Capgemini Accessibility, among others.

Our commitment is ongoing: we are recognized by GPTW, Bloomberg Gender Equality Index, EDGE, and Ethisphere as one of the most ethical and inclusive companies in the world. Our job opportunities are open to everyone, regardless of color, ethnicity, religion, age, gender identity, sexual orientation, or disability.

Make it real

At Capgemini, we unleash human energy through technology to build a more inclusive, sustainable, and innovative future. If you share these values, come transform the world with us!