dba (oracle and ms sql), Toronto

randstad canada
job type
apply now

job details

toronto, ontario
job type
reference number
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 with Oracle and 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 Architecting and 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


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 Oracle 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

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

- 7 years I/T experience administering Oracle and MS SQL databases

Specific technical proficiency required in:
o Oracle, 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 (PL/SQL & 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

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.