Database and Sharepoint Administrator

September 14 2022
Industries Healthcare, social assistance
Categories Database Dev. & Admin., Information Technology
Mississauga, ON

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. 

DUTIES & RESPONSIBILITIES

Database Administration

  • Administers, maintains Microsoft SQL Server databases through replication, index maintenance, software upgrade, performing backup and recovery procedures to ensure system availability to meet Service Level Agreement (SLA)
  • Monitors, troubleshoots, isolates and optimizes database system performance to provide optimal system response time, meeting business needs to timely analyze and report on operational and management data
  • Ensures data integrity by developing, testing, implementing and performing database maintenance functions and data audits in collaboration with Decision Support, Business Systems and Client Services user groups.
  • Analyzes business requirements and designs database schemas, develops and implements stored procedures and triggers in collaboration with IM&T teams and user groups (i.e. client services), to enable Business Intelligence (BI) capability
  • Identifies needs, recommends, supports and facilitates DBA & SharePoint administration throughout the development lifecycle to deliver technical solutions that meet business requirements
  • Leads the deployment of database software to ensure optimal operation by working with project teams, IM&T teams and user groups (i.e. client services)
  • Researches, evaluates, proposes and implements new hardware and software as they are related to database administration, to ensure security of data, the reliability and performance of the applications
  • Provides and maintains documentation about database, data warehouse structures including database configuration, data models, data cleansing rules and data transformation rules
  • Designs, test and implements data cleansing rules, data transformation rules, using Software Development Life Cycle (SDLC) and/or Rapid Application Development (RAD) methodology in collaboration with project teams, Decision Support team, Business System team and user groups
  • Follows coding policies and standards as well as configuration management/version control policies in designing databases, data schemas to ensure software audit standards are met
  • Creates ad-hoc SQL queries, integrates large data files and databases from disparate systems, working with Decision Support and user groups to support the reporting needs of business groups including Home and Community Care Support Services management and the Ministry of Health and Long-term Care

SharePoint Administration

  • Manages the SharePoint Portal Server infrastructure, user access and application deployment – taking the lead role in implementing SharePoint across the organization
  • Provides guidance and supports the installation, configuration, security, operation, and maintenance of all web portal servers, equipment, and software related to SharePoint infrastructure
  • Leads 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
  • Researches, provides technical guidance to the team in the technologies related to the development and support of an Enterprise SharePoint environment
  • Develops, configures and maintains document libraries, enterprise lists and site collections following SDLC and/or RAD methodology to ensure software audit standards are met
  • Performs typical system administrative activities such as site creation, user training, backup, restore and issue resolution
  • Coordinates with other departments to standardize and optimize the way data/information is stored and retrieved, fulfilling SLA metrics
  • Collaborates with project managers, Business Analysts and developers to design and develop solutions to address business needs and opportunities, and propose changes that would make the SharePoint environment a more effective solution
  • Analyzes requirements documents to creates technical design documents, unit tests, system tests and implementation plans for small to complex projects

QUALIFICATIONS

Education, Training & Experience

  • 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
  • Experience with SQL Server Reporting Services, SQL Server Integration Services, and SQL Server Analysis Services is preferred
  • Good coding, troubleshooting, and debugging skills
  • Good understanding of SDLC methods
  • Excellent understanding of MS SharePoint Architecture (2013, SharePoint Online )
  • Solid understanding of relational database structures, theories, principles, and practices
  • Working knowledge of Microsoft SharePoint and SharePoint’s BI tools PerformancePoint Services and Excel Services
  • Working knowledge of database design, optimization and troubleshooting of Microsoft SQL 2016 or later
  • Knowledge of Active Directory and Windows-based server

Skills and Attributes

  • Adept in the use of 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
  • Good customer services skills
  • Knowledge of basic measurement, analytical and data warehousing techniques (i.e. data warehouse lifecycle, dimensional data modeling, data modeling, ETL design and development)
  • Detail-oriented

To apply for this vacancy please submit a resume with covering letter via email referencing competition number FY2122-224 – Database Administrator and Sharepoint Administrator in the email subject line to mh.careers@hccontario.ca

Home and Community Care Support Services values the health and safety of its employees and is committed to the prevention of COVID-19 exposure and transmission of infection to employees, patients, caregivers, volunteers, visitors and residents. As a requirement of Home and Community Care Support Services Mandatory COVID-19 Vaccination Policy, all employees must be considered fully vaccinated for COVID-19 (two doses of a two-dose series, or one dose of a single dose series).

Home and Community Care Support Services Mississauga Halton 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, Indigenous peoples, 2SLGBTQ+ 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 requirements known when contacted.

To receive any Home and Community Care Support Services Mississauga Halton 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-366-9090.

Apply now!

Jobs.ca network

#