PositionDescription
If youre at home managing complex datasets and AI systems, yourintelligence could help drive our digital revolution. OurApplication Support Analysts (Oracle PL/SQL) are trusted to workclosely with a wide range of clients on exciting projects withreal-world purpose and impact. From public service systems tocutting-edge commercial projects, our work has a wide reach,helping make the everyday easier, for everyone. When you start yourCGI story, not only will you be improving peoples lives, you can besure well do the same for you.
CGI wasrecognised in the Sunday Times Best Places to Work List 2023 andhas been named one of the Worlds Best Employers by Forbes magazine.We offer a competitive salary, excellent pension, privatehealthcare, plus a share scheme (3.5% + 3.5% matching) which makesyou a member not just an employee. We are committed to inclusivity,building a genuinely diverse community of tech talent and inspiringeveryone to pursue careers in our sector, including our ArmedForces, and are proud to hold a Gold Award in recognition of oursupport of the Armed Forces Corporate Covenant. Join us and youllbe part of an open, friendly community of experts. Well train andsupport you in taking your career wherever you want it to go.
This role is based on-site, 5 days per week, ineither our Bridgend or Reading offices. Occasional evening andweekend work for support activities will be required. Allapplicants must hold or be prepared to undergo National SecurityVetting (NSV) to Security Check (SC) and NPPV3 level.
Yourfuture duties andresponsibilities
You will provide Application Support and Database Administration toour key clients on a VLDB with multiple partitioning strategies.This typically comprises Application Support to identify dataanomalies and code defects; PL/SQL and SQL statement tuning;Application releases and deployments together with DatabaseAdministration; Capacity Planning; Performance Monitoring andTuning. You will work to resolve incidents via Remedy (ITSM) callmanagement system with SLA deadlines and perform planned releasessupporting a bespoke application.
Requiredqualifications to be successful in thisrole
Essential:
Experience of development and/orsupport of Oracle PL/SQL modules in a large system
Basicknowledge of Oracle Database Administration in a Development orProduction role
MS-Office tools including Word, Excel,Visio
Technicalskills:
Underlying technology skillrequirements, must have development / support skills in a range ofthe following:
Exposure to Oracle 10g or later(the application version is Oracle 11gR1)
In depthknowledge and experience in writing Oracle SQL statements andPL/SQL packages
Exposure to Unix (the application usesSun Solaris, but any flavour of Unix or Linux isacceptable)
Desirableskills:
Performance Tuning of SQL andPL/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 OracleWeblogic, Oracle Service Bus or other Application Server technology
Insights you can acton
While technology is at theheart of our clients digital transformation, we understand thatpeople are at the heart of businesssuccess.
When you join CGI, you become a trustedadvisor, collaborating with colleagues and clients to bring forwardactionable insights that deliver meaningful and sustainableoutcomes. We call our employees members because they are CGIshareholders and owners, and, as owners, we enjoy working andgrowing together to build a company we are proud of. This has beenour Dream since 1976, and it has brought us to where we aretodayone of the worlds largest independent providers of IT andbusiness consulting services.
At CGI, werecognize the richness that diversity brings. We strive to create awork culture where everyone belongs, and we collaborate withclients in building more inclusive communities. As an equalopportunity employer, we empower all our members to succeed andgrow. If you require an accommodation at any point during therecruitment process, please let us know. We will be happy toassist.
Ready to become part of our successstory? Join CGIwhere your ideas and actions make a difference.
- CapacityManagement
- Incident Management
- OracleDBMS
- Release Management
- Remedy