<div>At PointClickCare our mission is simple: to help providers deliver exceptional care. And that starts with our people. As a leading health tech company that’s founder-led and privately held, we empower our employees to push boundaries, innovate, and shape the future of healthcare. </div><div><br /></div><div>With the largest long-term and post-acute care dataset and a Marketplace of 400+ integrated partners, our platform serves over 30,000 provider organizations, making a real difference in millions of lives. We also reinvest a significant percentage of our revenue back into research and development, ensuring our employees have the resources to innovate and make a lasting impact. Recognized by Forbes as a top private cloud company and honored as one of Canada’s Most Admired Corporate Cultures, we offer flexibility, growth opportunities, and meaningful work.  </div><div><br /></div><div> At PointClickCare, we empower our people to be the architects of a smarter healthcare future; one that is human-first and accelerated by AI to create meaningful and lasting change. Employees harness AI as a catalyst for creativity, productivity, and thoughtful decision-making. By integrating AI tools into our daily workflows, collaboration is enhanced, outcomes are improved, and every team member has the proficiency to maximize their impact. It all starts with our hiring practices where we uncover AI expertise that complements our mission, and we continue to invest in training and development to nurture innovation throughout the employee journey.</div><div><br /></div><div>Join us in redefining healthcare — so it doesn’t just survive, it thrives. To learn more about PointClickCare, check out <a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpointclickcare.com%2Flife-at-pointclickcare%2F&amp;data=05%7C02%7CSandeep.Dhillon%40pointclickcare.com%7Ce9353db140a24fd980f808ddb00013f1%7Cafd0249eca3d42058bf4ac2b6abd0fec%7C0%7C0%7C638860236586947941%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&amp;sdata=dIKtrMG7L0sb%2FfLrFRvhcZAmfqfNXTXDTvMsoJkwGvM%3D&amp;reserved=0">Life at PointClickCare</a> and connect with us on <a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.glassdoor.ca%2FOverview%2FWorking-at-PointClickCare-EI_IE452666.11%2C25.htm&amp;data=05%7C02%7CSandeep.Dhillon%40pointclickcare.com%7Ce9353db140a24fd980f808ddb00013f1%7Cafd0249eca3d42058bf4ac2b6abd0fec%7C0%7C0%7C638860236586978442%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&amp;sdata=KVgSiL%2ByFmnpxTc5PmuErMwRNwDmTGqUzJIUSIm5fY0%3D&amp;reserved=0">Glassdoor </a>and <a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fpointclickcare%2F&amp;data=05%7C02%7CSandeep.Dhillon%40pointclickcare.com%7Ce9353db140a24fd980f808ddb00013f1%7Cafd0249eca3d42058bf4ac2b6abd0fec%7C0%7C0%7C638860236586994867%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&amp;sdata=AFNWMltUX65iQ5E5LFYOrA9bKP10SzKQ7jwcti57q2E%3D&amp;reserved=0">LinkedIn</a>.</div><div><br /></div><div><br /></div><div><b>**Travel to Office expectations**</b></div><div><b>For Remote Roles</b>: If<span> this role is remote, there will be in-office events that will require travel to and from the Mississauga and/or Salt Lake City office. These will include, but not limited to, onboarding, team events, semi-annual and annual team meetings.</span></div><div><br /></div><div><b>For Hybrid Roles</b>: If<span> this role is Hybrid, there will be an expectation to reside within commutable distance to the office/location specified in the job listing. This will include, but not limited to, weekly/bi-weekly/monthly events in the office with your specific team. This is a requirement for this role.</span></div><div><br /></div><div><b>Position Summary:</b></div><div>The Intermediate 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.</div><div><br /></div><div><b>Key Responsibilities</b></div><div>· Manage and operate large scale production database systems across multiple Azure regions.</div><div>· Provide direct operational support across all areas of the production database infrastructure including high availability, database replication, release management and disaster planning.</div><div>· Install, configure, and deploy MS SQL Server using automation and infrastructure as code.</div><div>· Perform capacity planning, performance turning, monitoring, troubleshooting, patching and optimization of the databases.</div><div>· Assist in designing Backup, Recovery and DR strategies.</div><div>· Develop automation of the database processes, tasks, and procedures.</div><div>· Develop and maintain documentation on systems management and operational procedures.</div><div>· Follow operational policies and processes that are compliant with ITIL standards. Participate in change control procedures.</div><div>· Resolve critical infrastructure incidents as part of on call rotation.</div><div>· Provide root cause analysis and/or proactively provide recommendations to prevent issues from surfacing.</div><div>· Work with Engineering teams to optimize queries.</div><div>· Stay up to date with the trends in the database industry. Use that knowledge to help shape our future database infrastructure.</div><div>· Support code or release deployment process</div><div>· Participate in on call rotation (24x7)</div><div>· Mentor Junior, or new DBA team members</div><div><br /></div><div><b>Required Experience/Skills</b></div><div>· 3+ Years’ Experience in a large scale, mission critical MS SQL Server environment</div><div>· Experience in performance tuning and troubleshooting</div><div>· Experience working with databases in the cloud (Azure preferred – specifically SQL Managed Instance and SQL Database)</div><div>· Installed and configured database servers (MS SQL 2016+) using various high availability technologies such as Availability Groups and Failover Cluster Instances.</div><div>· Experience working with multi-TB highly transactional databases.</div><div>· Develop and adhere to strong security practices with regards to Authentication, Authorization and Encryption</div><div>· Takes an evidence-based approach to all troubleshooting and recommendations.</div><div>· Strong communication skills.</div><div>· Ability to work varying hours, including evenings, weekends and holidays as required.</div><div>· Ability to work in a fast pace and rapidly changing environment.</div><div>· Ability to multitask and work effectively on multiple assignments simultaneously.</div><div>· Team player, flexible with “get it done” attitude.</div><div><br /></div><div><b>Other Desirable Skills:</b></div><div>· Experience automating infrastructure deployment using tools such as Ansible or Terraform</div><div>· Experience with supporting a multi-tenanted hosting infrastructure with thousands of customers.</div><div>· Experience in other database systems such as MySQL Postgres, and flavors of NoSQL Databases (such as Cassandra, and Influx DB)</div><div>· Working knowledge of Cloud infrastructure beyond the database (i.e., networking, security and access control, storage, cost optimization, etc.)</div><div>· Knowledge of Git and JIRA</div><div>· PowerShell, Linux, AWS, Redgate, AppDynamics, Azure Data factory, Data Bricks, Grafana</div><div>· Experience with HITRUST, HIPPA Compliance and healthcare field.</div><div>· MCTS, MCITP Certification is a plus.</div><div><b>PointClickCare Benefits &amp; Perks:</b></div><div><br /></div><div><span>Benefits starting from Day 1!</span></div><div><span>Retirement Plan Matching </span></div><div><span>Flexible Paid Time Off</span></div><div><span>Wellness Support Programs and Resources</span></div><div><span>Parental &amp; Caregiver Leaves</span></div><div><span>Fertility &amp; Adoption Support</span></div><div><span>Continuous Development Support Program</span></div><div><span>Employee Assistance Program </span></div><div><span>Allyship and Inclusion Communities</span></div><div><span>Employee Recognition … and more!</span></div><div><br /></div><div>It is the policy of PointClickCare to ensure equal employment opportunity without discrimination or harassment on the basis of race, religion, national origin, status, age, sex, sexual orientation, gender identity or expression, marital or domestic/civil partnership status, disability, veteran status, genetic information, or any other basis protected by law. PointClickCare welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection process. Please contact recruitment@pointclickcare.com should you require any accommodations.</div><div><br /></div><div>When you apply for a position, your information is processed and stored with Lever, in accordance with <a href="https://www.lever.co/privacy-policy">Lever’s Privacy Policy</a>. We use this information to evaluate your candidacy for the posted position. We also store this information, and may use it in relation to future positions to which you apply, or which we believe may be relevant to you given your background. When we have no ongoing legitimate business need to process your information, we will either delete or anonymize it.  If you have any questions about how PointClickCare uses or processes your information, or if you would like to ask to access, correct, or delete your information, please contact PointClickCare’s human resources team: <a href="mailto:recruitment@pointclickcare.com">recruitment@pointclickcare.com</a> </div><div><br /></div><div>PointClickCare is committed to Information Security.  By applying to this position, if hired, you commit to following our information security policies and procedures and making every effort to secure confidential and/or sensitive information.</div>