Senior Programmer/Database Administrator - Initiatives/Opportunities

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.

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.

• 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

• 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

• 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

• 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
• Mandatory five years experience with SQL Server, SQL Server Integration Services, and SQL Server Reporting Services
• 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

• 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.

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

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: askhr@fanshawec.ca

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.