Database Administrator

Assuritz Infosec; Hong Kong; On-site; HKD 480,000 - 660,000; Full time

Job summary

Assuritz Infosec is seeking an experienced Database Administrator (DBA) in Hong Kong to ensure database performance, integrity, and security. You will work with project teams to ensure availability and secure data systems, implementing best practices for backups, DR, and access control.

The role involves collaborating with developers on schema design, optimizing performance, and maintaining documentation and standards for mission-critical databases, including SQL Server, Oracle, and MongoDB.

Qualifications

• Bachelor's degree in computer science, IT, or related field required.
• Experience with database management systems such as SQL Server and Oracle.
• Strong knowledge of data security principles and best practices.
• Hands-on experience improving database performance via schema changes and tuning.
• Experience with failover, clustering, mirroring, and Availability Groups.

Responsibilities

• Install, configure, and maintain database software and related technologies.
• Monitor and optimize database performance, ensuring high availability and reliability.
• Configure database backups and disaster recovery procedures.
• Troubleshoot database issues and perform root cause analysis.
• Collaborate with developers to design and implement database schemas.
• Optimize database design for performance and scalability.
• Develop and maintain database documentation and standards.
• Create and maintain database users and roles, managing access permissions.
• Perform database upgrades and patches, ensuring system stability.
• Configure and maintain replication and clustering for high availability.
• Analyze and optimize queries and indexes for better performance.
• Monitor performance metrics and apply tuning strategies as needed.
• Identify and resolve bottlenecks and resource contention.

Skills

SQL Server

Oracle

Data security

Query tuning

SSRS

SSIS/ETL

MongoDB

High availability

Disaster recovery

Education

Bachelor's degree in Computer Science or Information Technology

Tools

SSRS

SSIS/ETL

MongoDB

Job description

Job Description

We are seeking a skilled and experienced Database Administrator (DBA) to join our team. The ideal candidate will be responsible for the performance, integrity, and security of our databases. As a DBA, you will work closely with our project team member to ensure the availability and functionality of our database systems, optimizing their performance and implementing data security measures.

Key Responsibilities

1. Database Management:

• Install, configure, and maintain database software and related technologies.
• Monitor and optimize database performance, ensuring high availability and reliability.
• Configure database backups and disaster recovery procedures.
• Troubleshoot database issues and perform root cause analysis.

2. Data Security:

• Implement and maintain data security policies and procedures.
• Ensure compliance with data privacy regulations and standards.
• Configure and maintain database access and permissions, identifying and mitigating security risks.

3. Database Design and Development:

• Collaborate with developers to design and implement database schemas.
• Optimize database design for performance and scalability.
• Develop and maintain database documentation and standards.

4. Database Administration:

• Create and maintain database users and roles, managing access permissions.
• Perform database upgrades and patches, ensuring system compatibility and stability.
• Configure and maintain database replication and clustering for high availability.

5. Performance Tuning and Optimization:

• Analyze and optimize database queries and indexes for improved performance.
• Monitor database performance metrics and implement tuning strategies as needed.
• Identify and resolve performance bottlenecks and resource contention issues.

Qualifications:

• Bachelor’s degree in computer science, Information Technology, or related field.
• In-depth knowledge of database management systems (e.g., SQL Server, Oracle…etc)
• Strong understanding of data security principles and best practices.
• Effective communication and collaboration abilities.
• Hands‑on experience driving improvements in product performance via changes in database schema, logical and physical data organization (partitioning), tuning and configuration.
• Experience implementing/maintaining database failover mechanism (clustering, mirroring, Availability Group) and perform disaster recovery exercises for mission-critical databases.
• Experience with maintaining and optimizing MongoDB is a plus.
• Strong skills in SSRS report development and SSIS/ETL.
• Relevant certifications (e.g., Oracle Certified Professional, Microsoft Certified: Azure Database Administrator Associate) are a plus.