Database Administrator (Ref 22954)

Responsibilities

• Daily health monitoring of production database system and data integrity checks

• Database migration and performance monitoring

• System / data backup, disaster recovery

• Carry out periodical production patch and upgrade management

• Automate and monitor huge file transfer for archiving

• Work with users and vendors to take timely and appropriate steps to resolve and troubleshoot issues impacting service levels and conduct root cause analysis

• Enforce security standards for databases

• Keep abreast of advances in database technologies to identify opportunities to fine tune and optimize databases and related system infrastructure

• Database administration and management (capacity planning, installation, backup, recovery, monitoring, performance optimizations, troubleshooting, load/hardware analysis mapping, security etc.)

• Query optimization and tuning skills, analysis and troubleshooting interactions between databases, operating systems and applications with regard to performance and resources usage

• Creating database tables, setting up indexes, data constraints and DB views Analyze, predict through trend analysis and resolve database system, storage and application issues

• Review existing software architecture and contribute to improving on the future architecture for stability and a maximum of performance

• Collect and analyze database performance information; identify and implement solutions for performance

Requirements

• Degree/Diploma, preferably IT or Engineering-related

• Minimum 1-2 years of working experience in DBA and operation management in MS SQL Enterprise Server

• Proficient in Linux / Unix environment shell scripting

• Familiar with virtualization technologies

• Experience in setting up and supporting database mirroring, failover clustering would be advantageous

• Relevant working experience as an MYSQL/ MARIA DB / MS SQL Database Administrator in production environment would be advantageous

• Managing experience of MS SQL servers (2016, 2019,2022)

Licence no: 12C6060