Lead Solution Specialist

4 weeks ago

Vaughan, Canada Miller Thomson LLP Full time

We are seeking a **Lead Solution Specialist (Database Administration & Integration)** to join **any of our Ontario offices** (Toronto, Markham, Vaughan, Waterloo or London).

The Lead Solution Specialist (Database Administration & Integration) 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.

**Key Responsibilities**:

- Monitor all production 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 senior resource on all database operations;
- Review and recommend/approve on all requests from internal or external parties regarding enterprise database operations;
- Conduct periodic review 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;
- 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 bring**:

- University degree /diploma in Computer Science or related information technology;
- Minimum of 7 years of IT experience, 3 years of which in a Senior level Role designing and implementing Database Architecture, 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;
- 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 we offer**:
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 Insu

  • Enterprise Solutions Specialist

    7 days ago

    Vaughan, Canada KGHM Full time

    Recruitment Opportunity! KGHM International (KGHMI) is a wholly owned subsidiary of KGHM Polska Miedz S.A., (KGHM S.A.) with headquarters in Vaughan, Ontario; and subsidiaries in the United States, Canada and Chile established to explore, extract and enrich copper, nickel, molybdenum and precious metal ores. We are focused on environmental protection and are...

  • Enterprise Solutions Specialist

    7 days ago

    Vaughan, Canada KGHM Full time

    Recruitment Opportunity! KGHM International (KGHMI) is a wholly owned subsidiary of KGHM Polska Miedz S.A., (KGHM S.A.) with headquarters in Vaughan, Ontario; and subsidiaries in the United States, Canada and Chile established to explore, extract and enrich copper, nickel, molybdenum and precious metal ores. We are focused on environmental protection and are...

  • Enterprise Solutions Specialist

    7 days ago

    Vaughan, Canada KGHM Full time

    Recruitment Opportunity! KGHM International (KGHMI) is a wholly owned subsidiary of KGHM Polska Miedz S.A., (KGHM S.A.) with headquarters in Vaughan, Ontario; and subsidiaries in the United States, Canada and Chile established to explore, extract and enrich copper, nickel, molybdenum and precious metal ores. We are focused on environmental protection and are...

  • WMS Solutions Specialist

    1 week ago

    Vaughan, Canada SDR Distribution Services Full time

    **Scope/ Overview of Position**: Launched in 1979 as a wholesale and distribution company, SDR has transformed itself into a leader in the North American 3PL market, specializing in the fashion, footwear, accessories, and related soft goods fulfillment market niche. Well known within the industry for its attention to detail and the constant strive for...

  • Energy Metering Specialist

    1 month ago

    Vaughan, Canada Trilliant Full time

    Description : Trilliant is hiring a Senior Metering Specialist who will be responsible for metering and broader communications across several different functions, from meter shop-level services to customer projects. The incumbent will play a lead role as the high-level metering and communication solution expert, interfacing with different technologies...

  • Parts Technical Specialist

    7 days ago

    Vaughan, Canada Toromont Cat Full time

    Description : Toromont Cat is looking for an Apprenticeship specialist to join our team! The Parts Technical Specialist will provide lead role to all Parts technical inquiries and will collaborate with Product Support Operation Leaders, including Mine sites, across ECAN to ensure timely Parts technical inquiry resolution and best in class parts technical...

  • Parts Technical Specialist

    7 days ago

    Vaughan, Canada Toromont Cat Full time

    Description : Toromont Cat is looking for an Apprenticeship specialist to join our team! The Parts Technical Specialist will provide lead role to all Parts technical inquiries and will collaborate with Product Support Operation Leaders, including Mine sites, across ECAN to ensure timely Parts technical inquiry resolution and best in class parts technical...

  • Parts Technical Specialist

    7 days ago

    Vaughan, Canada Toromont Cat Full time

    Description : Toromont Cat is looking for an Apprenticeship specialist to join our team! The Parts Technical Specialist will provide lead role to all Parts technical inquiries and will collaborate with Product Support Operation Leaders, including Mine sites, across ECAN to ensure timely Parts technical inquiry resolution and best in class parts technical...

  • Customer Success Specialist

    4 days ago

    Vaughan, Canada EightSix Network Inc Full time

    Ideal Warehouse Innovations is a worldwide leader in the design and manufacturing of loading dock, warehouse and industrial workplace safety and asset protection solutions. As a Customer Success Specialist, you play a pivotal role in ensuring we create and deliver world-class customer experiences, supporting our Channel Development team, and leveraging...

  • Customer Success Specialist

    4 days ago

    Vaughan, Canada EightSix Network Inc Full time

    Ideal Warehouse Innovations is a worldwide leader in the design and manufacturing of loading dock, warehouse and industrial workplace safety and asset protection solutions. As a Customer Success Specialist, you play a pivotal role in ensuring we create and deliver world-class customer experiences, supporting our Channel Development team, and leveraging...

  • Customer Success Specialist

    4 days ago

    Vaughan, Canada EightSix Network Inc Full time

    Ideal Warehouse Innovations is a worldwide leader in the design and manufacturing of loading dock, warehouse and industrial workplace safety and asset protection solutions. As a Customer Success Specialist, you play a pivotal role in ensuring we create and deliver world-class customer experiences, supporting our Channel Development team, and leveraging...

  • Energy Metering Specialist

    1 month ago

    Vaughan, Canada Trilliant Full time

    Trilliant offers a universal communications platform that is at the convergence of the smart grid, smart city, and global Industrial Internet of Things (IIoT) applications. We bring together multi-technology solutions, global capabilities, and mission-critical communications to deliver future-proof solutions.We are a device-agnostic, integrated,...

  • Business Deposit Specialist

    1 month ago

    Vaughan, Canada Royal Bank of Canada Full time

    **Come Work with Us!** At RBC, our culture is deeply supportive and rich in opportunity and reward. You will help our clients thrive and our communities prosper, empowered by a spirit of shared purpose. Whether you’re helping clients find new opportunities, developing new technology, or providing expert advice to internal partners, you will be doing work...

  • Cash Application Lead

    1 month ago

    Vaughan, Canada GFL Environmental Inc. Full time

    **Key Responsibilities**: Serve as backup to supervisor Maintain Daily Team Stats Compile and publish Quarterly Team Metrics Assist GL in resolving discrepancies identified in their Monthly Reconciliation of 2041 account Accurately post adjustment from division branches with 24 hours of receipt. Adjustments include credit, debit and transfers from one...

  • Customer Success Specialist

    2 weeks ago

    Vaughan, Canada Ideal Warehouse Innovations, Inc. Full time

    Ideal Warehouse Innovations is a worldwide leader in the design and manufacturing of loading dock, warehouse and industrial workplace safety and asset protection solutions. As a Customer Success Specialist, you play a pivotal role in ensuring we create and deliver world-class customer experiences, supporting our Channel Development team, and leveraging...

  • Customer Success Specialist

    2 weeks ago

    Vaughan, Canada Ideal Warehouse Innovations, Inc. Full time

    Ideal Warehouse Innovations is a worldwide leader in the design and manufacturing of loading dock, warehouse and industrial workplace safety and asset protection solutions. As a Customer Success Specialist, you play a pivotal role in ensuring we create and deliver world-class customer experiences, supporting our Channel Development team, and leveraging...

  • Customer Success Specialist

    2 weeks ago

    Vaughan, Canada Ideal Warehouse Innovations, Inc. Full time

    Ideal Warehouse Innovations is a worldwide leader in the design and manufacturing of loading dock, warehouse and industrial workplace safety and asset protection solutions. As a Customer Success Specialist, you play a pivotal role in ensuring we create and deliver world-class customer experiences, supporting our Channel Development team, and leveraging...

  • Recruitment Specialist

    1 month ago

    Vaughan, Canada Appoint Staffing Full time

    Appoint Staffing is actively looking for a Recruitment Specialist for our Client in the **Transportation** Industry. **Russian/Ukrainian** speaking is preferred as a second language. **Key Responsibilities**: - Hiring and onboarding drivers. - Help Management in evaluating top personnel in light of established positions. - Conduct tests and train workers...

  • Marketing Specialist

    2 weeks ago

    Vaughan, Canada Spccard Full time

    Marketing Specialist  Reporting to: Director of Digital & Brand Strategy We are in search of a dynamic and results-focused Marketing Specialist to become an integral part of our team. As a Marketing Specialist, you will play a pivotal role in steering marketing campaigns, taking charge of social media management, supporting digital marketing initiatives,...

  • Marketing Specialist

    2 weeks ago

    Vaughan, Canada Spccard Full time

    Marketing Specialist  Reporting to: Director of Digital & Brand Strategy We are in search of a dynamic and results-focused Marketing Specialist to become an integral part of our team. As a Marketing Specialist, you will play a pivotal role in steering marketing campaigns, taking charge of social media management, supporting digital marketing initiatives,...