Location
Waterloo, ON | Canada
Job description
Your new company
Our client, a highly recognized business law firm, is looking for a Senior Solutions Analyst to join their team!
Your new role
The Senior Solutions Analyst supports Firm operations through the rigorous management of all SQL Server instances, various data integrations & architecture, data analysis & reporting, as well as databases platforms across all departments and practices. Also Manages data, infrastructure and resource lifecycles, including capacity and succession planning as well as performs routine monitoring, testing and troubleshooting of all supported database infrastructure to maintain high availability and optimal performance levels. Maintains support documentation on all active database instances, as well as installation and operating procedure documentation.
The Senior Solutions Analyst should possess proven expertise in Data Architecture, Database Administrations, integration, analysis, & reporting as well as database & application architectural designing, operations, delivery & management preferably in Legal Industry. This includes expertise in business requirement gathering & analysis, capacity planning, trend & root cause analysis, project management, remediation planning, as well as in problem, incident, and change management. At this lead level, it is expected that the candidate has chosen this area as their career focus and has committed to professional development and achievement.
Key Responsibilities
- Participate in monitoring all LOB application and SQL Server instances for optimal performance, addressing issues directly or via escalation as appropriate to circumstance.
- Enrich monitoring through systematic addition of detail on monitored queries and processes to monitoring solution.
- Optimize database growth and index performance by ensuring appropriate maintenance plans are in place and operating normally on all production instances;
- Review database backup operations to ensure consistent completion and availability of restore points.
- Maintain high-level documentation of all production instances configurations, licensing, operating relationships and dependencies, and workflow;
- Review and refine security model applied to all production, test and development instances, ensuring best balance of information protections and operating efficiency.
- Participate in ongoing and project-based activity as required, serving as a senior resource on all LOB applications & database operations;
- Review and recommend all requests from internal or external parties regarding applications enhancement & database operations.
- Conduct periodic reviews of resource utilization to inform instance lifecycle management and annual resource planning.
- Review and draw together all existing data integration operations to central integration/workflow platform to ensure central management going forward;
- Participate in integration/workflow platform development efforts, representing database operations and data flow.
- Assume ownership of one or more key application offerings and responsibility for functional lifecycle management and continuous improvement.
- Engage with stakeholders to determine solution requirements, scope and estimate project efforts, identify risks and recommend mitigation measures, communicate activity status, assess impact to existing work processes and systems, and pinpoint how to manage integration;
- Work with technology partners (i.e. Solution Designers and Architects) to research and analyze current state system capabilities and define technology solutions options and recommendations.
- Assist quality assurance teams in translating requirements and use cases into test conditions and expected results for product, performance, user acceptance, and operational acceptance testing.
What you'll need to succeed
- University degree /diploma in Computer Science or related information technology;
- Minimum of 5 years of IT experience, 3 years of which in a Senior level Role designing and implementing Legal Industry specific LOB application solutions, Database Integrations, Data analysis & reporting Solutions, and Application Integration after analyzing & gathering Business requirements, preferably in Legal Industry.
- Knowledge of designing, implementation, and management of SQL Clustering, High Availability (HA) and (DR) options for SQL;
- Experience with Implementing operational automation using scripts (PowerShell, TSQL, VB Scripts, etc.);
- Experience in ETL design, strategy and associated processes as well as in PowerBI, Analytics, SSIS and Other ETL Tools;
- In-depth knowledge of relational objects such as tables, stored procedures, triggers and DTS/SSIS packages is required along with experience performance tuning and troubleshooting of queries, stored procedures, and SSIS packages;
- Experience Indexing for performance (index maintenance and statistics, index usage analysis, etc.);
- Experience in one or more development platforms, including .NET, Visual Basic, Visual C++, Java, SharePoint, Lotus Notes/Domino;
- Experience in designing solutions for data warehouse system integrations;
- Experience building integrated systems from on-premise to cloud-based infrastructures;
- Develop, maintain, & improve processes for deploying Power BI reports & Dashboards;
- Experience working with software & service vendor resources, and managing scope and activity on professional service engagements;
- Familiarity with the software development life cycle (SDLC) model and one or more application development methodologies (i.e. Agile, Waterfall, etc.);
- Possess a broad range of legal industry applications & related security & operational knowledge (application management, monitoring, troubleshooting, security & access controls, database administration, backup & recovery, DR, BCP etc.) & systems development life cycle management experience in multiple technological platforms;
- Senior-level experience with business requirements gathering & analysis, process and policy development/enforcement with a vision and strategy for continual improvement and Enterprise Governance for all Line of business (LOB) applications;
- Proficiency in the use of PowerShell and Scripting languages;
- Knowledge of Aderant, IntApp, Iridium and iManage will be an asset;
- Knowledge of Incident Management, Security Analysis & reporting, Risk management and business awareness and end-user training.
What you'll get in return
We believe in the importance of a Total Compensation package, ensuring our mix of salary, benefits, and perks are competitive within the market as well as a work-life balance. We offer:
- A comprehensive Benefits package that includes Health, Dental and Vision Care, Employee Assistance Program, Life Insurance, Short Term and Long Term Disability Insurance, 3+ Weeks’ Vacation and 10 Personal Days;
- A Diverse and Inclusive Workplace;
- Flexible working options;
- Maternity Leave Top-up;
- A Firm matching Group Retirement Savings plan;
- An individual TFSA with low fund management fees and competitive investment options;
- Employee Assistance Program to support you and your family;
- A wellness spending account to foster employee well-being;
- Professional Development opportunities;
- Employee appreciation events;
- Charitable giving programs.
What you need to do now
If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.
If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion on your career.
Job tags
Salary
