SQL Support jobs in London, ON

Overview

Join our dynamic team as an IT Generalist and become a vital contributor to our technology infrastructure! Primarily, your expertise in a Microsoft environment will support our network administration team and you will be responsible for maintaining and enhancing our IT environment, ensuring seamless operations across various platforms and systems.

Additionally, as a medium sized company, there will be an opportunity to have an impact on our entire Information System strategy, including SQL report writing to extract information from the system, serve as the primary administrator for our Base44 app and angular development. This is an ideal role for a recent graduate looking for a position with a vast array of Information Systems experience.

This is an exciting opportunity for a motivated IT professional eager to apply a broad skill set in a fast-paced, innovative setting.

Responsibilities

1. Network Administration

• Maintain server updates, and ensure 100% uptime
• Manage daily, weekly, monthly, backup cycles for databases, mailboxes and file servers
• Virus scanning and remediation of virus situations.
• Web server administration
• Desktop support for internal staff including printers, fax, and phone systems
• Email, network, and internet connectivity troubleshooting.
• Manage phone IVR system
• Maintain security the Network and set up appropriate firewalls

Systems

• Ability to work in a Windows environment
• An understanding of the Microsoft active directory security model
• Understanding of internet protocols technologies, firewalls, Transmission control protocols and related Hardware

3. Software

• Proficient with MS SQL and Access databases
• Knowledge of Base44 would be an asset
• Adobe and Microsoft Publisher
• File transfer protocol
• Basic programing knowledge would be an asset, specifically in Angular

4. Reporting

• Ability to write and distribute report from MS SQL Server using SSRS (Microsoft Reporting Service) and Crystal Reports.
• Ability to integrate database reports into Microsoft Excel, Microsoft Word and MS Access. Advanced Microsoft Office and Excel experience would be an asset.
• Ability to work within Persits PDF platform ensuring programmed reports and forms are presented professionally.
• Basic experience in graphic manipulation especially for web systems would be an asset.
• Proficient in Microsoft Office suite

5. Collaboration

• Work closely with the Administration, Claims, Sales, Accounting and Marketing teams to ensure our in house database and third party software reflect the business requirements and needs of the company;
• Eagerness to learn and ability show patience when working with all members of the organization
• Ability to manage a project list and set priorities as part of a project team using a shared project management tool.
• Contribute to the database and programming aspects of projects and business plans;
• Perform other tasks as assigned by the Executive Team and Information Technology Team.
• Reports directly to the CFO

Experience & Skills

• Post-secondary education in Information Systems or the equivalent
• Excellent written and oral communication skills;
• Demonstrated leadership ability, team management, and interpersonal skills;
• Excellent analytical and abstract reasoning skills, plus excellent organization skills.
• Ability to work on multiple tasks simultaneously
• Microsoft Certifications are an asset
• Microsoft, network-vendor licensing and software acquisition.
• Windows Server 2012-2016 and related Enterprise applications
• MS Exchange and MS SQL Server administration
• MS IIS and Apache webservers. Additional Wordpress administration preferred.
• XENServer virtualization platform experience (preferred).
• Windows 7 operating systems. How to troubleshoot, use control panel, add/remove programs, troubleshooting Windows Updates.
• Network security devices and protocols configuration and support.
• Fundamental network protocols (DHCP, DNS, TCP/IP, LAN and WAN design, etc.).
• Knowledge of Angular development would be an assert
• Asterisk VIP telephony server. Managed by FreePBX
• Server peripheral hardware (UPS, backup drives, KVM/vKVM, etc.).
• Troubleshooting networks.

Working at NAL:

Our new and expansive office space is located in the Bostwick area at Wonderland & Bradley. This space has allowed us to create a unique and rewarding work experience, including the following:

• A private sport court for pickleball, basketball, and more
• On-site games & entertainment spaces
• Several break areas, including an outdoor patio
• Corporate subsidized gym membership at Damian Warner Fitness Centre, located next to us
• Team lunches & events
• Reimbursement for continuing education, where applicable
• Open collaboration between all departments and levels of management

About NAL:

NAL Insurance Inc is the leading provider of WSIB-Alternative disability coverage for Owner Operator truck drivers in Canada. We operate in a niche area of insurance, but we have a big impact in the community and transportation industry.

Named one of the 2024 Best Places to Work in London and the proud recipient of the 2022 London Chamber of Commerce Business Achievement Award in Corporate & Social Responsibility, NAL has given back by raising over $400,000 for the Make A Wish Foundation of SWO, provided over $20,000 in meals and rewards to Canadian Truck Drivers, and so much more.

We value our team, our clients, our community, and our industry, and we believe we have built one of the best teams in London. We'd love to have you join us!

Pay: $60,000.00-$70,000.00 per year

Benefits:

• Company events
• Dental care
• Employee assistance program
• Extended health care
• On-site parking
• Paid time off
• Vision care
• Wellness program

Ability to commute/relocate:

• London, ON N6L 1A6: reliably commute or plan to relocate before starting work (required)

Application question(s):

• Are you able to work full-time in-office? This is not a remote position.
• Why are you interested in this role?
• What do you feel makes you the right fit for this role?

Education:

• DCS / DEC (required)

Experience:

• Angular: 1 year (preferred)
• MS Exchange and MS SQL Server: 1 year (preferred)
• Network support: 2 years (preferred)

Location:

• London, ON N6L 1A6 (required)

Work Location: In person