Job Description:
We are seeking an experienced PostgreSQL Database Administrator to manage and optimize our PostgreSQL database system on a multi-cloud tenant (Azure, AWS, and GCP).
Responsibilities
* Provision, configure, and manage PostgreSQL databases in multi-cloud environments.
* Create database objects such as triggers, indexes, and views.
* Monitor and ensure database performance in cloud environments.
* Identify and resolve potential issues with the database in a timely manner.
* Maintain backups and conduct disaster recovery operations.
* Monitor security and prevent unauthorized access.
* Schedule server maintenance and provide best practice guidance.
* Resolve production data issues and manage tablespaces and roles.
* Develop automation technologies for data loading and data refresh activities.
* Migrate databases between platforms (Oracle, MS SQL, and DB2) into Multi Cloud (Azure, AWS, and GCP) PostgreSQL database technology.
Required Skills and Qualifications
* A minimum of 5 years of experience in PostgreSQL database technology, specifically with multi-cloud environments including Azure, AWS, and GCP tenants.
* Proven previous experience as a PostgreSQL DBA or similar role.
* In-depth understanding of database management and security.
* Strong problem-solving and communication skills.
* Experience in managing PostgreSQL databases in multi-cloud environments.
* Knowledge of database migration from legacy databases (SQL, Oracle, and DB2) to multi-cloud PostgreSQL PaaS databases.
Languages
English: B2 Upper Intermediate