Job Description
We are seeking a skilled PostgreSQL Database Administrator to join our team of professional engineers. The ideal candidate will have extensive experience in managing PostgreSQL databases in multi-cloud environments, including Azure, AWS, and GCP.
About the Role
* Provision, configure, and manage PostgreSQL databases in cloud environments.
* Create database objects (triggers, indexes, etc.) and ensure optimal performance.
* Monitor and resolve potential issues with the database to ensure reliability.
* Maintain backups and conduct disaster recovery operations in accordance with business standards.
* Ensure database security and prevent unauthorized access.
* Provide best practice guidance to development teams and stakeholders.
* Resolving production data issues within SLA timelines to avoid major incidents.
* Manage tablespaces and roles as per security standards.
* Develop automation technologies for data loading and refresh activities.
* Database migrations between cross-platforms (Oracle, MS SQL, DB2) into Multi-Cloud (Azure, AWS, GCP) PostgreSQL databases.
* Ensure data integrity and manage user access and permissions as per organization standards.
Key Skills and Qualifications
* Minimum 5 years of experience in PostgreSQL database technology, specifically with multi-cloud environments.
* Proven experience as a PostgreSQL DBA or similar role.
* In-depth understanding of database management and security.
* Strong problem-solving and communication skills.
* Experience in optimizing database performance, managing database issues, and backups for point-in-time recovery, disaster recovery, and monitoring security and access management.
* Understanding of access management to ensure database security.
* Problem-solving skills to identify and address potential issues swiftly.
Nice-to-Have Skills
* Bachelor's degree in computer science, Information Technology, or a related field.
* Multi-Cloud (Azure/AWS/GCP) Certified Professional.
Languages
English: B2 Upper Intermediate