SENIOR ORACLE PL/SQL LEAD

Position Description.
At CGI, we’re a team of builders.
We call our employees members because all who join CGI are building their own company - one that has grown to professionals located in 40 countries.
Founded in , CGI is a leading IT and business process services firm committed to helping clients succeed.
We have the global resources, expertise, stability and dedicated professionals needed to achieve.
At CGI, we’re a team of builders.
We call our employees members because all who join CGI are building their own company - one that has grown to professionals located in 40 countries.
Founded in , CGI is a leading IT and business process services firm committed to helping clients succeed.
We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members.
Come grow with us.
Learn more at www.
gi.
om.
This is a great opportunity to join a winning team.
CGI offers a competitive compensation package with opportunities for growth and professional development.
Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans.
We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted.
No unsolicited agency referrals please.
Job Title.
Oracle PL/SQL Lead Position.
Lead Engineer/Associate Consultant Experience.
Years Category.
Software Development/ Engineering Main location.
Bangalore/Chennai /Hyderabad/Pune/Mumbai Position ID.
J Employment Type.
Full Time We are seeking an experienced Oracle PL/SQL Lead to join our team.
The ideal candidate will be responsible for developing, testing, implementing, and maintaining Oracle PL/SQL code in support of various software applications and projects within our organization.
Qualification.
Bachelor's degree in Computer Science or related field or higher with minimum 4 years of relevant experience.
Responsibilities.
1.
Develop and maintain Oracle PL/SQL code for database-driven applications.
2.
Design, implement, and optimize stored procedures, functions, triggers, and packages to support business requirements.
3.
Collaborate with software developers, business analysts, and project managers to understand requirements and translate them into technical solutions.
4.
Perform database performance tuning and optimization, including PLSQL code optimization, and query optimization.
5.
Develop and maintain Unix shell scripts to automate system tasks, data processing, and application workflows.
6.
Troubleshoot and debug existing scripts to identify and resolve issues in a timely manner.
7.
Participate in code reviews and provide constructive feedback to peers.
8.
Troubleshoot and debug PL/SQL code as needed.
9.
Identifying and resolving performance bottlenecks and data integrity issues.
10.
Stay up-to-date with the latest trends and best practices in Oracle PL/SQL development.
Must Have Skills.
1.
Proven experience as an Oracle PL/SQL Developer (5 years plus).
2.
Strong proficiency in Oracle PL/SQL programming, including stored procedures, functions, triggers, and packages.
3.
Strong proficiency in collections.
4.
Strong understanding of database architecture.
5.
Excellent problem-solving and analytical skills.
6.
Strong communication and collaboration abilities.
7.
Ability to work independently and as part of a team.
Good to Have Skills.
8.
Experience as a Unix Scripting Developer.
9.
Proficiency in Unix shell scripting (bash, ksh, csh, etc.).
10.
Understanding of Unix/Linux operating systems and command-line utilities.
11.
Familiarity with scheduling tools (e.
., cron) and job automation frameworks.
12.
Experience with performance tuning and optimization techniques.
13.
Familiarity with Oracle database administration tasks.
14.
Experience with version control systems (e.
., Git) and continuous integration tools (e.
., Jenkins).
15.
Knowledge in wealth management domain 16.
Experience working in an Agile development environment.
Skills.
Oracle Performance Tuning SQLite Unix What you can expect from us.
Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging.
Here, you’ll reach your full potential because… You are invited to be an owner from day 1 as we work together to bring our Dream to life.
That’s why we call ourselves CGI Partners rather than employees.
We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value.
You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.
You’ll shape your career by joining a company built to grow and last.
You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
Come join our team—one of the largest IT and business consulting services firms in the world.