Senior Database Lead - PostgreSQL & MySQL

CLSA; Hong Kong; On-site; HKD 600,000 - 900,000; Full time

Job summary

CLSA in Hong Kong is seeking a Senior Database Administrator to lead complex database issues and guide team members. You will collaborate with IT stakeholders, vendors, and cross-functional teams to deliver high-quality database services.

The role focuses on PostgreSQL and MySQL, ensuring integrity, availability, and performance, with responsibilities spanning monitoring, backups, capacity planning, and automation. On-call rotations include mornings and weekends.

Qualifications

• Bachelor’s degree or above in Computer Science, MIS or related field.
• Around 10 years of relevant experience including database admin and programming.
• Strong knowledge of database installation, upgrades and migration.
• Experience with POSTGRESQL / MYSQL patches and fixes.
• Skills in automation, scripting (Perl, Python) and shell scripting.
• Knowledge of backup, recovery, and disaster recovery planning.
• Familiarity with logins, user accounts, permissions, and security.
• Capacity planning for storage, compute, memory and performance tuning.
• Experience with high availability, replication, and monitoring.
• Ability to work non-standard shifts including nights/weekends.

Responsibilities

• Provide DBA PostgreSQL/MySQL support for application development.
• Ensure database integrity, availability, security and performance.
• Monitor uptime and performance; recommend improvements.
• Assist capacity planning and data maintenance tasks.
• Perform database enhancements and modifications as required.
• Perform daily/weekly backup and recovery tasks.
• Develop and maintain patches for database environments.
• Lead efforts to automate monitoring and reduce downtime.
• Create and migrate development, staging and production instances.
• Remediate database operational problems proactively.
• Manage logins, users, and permissions.
• On-call rotations for mornings and weekends.

Skills

PostgreSQL

MySQL

Database administration

PL/SQL

Shell scripting

Backup and recovery

Education

Bachelor’s degree in Computer Science, MIS or related

Tools

PostgreSQL

MySQL

MS SQL

OceanBase

Job description

CLSA in Hong Kong is seeking a Senior Database Administrator to lead complex database issues and guide team members. You will collaborate with IT stakeholders, vendors, and cross-functional teams to deliver high-quality database services.

The role focuses on PostgreSQL and MySQL, ensuring integrity, availability, and performance, with responsibilities spanning monitoring, backups, capacity planning, and automation. On-call rotations include mornings and weekends.