Address
Form of workPosition 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. From public service systems to cutting-edge commercial projects, our work has a wide reach, helping make the everyday easier, for everyone. When you start your CGI story, not only will you be improving peoples lives, you can be sure well do the same for you.
CGI was recognised in the Sunday Times Best Places to Work List 2023 and has been 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, including our Armed Forces, and are proud to hold a Gold Award in recognition of our support of the Armed Forces Corporate Covenant. 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.
This role is based on-site, 5 days per week, in either our Bridgend or Reading offices. Occasional evening and weekend work for support activities will be required. All applicants must hold or be prepared to undergo National Security Vetting (NSV) to Security Check (SC) and NPPV3 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 a range 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
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
