SENIOR POSTGRESQL DATABASE ADMINISTRATOR (DBA) (WITH AZURE, AWS AND GCP)

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 tGoogle knowledge on Azure, AWS, and Google Cloud technologies.
tFamilier on PostgreSQL provision, configuration and management.
tCreating database objects (triggers, indexes, etc.)n tMonitoring and ensuring database performance in cloud environments.
tIdentifying potential issues with the database and resolving them in a timely manner to ensure optimal performance and reliability.
tEnsuring the maintenance of backups and conducting disaster recovery operations in accordance with business requirements and standards.
tMonitoring security and preventing unauthorized access and follow compliance procedures.
tScheduling server maintenance in accordance with business requirements, after coordinating with all relevant stakeholders to ensure minimal disruption and optimal timing.
tProviding best practice guidance to the development/application/stake holders.
tResolving production data issues as per given SLA timeline to avoid major incidents.
tManaging tablespaces and roles as per given security standards.
tDeveloping automation technologies for data loading and data refresh activities.
tDatabase Migrations between cross platforms (Oracle, MS SQL and DB2) into Multi Cloud (Azure, AWS and GCP) PostgreSQL database technology.
tEnsuring data integrity and managing user access and permissions as per the organization standards.
tUsing utilities like PgAdmin4, Azure Data studio and psql for database maintenance.
SKILLS Must have tA minimum of 5 years of experience is required in PostgreSQL database technology, specifically with multi-cloud environments including Azure, AWS, and GCP tenants.
n tProven previous experience as a PostgreSQL DBA or similar role.
tIn-depth understanding of database management and security.
tStrong problem-solving and communication skills.
n tResponsible 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.
tExperience in Multi Cloud tenant(Azure, AWS, and GCP) to provision the PostgreSQL PaaS solution and configure as per security standards.
tExperienced in database migrations across platforms from legacy databases (SQL, Oracle, and DB2) to multi-cloud PostgreSQL PaaS databases.
tUnderstanding 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.
tProblem-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.
tEffective 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.
tPostgreSQL 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 Bachelor's degree in computer science, Information Technology, or a related field.
•Multi Cloud (Azure/AWS/GCP) Certified Professional.
•tGoogle knowledge on Azure, AWS, and Google Cloud technologies.
•tFamilier on PostgreSQL provision, configuration and management.
•tCreating database objects (triggers, indexes, etc.)n•tMonitoring and ensuring database performance in cloud environments.
•tIdentifying potential issues with the database and resolving them in a timely manner to ensure optimal performance and reliability.
•tEnsuring the maintenance of backups and conducting disaster recovery operations in accordance with business requirements and standards.
•tMonitoring security and preventing unauthorized access and follow compliance procedures.
•tScheduling server maintenance in accordance with business requirements, after coordinating with all relevant stakeholders to ensure minimal disruption and optimal timing.
•tProviding best practice guidance to the development/application/stake holders.
•tResolving production data issues as per given SLA timeline to avoid major incidents.
•tManaging tablespaces and roles as per given security standards.
•tDeveloping automation technologies for data loading and data refresh activities.
•tDatabase Migrations between cross platforms (Oracle, MS SQL and DB2) into Multi Cloud (Azure, AWS and GCP) PostgreSQL database technology.
•tEnsuring data integrity and managing user access and permissions as per the organization standards.
•tUsing utilities like PgAdmin4, Azure Data studio and psql for database maintenance.
•tA minimum of 5 years of experience is required in PostgreSQL database technology, specifically with multi-cloud environments including Azure, AWS, and GCP tenants.
n•tProven previous experience as a PostgreSQL DBA or similar role.
•tIn-depth understanding of database management and security.
•tStrong problem-solving and communication skills.
n•tResponsible 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.
•tExperience in Multi Cloud tenant(Azure, AWS, and GCP) to provision the PostgreSQL PaaS solution and configure as per security standards.
•tExperienced in database migrations across platforms from legacy databases (SQL, Oracle, and DB2) to multi-cloud PostgreSQL PaaS databases.
•tUnderstanding 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.
•tProblem-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.
•tEffective 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.
•tPostgreSQL 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.