We are currently recruiting a Database & Sharepoint Administrator
Competition #: FY1718-202
Date Posted: February 2, 2018
Date Closed: Until Filled
Portfolio: Finance and Corporate Services
Department: Information Management & Information Technology
Team: Information Management
Reports to: Manager, Information Management
Category: Permanent Full-time
Current primary assigned location: 401 The West Mall, Etobicoke
Reporting to the Manager, Information Management, the DBA & SharePoint Administrator is responsible for the availability of the SQL Server databases and the SharePoint environments through maintenance, monitoring and upgrade to meet Service Level Agreements (SLAs). The DBA & SharePoint Administrator resolves technical problems, designs, develops and implements new databases, SharePoint functions and capabilities to meet business needs and to increase the value of the technology investment.
Key accountabilities of this position include:
Administers, maintains Microsoft SQL Server databases through replication, index maintenance, software upgrade, performing backup and recovery procedures
Monitors system performance and optimizes/tune stored procedures and indexes
Designs procedures for maintaining and refreshing data on a regular basis
Ensures data integrity by performing database maintenance functions and data audits
Oversees the SharePoint Portal Server infrastructure, user access and application deployment – taking the lead role in implementing SharePoint across Mississauga Halton Local Health Integration Network (MH LHIN)
Supports the installation, configuration, security, operation, and maintenance of all web portal servers, equipment, and software related to SharePoint infrastructure
Participates in planning and execution of tasks related to the evaluation of new SharePoint based initiatives (Upgraded Versions, Third-Party Solutions, Integration with additional Enterprise Systems)
Maintains and administers Microsoft SharePoint Portal Server, including daily monitoring, troubleshooting and performance analysis
University degree in mathematics, computer science, computer engineering or related information technology discipline (or equivalent combination of education and experience)
Two (2) to four (4) years’ experience directly related to Database Administration and Business Intelligence/Data Warehousing in an environment with multiple production databases; including one (1) to three (3) years’ experience working with SharePoint Platform in an administrative capacity
Development experience with Microsoft Visual Studio.NET, Microsoft SQL Server, InfoPath, Workflow, Visual SourceSafe, and SharePoint Designer
Detail oriented, good coding, troubleshooting, and debugging skills
Good understanding of Software Development Life Cycle methods
Knowledge of Active Directory and Windows-based server
Experience with SQL Server Reporting Services, SQL Server Integration Services, and SQL Server Analysis Services is preferred
Solid ability to use MS Office applications (e.g., Word, Excel, Outlook, PowerPoint, etc.)
Understanding and commitment to quality service and best practice
Flexible, adaptable and responsive to change
Knowledge of basic measurement, analytical and data warehousing techniques (i.e. data warehouse lifecycle, dimensional data modeling, data modeling, ETL design and development)
Ability to communicate in French or another language an asset
Thank-you for your interest in joining our exceptional team at the Mississauga Halton Local Health Integration Network (LHIN).
To apply for this vacancy please submit a resume with covering letter referencing FY1718-202 via the following link www.lhinjobs.ca or visit the Mississauga Halton LHIN Career Opportunity page at lhinjobs.ca Please note, only those candidates selected for an interview will be contacted.
Mississauga Halton LHIN is a respectful, caring and inclusive workplace, committed to Employment Equity. We welcome diversity in the workplace, and encourage applications from all qualified individuals including women, members of visible minorities, aboriginal persons, and persons with disabilities. We will provide accommodations throughout the recruitment and selection and/or assessment process to applicants with disabilities.
Applicants need to make their accommodation needs known when contacted.
To receive any Mississauga Halton LHIN document required by the Accessibility for Ontarians Disability Act (AODA) and its standards, or to receive any public document on our website in an alternate format, please contact our Communications Department at 905-855-9090 or 1-877-336-9090.