Senior Oracle Programmer Analyst

Job title: Senior Oracle Programmer Analyst

Company: Randstad


Job description: Our leading public sector organization is seeking a highly skilled Senior Oracle Programmer Analyst to support a wide range of custom-built business applications. The successful candidate will bring over 7 years of IM/IT experience and at least 5 years as a Programmer Analyst, with proven expertise in Oracle Forms 11gR2, Oracle Reports, and PL/SQL development-including packages, procedures, functions, and database triggers. This role involves problem analysis, solution design and implementation, small-to-medium-scale application development, and ongoing documentation and support within a collaborative, cross-functional team. Experience with .NET technologies such as VB.Net, C#, and Visual Studio is considered an asset. Strong communication skills and the ability to work effectively in a distributed team environment are essential. While preference will be given to candidates located in Fredericton, NB, remote work arrangements are acceptable. However, the successful candidate must be available to attend onsite as required. If you’re a driven and detail-oriented Oracle expert, this is a great opportunity to contribute to meaningful, high-impact projects.*** 11 month contract to start ***Advantages

• Location Flexibility: Remote work is possible with occasional travel to Fredericton, offering flexibility for candidates.

Responsibilities

• Review and assess incoming bug reports or change requests for existing Oracle-based business applications.
• Perform root cause analysis to identify underlying problems within the codebase, database, or application interfaces.
• Document and present proposed solutions to the support team, ensuring clarity and feasibility before implementation.
• Modify and enhance Oracle Forms and Reports to reflect approved changes and updates.
• Design, develop, and maintain PL/SQL components including advanced database packages, stored procedures, functions, and event triggers.
• Ensure updates are optimized, maintainable, and aligned with system performance requirements and architectural standards.
• Collaborate with business analysts and stakeholders to understand functional requirements for new features or small-to-medium-scale applications.
• Translate functional specifications into technical designs and implement clean, testable code within Oracle and .NET environments (where applicable).
• Perform unit testing and assist with user acceptance testing (UAT) to validate the solution prior to deployment.
• Interpret and define complex database table relationships, field specifications, and dependencies across integrated systems.
• Analyze and work with existing schemas to ensure consistency and data integrity while implementing new logic or modifying structures.
• Produce comprehensive and up-to-date technical documentation for all developed or modified components.
• Follow internal standards and guidelines for documentation to ensure consistency across the team.
• Share knowledge and insights with team members to foster a collaborative and informed support environment.
• Engage in regular team scrums and project meetings to provide updates on assigned tasks and development progress.
• Communicate any roadblocks, dependencies, or resource needs in a timely manner.
• Contribute to planning sessions and retrospective meetings to support continuous team improvement.
• Maintain a strong focus on the ongoing support, stability, and maintainability of mission-critical applications.
• Work effectively with a distributed team, including business analysts, DBAs, developers, and end users, to ensure prompt resolution of issues and high-quality service delivery.

Qualifications

• Minimum 5 years of experience developing interfaces using Oracle Forms and Oracle Reports, incorporating a variety of controls and validation logic.
• At least 5 years of hands-on experience writing, debugging, and maintaining advanced PL/SQL components such as packages, procedures, and functions.
• 5 years of experience creating and managing complex database event triggers within Oracle environments.
• 5 years of experience analyzing, defining, and working with complex Oracle database tables and field specifications in systems with high interdependencies.
• 5 years of experience in reading, understanding, and interpreting complex database schemas.
• At least 3 years of experience working effectively as part of a distributed or cross-functional team (e.g., with business analysts, DBAs, developers, and end users).
• 3 years of experience in roles requiring strong verbal and written communication skills, with the ability to adapt messaging to technical and non-technical audiences.
• 3 years of experience working in a support-focused development environment, showing strong interpersonal and collaborative skills.

Additional Assets

• Experience with .NET development environments, including VB.Net, C#, Visual Studio, and .NET Forms.
• Prior experience in a public sector or enterprise-scale application support environment.
• Familiarity with Agile methodologies and participation in scrum-based teams.

Summary
If you are qualified and interested we encourage you to apply for this exciting opportunity!Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada’s workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.

Expected salary:

Location: Fredericton, NB

Job date: Sun, 06 Apr 2025 06:44:58 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnear.pro) you saw this job posting.Thanks&Good Luck