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.

“This role requires an employee to work in a rotational basis (24/7) that includes night shifts and fixed weekend including Saturday and Sunday shifts (12 hours a day or 12 hours evening/night during weekends) and rest of the weekdays 9 hours, totally 40 hours a week”

Essential Job Duties and Responsibilities: 

• Responsible for all customer facing SQL Servers, and associated test and development systems.
• Identify opportunities for automation, optimization 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).
• Analyze 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

Minimum Job Requirements: 

• Degree, or equivalent experience, in a technical or technical management discipline plus 5+ years of experience in Microsoft SQL Server/SQL Server 2012, 2016,2019.
• Formal training in Database Administration. IBM Cognos BI qualifications. 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; 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.
• Familiarity with Cloud based solutions such as both MS Azure and Amazon AWS will be preferred. Experience providing out of hours support

Worker Type:

Employee

Global Level:

Global Level 3