Sql analyst Jobs in Ottawa, ON
Last updated: 1 day ago
System Analyst
Optimal Growth TechnologiesGatineau, QC, CanadaSenior Application Support Analyst to triage complex issues within a Salesforce & Java environment
S.i. SystemsOttawa Show moreLast updated: 30+ days ago
- Promoted
Business analyst - computer systems
Business Analyst Computer SystemsOntario, Canada- Promoted
Senior Financial Analyst
Randstad CanadaOttawa, Ontario, CA- Promoted
Network Analyst
Renaud Consulting IM / IT SolutionsOttawa, Ontario- Promoted
- Promoted
Senior Business Analyst
Digital Edge Consultants IncOttawa, Ontario, Canada Show moreLast updated: 27 days ago
Senior Financial Analyst
Adecco CanadaOttawa, Ontario, CanadaData Analyst
Tundra Talent CommunityOttawa, ON, Canada (Remote)Business Systems Analyst
York UniversityOntario, CanadaIntermediate Systems Analyst
MaxSys Staffing and ConsultingOttawa, ONScrum Product Owner
TV2 ConsultingOttawa, ON, CA- Promoted
Data Analyst
PeroptyxOttawa, Ottawa, Ontario, Canada- Promoted
Financial Analyst
CAEOttawaSQL Database Administrator
CB CanadaOttawa, Ontario, CanadaSoftware / Systems Analyst
John Clements Consultants, IncNATIONAL CAPITAL REGIONANALYST
Treasury Board of Canada SecretariatOttawa, OntarioSenior Systems Analyst
Brookfield RenewableGatineau, QC J8X2A1, CASystem Analyst
Optimal Growth TechnologiesGatineau, QC, Canada2 days ago
Job type
- Full-time
- Quick Apply
Job descriptionUniversity or College Degree in Computer Science / Technology or equivalent. Advanced knowledge in database coding ( T-SQL & PL / SQL ). Experience in data analytics tools (Alteryx, Tableau). Senior application professional with experience in monitoring, configuring and documenting, troubleshooting, and maintaining business applications. Expert knowledge of SharePoint, Teams, OneDrive, and Power Platform. Power Platform certification will be considered an asset. Development experience with tools such as Microsoft Logic Apps and Microsoft Compliance Center, Data Factory, API Manager Azure Functions, DevOps and Key Vault, VB, .NET, SQL Server, Oracle . Experience with integrating cloud-based (Software as a Service) digital solutions. Moderate to expert knowledge of PowerShell. Knowledge of server and business applications configuration and implementation / migration. Knowledge of server and desktop processing / operating systems (Microsoft). Deep understanding of all Microsoft 365 applications and experience working in an M365-focused environment. Microsoft 365 certification will be considered an asset Experience providing 2nd 3rd level application support for requests, incidents, and problems in a Windows environment. Experience in root cause analysis and providing workarounds and solutions for custom-coded applications and commercial software. Curious and enthusiastic about acquiring knowledge of new ideas and technological advancements. Strong planning, prioritizing and time management skills - must be able to undertake and manage multiple tasks at the same time and work under tight deadlines and operational pressures. Excellent communication skills (verbal and written). Bilingualism (French and English) will be considered an asset.
System Analyst
Gatineau - Canada
Description
About the Role
The System Analyst will be a Business Applications Solutions team member, responsible for developing, maintaining, and supporting cloud-based solutions and client applications using various technologies such as Data Factory, DevOps, Azure Logic Apps, Azure SQL, Microsoft 365, VB.NET and Power Platform. Reporting to the Manager, Business Applications Solutions, the System Analyst will collaborate with internal and external stakeholders to deliver high-quality solutions that meet the business needs and comply with the established standards and best practices.
Key Responsibilities
- Respond to production incidents and support requests.
- Analyze and follow service calls through to resolution.
- Troubleshoot and resolve access and performance issues.
- Maintain, develop, and deploy Powerautomate code.
- Write complex SQL code to query data, fix bugs and implement enhancements.
- Design and deploy in production various data objects, including tables, views, indexes, and stored procedures (T-SQL and PL / SQL)
- Create and maintain technical documentation.
- Work within the support process standards (and improve when required).
- Provide customer-facing support to stakeholders.
- Provide periodic on-call support (24 / 7).
- Develop, maintain, and support cloud systems and applications functionalities, such as SharePoint, Teams, OneDrive, Power Apps, Power Automate, Power BI, Generative AI, Microsoft Logic Apps, Data Factory, API Manager Azure Functions, DevOps, and Key Vault.
- Analyze and revise existing system logic difficulties and documentation as necessary.
- Testing of patches implemented against business applications.
- Ensure continued, uninterrupted service through identifying and resolving problems in a client / server environment.
- Responsible for software integration, external interface development and technical documentation.
- Have excellent communication skills, with the ability to effectively interact with clients and peers.
- Collaborate with third parties and internal teams to configure and deploy new features and applications.
Knowledge and Experience Required