Application Support Analysts (Oracle PL/SQL)

 

Main characteristics

Location

Mid Glamorgan

Company

CGI

Employment type

Permanent

Category

IT

Job summary

Title
Application Support Analysts (Oracle PL/SQL)

Category
Service Desk / End User Services

City
Bridgend, Wales - South East Wales, United Kingdom

Job Description
Application Support Analysts (Oracle PL/SQL)

Position Description
If youre 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 2022, CGI was voted a Best Workplace in Tech by Great Place to Work and was named one of the Worlds 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 youll be part of an open, friendly community of experts. Well 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

Insights you can act on

While technology is at the heart of our clients digital transformation, we understand that people are at the heart of business success.

When you join CGI, you become a trusted advisor, collaborating with colleagues and clients to bring forward actionable insights that deliver meaningful and sustainable outcomes. We call our employees members because they are CGI shareholders and owners, and, as owners, we enjoy working and growing together to build a company we are proud of. This has been our Dream since 1976, and it has brought us to where we are todayone of the worlds largest independent providers of IT and business consulting services.

At CGI, we recognize the richness that diversity brings. We strive to create a work culture where everyone belongs, and we collaborate with clients in building more inclusive communities. As an equal opportunity employer, we empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process, please let us know. We will be happy to assist.

Ready to become part of our success story? Join CGIwhere your ideas and actions make a difference.

Skills

Capacity Management

Incident Management

Oracle DBMS

Release Management

Remedy

Reference
(phone number removed)