Sr. Infra Analyst, Databases, IT

CLSA

Hong Kong

On-site

HKD 600,000 - 900,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

MS SQL Servers
Perl scripting
Python scripting
ITIL principles
Oracle database administration
MySQL database administration

Job summary

H130 MetLife Investment Management Taiwan Limited is seeking a Database Administrator to own complex issues, collaborating with IT stakeholders, vendors and teams to deliver high-quality database services. You will support PostgreSQL and MySQL, ensure integrity, security, availability and performance, monitor uptime and capacity, and contribute to automation and procedures.

The role requires 5–7 years of experience, hands-on PostgreSQL/MySQL, Linux scripting, and strong English/Chinese

Qualifications

  • Bachelor’s degree in Computer Science, MIS or related field.
  • 5-7 years of relevant experience including database administration and programming.
  • 3 years of hands-on PostgreSQL / MySQL experience.

Responsibilities

  • Offer DBA PostgreSQL / MySQL support for application development team.
  • Ensure integrity, availability, security and performance of PostgreSQL / MySQL database systems.
  • Monitor database uptime, performance and recommend improvements for operational efficiency.
  • Assist in capacity planning, space management and data maintenance activities.
  • Perform database enhancement and modification as per the requirements.
  • Perform database recovery and backup tasks on daily and weekly basis.
  • Develop and maintain patches for database environments.
  • Identify and recommend database techniques to support business needs.
  • Lead efforts to develop and improve procedures for automated monitoring and proactive intervention.
  • Participate in creation of development, staging, and production DB instances, and migration between environments.
  • Responsible for pro-active remediation of database operational problems.
  • Manage logins and user accounts, including permissions.
  • Participate in 24x7 on-call rotation.

Skills

Database administration
Query tuning
Shell scripting
Communication skills
English proficiency
Teamwork

Education

Bachelor's degree in Computer Science / MIS or related

Tools

PostgreSQL
MySQL
Linux
Shell scripting
Perl
Python
PL/SQL
Oracle
MS SQL Server

Job description

Position Description

As a Database Administrator, you are the primary on the most complex or escalated issues and may provide direction and guidance to team members. You will work closely with IT stake holders, vendors and other teams to deliver high quality database services.

Key Areas of Responsibilities
  • Offer DBA PostgreSQL / MYSQL support for application development team.
  • Ensure integrity, availability, security and performance of POSTGRESQL / MYSQLdatabase systems by providing technical support and maintenance.
  • Monitor database uptime, performance and recommend improvements for operational efficiency.
  • Assist in capacity planning, space management and data maintenance activities for database system.
  • Perform database enhancement and modification as per the requirements.
  • Perform database recovery and backup tasks on daily and weekly basis.
  • Develop and maintain patches for database environments.
  • Identify and recommend database techniques to support business needs.
  • Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
  • Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
  • Responsible for pro-active remediation of database operational problems.
  • Manages logins and user accounts, including assigning database object permissions and privileges.
  • Participate in a 24×7 support rotation (on-call)
Requirements
  • Bachelor’s degree/above in Computer Science, MIS or related degree
  • 5-7 years of relevant experience including database administration, database programming, preferably in Financial Services or other regulated industry
  • 3 years’ experience as a hands on PostgreSQL / MYSQL database administrator.
  • Strong Knowledge on Database Installation, Upgrades and Migration.
  • Strong Knowledge on applying POSTGRESQL / MYSQL Patches and Fixes
  • Experience in POSTGRESQL / MYSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
  • Strong knowledge of Linux and shell scripting (e.g., Bash, Perl)
  • Strong understanding of command line and database server administration.
  • Strong analytical, verbal and written communication skills.
  • Capacity planning for all aspects of a database system (storage, compute, memory, etc.)
  • Ability to work non-standard shift including nights and/or weekend on-call responsibilities
  • Good communication skills in English, Chinese efficiency will be a plus
  • Good team player. Capable of working under pressure and dynamic environment with minimal supervision

(Good to have)

  • Good Knowledge of MS SQL Servers
  • Experience with automation and scripting skills using Perl, Python
  • Strong ITIL principles
  • Understanding of networking and connectivity and how it relates to a database environment
  • ORACLE database administration experience
  • MySQL database administration experience
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Database Administrator — PostgreSQL & MySQL
Senior Database Administrator — PostgreSQL & MySQL

CLSA • Hong Kong

On-site
HKD 600,000 - 900,000
MS SQL Servers
Perl scripting
Python scripting
+3
Database Administrator (Unix/Linux, Government)
Database Administrator (Unix/Linux, Government)

Swing Consulting Ltd. • Hong Kong

On-site
HKD 334,800 - 558,000
5-day Work Week
30-50K Salary Depends on Experience
10-20 Days Annual Leave
Temporary Systems Analyst (Database Administration)
Temporary Systems Analyst (Database Administration)

Delken Group Limited • Hong Kong

On-site
HKD 420,000 - 640,000
Database Administrator (Technical Support) - IC
Database Administrator (Technical Support) - IC

Classy Wheeler Limited • Hong Kong

On-site
HKD 279,000 - 390,600
(Senior) Database Administrator - DBA (Asia-pacific Centre)
(Senior) Database Administrator - DBA (Asia-pacific Centre)

Bank of China (Hong Kong) • Hong Kong

On-site
HKD 300,000 - 450,000
Medical insurance
Life insurance
Various allowances
Database Administrator (Lead Consultant) - IC
Database Administrator (Lead Consultant) - IC

Classy Wheeler Limited • Hong Kong

On-site
HKD 500,000 - 700,000
Senior DBA - PostgreSQL, MongoDB & SQL Server Expert
Senior DBA - PostgreSQL, MongoDB & SQL Server Expert

IT Solutions Ltd. • Hong Kong

On-site
HKD 420,000 - 720,000
Database Administrator (DBA) – Major Bank
Database Administrator (DBA) – Major Bank

IT Solutions Ltd. • Hong Kong

On-site
HKD 420,000 - 720,000
Database Administrator - GCIS
Database Administrator - GCIS

Gfi World • Tsuen Wan

On-site
HKD 420,000 - 640,000
Senior Database Manager - IC
Senior Database Manager - IC

Classy Wheeler Limited • Hong Kong

On-site
HKD 500,000 - 700,000