Sql analyst Jobs in Milton, ON

Your responsibilities

· Provide technical and end-user help desk support for web-based and digital systems.

· Performs systems analysis of business problems with varying scope and complexity that includes requirements definition, interfacing with users and providing cost/benefit analysis

· Work with users to support and develop applications to meet the business needs

· Maintain SQL Server databases. Utilizes SQL diagnostics involving fine tuning SQL queries and enhancing performance using SQL profiler and scripts. Create views, stored procedures, and UDFs as part of database development.

· Lead continuous improvement initiatives to enhance system efficiencies within enterprise solutions, collaborating with divisions on localized systems.

· Document application software solutions, metadata, and processes to support application migration, on-going development, and end-user issues.

· Recommend modifications of IT systems to improve and simplify business systems

· Communicate project status to key personnel including supervisor, project stakeholders, sponsors and project team members on a periodic basis.

· Participates in new or alternative technology evaluation related to development tools, databases and methodologies.

· Operational support & reliability: Troubleshoot production systems, perform structured root-cause analysis, implement corrective actions, and provide after-hours / on-call support as needed.



Advantages
Education, Experience and Skills

· University degree in computer science, software engineering, or related field, with an emphasis on programming.

· 5+ years of related experience

· Knowledge in client/server application development, architecture, database-connectivity and database design methodology

· 2 + years of SQL DBA/Developer experience in a Data Warehouse environment

· Experience with data integrity, data retention, data analysis and data input/output processing and improving SQL code performance efficiency

· Strong SQL, data-warehouse and stored procedure skills

· Preference will be given to those applicants who have a working knowledge of C#, Visual Basic, ASP, JavaScript / VBScript, and T-SQL

· Knowledge of Telerik Tools, Web Server Administration, Database Administration, SSIS and SSRS will be considered an asset

· Experience using PowerBi will be considered an asset

· Exposure to Agile development methodologies and MS DevOps will be considered an asset.

· Knowledge of warehouse management and automation technology will be considered an asset

· Project Management experience



Responsibilities
our responsibilities

· Provide technical and end-user help desk support for web-based and digital systems.

· Performs systems analysis of business problems with varying scope and complexity that includes requirements definition, interfacing with users and providing cost/benefit analysis

· Work with users to support and develop applications to meet the business needs

· Maintain SQL Server databases. Utilizes SQL diagnostics involving fine tuning SQL queries and enhancing performance using SQL profiler and scripts. Create views, stored procedures, and UDFs as part of database development.

· Lead continuous improvement initiatives to enhance system efficiencies within enterprise solutions, collaborating with divisions on localized systems.

· Document application software solutions, metadata, and processes to support application migration, on-going development, and end-user issues.

· Recommend modifications of IT systems to improve and simplify business systems

· Communicate project status to key personnel including supervisor, project stakeholders, sponsors and project team members on a periodic basis.

· Participates in new or alternative technology evaluation related to development tools, databases and methodologies.

· Operational support & reliability: Troubleshoot production systems, perform structured root-cause analysis, implement corrective actions, and provide after-hours / on-call support as needed.



Qualifications
Education, Experience and Skills

· University degree in computer science, software engineering, or related field, with an emphasis on programming.

· 5+ years of related experience

· Knowledge in client/server application development, architecture, database-connectivity and database design methodology

· 2 + years of SQL DBA/Developer experience in a Data Warehouse environment

· Experience with data integrity, data retention, data analysis and data input/output processing and improving SQL code performance efficiency

· Strong SQL, data-warehouse and stored procedure skills

· Preference will be given to those applicants who have a working knowledge of C#, Visual Basic, ASP, JavaScript / VBScript, and T-SQL

· Knowledge of Telerik Tools, Web Server Administration, Database Administration, SSIS and SSRS will be considered an asset

· Experience using PowerBi will be considered an asset

· Exposure to Agile development methodologies and MS DevOps will be considered an asset.

· Knowledge of warehouse management and automation technology will be considered an asset

· Project Management experience




Summary
Education, Experience and Skills

· University degree in computer science, software engineering, or related field, with an emphasis on programming.

· 5+ years of related experience

· Knowledge in client/server application development, architecture, database-connectivity and database design methodology

· 2 + years of SQL DBA/Developer experience in a Data Warehouse environment

· Experience with data integrity, data retention, data analysis and data input/output processing and improving SQL code performance efficiency

· Strong SQL, data-warehouse and stored procedure skills

· Preference will be given to those applicants who have a working knowledge of C#, Visual Basic, ASP, JavaScript / VBScript, and T-SQL

· Knowledge of Telerik Tools, Web Server Administration, Database Administration, SSIS and SSRS will be considered an asset

· Experience using PowerBi will be considered an asset

· Exposure to Agile development methodologies and MS DevOps will be considered an asset.

· Knowledge of warehouse management and automation technology will be considered an asset

· Project Management experience



Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.