Job Title: Advanced Cloud Database Architect
Description:
We are seeking an experienced Senior PostgreSQL Database Administrator to join our team of professional engineers. As part of this program, multiple applications are impacted with strategic changes across the portfolio. The successful candidate will have strong DBA skills and experience with PostgreSQL in multi-cloud environments.
Responsibilities:
* Provision, configuration, and management of PostgreSQL databases in cloud environments.
* Creating database objects such as triggers, indexes, and ensuring database performance.
* Monitoring and resolving potential issues with the database to ensure optimal performance and reliability.
* Maintenance of backups and disaster recovery operations in accordance with business requirements and standards.
* Ensuring security and preventing unauthorized access, following compliance procedures.
* Scheduling server maintenance in accordance with business requirements and coordinating with stakeholders.
* Providing best practice guidance to development teams and stakeholders.
* Resolving production data issues within given SLA timelines.
* Managing tablespaces and roles as per security standards.
* Developing automation technologies for data loading and refresh activities.
* Database migrations between platforms (Oracle, MS SQL, and DB2) into Multi-Cloud PostgreSQL.
* Ensuring data integrity and managing user access and permissions.
* Utilizing tools like PgAdmin4, Azure Data Studio, and psql for database maintenance.
Requirements:
* A minimum of 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 managing PostgreSQL databases in multi-cloud environments.
* Experience in optimizing database performance, managing database issues, and backups for point-in-time recovery.
* Understanding of access management for database security.
* Effective problem-solving and communication skills for collaboration with application teams and stakeholders.
* Bachelor's degree in computer science, information technology, or a related field.
* Multi-Cloud (Azure/AWS/GCP) Certified Professional.
Languages:
English: B2 Upper Intermediate