Database Administrator/Technical Analyst

Legal Aid Ontario; Greater Toronto Area; Hybrid; CAD 98,000 - 115,000; Full time

Job summary

A leading organization is seeking a Database Administrator/Technical Analyst to manage and enhance Oracle and SQL databases. The role involves installation, administration, and migration of databases, along with mentoring team members. Candidates should possess a Computer Science degree and relevant experience in database management and system architecture. This is a contract position based in Toronto with flexible hybrid work options.

Qualifications

• 5 years experience with full system development cycle.
• 3-5 years experience with Oracle RDBMS, SQL, and PL/SQL.
• Experience with cloud migration of on-premises infrastructure.

Responsibilities

• Install, administrate, upgrade, and migrate Oracle and SQL databases.
• Develop operational procedures for database products.
• Lead analysis, design, development, and testing of databases.

Skills

Database Design

System Architecture

ETL

API Development

Data Warehousing

Technical Writing

Education

Computer Science or IT Degree

Tools

Oracle

SQL Server

Linux

Windows

MS Azure

Salesforce

Job description

Database Administrator/Technical Analyst

Join to apply for the Database Administrator/Technical Analyst role at Legal Aid Ontario

Database Administrator/Technical Analyst

Join to apply for the Database Administrator/Technical Analyst role at Legal Aid Ontario

Get AI-powered advice on this job and more exclusive features.

This range is provided by Legal Aid Ontario. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

CA$98,547.36/yr - CA$114,243.38/yr

Database Administrator/Technical Analyst (3 Years)

Job Number: J0425-1135

Job Type: Contract

Contract Duration (months): 3 years

Job Location: Toronto

Job Category: Information Technology

Role Designation: Flexible Hybrid - In person days can be flexible from week to week subject to manager approval and operational requirements.

Open Positions: 1

Closing Date: May 23, 2025

Building a diverse workforce that represents the communities we serve while promoting a safe culture and work environment that dismantles systemic barriers, welcomes fresh perspectives and embraces differences as a priority is a core value at LAO. LAO encourages applicants from equity-seeking groups, including but not limited to individuals who are First Nations, Inuit or Métis, Black and racialized, as well as persons with disabilities, women and members of the 2SLGBTQ+ community.

We recognize the value of equity, diversity and inclusion and are committed to addressing systemic barriers, and prioritizing, attracting and retaining diverse staff. All interested and eligible people will be considered, with due consideration to all protected grounds under the Ontario Human Rights Code.

Legal Aid Ontario values integrity, respect, responsiveness, excellence, independence, accountability, openness and consistency. Our recruitment process reflects our commitment to equity, diversity and inclusion. Accommodations are available throughout the recruitment process as well as during employment at LAO. Please direct any accommodation requests to our recruitment team.

Primary Function

In this role, the Database Administrator/Technical Analyst will be required to install, administrate, upgrade, enhance, and migrate Oracle and other SQL databases used at LAO. This work includes analysis, design, development, configuration, deployment, and testing of databases to support CRM Replacement Project. Other key responsibilities include system architecture, security, backup/recovery management, migration planning/execution, ETL, APIs, data warehousing, environment setups, and deployment. Additionally, provide mentoring to other members of the team specific to sharing expert knowledge as outlined in this job description.

Secondary Location: n/a

Reports to: Manager, Technical Delivery and System Design, CRM Replacement Project

Key Accountabilities

• Creation of logical and physical database designs, Oracle database server tuning , application, along with OLTP and OLAP optimization.

• Develop and implement operational procedures associated with the Oracle and SQL Server database products, which includes backup, recovery, standby databases, integrity, security and performance monitoring, along with remediation.

• Install, design and configure all Oracle and SQL Server databases and execute planned upgrades and patches. Develop data migration and conversion scripts, along with developing data migration and conversion test scripts.

• Guide system development staff (technical and non-technical) in all issues related to the Oracle and SQL Server database product components. This will include performing DBA tasks specific to Microsoft platform systems, Linux/Unix platforms, SQL Server XML systems, PeopleSoft packages, along with other n-Tier systems.

• Participate in the systems release management procedures, along with providing system architecture recommendations, as it pertains to database technologies. This would include Oracle analysis for various package upgrades, along with fresh installations on the platforms discussed in this position description.

• Lead the analysis, design, development, configuration, deployment, and testing of various CRM replacement project related databases; this involves leading system architecture, object modeling, security, data preparation, migration, API, performance, environment setup, deployment, and testing

• Provide mentoring to other members of the team specific to sharing expert knowledge as outlined in this job description

• Support business analysts and other stakeholders with ad-hoc data requests to perform data-driven analysis and decision-making.

• Flexible to other responsibilities within role.

Required Skills & Experience

• Computer Science or IT degree and relevant work experience

• 5 years experience with the full system development cycle, which includes system architecture design, database design, object modeling, system programming, security, backup/recovery management, ETL scripting, API design/development, data preparation, migration planning/execution, data warehousing design/implementation, environment configuration, code deployment, and testing

• 3-5 years experience with Oracle RDBMS, SQL, and PL/SQL

• 3 years experience in the designing and development of APIs

• 3 years experience in designing, developing, and executing data preparation and migration

• Experience with cloud migration of on-premises infrastructure and application

• Experience solutioning and configuring backend workflows in one or more CRM, and cloud platforms such as Salesforce, MS Dynamics 365, MS Azure

• Strong working knowledge of the Linux/Unix/Windows operating environment.

• Excellent communication and technical writing skills.

Asset:

• Experience designing, implementing, and configuring one or more data warehousing solutions such as MS Azure Synapse Analytics, Data bricks, Snowflake is an asset

• Experience with DevOps processes such as continuous integration and continuous deployment (CI/CD) is an asset

Final candidates for this position will be required to undergo a criminal record check.

Only those candidates selected for an interview will be notified by email.

This position is collectively represented by the Ontario Public Service Employees Union (OPSEU) and the successful incumbent will be governed by the provisions of a collective agreement and subject to union dues.

Please note that all applicants are encouraged to provide a valid email address for communication purposes. Applicants may receive written correspondence regarding this job posting directly to the email address provided on their resume or to the one used to set up their Candidate Profile if applying on Njoyn. As an applicant, it is your responsibility to ensure that you check your email regularly.

First time applying to LAO? You will need to create a profile AND then apply for the position.

Already have an Njoyn account? Just sign in and select "my jobs" to apply.

Once you have successfully applied you will receive a confirmation email.

Trouble applying? For telephone support please call 1-877-427-7717 or email support: [e-mail]

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Analyst, Information Technology, and Quality Assurance

• Industries

  Legal Services and Community Services

Referrals increase your chances of interviewing at Legal Aid Ontario by 2x

Sign in to set job alerts for “Database Administrator” roles.

SQL Server Database Administrator Specialist

Richmond Hill, Ontario, Canada 2 weeks ago

Mississauga, Ontario, Canada $120,000.00-$130,000.00 3 weeks ago

RQ04205 - Database Administrator - Senior

Junior Application and Database Developer

Richmond Hill, Ontario, Canada 1 week ago

Markham, Ontario, Canada CA$140,000.00-CA$150,000.00 1 day ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.