dba ( ms sql only), Toronto

posted
contact
randstad canada
job type
temporary
apply now

job details

posted
location
toronto, ontario
sector
technologies
job type
temporary
reference number
2145271PROEN
contact
randstad canada
apply now

job description

Our client, a leader in the education industry, is looking to hire a Database Administrator who has strong experience Ms SQL databases.

The database administrator (DBA) will be responsible for the direction, future planning, design & continuous operation of the Enterprise database services . Responsibilities include, but are not limited to:

o Planning the design, build, configuration, maintenance, capacity planning & security of the Enterprise database services, middleware & third party applications;

o Leading the implementation of application releases through the different environments;

o Integration of data with applications & services

o Leading problem analysis & resolution regarding critical incidents & daily support operations such as unexpected outages, database contention, security modifications & back-up or disaster recovery procedures

KEY DUTIES :

1 - Responsible for the architecture design, future planning, implementation &/or use of database & middleware applications to ensure that any changes to these environments provides optimum performance, reliability & security: ( - 50% of time spent on these following duties)

o Engage functional areas of the organization, including management, to ensure that identified changes to existing and/or new functionality meet the business needs of the affected parties & that any & all risks are identified, understood by those parties and mitigated/reduced;

o Accountable for MS SQL database architecture & security design, provisioning testing, training, development, QA, & production environments; including database & application software installation, quarterly release management, configuration, performance tuning & facilitation of end-to-end testing to ensure target service levels are met;

o The incumbent will be required to support & manage databases & middleware applications within a physical, virtual & clustered environment spanning multiple databases & applications tiers

2 - Consult & advise with business analysts, clients and management in defining business requirements and identifying opportunities to improve efficiency and effectiveness of existing processes for database and middleware applications. Document and recommend best (effective & efficient) options to support business requirements, identify impacts, risks and mitigation strategies of systems, business & security changes: ( - 20% of time)

o Provide key advice and recommendations on the establishment of accepted service levels with client departments / management & be accountable for system performance to meet those levels;

o Proactively analyze systems, logs, exception reports and make recommendations to improve database performance and operations; Lead cross functional / department teams on enterprise projects to improve the affected applications and related business processes. Provides direction and feedback to the project team in terms of project goals, deliverables, timelines and quality of work. Responsible for providing performance
feedback to managers of the project team members.

o Research & assimilate industry standard guidelines & best practices for database & applications management, security & integration into the policies; Provide innovative solutions and recommendations to college management to business opportunities though application of best practices, industry guidance, fiscal awareness and institutional policies and direction.

3 - Responsible for incident management and problem resolution & input on resource planning: ( 15% of time)

o Incident management and problem resolution will include leading a cross functional team, resource allocation & coordination, requests receipt, monitoring of resolution progress, provision of status updates to groups as appropriate, determining root cause & ultimately validation of implemented solutions;

o Provide recommendations to the capacity planning of servers, storage & network environments in order to ensure that resource requirements are addressed in advance of actual requirements for implementation on a timely basis. These recommendations are always accepted.

o Upgrade technical skills to keep abreast of trends and changes.

o Provide feedback and recommendations to college management where inappropriate of misuse of the system by staff, faculty and/or student.

4 - Review security & access control settings & configuration: ( 15% of time)

o Ensure that settings & configurations meet College, provincial & federal security & privacy policy requirements as well as client needs

o Ensure that auditing and controls are in place to ensure that appropriate access has not been modified or changed beyond accepted policy and provide feedback to the appropriate management and/security personnel in incident and/or performance

SKILLS NEEDED:
o Degree in Computer Science/ Management Science or equivalent training & experience
o MS SQL Certification ( preferred)
o RedHat Certification (preferred)
o Leadership training (nice to have)

- 7 years I/T experience administering MS SQL databases

Specific technical proficiency required in:
o MS- SQL MySQL & their associated applications;

o Management of large systems which includes clustering & load balanced applications;

o RedHat & Windows Server operating systems including command-line tools, configuration management, monitoring & back-up technologies;

o Future proof approach to infrastructure and capacity planning, product acquisition & maintenance;

o Understanding of the strengths & weaknesses of the IT environment, components & operations;

o Data modelling & database development methodology & techniques, programming ( SQL , T-SQL)

o Superior written & communication skills of both technical & non-technical nature including: client consultation, interviewing, consensus building,
facilitation, negotiation,

o Leadership, team building, work supervision, feedback;

o Superior active listening skills;

o Problem-solving & root cause analysis skills;

o Ability to influence others to move towards a common goal;

o Project management methodologies & best
practices;

o Configuration & change management skills;

o Knowledge of contents & intent of Service Level Agreements;

o Investigation, resolution & follow-up skills for issues in technical environments with associated

Randstad Professionals Canada
Randstad Canada is committed to building a diverse workforce reflective of the diversity of Canada. As a result, we promote employment equity and encourage candidates, especially those who identify as a woman, an Aboriginal person, a person with a disability or a member of a visible minority group, and any others who may contribute to the diversification of our workforce, to apply.

Randstad Canada is also committed to developing an inclusive, barrier-free selection processes and work environments.If contacted in relation to a job opportunity, you should advise your Randstad Representative or your local Randstad branch in a timely fashion of the accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner.Information received relating to accommodation measures will be addressed confidentially.

For all feedback on equity and accommodation needs, please contact your local Randstad Canada Branch.