Database Analyst

Woodbine Entertainment • Etobicoke, ON

1d • CA$75,000 - CA$80,000

About The Position

The role of the Database Analyst is to provide technical assistance, troubleshooting, and maintenance support for applications and associated databases. This involves designing and developing IT systems, improving existing ETL systems, integrating data from different sources, monitoring and maintaining IT systems, conducting preventive maintenance, performing troubleshooting and QA, documenting workflows and changes, generating reports, collaborating with stakeholders, and leveraging DevOps practices for automation and system enhancement.

Requirements

• Bachelor’s Degree in Computer Science, Information Technology, Software Engineering, IT, Business Administration or related field
• Prior experience as a programmer or systems analyst is expected
• Proficiency in Operating Systems and Databases: Solid understanding and experience working with various operating systems (Windows, Linux, Unix,etc.), databases (MS SQL, MySQL, Data Bricks, Fabric, etc.) and programming languages (.net, python)
• Familiarity with Application and Database Support: Prior experience or knowledge of supporting and troubleshooting applications and databases, understanding software development lifecycles, and familiarity with ITIL (Information Technology Infrastructure Library) principles may be advantageous.
• Critical Thinking and Problem-Solving Skills: Diagnosing root causes, identifying discrepancies, and applying preventive measures under pressure and complexity

Nice To Haves

• Certification(s): Database Administrator Associate, Azure Data Fundamentals, Fabric Analytics, Windows Server Hybrid Administrator Associate, Dynamics 365: Finance and Operations Apps Developer Associate, GitHub fundamentals or other relevant vendor-specific certifications are an asset
• Other certifications: Certified AWS, AZURE, GCP, OCI

Responsibilities

• Design and develop IT systems — such as backend processes and ETL (Extract, Transform, Load) workflows using SQL stored procedure scripts to improve efficiency.
• Improve the existing ETL systems, develop alert mechanisms to prevent fraud (e.g. wagering safeguards), and optimize databases and software as per business requirements.
• Integrate data from different sources, ensuring data consistency and accuracy by developing and implementing data integration strategies and solutions.
• Review, monitor, and maintain IT systems, including ETL jobs, applications, loyalty databases, and APIs.
• Conduct preventive maintenance (e.g., statistical updates, indexing), schedule server reboots, and test performance and customer experience for the internal applications.
• Perform multiple troubleshooting rounds for existing IT systems and perform QA (e.g., POS system) to enhance system reliability.
• Document new workflows for IT infrastructure, applications, database changes, discrepancies, and resolutions. Create policies/procedures and maintain a knowledge base.
• Collect and analyze data to improve IT infrastructure, applications, and databases.
• Generating and presenting periodic reports and dashboards to management.
• Collaborate with stakeholders—including management, developers, unit leaders, and end users—to discuss technical issues and advise on improvements.
• Provide user support for application and database issues, communicate system-related problems clearly, and coordinate development and operational efforts.
• Develop JavaScript API automation code to enhance testing efficiency.
• Leverage DevOps practices to improve overall system quality.
• Update internal website frontend features and promote process automation and enhancement.

Benefits

• AI-powered resume screening software to help identify qualified candidates based on the criteria in this job posting. All applications prioritized by the system are subsequently reviewed by our hiring team to ensure a fair and human-centered selection process

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level