PCCW Solutions

Senior Analyst, Database Administrator

PCCW Solutions Hong Kong Island, Hong Kong, China

Technology, Information and Internet · 201-500 employees

Oct 13
dba Senior (5-10 yrs) Full-time China
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The Senior Analyst, Database Administrator will manage, optimize, and support Oracle database environments across enterprise platforms. They are responsible for ensuring database health, performance tuning, high availability, and implementing security controls.

What they look for

Oracle Database 19c Oracle RAC ASM Data Guard Active Data Guard Oracle Enterprise Manager SQL PL/SQL Performance Tuning Database Administration Capacity Planning Disaster Recovery Database Security Root Cause Analysis Database Architecture

Requirements

Candidates must have a bachelor's degree in a relevant field and at least 5 years of hands-on Oracle DBA experience. Proficiency in Oracle 19c, RAC, ASM, and performance tuning tools is required.

Full description

Job Description – Senior Analyst, Database Administrator (DBA)

Job Summary

We are seeking an experienced Senior Analyst, Database Administrator (DBA) to design, implement, manage, optimize, and support Oracle database environments across enterprise platforms. The successful candidate will provide consulting expertise on database architecture, performance tuning, high availability solutions, security, migration projects, and operational best practices. This role requires strong technical skills, and the ability to deliver database solutions aligned with business objectives.

Key Responsibilities

Database Administration & Support

  • Manage Oracle databases across Development, UAT, Production, and Disaster Recovery environments.
  • Monitor database health, availability, capacity, and performance.
  • Perform proactive maintenance, troubleshooting, and root cause analysis.
  • Ensure database backup, recovery, and disaster recovery procedures are regularly tested and maintained.

Performance Tuning & Optimization

  • Analyze and optimize SQL queries, PL/SQL code, and database performance.
  • Perform database tuning using AWR, ASH, ADDM, Statspack, and OEM tools.
  • Monitor system resources and recommend capacity planning strategies.
  • Identify and resolve performance bottlenecks across database and application layers.

Architecture & Consulting

  • Provide expert consulting services on Oracle database solutions and best practices.
  • Design highly available and scalable database infrastructures.
  • Advise stakeholders on database architecture and modernization strategies.
  • Participate in solution design discussions and technical reviews.
  • Prepare technical documentation, standards, and operational procedures.

High Availability & Disaster Recovery

  • Conduct DR drills and ensure recovery objectives are met.

Security & Compliance

  • Implement database security controls and access management.
  • Perform database auditing, vulnerability assessments, and compliance reviews.
  • Ensure adherence to organizational security policies and regulatory requirements.
  • Support data encryption, masking, and database hardening initiatives.

Required Qualifications

Education

  • Bachelor's degree in Computer Science, Information Technology, Engineering, or related discipline.

Experience

  • At least 5 years of hands-on Oracle DBA experience.
  • Proven experience in enterprise-level Oracle database administration and consulting.
  • Experience managing mission-critical Production databases.

Technical Skills

  • Oracle Database 19c
  • Oracle RAC, ASM, Data Guard, Active Data Guard.
  • Oracle Enterprise Manager (OEM).
  • SQL and PL/SQL performance tuning.
  • Database monitoring and capacity planning.

Similar roles