Job Description

Job Category: Information Technology
:
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

About Us:
GREAT ENTERTAINMENT. GREAT PEOPLE. GREAT INVESTMENT. GREAT CANADIAN.
Since our inception in 1982, Great Canadian has grown to be one of the largest and most dynamic gaming and entertainment companies in Canada. With 25 properties across Ontario, British Columbia, Nova Scotia, and New Brunswick, our facilities include over 16,000 slot machines, 575 table games, 71 dining amenities and over 500 hotel rooms. Working closely alongside our crown agency partners, our team of ~8,000 strive to offer the very best gaming, entertainment, dining, and hospitality experiences.
Our Vision is to be the leading gaming, entertainment, and hospitality company in our chosen markets by providing superior entertainment value and exceptional experiences.
Our Mission is to provide outstanding experiences to our guests, rewarding opportunities for our team, and superior value to our shareholders.
What's in it for you?

• We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!
• We provide you with the tools and technology needed to delight your clients!
• You'll get to work with and learn from diverse industry leaders, who have hailed from top organizations around the world.
• Freedom to Innovate: supports new and better ways to be successful.
• Be your Authentic Self: environment that values diversity as a source of strength.
• This isn't your typical "corporate" job. We work hard and we have fun!

The only thing we don't play games with.....is your career!
Great Canadian Entertainment is committed to promoting an inclusive, accessible environment, where all employees and customers feel valued, respected, and supported. We are dedicated to employing a workforce that reflects the diversity of our communities in which we live and serve.
Qualified applicants will receive consideration without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity, gender expression, or disability.
Please note that due to the volume of applications, only those under consideration will be contacted for an interview.
Thank you for your interest in Great Canadian Entertainment!

Skills Required