Database Administrator

Serco

Dubai, UAE

Ref: LP119-646

Job description / Role

Employment: Full Time

Database Administrator - Success Profile

Reporting to: AFC Systems Manager

Division / Function: Operations

Base location: Dubai UAE

Date: 06 June 2018

Job family: AFC Systems & Resource Planning

Grade: 16

Serco Leadership Tier: Managing a team within a business or function

Key purpose
- 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

Key accountabilities
- 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

Requirements

Essential technical and professional skills, knowledge and qualifications
- A degree holder in Computer Science or Computer Engineering
- Relevant Microsoft / Oracle certification level;
- Professionally qualified with membership of a recognized transport institution
- Strong self-sufficiency and initiative working on Database projects.
- Understanding of XML schemas, XSLT, Practical experience in handling XML files from database perspective.
- A proactive attitude to work, ability to perform with little or no supervision.
- Ability to demonstrate professional competence to the customer organization.
- Working Knowledge with:
- Windows Server operating system administration.
- Microsoft Active Directory administration.
- PERL programming.
- Windows cluster administration.
- VMWare Virtualization and VEEAM Backup and Replication
- General file system and Operating System performance tuning
- SQL Server Administration
- Oracle Server Administration
- SAP Business Object Reporting tool
- Windows administration
- Linux, Virtualization
- Microsoft Office
- Statistical analysis
- Excellent written and verbal communication skills and the ability to manage multiple tasks efficiently and work productively in a fast-paced, team-oriented environment;
- Highly motivated and flexible to be able to work in a time-sensitive environment and respond quickly and effectively to unanticipated high workloads, events and emergencies;
- Leadership and management skills to lead by example;
- Excellent numerical and PC skills including the use of MS Excel and analytical tools;
- Knowledge of transport performance regimes within a large public transport (preferably rail) organization;
- Strong organizational skills, detail oriented, and the ability to handle multiple priorities;
- Ability to understand complex systems and learn new software based applications;
- A proactive attitude to work, ability to perform without supervision;
- Working knowledge of statistical and numerical analysis and technique are essential; with Relational database Administration and basic knowledge in Networking;
- Ability to make pro-active decisions on behalf of the AFC Systems Manager / Head of AFC Systems and Resource Planning.

Additional / special features of the role

- Ensure compliance with the Serco Management System and all relevant business processes, procedures and work instructions to deliver all work with appropriate quality and governance standards
- Ensure that a good HSQE and Information Security culture is promoted within their departments and among their peers;
- Ensure security and integrity of all data provided including reporting performance, finance and customer information; reference Serco non-disclosure policy
- To exercise personal duty of care for their own health, safety and welfare and for those affected by their acts or omissions; reference SMS GSOP-HSE1-6 Serco organisational HSE responsibilities
- Ensure compliance with all training requirements of Serco and ensure adherence to these requirements at all times whilst in employment
- Report any accidents, incidents, breaches or potential breaches to appropriate management or the speak up process

Serco is committed to Equal Employment Opportunities and is committed to ensuring the safety of all of its employees through its Zero Harm initiative.

About the Company

Serco is a FTSE 250 international service company which combines commercial know-how with a deep public service ethos.

Serco customers are looking for expertise in managing their people, processes, technology and assets more effectively. We advise economic decision makers, design innovative solutions, integrate systems and - most of all - deliver quality services directly to the public.

Serco supplies to governments, government enterprise, agencies and companies who seek a trusted outsourcing partner with a solid track-record of service excellence. Serco people offer operational, logistical and technical expertise in the Transport, Justice and Immigration, Defence, Education and Healthcare industries as well as in the commercial sectors of Facilities Management.

Serco Middle East have been in the Region since 1947, starting out delivering Air Traffic Control Services in Bahrain; a service we are proudly still running today and have expanded to include many other Airports in the region.

We have expanded significantly since that time across the UAE, Saudi Arabia and Qatar. We have been supporting the RTA to operate the Dubai Metro since 2009, are preparing to launch the flagship Saudi Arabia Passenger Rail service from Riyadh to Qassim in 2016. We deliver Facility Management services to both Cleveland Clinic and Healthpoint Hospitals in Abu Dhabi, large-scale medical facilities in Saudi Arabia and a range of educational and commercial properties in the UAE. We also deliver postgraduate education to Officers in the Qatar Armed Forces through the Joaan Bin Jassim Joint Command and Staff College in Doha.

Focusing on our core values, and creating a positive environment for employees to thrive, we look forward to a bright future as we continue to grow with the region.

Get personalised updates on latest vacancies
Job Alerts by Email
  • Personalised updates on latest career opportunities
  • Insights on hiring and employment activity in your industry
  • Typically sent twice a month
Database Administrator salaries in UAE

Average monthly compensation
AED 7,500

Breakdown available for industries, cities and years of experience