Infrastructure Specialist - Intermediate

One of our large clients is looking for a contract Infrastructure Specialist- Intermediate. Below are the role details:

Work Style: Hybrid - 3 day/week in-office – Tuesday and Thursdays are mandatory

Location city(s): Toronto, London, Winnipeg

Number of Openings: 1

Anticipated Start Date: 4 weeks from offer

End Date: 6 months from offer

Part-time or Full-time: Full-time

Potential convert to permanent : No

Reason for role: Staff Aug

Contractor to work extra time or on-call - Weekly On-call rotation Monday 5:00 pm to Monday of the following week until 9:00 am

Role Title: Infrastructure Specialist - Intermediate

Enhanced Reliability (Protected B Clearance):  Not required

Any specific tools/skillset: Strong MS SQL skills, analysis skills § Experience with SSIS and SSRS § Exceptional troubleshooting skills § Experience with numerous environments and architectures § Working knowledge of the following applications: • Visual Studio • JBOSS • Apache

Role Profile:

The primary responsibility of the Infrastructure Specialist Database Analyst is to provide exceptional support services to all business units across the enterprise. Working closely with teams within IPC's Delivery & Technology organization, the successful candidate will be responsible for the administration, support, maintenance, and continuous improvement of the organization's Transfer Agency platforms and related systems.

JOB RESPONSIBILITIES & ACTIVITIES: 

• Support, maintain, and optimize infrastructure platforms, middleware, applications, and databases across multiple environments.
• Design and implement automation solutions to improve operational efficiency, scalability, and system reliability.
• Manage application deployments, upgrades, environment refreshes, database migrations, and infrastructure maintenance activities.
• Develop and maintain SQL scripts, ETL processes (SSIS), reporting solutions (SSRS), database objects, and business intelligence deliverables.
• Monitor application, database, and infrastructure performance; proactively address capacity, availability, and reliability concerns.
• Provide Level 2 production support by investigating incidents, troubleshooting technical issues, managing service requests, and coordinating resolutions with internal teams and vendors.
• Collaborate with internal teams and third-party vendors to integrate, support, troubleshoot, and enhance enterprise applications and technology solutions.
• Administer security configurations, certificates, and vulnerability remediation activities in accordance with enterprise standards.
• Produce operational, performance, and capacity-planning reports and provide recommendations for continuous improvement.
• Collaborate with business stakeholders to evaluate change requests, prioritize enhancements, and support strategic initiatives.
• Develop and maintain technical documentation, operational procedures, knowledge articles, and support processes while contributing to continuous improvement initiatives within an Agile environment.
• Participate in a rotational on-call schedule to support business-critical production systems and ensure timely response to operational incidents and service disruptions.

Professional Experience

• Minimum 3-5 years of experience in a similar role.
• Strong Microsoft SQL Server skills, including database administration, query development, performance tuning, troubleshooting, and data analysis.
• Experience developing and maintaining SSIS packages and SSRS reports.
• Exceptional analytical and troubleshooting skills with the ability to resolve complex technical issues.
• Experience supporting applications across multiple environments and system architectures
• Experience developing automation solutions using scripting technologies such as PowerShell, SQL, or similar tools.
• Strong working knowledge of Microsoft Visual Studio, Apache Tomcat, JBoss, Apache Web Server, and related technologies.

Core Competencies and Skills

• Relationships - Able to foster and maintain excellent relationships with IPC Head Office staff and key stakeholders. Comfortable working independently and collaboratively within a team environment.
• Excellent planning, analytical, and problem-solving skills - Ability to manage and prioritize multiple tasks and competing deadlines across cross-functional projects. Working knowledge of project management methodologies. Demonstrated ability to analyze issues, identify root causes, and implement effective solutions in a timely manner.
• Work Ethic - Detail-oriented and quality-driven with the ability to consistently meet tight deadlines and deliver accurate results.
• Communication - Strong verbal and written communication skills with the ability to effectively communicate with both technical and non-technical audiences. Able to clearly articulate project requirements, effort estimates, technical concepts, and research findings.
• Organizational skills and Time Management – Demonstrated ability to manage multiple priorities, effectively organize workload, and thrive in a fast-paced environment.

Education Requirements

 Undergraduate degree in Computer Science preferred or equivalent experience, preferably in the Financial Services Industry.