Senior Programmer/Database Administrator - Initiatives/Opportunities

The Fanshawe College of Applied Arts and Technology; London; Hybrid; CAD 75,000 - 87,000; Full time

Benefits offered by this job

Hybrid work

On-site 1 day/week

Job summary

Fanshawe College in London, Ontario is seeking an Initiatives/Opportunities position within Information Systems Services to support the Phase 3 ERP migration. The role provides senior programming, systems analysis, and database expertise to implement data conversion, migration, integration, and reporting from legacy to future systems.

Under the Director, Enterprise Solutions, you will design, develop, test, deploy, and maintain enterprise database interfaces and APIs, mentor programmers, and

Qualifications

• 3 year diploma/degree in Computer Programming, Computer Science, Software Engineering, Information Technology or related field.
• Minimum five years computer programming experience including at least three years experience in project management, systems analysis, systems design.
• Minimum five years ASP.NET, VB.NET, XML programming experience.

Responsibilities

• Analyzes processes, systems and programs to resolve problems and introduce enhancements.
• Reviews existing processes and develops an understanding of user requirements.
• Identifies alternative solutions and makes recommendations to Manager or end users to meet the requirements.
• Designs complex systems.
• Prepare programming specifications.
• Provides project management involving project teams.
• Collaborates extensively with end-users in requirements gathering, prototyping and release management.
• Programming and Code Review.
• Performs quality assurance by reviewing, testing, and approving system changes (code, configuration settings, scripts) by Programmer/Analysts and Programmers.
• Accountable for programmer compliance in documenting activity, changes, and tasks in application life cycle management tools (ie. Team Foundation Server).
• Codes/Programs to approved specifications.
• Database Developer and System Integration.
• Creates and manages database objects.
• Subject Matter Expert for enterprise database schemas, entities, attributes, and objects.
• Responsible for query and modifying data.
• Creates and manages stored procedures, functions, and triggers.
• Accountable for optimizing system performance and integrity.
• Designs, Develops, Tests, Deploys, and Maintains supported enterprise database interfaces (ie. APIs, ETLs and batch interfaces for systems such as Colleague).
• Ensures users have appropriate system and database access.
• Ensures appropriate database back-up and recovery procedures are in practice.
• Other Duties as Assigned.

Skills

Programming experience

Project management

Systems analysis

Systems design

Education

3-year diploma/degree in IT or related field

Tools

ASP.NET

VB.NET

XML

Job description

Interested in growing your career at Fanshawe College? Fanshawe College thrives because of its people. We foster a culture of excellence and see opportunities to turn potential into impact. Leading with empathy, belonging, unity, learning and courage, we guide the learning journey of our students, ensuring they are ready for work and life, today and tomorrow.

Fanshawe College is committed to the principles of hybrid work and may offer this option to employees whose work can be performed in an alternate location, without adverse impact to the operations of the College, inclusive of our Student and Staff experience. Confirmation of hybrid work options available to you will be clarified upon hire and may be subject to change based on the duties required of your position. Successful candidates will be required to perform work within Ontario and must be available to work on campus, as required.

Fanshawe College uses Workday to manage recruitment and hiring processes.

Posting Closing Date: October 6, 2026 Campus Location: London, ON Department: ISS1 Information Systems Services Employment Group: Support Pay Details: $41.20 Hourly Worker Sub-Type: Fixed term (Fixed Term) Time Type: Full time Remote Type: Hybrid Contract End Date: July 31, 2028 Hours of Work per Week: 35

Job Description

Note: Previous applicants need not re-apply for this position. Your previously received application will be considered. This position is an Initiatives/Opportunities position and is subject to the terms of the Full-Time Support Staff Collective Agreement aside from Article 15. Note: One Temporary Full-Time vacancy is available with a contract duration of 2 years from the date of hire. This position is deemed a critical vacancy. Payband: $41.20 - $47.57 per hour (Payband I) Hours: Monday to Friday, 8:30 a.m. to 4:30 p.m.; Averaging of hours applies according to the Support Staff Collective Agreement (Appendix C) Work Mode: Hybrid - This position requires minimum 1 day onsite per week.

Why this Role is Important

This role will be dedicated to supporting the implementation of Phase 3 - Student of the colleges Enterprise Resource Planning Student Information System Migration. The analysts will help support key initiatives regarding the conversion, migration, integration and reporting of data from legacy to future systems. Under the supervision of the Director, Enterprise Solutions, provides senior programming, systems analysis, systems design and database administration expertise in the development and support of the College's information systems; provides training and support to Programmer/Analysts and Programmers as needed.

How You’ll Make an Impact

• Analyzes processes, systems and programs to resolve problems and introduce enhancements.
• Reviews existing processes and develops an understanding of user requirements.
• Identifies alternative solutions and makes recommendations to Manager or end users to meet the requirements.
• Designs complex systems.
• Prepare programming specifications.
• Provides project management involving project teams.
• Collaborates extensively with end-users in requirements gathering, prototyping and release management.
• Programming and Code Review.
• Performs quality assurance by reviewing, testing, and approving system changes (code, configuration settings, scripts) by Programmer/Analysts and Programmers.
• Accountable for programmer compliance in documenting activity, changes, and tasks in application life cycle management tools (ie. Team Foundation Server).
• Codes/Programs to approved specifications.
• Database Developer and System Integration.
• Creates and manages database objects.
• Subject Matter Expert for enterprise database schemas, entities, attributes, and objects.
• Responsible for query and modifying data.
• Creates and manages stored procedures, functions, and triggers.
• Accountable for optimizing system performance and integrity.
• Designs, Develops, Tests, Deploys, and Maintains supported enterprise database interfaces (ie. APIs, ETLs and batch interfaces for systems such as Colleague).
• Ensures users have appropriate system and database access.
• Ensures appropriate database back-up and recovery procedures are in practice.
• Other Duties as Assigned.

What You’ll Bring

• 3 year diploma/degree in Computer Programming, Computer Science, Software Engineering, Information Technology or related field
• Minimum five years computer programming experience including at least three years experience in project management, systems analysis, systems design
• Minimum five years ASP.NET, VB.NET, XML programming experience