Talent.com
This job offer is not available in your country.
Senior MSSQL Database Administrator

Senior MSSQL Database Administrator

Unison Consulting Pte LtdKuala Lampur, Kuala Lumpur, MY
30+ days ago
Job type
  • Quick Apply
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..

    • 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 & 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.
    • Create a job alert for this search

    Administrator • Kuala Lampur, Kuala Lumpur, MY