Job Description

Job Title:

Database Solutions Specialist

Location:

Vaughan, Toronto, ON (On-Site)

Employment Type:

Full-Time, Permanent

Experience:

3-5 Years

Work Authorization:

Must be legally authorized to work in Canada (without the need for any sponsorship)

About the Role

We are seeking an experienced Database Solutions Specialist with 3-5 years of hands-on experience in database design, optimization, and reporting within enterprise environments. The ideal candidate will be responsible for architecting and maintaining database solutions across on-premises and cloud (Azure/AWS) infrastructures, as well as developing insightful analytics and dashboards using Power BI to support business intelligence and decision-making.

Key Responsibilities

Design, implement, and maintain scalable and secure database solutions across on-prem and cloud environments. Administer, optimize, and troubleshoot databases (SQL Server, Azure SQL, MySQL, Oracle). Develop and maintain Power BI dashboards and reports, ensuring data accuracy, visualization clarity, and business relevance. Work with stakeholders to define data models, ETL processes, and performance metrics for analytics solutions. Implement database performance tuning, query optimization, and indexing strategies. Maintain backup, recovery, and disaster recovery procedures for critical systems. Monitor database health, capacity, and performance using tools such as SQL Profiler, Azure Monitor, or AWS CloudWatch. Collaborate with application and infrastructure teams to ensure high availability and compliance standards (e.g., PCI-DSS and SOC 2). Support incident resolution and participate in planned change windows and audits as required. Maintain comprehensive documentation of data flows, models, and configurations.
Required Skills & Experience

3-5 years of experience in database administration, design, or development in enterprise environments. Strong proficiency in Microsoft SQL Server (T-SQL, SSIS, SSRS) and cloud-based databases (Azure SQL / AWS RDS). Proven experience developing and deploying Power BI reports, dashboards, and data models. Solid understanding of ETL design, data warehousing concepts, and relational data modeling. Experience with database security, access control, and audit mechanisms. Familiarity with automation and scripting using PowerShell, GoLang, or similar tools. Strong analytical and troubleshooting skills across hybrid data environments. Excellent communication, documentation, and collaboration skills.
Preferred Qualifications

Experience in financial, retail, or data analytics environments. Experience with MongoDB/ PostgreSQL is an asset. Certifications (any of the following are assets): Microsoft Certified: Power BI Data Analyst Associate (PL-300) Microsoft Certified: Azure Database Administrator Associate (DP-300) AWS Certified Database - Specialty Familiarity with data governance, compliance frameworks, and data integration pipelines.
Why Join Us

Opportunity to work on hybrid database ecosystems and advanced business intelligence solutions. Exposure to data-driven decision-making and modern BI practices. Competitive salary and benefits package. Collaborative, growth-oriented work environment. Insurance plan for the candidate and immediate family members. On-site parking.
Job Type: Full-time

Pay: $40,486.97-$60,484.00 per year

Benefits:

Dental care Extended health care Life insurance On-site parking Paid time off
Work Location: In person