Database Administrator

2 weeks ago


Old Toronto, Canada CareRx Integrated Pharmacy Full time

CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We require a multifaceted professional who is proficient in executing different data applications and processes, enabling and streamlining coordination between our Data Warehouse and multiple integrated systems. The successful candidate will be a critical contributor to expanding our IT capabilities and will play a vital role in helping our company optimize data solutions and operational efficiencies.

Key Responsibilities:

  • Oversee and manage all aspects of our MS SQL, PostgreSQL and other databases.
  • Monitor and improve database performance and capacity proactively, anticipate and prevent any potential database issues for data accuracy and security.
  • Utilize extensive experience with Data Warehouse and SQL to develop and maintain database structures, analyse database implementation, and ensure data integrity.
  • Design and execute backup and recovery processes to protect our system against data loss and streamline database efficiency.
  • Work collaboratively with the IT team, understanding the needs and goals to ensure data integrity, security, and performance of multiple databases.
  • Regularly review, analyse, and tune SQL queries for maximum efficiency.
  • Demonstrate robust problem-solving skills in identifying data-related problems and providing solutions for continuous business operations.
  • Coordinate with data producers and users to establish procedures for data input, management and output to ensure the data warehouse's ongoing functionality.

Job Requirements:

  • Bachelor’s degree in Computer Science or a related field.
  • 8+ years of experience as Database Administrator.
  • Extensive experience working with Data Warehouse and MS SQL Server environment. Ideally knowledge of Big Data and Data Lakes.
  • Proven experience in database performance tuning and capacity planning.
  • Good knowledge of data backup, recovery, security, integrity and SQL.
  • Familiarity with database design, documentation and coding.
  • Proficient in the use of SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and other SQL server related services.
  • Excellent problem-solving skills, ability to manage multiple projects simultaneously, and work in a team environment.
  • Strong written and oral communication skills.

Work Location:

The candidate will be required to work from our downtown Toronto office for a minimum of one day per week (currently Tuesday). The remainder of the workweek will be flexible.

#J-18808-Ljbffr

  • Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...


  • Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...


  • Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need:• The Global Technology Services (GTS) Tools and Monitoring group’s mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need:• The Global Technology Services (GTS) Tools and Monitoring group’s mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need:• The Global Technology Services (GTS) Tools and Monitoring group’s mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time...


  • Old Toronto, Canada Workathome-Jobboard Full time

    This is a fantastic opportunity to become a Member of our CGI-Halifax team providing leading information technology services to our clients. We are seeking a skilled Cloud Database Administrator with a minimum 6 years experience, to join our team and oversee the management and optimization of our cloud-based database systems. The ideal candidate will have...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...


  • Toronto, Canada iPartner Staffing Full time

    3 days per week in the office Expert Oracle and Microsoft SQL Database administration experience Demonstrated experience with DACPAC Experience with Azure build automation using Ansible, Terraform, Packer and VSTS Description The Services and Deliverables to be provided by the Vendor will include the following: - Participate in the review of...


  • Toronto, Canada Cleartech International ltd Full time

    As a DBA, you will be responsible for the administration, maintenance, performance tuning, and security of our database systems across various platforms, including (but not limited to) PostgreSQL, MariaDB, MySQL. You will play a crucial role in ensuring the availability, reliability, and performance of our database systems. Your primary responsibility will...


  • Toronto, Canada Cleartech International ltd Full time

    As a DBA, you will be responsible for the administration, maintenance, performance tuning, and security of our database systems across various platforms, including (but not limited to) PostgreSQL, MariaDB, MySQL. You will play a crucial role in ensuring the availability, reliability, and performance of our database systems. Your primary responsibility will...


  • Toronto, Canada Cleartech International ltd Full time

    As a DBA, you will be responsible for the administration, maintenance, performance tuning, and security of our database systems across various platforms, including (but not limited to) PostgreSQL, MariaDB, MySQL. You will play a crucial role in ensuring the availability, reliability, and performance of our database systems. Your primary responsibility will...


  • Toronto, Canada Institutional Shareholder Services Full time

    Let's be Brilliant Together! - Advance your career with the leading provider of corporate governance and responsible investment solutions. Institutional Shareholder Services (ISS) empowers investors and companies to build sustainable financial and social value by providing high quality data, analytics, and insight. Our clients rely on ISS’ expertise and...


  • Toronto, Canada iPartner Staffing Full time

    Must haves: - Expert level knowledge of migrating Oracle technologies from Unix (Solaris) to Oracle Enterprise Linux / Red Hat Enterprise Linux 5.x/6.x/7.x; UNIX OS (Operating System) and Linux OS, utilities, shell scripting - **Expert level knowledge of Oracle 12c/19c database administration**, maintenance, security implementation include:, upgrade and...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Hybrid (Currently remote with the possibility of transitioning into a hybrid work model in the future. Candidates are expected to come to the office when necessary) – Toronto Contract Duration: June 3rd, 2024 until October 31, 2024 Number of Positions: 1 Scheduled Hours: 8:30am-5pm (Occasional over time and weekend hours may be...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Hybrid (Currently remote with the possibility of transitioning into a hybrid work model in the future. Candidates are expected to come to the office when necessary) – Toronto Contract Duration: June 3rd, 2024 until October 31, 2024 Number of Positions: 1 Scheduled Hours: 8:30am-5pm (Occasional over time and weekend hours may be...


  • Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Hybrid (Currently remote with the possibility of transitioning into a hybrid work model in the future. Candidates are expected to come to the office when necessary) – Toronto Contract Duration: June 3rd, 2024 until October 31, 2024 Number of Positions: 1 Scheduled Hours: 8:30am-5pm (Occasional over time and weekend hours may be...


  • Toronto, Canada Systematix Full time

    We are Systematix and we are looking for 4 experienced Sybase Database Administrators for our Saskatchewan-based client, to support production and non-production environments in a Digital & Information Services (D&IS) division for a six-month term with the possibility of extension. The work can be done 100% remotely. Position Details: Title: Sybase...