Enterprise DBA or Data Analyst

1 month ago


Canada, CA Finesse Tech Full time

We understand the importance of a system that works together. Join our team of leaders to begin a rewarding career.

Current Need – This job is located in British Columbia, Canada. All applicants must have the right to work in Canada in order to be considered for this role.

The Enterprise DBA / Data Analyst is a member of the Enterprise Tools team, focusing on administration of the Microsoft SQL Server infrastructure used to support over 35 line of business applications and 90 databases, including the Data Warehouse and data integration services across the IWS business unit while meeting regulatory requirements and compliance standards. Approximately 50% DBA duties and 50% Data Warehousing duties.

  • Manages the SQL Server environments, including Production, Test, and Development
  • Responsible for High Availability and Disaster Recovery capabilities and strategy, such as fail-over clustering, backups, and log shipping
  • Monitors and optimizes performance and troubleshoots both functional and performance related issues
  • Provisions databases, permissions, and other configuration as required
  • Oversees Data Warehousing strategy and implementation
  • Contributes to the design and standards around dimensional data models, extract-transform-load (ETL), and reporting
  • Manages the IWS QlikView infrastructure
  • Develops databases, ETL, and reports as required
  • Follows standards for documentation, configuration management and change management
  • Carries out other tasks as assigned

Qualifications

  • + years experience in database administration

Additional Knowledge & Skills

  • years combined working experience as a DBA, database developer, and/or data analyst preferred

Critical Skills

  • Strong administration experience with Microsoft SQL Server, including failover-clustering (FCI), log shipping or Availability Groups
  • Experience in T-SQL database development, including views, complex stored procedures, functions, CLR functions and the like
  • Experience with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) or similar reporting/ETL tools
  • Experience with monitoring tools, such as SQL Sentry, for server health and performance
  • Any experience with other BI tools such as QlikView, Tableau, MS PowerPivot / PowerView / Semantic Model is an asset
  • Any experience with Oracle / PL-SQL is an asset
  • Excellent English communications (written and verbal) to communicate effectively with peers and stakeholders across the organization
  • Excellent interpersonal skills
  • Excellent organizational skills
  • Able to learn quickly and independently

Education

  • -year degree in computer science or related field or equivalent experience
#J-18808-Ljbffr
  • DBA Analyst

    1 month ago


    Canada, CA Fopconsultants Full time

    Brief description of the position: To meet the needs of its clients in the IT sector, FOP EXPERTS CONSEILS is looking for motivated consultants in DBA analysis (Oracle and SQL Server) for various projects. The main tasks would include developing functional specifications for programs and software, creating and testing solutions, monitoring productions,...


  • Canada, CA Wavicle Data Solutions Full time

    About the Role We are looking for a highly skilled Data Engineering Architect with strong Talend implementation experience to serve as the lead Solution/Technical Architect and Subject Matter Expert for customer experience data solutions across multiple data sources. The ideal candidate will collaborate with the Enterprise Architect and the client IT team to...

  • Analyste Rseau

    3 weeks ago


    Canada, CA NexGedia Enterprise Full time

    Titre : Analyste RéseauLieu : 90% présentiel à QuébecDate de début visée : dès que possible.Durée : 1 an, renouvelable pendant 2 ans pour un total de 3 ans.Langue : Bilingue ou Français unilingue.ResponsabilitésVeille au bon fonctionnement des équipements de télécommunications sur la colline parlementaire, dans les 125 bureaux de...

  • SQL Server DBA

    4 weeks ago


    Canada, CA ROSS Full time

    Our client is a well-established leader in online sports gaming with a Technical Centre of Excellence at Yonge and Sheppard. They have engaged ROSS to help them recruit a SQL Server DBA. They are profitable and growing with over 400 employees worldwide. The SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance...

  • Data Engineer

    1 month ago


    Canada, CA Data Spree GmbH Full time

    The role at KUBRA is focused on designing, building, and maintaining data infrastructure and ETL processes to support data analytics within the organization. The Data Engineer will work on AWS and Databricks to optimize data pipelines and frameworks using Python/Pyspark, manage SQL Server and AWS data infrastructure, and assist in migrating on-premise data...


  • Canada, CA Cpus Engineering Staffing Solutions Inc. Full time

    We are currently requesting resumes for the following position: Enterprise Business Analyst Resume Due Date: Monday June 17th, 2024 (5:00PM EST) Number of Vacancies: 1 Job ID: 24-042 Level: MP6 Duration: 24 months Hours of work:40 Location: 889 Brock Road (100% remote) Recruiter: Courtney Perron Job Overview The client is seeking an experienced candidate to...

  • Revenue Analyst

    1 month ago


    Canada, CA Jungle Scout Enterprise Full time

    At Jungle Scout, we are on a mission to build the best Amazon competitive intelligence tools for Amazon sellers and brands.We’re growing and we are looking to add a Revenue Analyst to our fast-paced and scrappy Finance team.The Revenue Analyst will be a strategic partner to the Sales team, providing critical insights to drive revenue growth and...

  • Data Analyst

    1 month ago


    Canada, CA I Can Infotech Full time

    Company DescriptionI Can Infotech is a technology solutions provider located in Kitchener, ON. We have helped companies across various domains deliver products that matter and strive to cover any technological need. Our team consists of highly skilled individuals who believe in delivering excellence. We are dedicated to helping businesses grow and offer...

  • Data Analyst

    2 weeks ago


    Canada, CA Shivansh Outsourcing Full time

    Job Summary:We are seeking a skilled Data Analyst to join our team and contribute to data-driven decision-making. The ideal candidate will have a strong analytical mindset, proficiency in data manipulation and analysis tools, and the ability to translate complex data into actionable insights.Responsibilities:Collect, clean, and organize large datasets to...

  • Data Analyst

    3 weeks ago


    Canada, CA PrecisionERP Incorporated Full time

    Title: Data AnalystTerm: 6-9 month contractLocation: Montreal - in office 2-3 days per week mandatoryLanguage: fluently bilingual - ENG & FR (Spanish an asset)Role Description:This role is a great opportunity for a data-driven individual with strong Excel skills. Supporting the Data Master team, you will: Utilize SAP (RTBS), Excel and sparesFinder tools for...


  • Canada, CA Cella Full time

    We are seeking a highly skilled Marketing Analyst with a strong focus on Paid Media to join our global client's team for a 12-month contract. This fully remote role is open to candidates across Canada. The ideal candidate will have a passion for data and a talent for turning complex numbers into actionable insights that drive business success.Key...

  • Data Analyst I

    1 month ago


    Canada, CA Oil and Gas Job Search Ltd Full time

    Main FunctionsWhat are you going to doResponsible for importing, cleansing, validating and analyzing data with the purpose of understanding or drawing conclusions from the data. May consolidade and/or present data in charts, graphs, or tables.Focused on improving data quality.Position will receive direction and support.This position level would typically...

  • Lead Data Analyst

    3 weeks ago


    Canada, CA Quarry Consulting Full time

    Title: Data Profiler/ Data AnalystDuration: 12 months contractLocation: Remote but might have to go onsite in Ottawa periodically for workshops and would cover travel expenses. *** Must have Secret clearance or have lived in Canada for 10 consecutive years to be eligible for it)***Job description: Past team leadership experience Lead team of 4 data profilers...


  • Canada, CA TECO Energy Inc. Full time

    Our people are our greatest investments. Be the light to help us keep our customers connected. If you are interested in a career and not just a position, Tampa Electric is the place to be! Tampa Electric offers competitive pay, a comprehensive benefits package and opportunities for growth and development in a friendly and professional work environment. We...


  • Canada, CA DM Lyons Consulting Full time

    SENIOR ANALYST, METER DATA90-100KOnsiteThe Sr. Analyst, Meter Data is responsible for key aspects of meter data management, including setup, system installation, and data analysis. This role involves data collection, monitoring, troubleshooting, and translating findings into actionable business recommendations. The Sr. Analyst will collaborate with...

  • SAS Data Analyst

    1 month ago


    Canada, CA Nexus Systems Group Inc. Full time

    SAS Data Analyst Typical day: - The day starts with a stand-up meeting where we review the current tickets assigned for the current sprint and address roadblocks - After the stand-up, the top ticket priority would have time set aside to develop on. - After a few hours of coding you have a meeting with a stakeholder to confirm some cosmetic choices and...


  • Canada, CA eStaffing Full time

    Are you a Data Entry Specialist seeking a transformative career change? This opportunity might be the perfect fit for you as you consider transitioning to Data Analyst Consulting. We are a staffing company specializing in training individuals for roles with our clients.Become a Data Analyst Consultant (No IT or Coding Required)Job Title: Data...

  • Lead Data Engineer

    1 month ago


    Canada, CA Bombardier Transportation GmbH Full time

    Bombardier’s Business Aircraft London Service Centre in Biggin Hill is part of an award-winning network and is the flagship of Bombardier’s European operation. This Base and Line Maintenance Centre is the fastest-growing Service Centre in Europe and the largest Business Aircraft OEM in the UK. The facility has the capabilities to perform an array of...

  • M&A Analyst

    4 weeks ago


    Canada, CA Keeplee Full time

    Keeplee is looking for an IT Security and Compliance Analyst to join our growing Enterprise Systems team.Keeplee is looking for an IT Security and Compliance Analyst to join our growing Enterprise Systems team. This role will be responsible for day-to-day activities in implementing information security and compliance best practices. They will resolve...

  • Senior Data Analyst

    1 month ago


    Canada, CA MERCADEO INTERACTIVO GCR, S.A. DE C.V. Full time

    Queen’s University, a leading Canadian research institution, offers a diverse employment experience across multiple fields. The university is committed to employment equity and diversity, welcoming individuals from various equity-seeking groups. The Senior Data Analyst role at the Southeastern Ontario Academic Medical Organization (SEAMO) focuses on...