Senior Programmer/Database Administrator - Initiatives/Opportunities

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

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

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

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.