Job Description:
">
">
* As a senior PostgreSQL database administrator, you will be responsible for managing and optimizing the PostgreSQL database system on multi-cloud tenant.
">
">
Responsibilities:
">
">
* Google knowledge on Azure, AWS, and Google Cloud technologies.
">
* Familiarity with PostgreSQL provision, configuration, and management.
">
* Creatings database objects (triggers, indexes, etc).
">
* Monitoring and ensuring database performance in cloud environments.
">
* Identifying potential issues with the database and resolving them in a timely manner to ensure optimal performance and reliability.
">
* Ensuring the maintenance of backups and conducting disaster recovery operations in accordance with business requirements and standards.
">
* Monitoring security and preventing unauthorized access and following compliance procedures.
">
* Scheduling server maintenance in accordance with business requirements, after coordinating with all relevant stakeholders to ensure minimal disruption and optimal timing.
">
* Providing best practice guidance to the development/application/stakeholders.
">
* Resolving production data issues as per given SLA timeline to avoid major incidents.
">
* Managing tablespaces and roles as per given security standards.
">
* Developing automation technologies for data loading and data refresh activities.
">
* Database migrations between cross platforms (Oracle, MS SQL, and DB2) into Multi Cloud (Azure, AWS, and GCP) PostgreSQL database technology.
">
* Ensuring data integrity and managing user access and permissions as per organization standards.
">
">
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.
">
* Experienced in database migrations across platforms from legacy databases (SQL, Oracle, and DB2) to multi-cloud PostgreSQL PaaS databases.
">
* Understanding access management to ensure database security.
">
* Problem-solving skills are crucial for troubleshooting and addressing potential issues swiftly.
">
* Effective communication skills are essential for collaborating with the application team 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.
">
* English: B2 Upper Intermediate.
">