Jobs
>
Toronto

    Database Specialist Administrator - Ontario, Canada - Miller Thomson LLP

    Miller Thomson LLP
    Miller Thomson LLP Ontario, Canada

    5 days ago

    Default job background
    Description
    As a recognized national business law firm, we support, grow, and impact our communities through our work. We help entrepreneurs, companies, and professionals shape and build the Canadian economy.

    We provide the opportunity to influence the course of your career, community, and workplace with the support and backing of a national organization.

    You can expect a friendly, safe, and supportive environment where your colleagues will rally around to help you succeed.

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

    Overseeing an integrated framework of overall IT, the Enterprise Architecture & Security team is responsible for defining, designing, build & overseeing overall IT Strategy, Enterprise Architecture, Governance & Security including Datacenter, Cloud, Networks, End Users devices, application platforms, Databases, Data Integrations, & Application & systems services delivery.

    The Specialist, Database Administrator & 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.

    The Specialist, Database Administrator & Integration 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 include 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 have committed to professional development and achievement.

    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 solutions;

    Optimize database growth and index performance by ensuring appropriate maintenance plans are in place and operating normally on all production instances.

    Also 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. Also 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 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.

    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 implementing operational automation using scripts (PowerShell, T-SQL, 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 in performance tuning and troubleshooting of queries, stored procedures, and SSIS packages;
    Experience Indexing for performance (index maintenance and statistics, index usage analysis, etc.);
    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 broad range of legal industry applications & related security & operational knowledge (application management, monitoring, troubleshooting, security & access controls, database administration, backup & recovery, DR, BCP etc.) & 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.

    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;
    Flexible working options;
    A Firm matching Group Retirement Savings plan;
    A wellness spending account to foster employee well-being;

    Miller Thomson LLP is one of Canada's fastest-growing national business law firms, with strategically placed offices across the country.

    Our consistent ability to provide practical, creative and cost-effective advice, combined with an unyielding service commitment to our clients and a strong dedication to our lawyers, business services professionals and the communities in which we practice, gives us a unique position in the Canadian legal industry.

    Miller Thomson LLP is an equal-opportunity employer and is committed to equity, diversity, inclusion, and accessibility.

    No phone calls or agencies, please.

    Miller Thomson will provide accommodation on request throughout the recruitment, selection and assessment process for applicants with disabilities.

    By submitting your personal information on this platform, you freely consent to the collection, use, and disclosure of that information in connection with our application process.

    You may decide to withdraw your consent to the collection, use, and disclosure of your personal information at any time by notifying us at .

  • Myo Health Rehab and Wellness Center

    Administration Specialist

    3 days ago

    Myo Health Rehab and Wellness Center Toronto, Canada

    MyoHealth Rehab and Wellness Centre has an exciting opportunity for an **Administration Specialist** to join our fast-paced private rehabilitation and wellness clinic. **This full-time role is a maternity leave position that will transition to a permanent role in our growing clin ...

  • Cortland Credit Group Inc.

    Administrative Specialist

    1 week ago

    Cortland Credit Group Inc. Toronto, Canada

    Education: Bachelor's degree · - Experience: 1 year to less than 2 years · **Screening questions**: · - Are you currently legally able to work in Canada? · - Do you currently reside in proximity to the advertised location? · - Do you have previous experience in this field of empl ...

  • H.H. Angus and Associates Limited

    Administrative Support Specialist

    4 hours ago

    H.H. Angus and Associates Limited Toronto, Canada

    Administrative Support Specialist - Administration - Toronto, Ontario, Canada · This is a great opportunity to join a dynamic team in a company with an excellent reputation in the engineering consulting industry. At HH Angus, we value our employees and strive to create a culture ...

  • MD Financial Management

    Regional Administrative Specialist

    1 week ago

    MD Financial Management Toronto, Canada

    **Requisition ID**: 177754 · **Cost Centre**: MD Financial Mgmt Inc · We are committed to investing in our employees and helping you continue your career at Scotiabank. · MD Management Limited, a division of Scotia Wealth Management, has an exciting opportunity for a talented, en ...

  • Canada Life Assurance Company

    Administration Service Specialist

    6 days ago

    Canada Life Assurance Company Toronto, Canada

    **Job Description**: · Reporting to the Assistant Manager, Medical Underwriting, the Administration Service Specialist is responsible for administrative and supportive duties for the department. · **What you will do** · - Open, sort, process and audit incoming documents and outgo ...

  • Canada Life Assurance Company

    Administration Service Specialist

    4 hours ago

    Canada Life Assurance Company Toronto, Canada

    **Job Description**: · **We are Canada Life** · Being a part of Canada Life means you have a voice. This is a place where your unique background, perspectives and talents are valued, and shape our future success. · You can be your best here. You're part of a diverse and inclusive ...

  • Bell Canada

    Specialist, Systems Administration

    6 days ago

    Bell Canada Toronto, Canada

    Req Id: 408476 · At Bell, we do more than build world-class networks, develop innovative services and create original multiplatform media content - we're revolutionizing how Canadians communicate. · If you're ready to bring game-changing ideas to life and join a community that va ...

  • Scotiabank

    Investment Specialist, Administrative Assistant

    1 day ago

    Scotiabank Toronto, Canada

    Requisition ID: 198770 · Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. · As an Investment Specialist, Administrative Assistant, you will be primarily responsible for working with Investment Specialists to support the develo ...

  • McDonald's Canada

    Rmhc - Executive Administration Specialist

    6 days ago

    McDonald's Canada Toronto, Canada

    Company Description · At McDonald's, we are committed to being the best, and that starts with finding the best people. We have built a team of extraordinary people from around the world. We are problem solvers, risk takers, innovators, and thought leaders that take our work serio ...

  • CMHC

    Bilingual Specialist, Administrative Services

    4 days ago

    CMHC Toronto, Canada

    **Job Requisition ID**: 9519 · **Position Status**: Temporary Full Time · **Position Type**:Hybrid · **Office Location**:Toronto (ON) · **Travel Requirement**: Limited · **Language Designation**: Bilingual · **Language Skill Levels (Read/Write/Speak)**: BBB · **Salary**: Our sala ...

  • CBC/Radio-Canada

    Administrative Specialist, Procurement(Finance)

    6 days ago

    CBC/Radio-Canada Toronto, Canada

    Position Title: · Administrative Specialist, Procurement(Finance) · - Hybrid · Status of Employment: · Permanent · Position Language Requirement: · English, French · Language Skills: · English (Reading), English (Speaking), English (Writing), French (Reading - A - Beginner), Fren ...

  • SPINVFX

    Payroll Administrator/hr Specialist

    1 week ago

    SPINVFX Toronto, Canada

    PAYROLL · - Review employment agreements · - Updating new hires and exits on Ceridian's HRIS system · - Maintaining payroll updates using the HRIS system · - Prepare monthly overtime report to be used for payroll at month end · - Eventually be able to prepare and run semi-monthly ...

  • Thought storm

    Systems Administrator/operations Support Specialist

    5 days ago

    Thought storm Toronto, Canada

    **Start Date**: ** · **End Date**: ** · **Client: Supply Ontario** · **Position**:RQ Systems Administrator/Operations Support Specialist - Junior** · **Location**:200 Front St West Toronto** · MSP Notes: · Requisition Closing Date: Nov 28 at 3:00 pm ET · Maximum number of submiss ...

  • Cleo Consulting

    Systems Administrator/operations Support Specialist

    6 days ago

    Cleo Consulting Toronto, Canada

    **Requisition: RQ00056** · **Supplier Assignment: RQ Systems Administrator/Operations Support Specialist - Junior** · **Account: Supply Ontario** · **Start Date: ** · **End Date: ** · **Business Days: 263.00** · **Job Title: Operations Support Specialist - Junior** · **This is an ...

  • Isheva Inc

    Systems Administrator/operations Support Specialist

    1 week ago

    Isheva Inc Toronto, Canada

    IBM WebSphere Application Server/NDM/Liberty · - Deployment Automation · - Middleware Monitoring tools e.g. ITCAM · - Cloud technology including Kubernetes/Ansible · - Experience with ITIL Incident Management process · - Experience with ITIL Change Management process · - Experien ...

  • vTech Solution

    Systems Administrator/operations Support Specialist

    1 day ago

    vTech Solution Toronto, Canada

    **o IBM WebSphere Application Server/NDM/Liberty** · **o IBM DataPower** · **o Deployment Automation** · **o Middleware Monitoring tools e.g. ITCAM** · **o Cloud technology including Kubernetes/Ansible** · **- Experience with ITIL Incident Management process** · **- Experience wi ...

  • sunlight dental clinic

    Administrative Specialist

    4 hours ago

    sunlight dental clinic Thornhill, Canada

    Education: Secondary (high) school graduation certificate · - Experience: 2 years to less than 3 years · **Work setting**: · - Clinic · **Tasks**: · - Interview patients to obtain case histories · - Schedule and confirm appointments · - Complete insurance and other claim forms · ...

  • OliveTree Accounting Inc.

    Administrative Specialist

    1 day ago

    OliveTree Accounting Inc. Concord, Canada

    Education: College, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 years · - Experience: 2 years to less than 3 years · **Screening questions**: · - Are you available for the advertised start date? · - Do you currently reside in proximity to th ...

  • MyoHealth Rehab and Wellness Centre

    Administration Specialist

    1 day ago

    MyoHealth Rehab and Wellness Centre Scarborough, Canada

    We have an exciting opportunity for an **Administration Specialist** to join our fast-paced private rehabilitation and wellness clinic. · Responsibilities include: the timely preparation, processing, management and follow-up of patient files, treatment plans and related documents ...

  • ONTARIO HEALTH SERVICES INC.

    Administrative Specialist

    1 day ago

    ONTARIO HEALTH SERVICES INC. Scarborough, Canada

    Work Term: Permanent · - Work Language: English · - Hours: 32 to 40 hours per week · - Education: Secondary (high) school graduation certificate · - Experience: 2 years to less than 3 years · - or equivalent experience · **Work setting**: · - Business services · **Tasks**: · - Es ...