Database Administrator/Technical Analyst

Responsibilities:

• 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 the role.

Skills:

• 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 solution architecture diagraming skills
• Excellent communication and technical writing skills.

Benefits:

• 💻 Flexible Hybrid Work Arrangement
• 🌈 Commitment to Diversity and Inclusion
• 📈 Career Development Opportunities
• 🌍 Worldwide Remote Work

Qualifications:

• 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

Company Overview:

Legal Aid Ontario employees are committed to making a difference in the lives of our clients. As an integral partner in the Justice system, working at Legal Aid Ontario is more than just a job. It's an opportunity to help people who need it the most; to ensure each client receives the access to justice afforded to them under the law.

If you are looking for a new challenge in your already meaningful career with a team dedicated to justice, and innovation in a flexible and supportive work environment consider this opportunity below.

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.