Up to £0.00 per annum
3 months ago
Support Enterprise level Database applications including Microsoft SQL and Oracle, and associated management and monitoring tools required to manage a large corporate estate.
Provide 2nd /3rd line support within the team to a number of legacy packaged and internally developed applications used by engineering, programmes, core IT Services and other Back Office functions.
Develop, support and maintain the corporate level SQL and Oracle database farms, working in close cooperation with the Data Centre, Network, Remote Site and Application Services teams.
Perform complex system management and SQL application performance, troubleshooting and tuning including using debugging TSQL, PowerShell and scripting tools as necessary to manage estate.
Support the implementation of a plan to rationalise the estate for optimum performance, security, licensing and ease of maintenance.
Implement high availability solutions like Clustering, Mirroring etc. and SQL Extended events.
Manage and implement updates and patches as and when required.
Use SSIS, & SSRS for report development and troubleshooting, , which includes data extraction, transformation and loading (known as ETL)
Develop and promote and SQL Standards and Monitoring for IT development and initiatives.
Build strong working relationships and effective alignment across functions and businesses in Raytheon UK, International counterparts, and Partner/Subcontractor community.
Develop and implement a plan to rationalise the estate for optimum performance, security, licensing and ease of maintenance.
Accountable for Service and system documentation, procedures and resource forecasting and planning to deliver against the defined service criteria ensuring the provision of an Out of hours service (aligned to the rest of IT).
Carry out a programme of daily/weekly/monthly checks and develop approaches to improve, streamline and automate the health status of the environment.
Effectively manage deliverables: Incidents, Requests, Small Works Projects and Technical leadership of major implementation and upgrade projects.
Ensure backup schedules & data retention and period maintenance are aligned.
Proactively identify and manage risk in line with departmental risk strategy.
Plan, agree and participate in scheduled BCP/DR exercises.
Maintain effective Asset Management and license compliance, system vulnerability management as required.
Perform Out of hours / On Call Cover service aligned to the rest of IT and agreed with your peers (where relevant) and key business contacts.
Provide cover for the Head of Database Services as required.
Deep and detailed experience of managing Databases including SQL and Oracle technologies.
Experience of designing and supporting enterprise systems that leverage SQL (All prevailing versions) and SQL application performance tuning and troubleshooting.
Experience of implementing high availability solutions like Clustering, Mirroring etc. and SQL Extended event
Experience of troubleshooting complex SQL and Oracle issues, debugging code, and resolving enterprise level issues for backbone data storage solutions.
Experience of developing, promoting and monitoring SQL Standards for IT developments and initiatives.
Good working knowledge of Team Foundation Server (TFS) and Visual Studio 2015
Experience of SharePoint, .NET, C#.NET, ASP.NET, JQuery, CSS, HTML, PowerShell scripting, InfoPath forms and BI capabilities.
Experience of providing high demand/mission critical systems on a 24x7 basis.
Knowledge of Service Management disciplines engagement, design, delivery and maintenance lifecycles in a high technology or IT services domain.
Thorough understanding of ITIL best practice, qualified to a minimum of ITIL Foundation.
Detailed knowledge / experience of project and service delivery disciplines including business analysis and requirements gathering, resource planning, ability to create project proposals. Full project lifecycle experience, user support & training experience.
Experience of working closely with Manufacturing, Supply Chain or Finance functions.
Ability to understand and analyse complex business problems in order to define and develop technology-based solutions.
SC cleared or the ability to become SC cleared.