Req ID 51784 – Posted 05/07/2018 – United Arab Emirates – Dubai – Administration/Secretarial/Clerical – Full Time
Database Administrator – Success Profile
Reporting to: AFC Systems Manager
Division / Function: Operations
Base location: Dubai UAE
Job family: AFC Systems & Resource Planning
Serco Leadership Tier: Managing a team within a business or function
The purpose of the job is to be responsible for supporting the Dubai Metro and Dubai Tram databases, ensuring their performance, availability and security.
Maintaining software databases of the company and manage database related issues ensuring availability and continuity.
Reason for role
To manage the AFC Systems and Software Databases
Structure and reporting relationship
Reporting to AFC Systems Manager
Based on the specific requirement of the role
Manages all database related issues of the whole Dubai Metro and Dubai Tram;
Responsible in system & database audit tasks to include assessment, evaluation and investigation:
Automatic Fare Collection (AFC) Systems
Internal Software Databases
Manage and document system configurations.
In depth analysis and investigation of systems fault and provide corrective action
Ensures that system hardware, operating systems, software systems, and related procedures are correct and in-place;
Develop and maintain installation and configuration procedures.
Contribute to and maintain system standards.
Responsible for ensuring availability and performance of the databases in the live production AFC system;
Ensuring that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning;
To proactively monitor the database systems to ensure secure services with minimum downtime;
Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management, e.g., storage and other hardware upgrades;
Responsible for troubleshooting, performance tuning of T-SQL stored procedures, jobs, and development of new procedures for reporting;
Responsible for continued improvement to Backup and restore procedures, and regular restore testing;
Responsible for setting up and managing online replication to archival server; Responsible for trouble-shooting database corruption, inconsistency incidents to ensure operational continuity;
Creation and implementation and testing of DR/BC plans;
Responsible for maintaining new and existing software databases
Assist with troubleshooting and implementation of Windows Operating System
Tasks for AFC Level 3
Monitoring the health of the data base;
Regular checking of error logs, scheduled maintenance tasks, monitoring of storage use.
Performance tuning – ensure that the database is running with optimal parameter settings, indexing, file system parameters.
Backup and Restore of both Metro and Tram and provide enhancement solutions;
Data Warehousing – long term solution for Serco Operations Planning & Performance analysis.
Perform and carry out other duties as instructed / directed by the AFC Systems Manager and Head of AFC Systems and Resource Planning