Kindly note that Jobline will be offline for maintenance on this Friday (May 14, 2021) from 5:00 PM to 9:00 PM.

Responsibilities

  • Lead and manage technical discussions in all aspects of database design, creation and implementation approach.
  • Lead and manage database changes through change request process & provide status reports to the relevant parties.
  • Participate in development projects eg logical & physical database design
  • Ability to manage customer in data modelling meeting and review meeting
  • Assist and respond promptly to incident, investigate & provide temporary &/or permanent resolution of incidents escalated.
  • Involvement in performance tuning, performance management, setup of Databases
  • Lead and monitor & measure the performance & availability of databases proactively; implement corrective actions identified to improve performance & availability.
  • Lead and monitor the agreed service level, document & maintain the configuration of the databases; provide regular reporting to relevant parties.
  • Ensure service level meet requirement. Propose and implement action plan when required. Lead and monitor databases according to standard operations procedures.
  • Lead in the implementation of service continuity measures, i.e., backup/restore procedures & disaster recovery plan, to ensure continuous operation of the business.
  • Involve and lead in database implementation.
  • Keep abreast of database technologies.
  • A good team player and leader.

Requirements

  • Degree in Computer Science or equivalent bachelor certification
  • More than 5 years of experience in installation, configuration, & management of SQL Server databases is Mandatory
  • Certification in SQL server
  • More than 2 years of experience of Advanced to Expert skills in all the following: o SQL Server Clustering & AlwaysOn Availability Group setup & management. o Writing & debugging complex SQL statements, stored procedure & functions, o Must be able to design & implement relational tables using the proper degree of normalization & denormalization o ER-Diagram Designer Tools o Performance Tuning
  • Proper index design & able to identify good & bad index design
  • Identify unused indexes & missing indexes
  • Identify bottlenecks in SQL Statistics, execution plans. o Database Performance Monitoring using the following:
  • SQL Profiler Trace,
  • Extended Events
  • Performance Monitoring Tool on SQL Server and Windows Counters
  • Third-Party DB monitoring tools o Database Performance Maintenance
  • Index Reorganization/Rebuild
  • Update Statistics
  • Archival Strategies
  • Experience in setting up & managing of DB replication is a value-add
  • Experience in Oracle database installation & administration is a value-add
  • Experience in cloud database migration is value-add.

Shortlisted candidates will be offered a Permanent or 1 Year Direct Contract employment