PostgreSQL Database Administrator Job Description
">
About the Role:
">
We are seeking a highly skilled PostgreSQL Database Administrator to join our team. As a key member of our IT infrastructure, you will be responsible for managing and optimizing our PostgreSQL database system across multiple cloud environments.
">
Key Responsibilities:
">
">
* Provision, configure, and manage PostgreSQL databases in multi-cloud environments (Azure, AWS, and GCP).
">
* Create database objects, including triggers, indexes, and other database elements.
">
* Monitor and ensure database performance in cloud environments, identifying potential issues and resolving them in a timely manner.
">
* Develop automation technologies for data loading and refresh activities.
">
* Migrate databases between cross-platform environments (Oracle, MS SQL, and DB2) to PostgreSQL technology.
">
* Ensure data integrity and manage user access and permissions according to organizational standards.
">
* Utilize tools like PgAdmin4, Azure Data Studio, and psql for database maintenance.
">
">
Requirements and Qualifications:
">
">
* A minimum of 5 years of experience in PostgreSQL database technology, specifically with multi-cloud environments.
">
* 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 Multi-Cloud tenant (Azure, AWS, and GCP) to provision PostgreSQL PaaS solutions and configure according to security standards.
">
* Understanding of access management to ensure database security.
">
* Problem-solving skills to identify and address potential issues swiftly.
">
* Effective communication skills to collaborate with application teams and stakeholders.
">
">
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