PLSQL Developer (Oracle, PLSQL, Unix L4) Full Time

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: PLSQL Developer (Oracle, PLSQL, Unix L4)

Position: PLSQL Developer (Oracle, PLSQL, Unix L4)

Experience: 7 – 9 Years

Category: IT Infrastructure

Main location: Chennai

Position ID: J0426-1878

Responsibilities

Direct Responsibilities

Oracle Developer will be performing:

• Consistent work experience of 9 years in Oracle SQL and PL/SQL development.
• Develop schemas, tables, indexes, sequences, constraints, functions, and procedures, Packages, Collections, Users and Roles.
• Understand business requirements and accordingly develop database models.
• Provide optimal design solutions to improve system quality and efficiency.
• Follow best practices for database design.
• Perform capacity analysis and oversee database tuning.
• Maintain technical documentations for reference purposes.
• Write complex codes and queries and participate in code reviews.
• Perform design review, modify codes and test upgrades.
• Work closely with other developers to improve applications and establish best practices.
• An ability to understand front-end users requirements(Java) and a problem-solving attitude
• In-depth understanding of data management (e.g. permissions, recovery, security and monitoring).
• Provide training and knowledge sharing with the development team.
• Maintains all databases required for development, testing, Pre-Production and production usage.
• Takes care of the Database design and implementation.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Performance tuning and monitoring, proactively propose solutions.
• Perform Data anonymization

Contributing Responsibilities

• Work in duet with our offshore and in-site technical team to coordinate the database initiatives.
• Perform detailed technical analysis with impacts (technical/functionally) and prepare Technical specification document.
• Mentor and carry out database peer code reviews of development team.
• Bug fixing & performance optimization
• Keep the development team up-to-date about the best-practices and in-site feedbacks.
• Challenge the time-response performance and the maintainability of the treatments/queries.
• Maintains data standards and security measures and anonymize Production data and import in Development and Testing environments.
• Performance tuning and Monitoring of All databases and proactively propose solutions in case of issues.

Develop and unit test the code :

• Develop the Code to suffice the business requirements
• Unit test the code and bug fix all the defects arising out of the unit testing
• Properly check in the code to avoid issues arising out of configuration management

Deploy and Integrate test the application Developed :

• Deploy the developed code into the IST Environments and perform the Integration testing by working with the cross teams
• Fix all the defects arising out of IST and UAT Testing.

Keep the development team up-to-date about the best practices and feedback.

Technical & Behavioral Competencies

• Knowledge and/or experience of the financial services industry
• Good understanding of software development life cycle and Agile/Iterative methodology
• Technical competency in the following:
• Experience in SQL and PL/SQL development – Oracle Database
• Good understanding of ER Diagrams, Data Flows
• Good to have experience on DB design & modelling
• Hands-on on performance tuning tools and debugging
• Ability to perform technical analysis, design and identify impacts (functional/technical)

Prior experience in High Volume / Mission critical Systems is a plus

Specific Qualifications:

Graduate degree in computer science

Skills Referential (Required Knowledge, Skills And Abilities)

Technical Skills:

• Oracle SQL/PLSQL
• DB design& Modeling
• Oracle performance tuning/Debugging
• Develop schemas, tables, indexes, sequences, constraints, functions, and procedures, Packages, Collections, Users and Roles
• Cloud/DevOps

Behavioral Skills:

• Adaptability
• Ability to deliver / Results driven
• Creativity & Innovation / Problem solving
• Ability to share / pass on knowledge

Education Level: Bachelor Degree or equivalent

Location: Chennai

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.

Your future duties and responsibilities

Required Qualifications To Be Successful In This Role

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.