PostgreSQL DBA

Luxoft; Belo Horizonte; Presencial; BRL 20.000 - 80.000; Tempo integral

Resumo da oferta

A leading company in the CPG sector is seeking a PostgreSQL DBA to manage and optimize databases across multi-cloud environments. The role requires strong experience in PostgreSQL, cloud technologies, and database management, ensuring optimal performance and security. The DBA will collaborate with teams globally, providing best practice guidance and resolving production data issues swiftly.

Qualificações

• At least 5 years of experience with PostgreSQL in multi-cloud environments.
• Proven experience as a PostgreSQL DBA or similar role.

Responsabilidades

• Manage and optimize PostgreSQL databases across multi-cloud environments.
• Monitor and ensure database performance in cloud environments.
• Perform database migrations between cross-platform environments.

Conhecimentos

Problem-Solving

Communication

Database Management

Security

Ferramentas

PgAdmin4

Azure Data Studio

psql

Descrição da oferta de emprego

Project description
Our client is one of the largest CPG companies, modernizing their IT landscape towards cloud infrastructure. As part of this program, multiple applications are impacted with strategic changes across the portfolio. We are looking for a strong DBA with PostgreSQL experience to support the program and join our team of professional engineers across the globe.
Responsibilities

1. Leverage knowledge of Azure, AWS, and Google Cloud technologies.
2. Familiar with PostgreSQL provisioning, configuration, and management.
3. Create database objects (triggers, indexes, etc.).
4. Monitor and ensure database performance in cloud environments.
5. Identify potential issues with the database and resolve them promptly to ensure optimal performance and reliability.
6. Maintain backups and conduct disaster recovery operations according to business requirements and standards.
7. Monitor security to prevent unauthorized access and ensure compliance procedures are followed.
8. Schedule server maintenance in coordination with stakeholders to minimize disruption and optimize timing.
9. Provide best practice guidance to development, application, and stakeholder teams.
10. Resolve production data issues within SLA timelines to avoid major incidents.
11. Manage tablespaces and roles according to security standards.
12. Develop automation technologies for data loading and refresh activities.
13. Perform database migrations between cross-platform environments (Oracle, MS SQL, DB2) into multi-cloud PostgreSQL databases.
14. Ensure data integrity and manage user access and permissions per organization standards.
15. Utilize utilities like PgAdmin4, Azure Data Studio, and psql for database maintenance.

Skills
Must have

• At least 5 years of experience with PostgreSQL in multi-cloud environments (Azure, AWS, GCP).
• Proven experience as a PostgreSQL DBA or similar role.
• Deep understanding of database management and security.
• Strong problem-solving and communication skills.
• Experience managing PostgreSQL databases in multi-cloud environments, ensuring smooth operation and performance.
• Experience provisioning PostgreSQL PaaS solutions in Azure, AWS, and GCP, and configuring them securely.
• Database migration experience from legacy systems (SQL, Oracle, DB2) to multi-cloud PostgreSQL.
• Knowledge of access management to secure databases, including user access control and inactive user removal.
• Ability to troubleshoot and resolve issues swiftly and effectively.
• Excellent communication skills for collaborating with teams and stakeholders, and providing support during AMS hours.

PostgreSQL DBA (Database Administrator) is responsible for managing and optimizing PostgreSQL databases across multi-cloud tenants and supporting operations during AMS working hours.