Jobs
>
Mississauga

    Sr. MS SQL Database Administrator - Mississauga, Canada - PointClickCare

    Default job background
    Full time
    Description

    Position Summary

    :
    The Senior MSSQL DBA plays an important role as part of a growing team that is responsible for managing, building, maintaining, monitoring, and troubleshooting the cloud-based database infrastructure that our mission critical SaaS application runs on.

    Key Responsibilities

  • Manage and operate large scale production database systems across multiple Azure regions.
  • Provide direct operational support across all areas of the production database infrastructure including high availability, database replication, release management and disaster planning.
  • Install, configure, and deploy MS SQL Server using automation and infrastructure as code
  • Perform capacity planning, performance turning, monitoring, troubleshooting, patching and optimization of the databases.
  • Assist in designing Backup, Recovery and DR strategies.
  • Develop automation of the database processes, tasks, and procedures.
  • Develop and maintain documentation on systems management and operational procedures.
  • Follow operational policies and processes that are compliant with ITIL standards. Participate in change control procedures.
  • Resolve critical infrastructure incidents as part of on call rotation
  • Provide root cause analysis and/or proactively provide recommendations to prevent issues from surfacing
  • Work with Engineering teams to optimize queries
  • Stay up to date with the trends in the database industry. Use that knowledge to help shape our future database infrastructure.
  • Support code or release deployment process
  • Participate in on call rotation
  • Mentor Intermediate, Junior, or new DBA team members
  • Document operation procedures and processes
  • Required Experience/Skills

  • 5+ Years' Experience in a large scale, mission critical MS SQL Server environment
  • 1+Years' experience administering and managing MySQL and/or PostgreSQL
  • Extensive experience in performance tuning and troubleshooting
  • 2+ years' experience working with databases in the cloud (Azure preferred – specifically SQL Managed Instance and SQL Database)
  • Installed and configured database servers (MS SQL using various high availability technologies such as Availability Groups and Failover Cluster Instances.
  • Experience working with multi-TB highly transactional databases
  • Experience with supporting a multi-tenanted hosting infrastructure with thousands of customers
  • Develop and adhere to strong security practices with regards to Authentication, Authorization and Encryption
  • Experience automating infrastructure deployment using tools such as Ansible or Terraform
  • Takes an evidence-based approach to all troubleshooting and recommendations
  • Strong communication skills. You are comfortable speaking and presenting to senior leadership. You can take a potentially complex topic and present to people of various skill levels (junior to architect)
  • Ability to work varying hours, including evenings, weekends and holidays as required
  • Ability to work in a fast pace and rapidly changing environment.
  • Ability to multitask and work effectively on multiple projects simultaneously
  • Team player, flexible with "get it done" attitude
  • Other Desirable Skills

  • Working knowledge of Cloud infrastructure beyond the database (, networking, security and access control, storage, cost optimization, etc.)
  • Experience in other database systems such as (Cosmos DB, Influx DB)
  • Knowledge of Git and JIRA
  • PowerShell, Linux, AWS, Redgate, AppDynamics, Azure Data factory, DataBricks, Grafana
  • Experience with HITRUST, HIPPA Compliance and healthcare field.
  • MCTS, MCITP, and/or MVP Certification is a plus
  • $112,000 - $127,000 a year


  • 10221163 Canada Inc. Mississauga, Canada

    Education: · Expérience: · Education · Bachelor's degree · Tasks · Data Science · Design and develop database · Operate database management systems to analyze data · Develop and implement data administration policy, standards and models · Research and document data requirements ...


  • Apex Group Mississauga, Canada

    Database Administrator · Location: Mississauga, ON, Canada · Date Posted: Apr 19, 2023 · **Description** · **Database Administrator** · **Role Location**: · **Open** · - Department: IT · - Employment Type: Permanent · **The Role & Key Responsibilities***: · - The role of the Data ...


  • Hitech Space Inc. Mississauga, Canada

    Education: Bachelor's degree · - Experience: 3 years to less than 5 years · **Work setting**: · - Data processing and computers · **Tasks**: · - Collect and document user's requirements · - Data Science · - Design and develop database · - Design, construct, modify, implement and ...


  • NCPL Mississauga, Canada

    Education: Bachelor's degree · - Experience: 3 years to less than 5 years · **Work setting**: · - Consulting firm · **Tasks**: · - Collect and document user's requirements · - Design and develop database · - Design, construct, modify, implement and test data models and database m ...


  • amaris Mississauga, Canada

    Job description · We are looking for dynamic consultants to grow our Information Systems & Digital team in Mississauga. Your experience, knowledge, and commitment will help us to face our client's challenges. · You will be supporting different projects through your expertise as D ...


  • Amaris Consulting Mississauga, Canada

    **Who are we?**: · **Amaris Consulting** is an independent technology consulting firm providing guidance and solutions to businesses. With more than 1000 clients across the globe, we have been rolling out solutions in major projects for over a decade - this is made possible by an ...


  • EllisDon Corporation Mississauga, Canada

    EllisDon is committed to being the safest general contractor. As part of our vaccine directive, we require employees to be fully vaccinated, or in the process of receiving the vaccine against COVID-19. Should you have any additional questions related to our vaccine directive as y ...


  • LRI Invest S.A. Mississauga, Canada

    Location: Mississauga, ON, Canada · Date Posted: Apr 19, 2023 · **Description** · **Database Administrator** · **Role Location**: · **Open** · - Department: IT · - Employment Type: Permanent · **The Role & Key Responsibilities***: · - The role of the Database Administrator will b ...


  • Devforce Mississauga, Canada

    Education: College/CEGEP · - Experience: 1 year to less than 2 years · **Tasks**: · - Collect and document user's requirements · - Data Science · - Design and develop database · - Design, construct, modify, implement and test data models and database management systems · - Operat ...


  • City of Mississauga Mississauga, Canada

    Req ID: 22930 · Vacancy Type: Permanent · Number of Positions: 1 · Closing Date: 02/14/2023 · **Job Summary**: · **Duties and Responsibilities**: · - Configure and provide database performance and general health / capacity monitoring as an ongoing task for the City to conduct bus ...


  • Scriptbox Mississauga, Canada

    Education: Bachelor's degree · - Experience: 1 year to less than 2 years · **Tasks**: · - Collect and document user's requirements · - Data Science · - Design and develop database · - Design, construct, modify, implement and test data models and database management systems · - Op ...


  • Peel District School Board Mississauga, Canada

    **Job Summary** · **Qualifications** · - University degree or College diploma in Computer Science equivalent experience · - 5 years of experience as an Oracle DBA, with significant experience in database migration, consolidation, and upgrade projects. · - Familiarity with modern ...


  • Sialka Cloud Solutions Mississauga, Canada

    Education: Bachelor's degree · - Experience: 1 year to less than 2 years · **Tasks**: · - Collect and document user's requirements · - Data Science · - Design and develop database · - Design, construct, modify, implement and test data models and database management systems · - Op ...


  • GoRight Fleet Solutions Mississauga, Canada

    We are seeking a talented and experienced Database Administrator to work out of our Mississauga, Ontario location. · What's in it for you? · - Comprehensive Benefits - featuring 100% reimbursement on medical and dental, vision, AD&D, affordable STD/LTD, Life and Dependent Life In ...

  • Peel District School Board

    Database Administrator

    11 hours ago


    Peel District School Board Mississauga, Canada

    **Job Summary** · **Qualifications** · - University degree or College diploma in Computer Science equivalent experience · - 5 years' experience with Oracle DBMS, JDeveloper, Oracle Forms and Reports, SQL is essential Experience with JavaScript, Html, XML/XHTML, J2EE, Servlets/App ...


  • Realty Fans Mississauga, Canada

    **Role**: MySQL Database Administrator (DBA) · **Position**: Contract Position Full · - time employment (extendable) · Duration: 6 months+ · **Location**: _Mississauga/Onsite_ · We are currently seeking a skilled and motivated MySQL Database Administrator (DBA) to join our team a ...


  • Showman Sphere Inc Mississauga, Canada

    **MySQL Database Administrator (DBA)** · Dear All, · We have following Job opening for you, · Please find the JD below: · - **Role**:MySQL Database Administrator (DBA)** · **Position**: Full Time Contract employment · **Location**: _Mississauga/Onsite_ · We are currently seeking ...


  • IKO Industries Ltd. Mississauga, Canada

    IKO Industries Ltd. is a market leader in the manufacturing of roofing and building materials. IKO is a Canadian owned and operated business with production facilities worldwide and has many years of unparalleled success in the roofing materials industry. Quality, integrity, and ...


  • CANADA CARTAGE Mississauga, Canada

    **Why you'll love Canada Cartage** · An iconic Canadian company with over 100 years of helping companies grow and succeed in Canada, we provide national dedicated fleet solutions, general freight services, managed transportation, fulfillment & distribution, and home delivery. Wit ...


  • Six side Logistics Mississauga, Canada

    Education: Bachelor's degree · - Experience: 3 years to less than 5 years · **Tasks**: · - Design and develop database · - Design, construct, modify, implement and test data models and database management systems · - Operate database management systems to analyze data · - Develop ...