Job Details:

Job Summary: 

This role is responsible for using a variety of tools to maintain and technically support complex and multi-platform systems/databases. This includes performance tuning of production databases, designing new database structures, data migration, initial database configuration and operational support of live systems.

Essential Job Duties and Responsibilities: 
Responsible for all customer facing SQL Servers, and associated test and development systems.
Identify opportunities for automation, optimisation of operational processes to improve the reliability and efficiency of the SQL Server team.
Support and maintenance of mission critical SQL Server databases.
Providing support to the application development team for review of SQL, stored procedures, database structures and processes.
Integration of different business systems to form automated data flows.
Disaster recovery design, planning and testing. Supervision of system backups.
Manage, implement and test Business Continuity and disaster recovery strategies.
Proactively monitor production and test systems to identify system issues (e.g. BMC Patrol, SCCM).
Analyse and troubleshoot production faults and determine the most effective course as a subject matter expert in an expedited manner.
Managing the security of database systems and working with security auditors where required.
Perform day to day system administration (such as user creation, disk configuration, troubleshooting, etc.) of both SQL Server and reporting systems.
Maintaining IT documentation.
To ensure all work is carried out with reference to CTS IT department work instructions and standards following industry best practice.
The candidate may be required to occasionally work on other Cubic sites.
Provide support, including out-of-hours support in critical incidents and participation in an on-call support rota.
Comply with Cubic’s values and adherence to all company policy and procedures. Comply with the code of conduct, quality, security and occupational health, safety and environmental policies and procedures.
In addition to the duties and responsibilities listed, the job holder is required to perform other duties assigned by their manager from time-to-time, as may be reasonably required of them.

Minimum Job Requirements: 
Skills knowledge and experience: 

Essential:
Demonstrable experience providing IT support in a 24/7 environment
Experience of using operating systems such as;
Microsoft Windows
Linux

Database and programming experience using;
Microsoft SQL Server/SQL Server 2012
MySQL
Transact-SQL
PostgreSQL

Working knowledge of in capacity planning and capacity audits
Knowledge and/or understanding of third-party reporting tools such as Cognos BI
Proven track record of taking a logical and detailed approach to assignments
Strong interest in the technicality and inner workings of relational databases
Experience of working in a pressured, complex and customer focused commercial environment

Desirable:
Familiarity with Cloud based solutions such as both MS Azure and Amazon AWS
Experience providing out of hours support

Education and qualifications

Essential:
A university degree in Computer Science or another a relevant discipline or equivalent qualification/experience
MS SQL Server MCTS
Formal training in Database Administration
IBM Cognos BI qualifications

Desirable:
ITIL certification

Personal Qualities
A technical team player, both approachable and adaptable
Self-motivated and proactive, able to work with minimal supervision
Excellent interpersonal skills (verbal and written) with a willingness to share knowledge, learn and collaborate
Attention to detail and adherence to procedures
Good problem-solving abilities
Strong customer service skills
Quick to build client relationships and earn their respect through sound judgement and a positive attitude
Ability to work both autonomously when required and productively within a cross-functional team environment
Possess a methodical and structured approach to duties and challenges
Proven ability to work in a team
Organised with the ability to handle multiple projects and undertake new tasks quickly
An enthusiasm for new technologies and their application for both business and consumers
Ability to travel to Cubic and customer sites to meet requirements of the role plus on-call responsibilities

The description provided above is not intended to be an exhaustive list of all job duties, responsibilities and requirements. Duties, responsibilities and requirements may change over time and according to business need.

Worker Type:

Employee

Global Level:

Global Level 3