Highly Experienced PostgreSQL Database Administrator
About the Job
We are seeking a highly skilled PostgreSQL DBA to manage and optimize our PostgreSQL database system on multi-cloud tenant.
Key Responsibilities:
* Provision, configure and manage PostgreSQL databases in multi-cloud environments (Azure, AWS, and GCP).
* Create database objects (triggers, indexes, etc.) and ensure database performance in cloud environments.
* Monitor and resolve potential issues with the database to ensure optimal performance and reliability.
* Ensure maintenance of backups and conduct disaster recovery operations in accordance with business requirements and standards.
* Monitor security and prevent unauthorized access while following compliance procedures.
* Schedule server maintenance in accordance with business requirements after coordinating with stakeholders.
* Provide best practice guidance to development/application/stakeholders and resolve production data issues within given SLA timeline.
* Manage tablespaces and roles as per given security standards.
* Develop automation technologies for data loading and data refresh activities.
* Migrate databases between cross-platforms (Oracle, MS SQL and DB2) into Multi Cloud (Azure, AWS and GCP) PostgreSQL database technology.
* Ensure data integrity and manage user access and permissions as per organization standards.
* Utilize tools like PgAdmin4, Azure Data Studio and psql for database maintenance.
Required Skills and Qualifications:
* A minimum of 5 years of experience is required 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.
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
],