Senior MSSQL Database Administrator

Unison Consulting Pte Ltd; Kuala Lumpur; On-site; MYR 80,000 - 110,000; Full time

Job summary

A premier consulting firm in Kuala Lumpur is seeking a Database Administrator with over 5 years of experience in MSSQL and MySQL administration. Responsibilities include managing database performance, backups, and disaster recovery protocols. The ideal candidate should hold a relevant degree and have strong vendor management skills. Join us to ensure optimal database health and support critical operations.

Qualifications

• Minimum 5 years of Database Administration experience required.
• Knowledge of Mainframe Databases is advantageous.
• Professional DBMS certification is preferred.

Responsibilities

• Manage database system outages within SLAs.
• Ensure proper database capacity management.
• Lead projects to ensure successful execution.

Skills

Database Administration

MSSQL & MySQL Database Administration

Database performance tuning

Backup & Recovery

Disaster Recovery

Vendor Management

Education

Bachelor's Degree in IT

Diploma in IT

Tools

MSSQL

MySQL

Microsoft Cluster

Job description

MSSQL Database Management

• Achieving resolution for database system outages within defined Service Level Agreements (SLAs).
• Ensure proper DB capacity management/data growth and threshold alerts are automated.
• Responsible for creating primary database storage structures (database areas and tablespaces), once application developers have designed/purchased an approved application.
• Ensure databases have routine maintenance performed on them (e.g. database reorganization, update statistics etc.)
• Assist developers in optimizing their applications, queries, etc.
• Ensure adherence to project management methodologies
• Identify project risks and provide possible solutions to problems
• Lead projects to be executed successfully on schedule, within budget and with the allocated resources
• Produce reports and updates of project status
• Identify issues that requires escalation with external/internal parties.

Installing and Upgrading

• Responsible for installing and upgrading the database and related tools
• Examines new releases of systems and database software, understand the features offered and the stability of the release and recommend further action.
• Coordinating with developers for pre-release testing of production systems
• Responsible for insuring the Bank is in compliance with the database license agreement.

System Setup and Database Creation

• Responsible for setting up database, Instamces in development, QA and production environment

Monitoring the Database Health and Tuning Accordingly

• Ensure the database is running with optimal performance
• Ensure the database is properly configured with the correct amount of memory and set with proper configuration parameters
• Ensure the error log or event log is monitored for database errors

Proper Utilization of Storage

• Making sure the databases are correctly setup, monitoring space requirements and adding new storage when required

Backup and Recovery

• Establishing standards and schedules for database backups and ensure recovery procedures are adhered
• Developing and periodic testing of recovery procedures for each database.

Financial Management

• Ensures that projects are implemented with the approved budget and track the budget drawdown accordingly
• Maintain professional client relationships
• Work with vendors to provide resolutions to client issues.
• Ensure that the projects are managed and administered in compliance with the established contract

Vendor / Stakeholder Management

• Investigate and resolve problems which are database related with the service owner/component owner..

• Minimum 5 years of Database Administration on MidRange/Wintel Databases. Knowledge on Mainframe Databases will be advantageous.
• Bachelor’s Degree in any discipline - Minimum of 5 years relevant experience in IT.
• Diploma in IT - Minimum of 7 years relevant experience in IT.
• Professional DBMS certification is advantageous.
• Good knowledge on MSSQL & Mysql Database Administration.
• Database performance tuning.
• Backup & Recovery.
• Automation of monitoring & alerts generation.
• Experience on Disaster Recovery.
• Knowledge on Cluster setup such Microsoft Cluster & Always On.
• Knowledge on replication ex log shipping, Always On & Disks Replication.
• DBMS installation & Upgrades.
• Standard enforcements.
• Capacity Management & Planning.
• SLA management 24X7 availability.