Type: Full-Time Contract (12 Months) Our downtown Edmonton client is seeking an experienced contract Systems Analyst (PL/SQL) to support the analysis, design, development, enhancement, and maintenance of enterprise Oracle applications. You will be responsible for gathering business requirements, developing technical solutions, supporting production systems, and collaborating with business and technical stakeholders throughout the software development lifecycle. You will have extensive experience working in Oracle environments, strong PL/SQL development expertise, and a proven ability to deliver solutions in complex enterprise environments.

Systems

Analysis & Development Gather, analyze, and document business and technical requirements. Design, develop, test, and implement application enhancements and change requests. Develop and maintain technical documentation, specifications, procedures, and support materials. Design, build, and validate solutions that meet business and technical requirements.

Application

Support &

• Maintenance Conduct root cause analysis and recommend improvements to systems and processes. Monitor application performance and recommend enhancements where appropriate. Testing &

• Quality Assurance Participate in system, integration, and user acceptance testing activities. Develop and execute test plans and test cases for application changes. Collaborate with IT teams and business stakeholders during testing cycles. Provide support throughout all phases of testing and implementation. Ensure solutions meet quality standards and business requirements. Collaboration &

• Project Delivery Contribute to workload planning, prioritization, and project deliverables.



Participate as a member of project teams and technology initiatives. Adhere to IT controls, governance standards, data privacy requirements, and organizational policies. Data &

• Reporting Solutions Design and develop data interfaces, extracts, and integrations. Assist in the design and maintenance of logical and physical data models. Develop and optimize complex database queries and SQL solutions. Support data management and reporting initiatives across the organization. Bachelor's degree or diploma in Computer Science, Information Technology, or a related technical discipline. Minimum 8 years of experience in systems analysis, application design, development, implementation, and support within enterprise environments. Advanced experience working with Oracle databases, Oracle development tools, and Oracle application environments. Strong ability to write and optimize complex SQL and PL/SQL queries against large and complex data sets. Demonstrated experience gathering business requirements and translating them into technical solutions.

Experience supporting application testing, implementation, and production support activities. Strong analytical, troubleshooting, root cause analysis, and problem‑solving skills. Exceptional consultation skills with the ability to communicate technical concepts to both technical and non‑technical audiences. Solid planning, organizational, and workload management abilities.

Assets: Experience with Java, Bash scripting, or other programming languages. Working knowledge of database administration or database environments.

Experience designing and developing data interfaces, reports, forms, and extracts.

Experience with logical and physical data modeling. Knowledge of IT governance, data privacy, and compliance practices.

📌 SYSTEM ANALYST (Full Time) (Edmonton)
🏢 10 Percent Recruiting
📍 Edmonton