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
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