Design resilient production databases at Keyano College in Fort McMurray, using MS-SQL, ETL, and monitoring expertise on campus. Relocation is required for this non-remote position.
The Database Analyst designs, installs, and maintains production databases for high availability and system resiliency. Working with the ERP team, this position supports on-premise and cloud-based enterprise application integration. Responsibilities include data warehouse structures, reporting, migrations, security controls, and technical documentation.
Key Responsibilities:
- Design and maintain database and data warehouse structures
- Monitor performance and resolve access, reliability, and efficiency issues
- Coordinate migrations, integrations, and platform data transfers
- Develop reports, datasets, ETL processes, and data solutions
- Implement auditing, logging, backup, and security controls
Requirements:
- Technical degree or diploma in computer science or related field
- Three-plus years managing and troubleshooting MS-SQL databases
- SQL industry certification, such as Microsoft MCSA or similar
- Competency with XML constructs, schemas, programming, and scripting
- Data warehouse and report or dashboard modeling experience
Bring MS-SQL, ETL, database governance, and integration expertise to Keyano College's campus-based Fort McMurray team.
Database Analyst Fort McMurray employer: Avanti Software Inc.
The City of Welland offers a dynamic work environment where employees are valued for their contributions to the community. As a Senior Finance Business Partner, you will enjoy a collaborative culture that fosters professional growth and development, with opportunities to influence key financial decisions that impact city services. With a commitment to transparency and innovation, working here means being part of a team dedicated to enhancing the quality of life for residents while enjoying competitive benefits and a supportive workplace.
