RQ07594 Database Administrator Senior

This is a contract position for a Database Administrator - Senior for our public sector client.

Work location : 21 College Street, Toronto

Duration : Three Months

7.25 hours / day

This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)

Advantages

Good compensation working on projects that will make a difference to the people of Ontario.

Responsibilities

• Creation of technical specifications for Azure, SQL and Oracle database systems development
• Design, implement and work with the project team in completing all relevant and required documentation in alignment with OPS standards
• Undertake special assignments / sub-projects as assigned
• Conduct, assess, evaluate and document stakeholder interests and business needs
• Create and validate business scenarios and use cases
• Produce visual depiction of use cases and process flows; ensure alignment with the program area and associated business architecture, as well as traceability to solution logical and physical architectures
• Create, review, provide input and support of Enterprise Architecture artifacts for all checkpoints as required
• Create system and user interface design and modifications (data & screen) as required
• Review all test scenarios to ensure the requirements are met; establish traceability matrix to monitor output
• Ensure alignment and adherence to Ministry of Government Services’ processes and standards
• Support the testing team during system and UAT testing
• Participate in Knowledge transfer

Qualifications

• Experience administering database management systems (i.e. ORACLE, Exadata, Microsoft SQL Server, Azure etc.) for business intelligence and analytics applications
• Create, test and implement safeguards to maintain data integrity and protect against unauthorized access
• Assist with SQL optimization and code reviews to ensure queries are efficient
• At least 10 years of experience
• Experience in database replication / Real-Time data delivery with either MSSQL or Oracle products (5+ years)
• Oracle Exadata, Golden Gate, MSSQL, Azure SQL technical knowledge and experience.
• Demonstrated experience in modifying database structures using information provided by application developers
• Demonstrated experience with monitoring, optimizing and performance tuning using either manual or automated tools
• Able to develop and interpret highly complex SQL to support queries and provide feedback for developers.
• Research, and evaluation of complex design options.
• Superior ability to identify root cause of complex environmental or underlying database specific issues.
• Determining areas of risk and recommending innovative alternatives and options for resolution to meet program needs.
• Demonstrated experience working within a team environment to troubleshoot and resolve technical problems.
• Demonstrated writing and negotiation
• Oral and written communication skills, Interpersonal and consultative skills,
• Experience preparing operational documentation (build guides, procedures, etc)

Summary

If interested and qualified for this role, please apply today for immediate consideration!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees.

In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary / gender non-conforming;

Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle.

We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.

ca to ensure their ability to fully participate in the interview process.