Oracle, PLSQL, Unix Oracle, PLSQL, Unix

Position Description:

Company Profile:
Founded in 1976 CGI is among the largest independent IT and business consulting services firms in the world. With 94000 consultants and professionals across the globe CGI delivers an end-to-end portfolio of capabilities from strategic IT and business consulting to systems integration managed IT and business process services and intellectual property solutions. CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results. CGI Fiscal 2024 reported revenue is CA$14.68 billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more at .

Job Title: Oracle PLSQL Unix
Position: Oracle PLSQL Unix

Experience: 5 - 7 Years

Category: IT Infrastructure

Main location: Chennai

Position ID: J0326-2227



Employment Type: Full Time

Qualification: Bachelors degree in Computer Science or related field or higher with minimum 3 years of relevant experience.

Job Description:
Direct Responsibilities
Design develop and maintain applications using Oracle technologies.
Collaborate with stakeholders to understand requirements and translate them into technical specifications.
Design and develop Oracle database schemas tables and stored procedures.
Write efficient SQL queries and optimize database performance.
Integrate ExtJS applications with Oracle databases ensuring data integrity and security.
Analyze and troubleshoot technical issues identifying root causes and implementing effective solutions.
Collaborate with team members to resolve complex technical challenges and optimize software performance.
Stay updated with emerging technologies and industry trends and apply them to enhance software solutions.
Collaborate with cross-functional teams including product owners designers and QA engineers to ensure successful project delivery.
Communicate effectively with team members and stakeholders providing updates seeking clarification and addressing concerns.
Participate in code reviews providing constructive feedback and suggestions for improvement.
Develop and execute unit tests and integration tests to ensure the quality and reliability of software applications.
Collaborate with QA engineers to identify and resolve defects ensuring the delivery of high-quality software products.
Follow quality assurance processes and best practices to maintain code integrity and software stability.
Create and maintain technical documentation including design documents user guides and API documentation.
Document code changes enhancements and bug fixes to facilitate knowledge sharing and future maintenance.
Stay updated with the latest technologies programming languages and industry trends through self-learning and professional development opportunities.
Actively participate in team discussions sharing knowledge and best practices with colleagues.
Identify areas for process improvement and propose innovative solutions to enhance software development practices.
Contributing Responsibilities
The candidate must be able to demonstrate the key competencies detailed below to the standard required for the role.
Competencies (1 essential 2 desirable)

Adaptability: 1
Results and quality orientation: 1
Communication: 1
Customer focus: 1
Decision making: 1
Team work: 1
Innovation and continuous improvement: 1
Technical expertise: 1

Technical & Behavioral Competencies
Primary Skill:
- Oracle SQL/PLSQL
- SQL Performance Tuning
- Scheduling concept in Oracle
- UNIX Shell Scripting

Added Advantage:
- Oracle Goldengate

Tools:
Configuration management using GIT
SQL Developer Putty
Octane
SonarQube
Jenkin

Specific Qualifications:
Minimum 5 years of experience in SQL and PL/SQL along with Bachelors Degree - in management finance science economics related field or equivalent experience.
Prior experience in similar domain.
Skills Referential (Required knowledge skills and abilities)
Technical Skills:
o Oracle SQL/PLSQL
o SQL Performance Tuning
o Scheduling concept in Oracle
o UNIX Shell Scripting

Behavioral Skills:
o Attention to detail / rigor
o Ability to deliver / Results driven
o Communication skills - oral & written
o Adaptability

Education Level: Bachelor Degree or equivalent
Location: Chennai

CGI is an equal opportunity addition CGI is committed to providing accommodations for people with disabilities in accordance with provincial legislation. Please let us know if you require a reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.
Life at CGI:
It is rooted in ownership teamwork respect and belonging. Here youll 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. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction
Your work creates value. Youll 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
Youll shape your career by joining a company built to grow and last. Youll 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

Skills:

• Linux
• Oracle
• Oracle DBMS
• Shell Script
• SQLite
• Unix

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll 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. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll 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.

Youll shape your career by joining a company built to grow and last. Youll 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 teamone of the largest IT and business consulting services firms in the world.