Support of the FOGS application/system and its modules to deliver business functionality, whilst adhering to LGIM coding standards. Whilst most work will be support focused, there will be some involvement in development and provision of fixes or enhancements, as required.

• Support of the FOGS application/system and its modules to deliver business functionality, whilst adhering to LGIM coding standards. Whilst most work will be support focused, there will be some involvement in development and provision of fixes or enhancements, as required.
• Maintain the integrity of systems or services within the remit by fully investigating all incidents and resolving them in a timely fashion. Ensuring all Incidents and Problems are accurately recorded and updated as per the Incident Management Matrix and SLA.
• Proactively highlight potential capacity, performance or operational issues and take preventative action where necessary.
• Advise business and/or technical solutions where possible, recommending the most appropriate and cost effective way forward.
• Assist with trend analysis, highlighting repeat issues and implementing solutions for permanent resolutions.
• Continually incorporate quality management, assurance, company security and best practices into all support areas to ensure services are delivered within agreed Business Requirements. Ensure proper implementation of changes in accordance with LGIM Change Management procedures.
• Maintain effective support processes for all software/systems across platforms.
• Provide technical support and advice to users. Liaise with other IT staff and/or with external providers as required to resolve complex hardware/software problems.
• Provision of support on a shift basis and out of hours support on a rota basis as and when required.
• Assist in the training of new team members.

Experience Mandatory

• In depth understanding and experience of the Risk Management business process or Investment Management.
• The primary skills required are extensive strong SQL Server (2008 and above) experience for which relevant understanding must be demonstrated.
• Transact-SQL
• Strong procedure, user defined funtions & triggers
• Distributed queries
• Experience of full support lifecycle activity to include:
• Analysis and the production of technical documentation using Use Cases, & activity diagrams.
• Support of quality assurance and user acceptance test cycles, & disaster recovery.
• Knowledge of Microsoft Office toolset (Excel VBA)

Experience - Desirable

• Exposure to Oracle (10g and above) – PL/SQL
• Support experience and knowledge of Business Objects (Universe Design)
• Experience with JIRA and Confluence
• Experience with of Informatica Powercenter (ETL workflow and Shell Scripts)
• Exposure to database query tools such as Aqua Data Studio or SQLAdvantage

Whatever your role, we reward ability, performance and attitude with a package that looks after all the things that are important to you. Our employees have a wide range of benefits including a generous pension scheme, life assurance, at least 22 days’ (with potential to rise to 25 days) holiday, performance related bonuses, a variety of share schemes, discounts at both a huge range of high street stores and our own great products, your hard work will be rewarded when you join us.