RFS Number: 1227761-17
Client: Toronto Police Service
Position: SQL Server DBA
Anticipated Start Date: November 6, 2017
Anticipated End Date: November 5, 2018
Location: 40 College St., Toronto
Engagement Description
The engagement requires a resource with the requisite skills, background, experience and professional accreditation to backfill a SQL Server database administrator's position in the Operations Support Services, of the TPS Information Technology Service (ITS) unit.
Working Conditions
The location of the engagement will be at Toronto Police Headquarters, 40 College Street, Toronto, Ontario, M5G 2J3. Work day is 7 hours, Monday to Friday excluding statutory holidays; working hours will be determined at the start of the engagement but will be between the hours of 8 a.m. and 5 p.m. There may be an occasional need for overtime or work outside of regularly scheduled hours, due to tasks or project accommodations.
The SQL Server DBAs may also be required to participate in "on-call" support and must be willing to be "on-call" for after-hour technical support on a 3 week rotation.
All positions will be required to fill in a time sheet on a daily basis, indicating start and end time, time lunch hour taken and activities with associated time spent. Time Sheet must be authorized by assigned TPS Supervisor.
Senior Senior SQL Server Database Administrator
Specialist Role Name: Senior SQL Server Database Administrator
Number of Specialists: One (1)
Experience: Minimum of 10 years of current SQL Server DBA experience
Contract Term
The term of this contract is for a one year period commencing on or around November 6, 2017, pending security background checks. TPS reserves the right to renew the contract for an additional two (2) six month option periods if needed.
The TPS reserves the right to terminate the engagement with or without cause with 10 days' notice.
Responsibilities
Support database environments with extensive experience in developing and reviewing high availability designs, implementing database clustering in a Windows Server
environment, scaling/tuning databases, documenting database designs; assisting with testing and all other functions of a senior database administrator.
Statement of Work:
Description:
The contracted resource is required to fill an existing Senior SQL Server Database Administrator position, on a temporary basis for Operations Support Services of the Information Technology Services.
Key expectations of the resource are:
• Primary duties include implementing and maintaining backup and recovery procedures; maintaining data security, reliability and availability; capacity planning, usage monitoring and performance tuning.
• Implement SQL Server databases into all environments.
• Provide technical assessment of existing and new database software products including database engine and auxiliary software and makes recommendations for their use based on cost, suitability and performance requirements.
• Participate in system development activities providing technical recommendations to application development teams and users.
• Provide performance tuning recommendations and assistance to developers.
• Provide complex technical support for existing hardware and software products. Assess and recommend release levels and updates of database software and utilities, taking into account the impact on resource utilization and the support of existing products.
• Develop procedures and provides input to standards relating to technical aspects of database software.
• Develop, implement and document database related utilities and other standard activities.
• Participate in the short- and long-term planning processes related to hardware, software, capacity planning, and disaster recovery.
• Work with ITS (Information Technology Services) and security team to establish and maintain technical aspects of database security.
• Act as a liaison with ITS users and computer vendors to identify and resolve problems. . Provide information and analyses for forecasting purposes.
. Provide technical input to formal tenders and information proposals.
. Maintain high level of technical knowledge of trends and products.
• Train and educate ITS operations and technical staff, application personnel and user groups.
• Perform typical duties inherent to the job.
Objectives of the SQL Server Database Administrator:
The mandate of the Database Administration (DBA) team is to provide a robust, secure, recoverable, well-managed data environment in support of the TPS applications. That is, the DBA team aims to ensure the secure collection and storage of the organization's mission-critical data, to make the data available to corporate users in a secure environment, and to provide recovery or fail-over while maintaining full data integrity in case of disaster. The DBA team also strives to manage all databases and related systems utilizing the most current software and best practices to deliver these services to TPS.
The DBA team seeks to provide an environment in which the applications perform well, the data is accurate, and the data is recoverable in case of disaster. The team's goal is to ensure the database systems are issue-free, always available, and running at peak performance.
In addition, the Database Administrators manage and support a secondary site, where the databases used by critical applications are replicated for business continuity
Deliverables:
The contractor selected for this role will be responsible for a number of possible deliverables during the engagement; these include but are not limited to:
a) create, maintain, tune and proactively monitor Development, QA (Quality Assurance), Training, Staging, Production and Secondary database environments,
b) maintain current software release levels by planning and implementing upgrades,
c) provide consulting and education to ITS (Information Technology Services) developers on the use of new database functionality and features,
d) participate in project work as assigned,
e) engage in research and development,
f) provide day-to-day technical support, and
g) lead and participate in project initiatives.
Transfer of Knowledge:
This engagement requires the sharing and transfer of knowledge to ITS personnel, included but not limited to, training and coaching ITS team members.
Education, Training, Certifications or Designations Required:
Mandatory
• Bachelor Degree in Computer Science or related discipline.
or an equivalent combination of education, training and/or experience. • Microsoft Certified Database Administrator
Preferred
Working knowledge of IBM DB2, Oracle and/or Informix
Knowledge, Skills and Experience Required:
Mandatory
• Must possess a minimum of 10 years of current senior SQL Server database administration and support experience in complex production environments.
• Must have experience designing, implementing and supporting complex high availability and disaster recovery database environments.
Preferred
• Significant experience designing, building, tuning and supporting relational database environments in SQL Server.
• Significant experience designing, implementing and supporting high availability and disaster recovery environments using SQL Server mirroring, clustering, Geocluster, Always-on
• Effective troubleshooting and problem solving skills to aid in the identification of root cause issues and develop creative solutions.
• Strong SQL programming and tuning skills.
• Effective strong problem-solving skills, self-motivation, and demonstration of proactive work in the design and management of reliable and robust production systems.
Experience in the Microsoft Windows Server operating system.
Experience with working in a team environment.
Experience with working in a 7X24 environment.
Preferred
SQL Server2Ol2;
SQL Server2Ol6;
• SQL Server clustering;
• Windows Multi-Subnet Failover clustering;
• SQL Server always-on;
• SQL Server database security;
• SQL Server database tuning;
• SQL Server database health monitoring;
• SQL Server database backup and recovery using IBM TSM;
• Biz Talk as related to SQL Server;
• SharePoint as related to SQL Server;
• Microsoft System Center Operations Manager
Soft Skills Required:
• Strong verbal, reading comprehension and written communication skills • Self motivated in learning new technologies
• Customer relationship and time-management skills • Requirements and information gathering skills
• Collaboration and teambuilding skills
• Strong problem solving and analytical skills • Meeting facilitation and presentation skills
