Zortech Solutions, located in Toronto, Ontario, is seeking MS SQL/Azure SQL Database Administrators (DBAs) to join our dynamic team. This is a hybrid, full-time position suitable for entry-level candidates who are passionate about database management and eager to grow in a collaborative environment. At Zortech, we value innovation and teamwork, providing our employees with the tools and support they need to thrive.
Responsibilities
As an MS SQL/Azure SQL DBA, you will play a crucial role in managing and enhancing our database systems. Your responsibilities will include:
- Designing and Developing Database Solutions – Create, test, and implement enhancements for MS SQL, Azure SQL, and Azure Managed Instance (MI) database systems.
- Technical Analysis and Recommendations – Analyze existing database systems and provide technical recommendations for new solutions, ensuring optimal performance and scalability.
- Translating Requirements into Database Designs – Convert metadata and requirements into effective database designs, understanding how design choices impact performance.
- Improving Database Performance – Develop and optimize Data Definition Language (DDL) and Data Manipulation Language (DML) scripts, including queries, stored procedures, views, and data distribution patterns.
- Utilizing Source Code Management Tools – Track database scripts using source code management tools like Git or TFVC, along with platforms such as Bitbucket and Azure DevOps.
- Implementing Data Security Measures – Understand and implement data encryption strategies, including Always Encrypted and tokenization, to safeguard sensitive information.
- Contributing in Agile Environments – Work collaboratively in Agile settings, applying methodologies like Scrum and Kanban, and using tools such as Jira, Confluence, and Azure DevOps.
- Developing ETL Solutions – Experience in building ETL solutions using SQL Server Integration Services (SSIS) or Azure Data Factory is a plus.
- Collaborating with Remote Teams – Engage effectively with remote teams, ensuring clear communication and project alignment.
Qualifications
To succeed in this role, candidates should meet the following qualifications:
- Educational Background – A degree in Computer Science, Information Technology, or a related field.
- Database Management Knowledge – Familiarity with MS SQL and Azure SQL database management systems.
- Technical Skills – Proficiency in writing DDL/DML scripts and optimizing database performance.
- Source Code Management Experience – Understanding of source code management practices and tools like Git or TFVC.
- Agile Methodology Familiarity – Experience working in Agile environments and familiarity with Agile tools such as Jira and Azure DevOps.
- Communication Skills – Strong verbal and written communication skills to collaborate effectively with team members.
- Problem-Solving Skills – Ability to analyze problems, propose solutions, and implement improvements effectively.
- Willingness to Learn – A passion for continuous learning and professional growth in database technologies.
Benefits of Joining Zortech Solutions
Zortech Solutions offers a supportive work environment with a range of benefits, including:
- Competitive Salary – Receive a salary that reflects your experience and expertise.
- Flexible Work Arrangement – Enjoy a hybrid work model that balances in-office and remote work for a better work-life balance.
- Professional Development – Access training and development opportunities to enhance your skills and advance your career.
- Collaborative Team Environment – Work with a diverse team of professionals who share your passion for technology and innovation.
- Health and Wellness Benefits – Comprehensive health and wellness packages to support your well-being.
Applying Guide
Ready to take the next step in your career as an MS SQL/Azure SQL DBA? Here’s how to apply:
- Prepare Your Application – Update your resume and write a tailored cover letter that highlights your relevant experience and skills.
- Visit the Job Posting – Check the official Zortech Solutions career page or job portal for detailed information.
- Submit Your Application Online – Complete the online application process, ensuring you attach your resume and cover letter.
- Confirmation and Tracking – After submitting your application, you’ll receive a confirmation email with instructions on how to track your application status.
- Interview Process – If selected, you will be contacted for an interview to discuss your experience and how you can contribute to our team.