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 the portfolio. We are looking for a strong dba with postgresql experience to join our team of professional engineers across the globe.
responsibilities:
1. google knowledge on azure, aws, and google cloud technologies.
2. familiar with postgresql provision, configuration, and management.
3. monitoring and ensuring database performance in cloud environments.
4. identifying potential issues with the database and resolving them in a timely manner to ensure optimal performance and reliability.
5. ensuring the maintenance of backups and conducting disaster recovery operations in accordance with business requirements and standards.
6. monitoring security and preventing unauthorized access and following compliance procedures.
7. scheduling server maintenance in accordance with business requirements, coordinating with all relevant stakeholders to ensure minimal disruption and optimal timing.
8. providing best practice guidance to the development/application stakeholders.
9. resolving production data issues as per given sla timeline to avoid major incidents.
10. managing tablespaces and roles as per given security standards.
11. developing automation technologies for data loading and data refresh activities.
12. database migrations between cross platforms (oracle, ms sql, and db2) into multi cloud (azure, aws, and gcp) postgresql database technology.
13. ensuring data integrity and managing user access and permissions as per the organization standards.
14. using utilities like pgadmin4, azure data studio, and psql for database maintenance.
mandatory skills description:
1. a minimum of 5 years of experience in postgresql database technology, specifically with multi-cloud environments including azure, aws, and gcp tenants.
2. proven previous experience as a postgresql dba or similar role.
3. in-depth understanding of database management and security.
4. strong problem-solving and communication skills.
5. 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.
6. 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.
7. experience in multi cloud tenant (azure, aws, and gcp) to provision the postgresql paas solution and configure as per security standards.
8. experienced in database migrations across platforms from legacy databases (sql, oracle, and db2) to multi-cloud postgresql paas databases.
9. understanding access management to ensure database security.
10. effective communication skills for collaborating with the application team and stakeholders.
nice-to-have skills description:
bachelor's degree in computer science, information technology, or a related field.
seniority level
* mid-senior level
employment type
* full-time
job function
* information technology
* it services and it consulting
#j-18808-ljbffr