Position Summary:

Under the direction of the It Operations Manager, this position is responsible for maintaining and ensuring all database systems and services are operate in accordance with functional design specifications through systematic and defined activities and processes while contributing to a safe and welcoming work environment for all employees. Ensures adherence to all policies and procedures.

Key Accountabilities:

Database Design, Development & Optimization

• Designs, optimizes, and maintains databases for efficient data storage and retrieval.
• Manage data warehouses or data lakes to ensure accessibility and reliability of data.
• MS SQL production database level performance tuning.
• Participate in SQL code-reviews for the application teams or vendors to enforce SQL coding standards.
• Create ETL (Extract, Transform, Load) processes and data ingestion pipelines to clean, transform, and prepare data for analysis.
• Assist in technical analysis and design for current and future projects.
• Maintain the highest levels of development practices including technical design, solution development, systems configuration, test documentation/execution, issue identification and resolution, clean writing, modular, and self-sustaining code.

Operations, Maintenance & Support

• Responsible for day-to-day activities regarding the upkeep and availability of all database servers in the environment including lower environments.
• Troubleshoot and resolve issues related to databases and data processing and be on call after hours for any escalated issues.
• Responsible for database backup and restore functions including scheduled tests of DR availability, including knowledge of MS SQL restoration and availability technologies such as Clustering, Replication, and especially Always-On.
• Build and report on SQL environment performance and availability metrics and takes appropriate actions to implement best practices and optimize performance.
• Monitor and maintain the performance, security, and availability of databases.
• Maintain database documentation, including data standards, procedures, and metadata.

Governance, Compliance & Security

• Ensures data completeness, integrity, and security through validation, monitoring, and governance practices.
• Stay up to date with emerging trends and technologies in database management and apply them to improve database performance and security, including testing and applying updates as they become available to stay in compliance.
• Ensures compliance with licensing laws, health and safety, and other statutory regulations.
• Appropriately protects the confidentiality, security, and integrity of the Association, employees, borrowers, and other stakeholders.

Collaboration, Leadership & Stakeholder Engagement

• Collaborate with other IT professionals and vendors to design and implement solutions that integrate with databases.
• Serve as SME (subject matter expert) for Microsoft SQL Server, Oracle, and other database technologies.
• Lead projects in a multi-stakeholder and dynamic environment to achieve team and project Objectives and Key Results.
• Works closely with stakeholders to understand data needs and provide access to relevant data.
• Creates documentation and provides support to help others understand and use the data infrastructure effectively.
• Manage other initiatives as required.

Education and Qualifications

• A university degree in Computer Science, Information Systems, or college diploma with concentration in computer technology or an equivalent combination of education and experience.
• Ability to exceed internal and external customer expectations through timely, effective, and service oriented communication.
• Experience with database technologies such as Oracle, SQL Server, and other databases.
• Experience with database programming languages such as SQL, PL/SQL, T-SQL, or JDBC.
• Experience with data modeling, schema design, and normalization.
• Experience with backup and recovery, high availability, and disaster recovery technologies.
• Experience with database security and access control.
• Experience with performance tuning and optimization. Understanding of systems and Game Management systems (GMS) is an asset.
• Minimum 7 years of experience in database administration