Sign in to save Intermediate Database Administrator at PointClickCare.
Report this job
For more than 20 years, PointClickCare has been the backbone of senior care. We’ve amassed the richest senior care dataset making our market density untouchable and our connections to the healthcare ecosystem exponentially more powerful than those of any other platform.
With Collective Medical & Audacious Inquiry, we’ve become the most expansive, full-continuum care collaboration network, offering care teams immediate, point-of-care access to deep, real-time insights at every stage of a patient’s journey.
For more information on PointClickCare, please connect with us on Glassdoor and LinkedIn.
Position SummaryThe 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.
Key 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.
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
Takes an evidence-based approach to all troubleshooting and recommendations
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
Other Desirable Skills
Experience automating infrastructure deployment using tools such as Ansible or Terraform
Experience with supporting a multi-tenanted hosting infrastructure with thousands of customers
Experience in other database systems such as MySQL Postgres, and flavors of NoSQL Databases (such as Cosmos DB, and Influx DB)
Working knowledge of Cloud infrastructure beyond the database (i.e., networking, security and access control, storage, cost optimization, etc.)
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 Certification is a plus
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.
When you apply for a position, your information is processed and stored with Lever, in accordance with Lever’s Privacy Policy. 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: recruitment@pointclickcare.com
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.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
Software Development
Referrals increase your chances of interviewing at PointClickCare by 2x
See who you know
Get notified about new Database Administrator jobs in Mississauga, Ontario, Canada.
Introduction: My name is Eusebia Nader, I am a encouraging, brainy, lively, nice, famous, healthy, clever person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.