Rq06249 - Database Administrator - Intermedia

1 week ago

Toronto, Canada Deop Inc. Full time

**Job Title: RQ06249 - Database Administrator - Intermediate**

**Location : Hybrid/315 Front St, Toronto**

**Client: Community Services Cluster /**
**Ministry of Education**

**Estimated Start Date:2024-06-10**

**Estimated End Date: 2025-03-31**

**#Business Days: 240.00**

**Hours per day or Week: 7.25 hours per day**
**Security Level: No Clearance Required**
**Closing Date/Time : 2024-06-04, 1:00 p.m.**
- **Updated Resume in word format (mandatory)**_
- **Expected hourly rate (mandatory)**_

MUST HAVES:

- Experience with one or more database technologies
- Experience designing data architecture for new databases
- Experience in monitoring and enforcing database rules
- Experience in developing documentation on data standardization and requirements

Description

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.

General Skills
- Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal skills and teamwork skills
- Outstanding consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
- Adept at communicating to both technical and non-technical audiences
- Experience with a range of analytical methods, techniques and tools such as, but not limited to: statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing, and other related disciplines at the specified experience level
- Ability to manipulate and analyze complex, high-volume data from structured and unstructured sources
- Experience developing data extraction, transformation, and load functionality for large relational and multi-dimensional data stores
- Experience designing high quality interfaces to present information in a meaningful way to end users
- Broad understanding of data management, financial and business analysis, database architecture, and information visualization
- Proficiency in query languages and experience constructing complex query statements
- Experience in one or more programming or scripting languages
- Strong investigative and logic skills. Proficiency in mathematics and statistics
- Awareness of emerging Business Intelligence trends and directions
- Experience with analytical software such as R,
- Proficiency with desktop analysis software including Microsoft Excel, Access, VBA, Power BI

The general scope of work for the Database Administrator involves:

- Assisting 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
- Supporting Power BI visualization and report building
- Develop and test any automated data validation tools deemed necessary

**Experience and Skill Set Requirements**

**Database Skills**:

- 70%
- 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 with dimensional data models
- Subject matter expert in database design of data warehouse or data marts.

**Communication Skills - 25%**
- 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 effe

  • Rq06249 - Database Administrator - Intermedia

    2 weeks ago

    Toronto, Ontario, Canada Deop Inc. Full time

    Job Title: RQ Database Administrator - IntermediateLocation : Hybrid/315 Front St, TorontoClient: Community Services Cluster /Ministry of EducationEstimated Start Date: Estimated End Date: #Business Days: 240.00Hours per day or Week: 7.25 hours per daySecurity Level: No Clearance RequiredClosing Date/Time : , 1:00 p.m.- Updated Resume in word format...

  • RQ06249 Database Administrator

    4 weeks ago

    Toronto, Canada Randstad Canada Full time

    This is a contract position for a Database Administrator - Intermediate for our public sector client.Work location: 777 Bay Street, TorontoDuration: Nine Months7.25 hours/dayThis 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...

  • RQ06249 Database Administrator

    2 weeks ago

    Toronto, Ontario, Canada Randstad Canada Full time

    This is a contract position for a Database Administrator - Intermediate for our public sector client.Work location: 777 Bay Street, TorontoDuration: Nine Months7.25 hours/dayThis 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...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Red Label Vacations Full time

    **Reports to**:Director, IT **Department**:IT **Location**:Hybrid**: - **Head Office, Toronto, ON/ Canada & work from home **Summary**: As DBA you'll be the first respondent to database problems that arise and carry out periodic maintenance and troubleshooting. To ensure success as a database administrator, you should be an excellent problem-solver and...

  • Database Administrator

    3 weeks ago

    Toronto, Canada Rang Healthcare Full time

    Job Title: Database Administrator Duration: 04 Month Contract Location: 125 Sir William Hearst, Toronto, ON M3M 0B5 (Position is 3 days onsite in a week) Must haves: Expert Database administration experience, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database Experience with database development, e.g., stored procedure, PL/SQL,...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Infotek Consulting Services Full time

    Support on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade: - Participate in the review of project and maintenance release artefacts - Use Case, System Requirement Specification, etc.; - Prepare and implement database changes according to design; - Promote database changes through Development,...

  • Database Administrator

    2 weeks ago

    Toronto, Ontario, Canada Infotek Consulting Services Full time

    Support on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade:Participate in the review of project and maintenance release artefacts Use Case, System Requirement Specification, etc.; Prepare and implement database changes according to design; Promote database changes through Development, Integration Testing,...

  • Database Administrator

    4 weeks ago

    Toronto, Canada iPartner Staffing Full time

    Role: Database Administrator - Senior Location: Toronto, ON Contract **Must-haves**: - More than 10 yrs Oracle DBA experience - Approved experience of Oracle 12c AND 19c using multi-tenant architecture - Oracle 12c and 19c RAC - Grid infrastructure/ASM - RMAN backup and Restore - Data Encryption using ASO/TDE - Oracle Dataguard Physical/Logical...

  • Database Administrator

    1 week ago

    Toronto, Canada Raise Full time

    Database Administrator Location: Toronto, ON- Hybrid – (2-3 days in office)Contract Length: 6 Months with possibility of extension.We at Raise are hiring a Database Administrator for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their team to meet rising demand.We’re hiring right now; if you’re...

  • Database Administrator

    5 days ago

    Toronto, Canada Raise Full time

    Database Administrator Location: Toronto, ON- Hybrid – (2-3 days in office)Contract Length: 6 Months with possibility of extension.We at Raise are hiring a Database Administrator for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their team to meet rising demand.We’re hiring right now; if you’re...

  • Database Administrator

    4 weeks ago

    Toronto, Canada AGCO Full time

    **Term**: Permanent, Full-Time **Division/Branch**: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch **Application Deadline**: May 24, 2024 **Level**: Level 10 **Salary Range**: Min: $92,902 to Max: $116,123 **Work Location**: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario...

  • Database Administrator

    2 weeks ago

    Toronto, Canada Sunwing Travel Group Full time

    **Join us in making vacation dreams come true** **!** Are you searching for a fun, passionate, travel loving team? -Sunwing has the EPIC work culture you have been searching for. We are currently looking for a **Database Administrator** to join us in making vacation dreams come true. As the Database Administrator, you are responsible for the installation,...

  • Database Administrator

    2 weeks ago

    Toronto, Ontario, Canada IBI Group Full time

    Company DescriptionWe are a global architecture, engineering, planning, and technology firm defining the cities of tomorrow.By connecting design and technology, we change how people experience their built environment. We work across disciplines to create the intelligent systems, sustainable buildings, and efficient infrastructure that shapes the way people...

  • Database Administrator

    2 weeks ago

    Toronto, Canada Raise Full time

    Database Administrator (Financial Industry) Location: Toronto, ON- Hybrid – ( In office every Tuesday for the time being) Contract Length: 6 Months with possibility of extension. We at Raise are hiring a Database Administrator (Financial Industry) for one of our top clients. After establishing th

  • Database Administrator

    5 days ago

    Toronto, Canada Raise Full time

    Database Administrator Location: Toronto, ON- Hybrid – (2-3 days in office) Contract Length: 6 Months with possibility of extension. We at Raise are hiring a Database Administrator for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their team t

  • Database Administrator

    3 days ago

    Toronto, Canada Rogers Communications Full time

     Our Technology team wakes up every day with one goal in mind - connecting Canadians to the people and things that matter most. Together, we are proud to support 30 million Canadians each month through managing a robust portfolio that champions leading-edge technology. We drive large-scale, complex, and high-visibility technology projects and programs that...

  • Database Administrator

    2 weeks ago

    Toronto, Ontario, Canada Momentum Financial Services Group_new Full time

    Job DescriptionThis is an excellent opportunity for a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features, Qlik, and Azure Data Factory (ADF) to join a dynamic team and contribute to the success of our cloud-based data initiatives. If you meet the above qualifications and are passionate about database...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Momentum Financial Services Group Full time

    Job DescriptionThis is an excellent opportunity for a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features, Qlik, and Azure Data Factory (ADF) to join a dynamic team and contribute to the success of our cloud-based data initiatives. If you meet the above qualifications and are passionate about database...

  • Database Administrator

    5 days ago

    Toronto, Canada Cloudvital Technologies Full time

    We are hiring Mainframe DB2 for one of the fast growing dynamic company Job Title: Database Administrator Job Location: Montreal **Job Type**: Hybrid - **This is a Hybrid role with 3 days in office and 2 days remote **_ **Required skills**: - Extensive hands-on experience in the use of z/OS and related software packages and tools - Extensive experience...

  • Database Administrator

    2 weeks ago

    Toronto, Ontario, Canada The Mabin School Full time

    Database Administrator / IT HelpdeskDuration: 20 hrs / week over 3-4 days / weekLocation: Toronto, ONPlease note this is a hybrid role. About The Mabin School:The Mabin School is a small, co-educational JK to Grade 6 progressive school with a strong commitment to inquiry, integration, and reflection. We are Canada's first independent Ashoka Changemaker...