Senior Programmer/Database Administrator - Initiatives/Opportunities (3 positions)

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.

Working at Fanshawe College

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.

Campus Location:

Department:

Remote Type:

Support Staff employees, as defined by the Full-Time Support Staff Collective Agreement, will be given first consideration. 

These are Initiatives/Opportunities positions and are subject to the terms of the Full-Time Support Staff Collective Agreement aside from Article 15.

Note:  There are 3 Temporary Full-Time vacancies available with a contract duration of 2 years from the date of hire.  These positions are Hybrid with in-person work based in London, Ontario. These positions are deemed critical vacancies.

Payband: These positions are paid at Payband I, $40.39 - $46.64 per hour 

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)

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 

Project Management, Systems Analysis and System Design

• 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, SQL Server database administration, SQL programming

• Minimum five years ASP.NET, VB.NET, XML programming, Envision, Unidata and Uniobjects experience

• An equivalent combination of education and experience may be considered

• Experience with PowerBI, Salesforce, Workday , VBScript and JavaScript would be an asset                      

• Advanced analytical and problem-solving abilities

• Strong organizational and prioritization skills, with the ability to manage competing priorities and lead multiple initiatives

• Demonstrated ability to work independently and foster collaboration across teams including training and supporting of team members

• Excellent verbal and written communication skills

• Ability to build strong relationships with stakeholders and effectively gather, clarify, and translate business requirements into technical solutions

What This Opportunity Offers

• Comprehensive Pension & Benefits: Join a defined-benefit pension plan (through the CAAT Pension Plan) that delivers predictable lifetime retirement income, plus dental, disability, travel insurance and extended health coverage.

• Vacation: Enjoy paid time off and benefit from a scheduled holiday closure that offers additional rest and time with family during the winter season

• Tuition & Professional Development: Continue your learning journey — eligible employees and their dependents can take select Fanshawe programs or courses at a reduced cost

• Inclusive, Meaningful Campus environment: Work alongside passionate colleagues in an inclusive culture that values diversity, drives student success, and connects you to the local community and campus life.

Fanshawe College uses Workday to manage recruitment and hiring processes.
Educational Credentials

While transcripts are not required for the interview, they are mandatory as a condition of employment.

Equity, Diversity and Inclusion

Fanshawe College is an equal opportunity employer. We are committed to equity, value diversity, and welcome applicants from diverse backgrounds.

Accommodation

Fanshawe College provides accommodations to job applicants with disabilities throughout the hiring process. If a job applicant requires an accommodation during the application process or through the selection process, the hiring manager and the recruiter leading the recruitment will work with the applicant to meet the job applicant’s accommodation needs. Accommodation requests per the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act can be emailed to: [email protected]

Land Acknowledgement

Fanshawe College would like to acknowledge and honour the Anishinaabe, Lotinuhsyuní and Lenape people of southwestern Ontario as the traditional owners and custodians of the lands and waterways where Fanshawe College is located.

We thank all applicants for their interest; however, only those chosen for an interview will be contacted.