RQ06249 Database Administrator

4 weeks ago

North York, Canada Randstad Canada Remote Work Freelance Full time
This is a contract position for a Database Administrator - Intermediate for our public sector client.
Work location: 777 Bay Street, Toronto
Duration: Nine 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
- Lead the development and delivery of functional and ministry-specific analytics to support evidence-based decision-making and produce actionable insights.
- Work closely with client groups to assess current data analytics and reporting capabilities, gather future-state requirements and identify further opportunities for improvement.
- Facilitate decision-making and manage client expectations.
- Own the execution of analytics initiatives including end-to-end reporting and data set delivery. Participate in documentation, development, testing.
- Work with functional area experts, Data Architects and ETL Developers and stakeholders to understand complex business issues and develop appropriate Business Intelligence solutions.
- Design methods to capture, structure, transform and process data to be used to generate models.
- Build data models that provide information which is accurate, easy to understand and unbiased.
- Communicate complex quantitative analysis in a clear and precise manner, providing useful visuals and summaries.
- Provide interpretation, advice, and expertise to client groups and other stakeholders, including direction on how to transform analytics into actionable information and proactive insights that support decision making.
- Assist with the transformation/cleaning of data from a legacy database into a new data warehouse
- Determine appropriate data structure for remaining relevant legacy data
- Develop mapping and transformation rules to align the two databases
- Create data dictionary for new data
- Develop connections with multiple other government databases and develop system to maintain the connection so that it does not go out of date
- Support Power BI visualization and report building
- Develop and test any automated data validation tools deemed necessary

Qualifications
- Experience with one or more database technologies
- Proficiency with SQL and experience writing SQL scripts
- Experience designing data architecture for new databases
- Experience in monitoring and enforcing database rules
- Experience cleaning, transforming and joining data
- Experience is creating and applying data standards
- Experience with dimensional data models
- Subject matter expert in database design of data warehouse or data marts.
- Experience in developing documentation on data standardization and requirements
- Demonstrated consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
- Previous public sector experience in an organization of equivalent size and complexity to the Ontario Public Service.

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.

  • Database Administrator

    2 weeks ago

    North York, Canada ThoughtStorm Inc Full time

    Must Have: Expert Database administration experience in IMS/DB2/PL1/COBOL Assembler Or Oracle, Microsoft Azure and PL SQL database, and Synapse database Database Administrator Description **The Data Management Office (DMO) is seeking to hire two (2) Mainframe Database Administrator to deliver**: - Support on preparation, installation, configuration...

  • Administrator, Database

    3 weeks ago

    North York, Canada Vertex Financial Consulting Inc. Full time

    Education: Bachelor's degree - Experience: 3 years to less than 5 years **Tasks**: - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Research and document...

  • Database Administrator

    2 months ago

    North York, Canada Ministry of Health Full time

    The Health Services I&IT Cluster, Emergency Health I&IT Solutions & Technology Management Branch is seeking a Database Administrator to provide strategic data resource management. **OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism**: We are committed to build a workforce that reflects the communities we serve and to promote a diverse,...

  • Database Administrator

    3 weeks ago

    North York, Canada Ministry of Children, Community and Social Services Full time

    Make the most of your expertise in data management techniques and technologies! Join the Children, Youth and Social Services I&IT Cluster as a Database Administrator. **Why work for the Ontario Public Service?** The Ontario Public Service (OPS) offers a competitive compensation package. We support career and leadership development, invest in learning...

  • Database Administrator

    2 months ago

    North York, Canada Extend Financial Ltd. Full time

    Durée de l'emploi: Permanent - Langue de travail: Anglais - Heures de travail: 40 hours per week - Education: - Expérience: **Education**: - Bachelor's degree **Work setting**: - Private company, corporation or industry **Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Develop and implement a...

  • Database Analyst

    4 weeks ago

    North York, Canada Ostim Ltd. Full time

    We are seeking a skilled Database Analyst to join our team. Duties: - Develop and maintain computer databases - Document customers requirements for projects - Setup the IT infrastructure to allow applications to access databases - Design and develop the database - Operate database management systems to analyze data - Develop and implement data administration...

  • Database Analyst

    3 weeks ago

    North York, Canada Ostim Ltd. Full time

    We are seeking a skilled Database Analyst to join our team. Duties: - Develop and maintain computer databases - Document customers requirements for projects - Setup the IT infrastructure to allow applications to access databases - Design and develop the database - Operate database management systems to analyze data - Develop and implement data administration...

  • Database Analyst

    3 weeks ago

    North York, Canada Ostim Ltd. Full time

    We are seeking a skilled Database Analyst to join our team. Duties: - Develop and maintain computer databases - Document customers requirements for projects - Setup the IT infrastructure to allow applications to access databases - Design and develop the database - Operate database management systems to analyze data - Develop and implement data administration...

  • Analyst, Database

    4 weeks ago

    North York, Canada OSTIM LTD. Full time

    Education: - Expérience: **Education**: - Bachelor's degree **Work setting**: - Construction - Construction industry **Tasks**: - Develop and maintain computer databases - Document customers' requirements for projects - Design and develop database - Operate database management systems to analyze data - Develop and implement data administration policy,...

  • Analyst, Database

    2 days ago

    North York, Canada OSTIM LTD. Full time

    Education: - Expérience: **Education**: - Bachelor's degree **Work setting**: - Construction - Construction industry **Tasks**: - Develop and maintain computer databases - Document customers' requirements for projects - Design and develop database - Operate database management systems to analyze data - Develop and implement data administration policy,...

  • Database Analyst

    4 weeks ago

    North York, Canada Vyoma Global Inc. Full time

    Work Term: Permanent - Work Language: English - Hours: 32 hours per week - Education: College/CEGEP - Experience: 1 year to less than 2 years - or equivalent experience **Work setting**: - Consulting firm **Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Data Science - Develop and implement a strategic...

  • Database Analyst

    3 hours ago

    North York, Canada Vyoma Global Inc. Full time

    Work Term: Permanent - Work Language: English - Hours: 32 hours per week - Education: College/CEGEP - Experience: 1 year to less than 2 years - or equivalent experience **Work setting**: - Consulting firm **Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Data Science - Develop and implement a strategic...

  • Database Analyst

    2 months ago

    North York, Canada Harisan Technology Inc. Full time

    Education: College/CEGEP - Experience: 1 year to less than 2 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards...

  • Database Analyst

    2 days ago

    North York, Canada Harisan Technology Inc. Full time

    Education: College/CEGEP - Experience: 1 year to less than 2 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards...

  • Database Analyst

    2 weeks ago

    North York, Canada Harisan Technology Inc. Full time

    Education: College/CEGEP - Experience: 1 year to less than 2 years - Information technology - Computer science **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and...

  • Database Administrator

    2 months ago

    North Vancouver, Canada District of North Vancouver Full time

    **Job Status** - Temporary Full-Time**About Us** - Home to vast parkland and attractions including Grouse Mountain, Lynn Canyon and Capilano Suspension Bridge, the District of North Vancouver is inspired by nature, and enriched by people. Designated one of BC’s Top Employers for five years, the District offers exciting professional development...

  • Analyst, Database

    4 weeks ago

    North York, Canada Ontario Association of Architects Full time

    Work Term: Permanent - Work Language: English - Hours: 35 hours per week - Education: Bachelor's degree - Experience: 3 years to less than 5 years **Work setting**: - Associations and non profit organizations **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement and test...

  • Database Analyst

    3 weeks ago

    North York, Canada SunCan Communications Corporation Full time

    Work Term: Permanent - Work Language: English - Hours: 40 hours per week - Education: Bachelor's degree - Experience: 2 years to less than 3 years **Work setting**: - Consulting firm - Server farm **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement and test data models...

  • Database Analyst

    4 weeks ago

    North York, Canada SunCan Communications Corporation Full time

    Work Term: Permanent - Work Language: English - Hours: 35 hours per week - Education: Bachelor's degree - Experience: 3 years to less than 5 years **Work setting**: - Consulting firm - Information technology (IT) service provider **Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Develop and maintain...

  • Database Administrator/analyst

    2 months ago

    North Vancouver, Canada District of North Vancouver Full time

    **Database Administrator/Analyst**: **3 Year Temporary Full-Time** Home to vast parkland and attractions including Grouse Mountain, Lynn Canyon and Capilano Suspension Bridge, the District of North Vancouver is inspired by nature, and enriched by people. Designated one of **BC’s Top Employers **for 4 years, the District offers exciting professional...