PostgreSQL Cloud Database Specialist
We are seeking a seasoned PostgreSQL database professional to join our team. The ideal candidate will have expertise in managing and optimizing PostgreSQL databases on multi-cloud platforms, including Azure, AWS, and GCP.
Key Responsibilities:
* Provision, configure, and manage PostgreSQL databases on cloud environments.
* Create database objects, such as triggers, indexes, and views.
* Monitor and ensure database performance, identifying potential issues and resolving them in a timely manner.
* Maintain backups and conduct disaster recovery operations according to business requirements.
* Ensure database security, preventing unauthorized access and complying with organizational standards.
* Schedule server maintenance, coordinating with stakeholders to minimize disruptions.
* Provide guidance on best practices to development teams and stakeholders.
* Resolve production data issues within SLA timelines to prevent major incidents.
* Manage tablespaces and roles according to security standards.
* Develop automation technologies for data loading and refresh activities.
* Migrate databases between cross-platforms (Oracle, MS SQL, and DB2) to multi-cloud (Azure, AWS, and GCP) PostgreSQL databases.
* Evaluate and maintain data integrity, managing user access and permissions according to organizational standards.
* Utilize tools like PgAdmin4, Azure Data Studio, and psql for database maintenance.
Requirements:
* A minimum of 5 years of experience in PostgreSQL database technology, specifically in multi-cloud environments, including Azure, AWS, and GCP tenants.
* Proven 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.