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.