Oracle, PLSQL, Unix - Oracle, PLSQL, Unix

Job description

Position Description:

Company Profile:
Founded in 1976, CGI is among the largest independent IT and business consulting services firms in the world. With 94,000 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 cgi.com.

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: Bachelor's 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 Bachelor's 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 employer. In 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, 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

Skills:

·  Linux
·  Oracle
·  Oracle DBMS
·  Shell Script
·  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.