Facebook pixel

Senior Database Administrator
Confirmed live in the last 24 hours
Locations
Remote • Mississauga, ON, Canada
Experience Level
Entry
Junior
Mid
Senior
Expert
Desired Skills
AWS
JIRA
Git
Linux/Unix
Microsoft Azure
MySQL
Postgres
SQL
Terraform
Ansible
Communications
Requirements
  • 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 2016+) 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
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
Desired Qualifications
  • Working knowledge of Cloud infrastructure beyond the database (i.e., 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
PointClickCare

1,001-5,000 employees

Cloud-based healthcare software provider
Company Overview
PointClickCare's mission is to advance healthcare technology and make a meaningful impact on the lives of millions. The company is a market leader driving the transformation of healthcare vulnerable and complex populations through a broad, connected care network powered by deep insights with a commitment to value, outcomes and innovation.
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
Company Core Values
  • People
  • Passion
  • Performance