Application Support Analysts - Bridgend, United Kingdom - CGI

Description

Position Description:

If you're at home managing complex datasets and AI systems, your intelligence could help drive our digital revolution. Our Application Support Analysts (Oracle PL/SQL) are trusted to work closely with a wide range of clients on exciting projects with real-world purpose and impact.

In , CGI was voted a 'Best Workplace in Tech' by Great Place to WorkTM and was named one of the 'World's Best Employers' by Forbes magazine. We offer a competitive salary, excellent pension, private healthcare, plus a share scheme (3.5% + 3.5% matching) which makes you a member not just an employee.

We are committed to inclusivity, building a genuinely diverse community of tech talent and inspiring everyone to pursue careers in our sector. Join us and you'll be part of an open, friendly community of experts. We'll train and support you in taking your career wherever you want it to go.

All applicants must hold or be prepared to undergo National Security Vetting (NSV) Security Check (SC) level.

Your future duties and responsibilities:

You will provide application support and Database Administration to our key clients on a VLDB with multiple partitioning strategies. This typically comprises Application Support to identify data anomalies and code defects; PL/SQL and SQL statement tuning; Application releases and deployments together with Database Administration; Capacity Planning; Performance Monitoring and Tuning. You will work to resolve incidents via Remedy (ITSM) call management system with SLA deadlines and perform planned releases supporting a bespoke application.

Required qualifications to be successful in this role:

Essential:

• Experience of development and/or support of Oracle PL/SQL modules in a large system

• Basic knowledge of Oracle Database Administration in a Development or Production role

• MS-Office tools including Word, Excel, Visio

Technical skills:
Underlying technology skill requirements, must have development / support skills in all of the following:

• Exposure to Oracle 10g or later (the application version is Oracle 11gR1)

• In depth knowledge and experience in writing Oracle SQL statements and PL/SQL packages

• Exposure to Unix (the application uses Sun Solaris, but any flavour of Unix or Linux is acceptable)

Desirable skills:

• Performance Tuning of SQL and PL/SQL

• Advanced PL/SQL techniques (analytical functions, collection handling, bulk processing, objects, LOBs)

• Experience of Oracle partitioning

• Exposure to Oracle RAC, Oracle RMAN, Oracle Data Guard

• Knowledge of Oracle Weblogic, Oracle Service Bus or other Application Server technology

#LI-NP1

Skills: