Database Administrator - SQL

Business Unit:Cubic CorporationCompany Details:Cubic offers an opportunity to provide innovative technology for government and commercial customers around the globe, helping to solve their future problems today. We’re the leading integrator of payment and information technology and services for intelligent travel solutions worldwide, and the leading provider of realistic combat training systems, secure communications and networking and highly specialized support services for military and security forces of the U.S. and allied nations. If you have an entrepreneurial spirit and thrive in an innovative environment, we want to talk to you about your next role at Cubic! We are seeking employees inspired by technology, and motivated by the rewards of hard work, commitment, teamwork, quality, integrity, and respect. We invite you to explore opportunities with Cubic.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