Senior MSSQL Database Administrator
Unison Consulting Pte Ltd, Malaysia

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..

Requirements

• 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 amp; Mysql Database Administration.
• Database performance tuning.
• Backup amp; Recovery.
• Automation of monitoring amp; alerts generation.
• Experience on Disaster Recovery.
• Knowledge on Cluster setup such Microsoft Cluster amp; Always On.
• Knowledge on replication ex log shipping, Always On amp; Disks Replication.\
• DBMS installation amp; Upgrades.
• Standard enforcements.
• Capacity Management amp; Planning.
• SLA management 24X7 availability.

Job Rewards and Benefits