Database Administrator

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:

1. Oversee and manage all aspects of our MS SQL, PostgreSQL and other databases.
2. Monitor and improve database performance and capacity proactively, anticipate and prevent any potential database issues for data accuracy and security.
3. Utilize extensive experience with Data Warehouse and SQL to develop and maintain database structures, analyse database implementation, and ensure data integrity.
4. Design and execute backup and recovery processes to protect our system against data loss and streamline database efficiency.
5. Work collaboratively with the IT team, understanding the needs and goals to ensure data integrity, security, and performance of multiple databases.
6. Regularly review, analyse, and tune SQL queries for maximum efficiency.
7. Demonstrate robust problem-solving skills in identifying data-related problems and providing solutions for continuous business operations.
8. 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:

1. Bachelor’s degree in Computer Science or a related field.
2. 8+ years of experience as Database Administrator.
3. Extensive experience working with Data Warehouse and MS SQL Server environment. Ideally knowledge of Big Data and Data Lakes.
4. Proven experience in database performance tuning and capacity planning.
5. Good knowledge of data backup, recovery, security, integrity and SQL.
6. Familiarity with database design, documentation and coding.
7. 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.
8. Excellent problem-solving skills, ability to manage multiple projects simultaneously, and work in a team environment.
9. 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.