Database Administrator (Ref 22954)

Jobline Resources Pte Ltd; Singapore; On-site; SGD 50,000 - 70,000; Full time

Job summary

A recruitment agency is seeking a Database Administrator to manage and optimize the production database systems in Singapore. The candidate will monitor database performance, handle backups, and ensure system integrity. The ideal applicant has a degree in IT or Engineering and 1-2 years of experience with MS SQL Server. Proficiency in Linux/Unix scripting and experience in database mirroring are advantageous. This role provides an opportunity to work with cutting-edge technologies in a dynamic environment.

Qualifications

• Minimum 1-2 years of experience in DBA and operation management.
• Proficient in Linux/Unix shell scripting.
• Experience with database mirroring and failover clustering is advantageous.

Responsibilities

• Monitor production database system and ensure data integrity.
• Perform system/data backup and disaster recovery.
• Optimize and tune database queries and performance.

Skills

Database performance tuning

Shell scripting in Linux/Unix

Database administration

Troubleshooting skills

Experience with MS SQL Server

Education

Degree/Diploma in IT or Engineering

Tools

MS SQL Server

MYSQL/MARIA DB

Virtualization technologies

Job description

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 the future architecture for stability and maximum 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)