We are currently recruiting a Database & Sharepoint Administrator
Competition # FY1617-161
Date Posted: March 30, 2017
Date Closed: Until Filled
Start Date: Immediately
Reports to: Manager, Business Systems
Category: Permanet FT
Team: Business Systems
Primary assigned location: 401 The West Mall, Etobicoke
Reporting to the Manager, Business Systems, 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 Community Care Access Centre (MH CCAC)
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(with recent experience using MOSS 2007) 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 serve
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 Mississauga Halton Community Care Access Centre (CCAC)!
To apply for this vacancy please submit a resume with covering letter referencing FY1617-161 via the following link ccacjobs.ca or visit the Mississauga Halton CCAC Career Opportunity page at ccacjobs.ca.
Please note, only those candidates selected for an interview will be contacted.
Mississauga Halton CCAC 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 CCAC 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