Oracle PL/SQL Developer

CGI Group, Inc. is seeking an experienced Oracle PL/SQL Developer to help design, develop, test, and maintain complex Oracle SQL and PL/SQL solutions. This onsite role in Plano, TX focuses on performance tuning, reliable data integration, and delivering database capabilities that support downstream applications and analytics.

In this position, you will build and support Oracle-to-Snowflake data flows, automate testing using TDD practices, and partner with business stakeholders, application developers, data engineers, architects, and QA teams throughout an Agile/Scrum delivery cycle.

What you’ll do

• Design, develop, test, and maintain complex Oracle SQL and PL/SQL solutions.
• Develop and optimize stored procedures, packages, functions, cursors, triggers, and complex SQL queries.
• Perform SQL and PL/SQL performance tuning, including execution-plan analysis, indexing, and query optimization.
• Deliver solutions for data maintenance, migration, copy, reconciliation, archival, and purge activities.
• Build and support Oracle-to-Snowflake integrations, including data movement, transformations, and validation processes.
• Troubleshoot database and data issues while ensuring data integrity, accuracy, and application performance.
• Translate business and data requirements into scalable technical designs and database solutions.
• Develop automated tests and follow Test-Driven Development (TDD) and engineering best practices.
• Participate in code reviews and contribute to development and database standards.
• Collaborate with stakeholders across teams, including application development, data engineering, architecture, and QA.
• Participate in Agile/Scrum activities, including sprint planning, daily stand-ups, reviews, and retrospectives.
• Communicate delivery status, dependencies, risks, and technical issues effectively across teams.

Requirements

• Bachelor’s or Master’s degree in a technical field such as Computer Science, Software Engineering, Information Systems, or a related discipline.
• 9+ years of Oracle SQL and PL/SQL development experience.
• Strong expertise in SQL, stored procedures, packages, functions, cursors, transactions, triggers, and exception handling.
• Strong knowledge of Oracle performance tuning, query optimization, indexing, and execution plans.
• Experience developing complex SQL queries and processing large-volume data sets.
• Strong understanding of relational and transactional databases and database design principles.
• Experience with data migration, maintenance, reconciliation, archival, and purge processes.
• Good understanding of dimensional modeling and Star Schema concepts.
• Experience with CI/CD and automated database deployment.
• Hands-on experience across analysis, design, development, testing, debugging, and production support.

Technologies

• Oracle SQL
• PL/SQL
• Oracle-to-Snowflake integrations
• Snowflake
• Amazon Relational Database Svc
• ETL
• GIT
• Jira
• CI/CD
• Test-Driven Development (TDD)

Compensation and location

• Location: Plano, TX (onsite)
• Salary range: USD 83,900 - 115,400 per year
• Compensation estimate notice: A reasonable estimate of the current range for this role in the U.S. is $83,900.00 - $115,400.00.

Benefits

• Competitive compensation
• Comprehensive insurance options
• Matching contributions through the 401(k) plan and the share purchase plan
• Paid time off for vacation, holidays, and sick time
• Paid parental leave
• Learning opportunities and tuition assistance
• Wellness and Well being programs

Good to have

• Snowflake integration or Oracle-to-cloud data platform integration
• Exposure to cloud and modern data engineering platforms
• Experience supporting high-volume, business-critical enterprise applications
• Financial services or other regulated-industry experience