Sr PL/SQL Engineer

Back

Sr PL/SQL Engineer

@ CGI

Support software implementation projects with one or multiple clients.

Duties include

  • System design and development tasks such as custom code,
  • System integration, data migration, and code deployment.
  • The Senior Software Engineer works both independently and as part of a team to meet deliverables in an efficient and timely manner.
  • Assumes quality assurance responsibility and necessary documentation of assigned tasks.
  • Works aggressively to develop his/her technical skills, learns from more experienced team members, and shares knowledge with less experienced team members.
  • Develops a basic understanding of the functional business processes and requirements that the software implementation is designed to address.

All team members receive Sunflower software and asset management training prior to providing customer support.


Qualifications:

  • At least 5 - 10 years’ experience in the Information Technology field. Minimum of 5 years recent experience with any RDBMS and tools based application design and development. Good understanding of design, development and analysis.
  • Minimum 5 years of experience with Oracle design and architecture, including advanced knowledge in:
  • Complex table relationships
  • Database packages, functions, procedures, triggers, jobs, etc…Sys privileges, object grants and database roles
  • Understanding and troubleshooting database errors (ORA-xxxxx, PLS-xxxxx, etc…)
  • PL/SQL: deep understanding of PL/SQL code; writing new code from scratch and updating existing code based on customers’ requirements
  • SYS privileges, object grants and database roles
  • SYS views “dba_” as well as general “user_” views for troubleshooting purposes
  • Writing complex static and dynamic SQL queries joining multiple tables
  • Experience in WebLogic Server and Oracle Fusion Middleware components, including:
    • Application deployments
    • Managed Servers
    • JDBC data sources
  • Familiarity with Java Runtime Environment (JRE) and Java Development Kit (JDK)
  • Familiarity with Oracle Forms based and Web based applications.
  • Familiarity with Windows and Linux operating systems
  • Information systems networking skills
  • Strong analysis, documentation, communication and writing skills.
  • Programming skills in either C/C++ or Visual Basic.
  • Not able to sponsor or take non-citizens for this role


DESIRED QUALIFICATIONS

  • Experience with HTML coding and calls from within PL/SQL code
  • Experience with Angular Web Application framework


Skills:

  • Application Design
  • Oracle
  • PL/SQL


How to Apply:

Apply online at https://www.cgi.com/en/careers

Visit Site to Apply

Location: Lafayette, LA
Date Posted: December 15, 2021
Application Deadline: January 19, 2022