Developer

Responsibilities

• Record, prioritise, manage, and resolve incidents and problems in the data warehouse escalated from the service desk and monitoring systems across all environments
• Investigate and fix code and data issues to resolve incidents and problems, escalating more involved resolutions to the UK development team where necessary
• Monitor data warehouse services and publish reports on service uptime, incidents, and data quality for all environments
• Troubleshoot and optimise data warehouse performance
• Provide technical consulting to business users and service small requests
• Maintain and improve support documentation
• Mentor junior team members
• Perform releases to the data warehouse
• Out of hours on-call support

Essential criteria

• Two years in an IT support role
• Two years’ experience with Oracle data warehouses
• Experience of Oracle 11g, PL/SQL
• Proven debugging skills
• Experience of release management and coordination
• Degree level education (in relevant/related subject)
• Proactive work ethic with the ability to deliver results and meet challenging
• deadlines
• Flexibility in working hours to participate in support rota
• Self-motivating
• Articulate team player
• Attention to detail with a high degree of pride in work produced
• Proven ability and desire to innovate
• Strong analytical skills
• Enthusiasm for the software development process
• Good English language skills

Desirable criteria

• ITIL background
• Experience of ETL, OLAP, BI
• Experience of Oracle database and PL/SQL performance tuning, storage management, and partitioning
• Knowledge of performance monitoring using in-depth Oracle features
• Knowledge of Unix/Linux including basic commands and shell scripting