Systems Analyst - Morinville, Canada - Sturgeon County
Description
This position is responsible for support, design, development, implementation, integrity, security, and administration of all corporate business solutions and databases.
Specializing in coordinating the integration of corporate business systems, troubleshooting advanced database issues, and providing technical support to the Information Services department team.
KEY DUTIES AND RESPONSIBILITIES
Corporate Business Solutions Planning and Development (25%)
Establishes business solutions roadmaps to suit the overall strategy of Information Services (IS) and corporate needs.
Corporate Database Administration & Support (15%)
Completes database administration includes backups, restores, data availability and accessibility using standard Open Database Connectivity (ODBC), and security on Microsoft SQL Server platform.
Integration of Corporate Business Systems Support (20%)
Manages and monitors all system integrations and works with vendors to ensure optimal performance and reliability.
Creates scripts and programs to convert, extract, and integrate Microsoft SQL server database data from multiple servers in a complex network environment.
Evaluates and develops system workflows, and processes to design solutions to automate manual tasks.
Other Related Duties (5%)
Completes other related duties/special projects as assigned by Manager, Information Services.
Adheres to applicable responsibilities and accountabilities as outlined in the Sturgeon County Health and Safety Management System.
KNOWLEDGE, EDUCATION, QUALIFICATIONS, SKILLS, ABILITIES, AND EXPERIENCE
Required:
Post-secondary degree from a recognized institution in computing science or information technology or computer programming.
Ability to work in a team environment and independently.
Strong organizational and time management skills, with the ability to set and manage among conflicting priorities while meeting deadlines.
Ability to communicate clearly and professionally verbally and in writing, including being adaptable, receptive, and timely when communicating with others, and possessing tact and discretion.
Proficiency with Microsoft Office products, including Microsoft PowerPlatform.
A minimum of 5 years of experience with the following are required (preference given to those with more experience):
Microsoft SQL Server
ASP.NET
Microsoft Power Platform
C#,
Microsoft IIS and
Microsoft Visual Studio
Assets/Preferences:
Knowledge of some or all of the following are beneficial to this position:
Microsoft SQL Server integration
Microsoft Great Plains 2018
PostGRE
MSSQL
Additional experience with some or all of the following are considered assets:
Diamond Municipal
Work Tech
Avanti
FMW
ESRI ArcGIS software
Gemini GPS software
HPTRIM software
More jobs from Sturgeon County
-
Operator Iii
Sturgeon County, Canada - 1 week ago
-
contracts officer
Morinville, Canada - 1 week ago
-
Neighbourhood Development Supervisor
Morinville, Canada - 4 days ago
-
Casual Clerk
Morinville, Canada - 3 days ago
-
economic development officer
Morinville, Canada - 1 week ago
-
Transportation Projects Officer
Sturgeon County, Canada - 4 days ago