Senior PostgreSQL Database Administrator (DBA)

24 Minutes ago • 5 Years +

Job Summary

Job Description

The project involves modernizing the IT landscape towards Cloud infrastructure for a CPG company. The role requires a strong PostgreSQL DBA to support the program. Responsibilities include Google knowledge on Azure, AWS, and Google Cloud technologies, PostgreSQL provision, configuration, and management. The DBA will create database objects, monitor and ensure database performance, identify and resolve potential issues, manage backups and disaster recovery, monitor security, schedule server maintenance, provide guidance to stakeholders, resolve production data issues, manage tablespaces and roles, and develop automation technologies. Database migrations across platforms (Oracle, MS SQL and DB2) into Multi Cloud (Azure, AWS and GCP) PostgreSQL database technology is also expected. Ensuring data integrity and managing user access and permissions are also key aspects of the role.
Must have:
  • 5+ years PostgreSQL database experience in multi-cloud environments.
  • Proven experience as a PostgreSQL DBA.
  • In-depth understanding of database management and security.
  • Strong problem-solving and communication skills.
  • Managing PostgreSQL databases in multi-cloud environments.
  • Experience in Multi Cloud tenant(Azure, AWS, and GCP) to provision the PostgreSQL PaaS solution.
  • Experienced in database migrations across platforms to multi-cloud PostgreSQL PaaS databases.
  • Understanding access management to ensure database security.
  • Ability to troubleshoot and resolve issues efficiently.
  • Effective communication skills for collaboration and support.
  • Managing and optimizing the PostgreSQL database system on multi-cloud (Azure, AWS, and GCP) tenant.
Good to have:
  • Bachelor's degree in computer science or related field.
  • Multi Cloud (Azure/AWS/GCP) Certified Professional.

Job Details

Project description

Our Client is one of the largest CPG companies is modernizing their IT landscape towards Cloud infrastructure. As part of this program multiple applications are impacted with strategic changes across portfolio. We are looking for strong DBA to support program with the Postgre SQL experience to join our team of professional engineers across the globe.

Responsibilities
bullet icon

Google knowledge on Azure, AWS, and Google Cloud technologies.

bullet icon

Familier on PostgreSQL provision, configuration and management.

bullet icon

Creating database objects (triggers, indexes, etc.)

bullet icon

Monitoring and ensuring database performance in cloud environments.

bullet icon

Identifying potential issues with the database and resolving them in a timely manner to ensure optimal performance and reliability.

bullet icon

Ensuring the maintenance of backups and conducting disaster recovery operations in accordance with business requirements and standards.

bullet icon

Monitoring security and preventing unauthorized access and follow compliance procedures.

bullet icon

Scheduling server maintenance in accordance with business requirements, after coordinating with all relevant stakeholders to ensure minimal disruption and optimal timing.

bullet icon

Providing best practice guidance to the development/application/stake holders.

bullet icon

Resolving production data issues as per given SLA timeline to avoid major incidents.

bullet icon

Managing tablespaces and roles as per given security standards.

bullet icon

Developing automation technologies for data loading and data refresh activities.

bullet icon

Database Migrations between cross platforms (Oracle, MS SQL and DB2) into Multi Cloud (Azure, AWS and GCP) PostgreSQL database technology.

bullet icon

Ensuring data integrity and managing user access and permissions as per the organization standards.

bullet icon

Using utilities like PgAdmin4, Azure Data studio and psql for database maintenance.

Skills

Must have

bullet icon

A minimum of 5 years of experience is required in PostgreSQL database technology, specifically with multi-cloud environments including Azure, AWS, and GCP tenants.

bullet icon

Proven previous experience as a PostgreSQL DBA or similar role.

bullet icon

In-depth understanding of database management and security.

bullet icon

Strong problem-solving and communication skills.

bullet icon

Responsible for managing a firm's PostgreSQL databases in multi-cloud environments (Azure, AWS, and GCP), ensuring smooth operation and functionality to meet business goals. Experience in optimizing database performance, managing database issues and backups for point-in-time recovery, disaster recovery, and monitoring security and access management as per business requirements.

bullet icon

Experience in Multi Cloud tenant(Azure, AWS, and GCP) to provision the PostgreSQL PaaS solution and configure as per security standards.

bullet icon

Experienced in database migrations across platforms from legacy databases (SQL, Oracle, and DB2) to multi-cloud PostgreSQL PaaS databases.

bullet icon

Understanding access management to ensure database security. This includes controlling who can access the database and to what extent, as well as removing inactive users when necessary.

bullet icon

Problem-solving is another crucial soft skill. Given that troubleshooting is a key responsibility, the candidate must be adept at identifying and addressing potential issues swiftly. They should be capable of devising quick and effective solutions to resolve these problems efficiently.

bullet icon

Effective communication skills are crucial for collaborating with the application team and stakeholders to comprehend business requirements and deliver DBA support during AMS working hours. This involves actively engaging with team members and stakeholders to ensure clear understanding and alignment on project goals. Additionally, providing timely and efficient DBA support during AMS working hours is essential for maintaining smooth operations and addressing any issues that may arise.

bullet icon

PostgreSQL DBA (Database Administrator) is responsible for managing and optimizing the PostgreSQL database system on multi-cloud (Azure, AWS, and GCP) tenant and provide support on AMS working hours.

Nice to have

bullet icon

Bachelor's degree in computer science, Information Technology, or a related field.

bullet icon

Multi Cloud (Azure/AWS/GCP) Certified Professional.

Other
seniority icon

Languages

English: B2 Upper Intermediate

seniority icon

Seniority

Senior

Similar Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Skill Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Jobs in Worldwide

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Category Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

Empower your future with Luxoft: Innovate, thrive and grow in a software-defined world.Luxoft works with companies from all over the globe and offers opportunities for candidates anywhere in the world.

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia (On-Site)

View All Jobs

Get notified when new jobs are added by luxsoft

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug