Senior PostgreSQL Database Administrator (DBA) (with Azure, AWS and GCP)

Luxoft; Brasil; Teletrabalho; BRL 60.000 - 100.000; Tempo integral

Resumo da oferta

An established industry player is seeking a skilled DBA to join their team and support the modernization of IT infrastructure. This role focuses on managing PostgreSQL databases in multi-cloud environments, ensuring optimal performance and reliability. You'll leverage your expertise in Azure, AWS, and Google Cloud technologies to provision, configure, and maintain databases while adhering to security standards. This is an exciting opportunity to make a significant impact in a dynamic environment, where your problem-solving skills and technical knowledge will be valued. Join a forward-thinking company that prioritizes innovation and collaboration.

Qualificações

• 5+ years of experience with PostgreSQL in multi-cloud environments.
• Strong problem-solving and communication skills are essential.
• Experience with database migrations from legacy platforms.

Responsabilidades

• Monitor and ensure database performance in cloud environments.
• Maintain backups and conduct disaster recovery operations.
• Develop automation for data loading and refresh activities.

Conhecimentos

PostgreSQL

Azure

AWS

Google Cloud

Database Management

Problem-solving

Communication Skills

Formação académica

Bachelor's degree in Computer Science

Ferramentas

PgAdmin4

Azure Data Studio

psql

Descrição da oferta de emprego

Project description

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

Responsibilities

• Leverage knowledge of Azure, AWS, and Google Cloud technologies.
• Familiarity with PostgreSQL provisioning, configuration, and management.
• Create database objects such as triggers and indexes.
• Monitor and ensure database performance in cloud environments.
• Identify potential issues with the database and resolve them promptly to ensure optimal performance and reliability.
• Maintain backups and conduct disaster recovery operations in line with business requirements and standards.
• Monitor security, prevent unauthorized access, and adhere to compliance procedures.
• Schedule server maintenance in coordination with relevant stakeholders to minimize disruption and ensure optimal timing.
• Provide best practice guidance to development, application, and stakeholder teams.
• Resolve production data issues within SLA timelines to prevent major incidents.
• Manage tablespaces and roles according to security standards.
• Develop automation for data loading and refresh activities.
• Perform database migrations between platforms (Oracle, MS SQL, DB2) into multi-cloud PostgreSQL databases.
• Ensure data integrity and manage user access and permissions as per organizational standards.
• Utilize utilities like PgAdmin4, Azure Data Studio, and psql for database maintenance.

Skills

Must have

• Minimum of 5 years of experience with PostgreSQL database technology, especially 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 to meet business goals.
• Experience provisioning and configuring PostgreSQL PaaS solutions across Azure, AWS, and GCP, adhering to security standards.
• Experience migrating databases from legacy platforms (SQL, Oracle, DB2) to multi-cloud PostgreSQL PaaS.
• Understanding of access management for database security, including controlling access levels and removing inactive users.
• Proven troubleshooting skills with the ability to quickly identify and resolve issues.
• Excellent communication skills for collaborating with application teams and stakeholders, providing support during AMS hours.

Nice to have

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Multi-cloud (Azure/AWS/GCP) certification.