Full-Time

Intermediate Database Administrator

Posted on 4/30/2024

PointClickCare

PointClickCare

1,001-5,000 employees

Cloud-based healthcare software integration platform


Mid

Remote in Canada

Required Skills
Microsoft Azure
Communications
SQL
Requirements
  • 3+ Years’ Experience in a large scale, mission critical MS SQL Server environment
  • Experience in performance tuning and troubleshooting
  • Experience working with databases in the cloud (Azure preferred – specifically SQL Managed Instance and SQL Database)
  • Installed and configured database servers (MS SQL 2016+) using various high availability technologies such as Availability Groups and Failover Cluster Instances
  • Experience working with multi-TB highly transactional databases
  • Develop and adhere to strong security practices with regards to Authentication, Authorization and Encryption
  • Strong communication skills
  • 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
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
  • Support code or release deployment process
  • Participate in on call rotation (24x7)
  • Mentor Junior, or new DBA team members

As a leader in cloud-based healthcare software, PointClickCare offers a dynamic work environment where technology and healthcare meet to improve patient care and streamline operational efficiencies. Employees at this company benefit from engaging in work that directly enhances healthcare outcomes through innovative data integration and revenue management solutions. This focus on impactful work, combined with the opportunity to contribute to advanced care coordination, makes PointClickCare an attractive workplace for professionals passionate about technology and healthcare.

Company Stage

Private

Total Funding

$231M

Headquarters

Mississauga, Canada

Founded

2000

Growth & Insights
Headcount

6 month growth

4%

1 year growth

4%

2 year growth

30%

Benefits

Competitive financial rewards & equity potential

Comprehensive benefits available from day 1

Midweek mingles with free lunch

Wellness spending account

Retirement savings plan with employer match

Flexible PTO

Hybrid work models

Parental leave

Family planning support

Training & development programs

Corporate discounts program

Summer half-day Fridays

Health & wellness programs