Database Expert (PostgreSQL)

Mô tả công việc

• Manage DB health and services (PostgreSQL first, also Oracle and MongoDB) to ensure the highest standards of availability, resilience, integrity, security, tuning, and performance, backups and recovery plans.
• Participate in transformation and architecture projects, related to AWS, OCI Cloud.
• Execute disaster recovery plans and procedures to ensure database availability during system outages or dysfunction.
• Support development teams on database aspects.
• Join operations sessions with customers for live monitoring, troubleshooting, fine-tuning production database.
• Monitor and resolve issues of both Production and Integration environments

Yêu cầu công việc

• At least 10 years experience in DB Administration (PostgreSQL, Oracle, MongoDB), performance tuning, and backup/recovery strategies.
• Strong knowledge of PostgreSQL, SQL performance optimization, and database security best practices.
• Bachelor’s Degree in Computer Science, Telco, or related fields.
• Strong experience on PostgreSQL (priority), Oracle, MongoDB, MySQL, DB cloud platform (OCI, AWS).
• Strong experience on PL/PGSQL, tuning, ETL, Data Warehousing.
• DB experience and hands on on PostgreSQL and Oracle Database: HA/replication, DR, DB perf optimization, backup, DB admin,…
• Experience in data modeling for large-scale applications and/or software development
• Excellent communication skills.
• Excellent self-learning skills, be able to self-research & propose solutions to database problems.
• Accurate, Organized, Detail oriented, Proactive, Caring, and Curious.
• Flexible shift working in big events or per requirement.

Nice to have

• Strong plus: Hands-on DB migration experience
• Migration tools: ora2pg, AWS DMS/SCT,…
• Managed PostgreSQL: AWS RDS/Aurora, OCI.
• IaC: Terraform, Ansible.
• AI experience