CGI Information Systems and Management Consultants Private Limited
Understand existing APS Framework, PL/SQL objects, Tables relationship.
Implement new functionalities using existing APS Framework and creating new database objects as required.
Investigate and Fix defects raised by System Testing/ Client UAT.
Prepare Details Design new functionality required as a part of CR/project.
Reuse and Create reusable components and solution.
Mentor/Support Junior members as well support member transitioning from old product version to new version.
Write performance efficient design and coding.
Analyzing Oracle execution plans and performance tuning of problematic query, reports.
Debugging and resolving DB environmental issues like table space issues, listener down, stale stats etc.
Debug and Resolve Oracle Database issues using Oracle Enterprise Manager.
SQL/PL SQL, MQSeries, Websphere Application Server
Jasper Reports, Oracle, Performance Tuning.
Primary Skill: – Pl/SQL developer.
Candidate should have experience working in Oracle.
Secondary Skills: – Performance tuning(Mandatory)
Years of experience: – 5 to 6 yrs/ 6 to 8 yrs
Deep experience with performance efficient design and coding
Deep understanding of Collections, Data structures, Exception handling, Performance Tuning, analytical Functions, RDBMS.
Solid knowledge of Oracle execution plans/performance tuning.
Experience in debugging DB environmental issues like table space issues, listener down, stats etc.
Knowledge of design and development using relational databases.
Understanding Low-level design document.
Effective verbal and written communication skills.
Ability to create reusable components and solution.
Secondary Skill: Mandatory/ Optional
Knowledge of Unix shell scripting or java or python.
Understanding of CGI payment hub product
Experience of working in Agile/Scrum.
Reference Id: J0319-1376
Apply to official link