We are seeking a highly skilled 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 knowledge on Azure, AWS, and Google Cloud technologies.
The ideal candidate will be familiar with PostgreSQL provision, configuration, and management. They should have expertise in creating database objects (triggers, indexes, etc.), monitoring and ensuring database performance in cloud environments.
They will be responsible for identifying potential issues with the database and resolving them in a timely manner to ensure optimal performance and reliability.
The DBA will ensure the maintenance of backups and conduct disaster recovery operations in accordance with business requirements and standards.
They will monitor security and prevent unauthorized access, following compliance procedures.
The DBA will schedule server maintenance in accordance with business requirements, coordinating with stakeholders to ensure minimal disruption and optimal timing.
They will provide best practice guidance to the development/application/stakeholders.
The successful candidate will resolve production data issues within given SLA timelines to avoid major incidents.
They will manage tablespaces and roles as per given security standards.
Database migrations between cross-platforms (Oracle, MS SQL, and DB2) into multi-cloud (Azure, AWS, and GCP) PostgreSQL database technology will also be part of their responsibilities.
Ensuring data integrity and managing user access and permissions as per organization standards is essential for this role.
The ideal candidate will utilize utilities like PgAdmin4, Azure Data Studio, and psql for database maintenance.
Mandatory 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 Description
* Bachelor's degree in computer science, Information Technology, or a related field.
* Multi-Cloud (Azure/AWS/GCP) Certified Professional.