PointClickCare is a leading North American healthcare technology platform enabling meaningful care collaboration and realtime patient insights. For over 20 years the company has been focused on realizing its vision: to help create a world in which providers and plans can confidently deliver frictionless care. Since its inception PointClickCare has grown exponentially with over 2200 employees working to impact millions across North America. Recognized by Forbes as one of the top 100 private cloud companies and acknowledged by Waterstone Human Capital as Canadas Most Admired Corporate Cultures PointClickCare leads the way in creating cloudbased healthcare software.
At PointClickCare we offer a wealth of opportunities and a vibrant culture that empowers our employees. Our dynamic environment is the perfect place to advance your career while engaging in meaningful work alongside incredible colleagues. Here youll discover a space where your talents can thrive your career can grow and your work will have a lasting impact on healthcare across North America. We believe that work becomes profoundly fulfilling when driven by a higher purpose.
Join us and be part of a team that is making a real impact.
Position Summary:
The Intermediate DBA plays an important role as part of a growing team that is responsible for managing building maintaining monitoring and troubleshooting the cloudbased 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.
Support code or release deployment process
Participate in on call rotation 24x7
Mentor Junior or new DBA team members
Required Experience/Skills
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 multiTB highly transactional databases.
Develop and adhere to strong security practices with regards to Authentication Authorization and Encryption
Takes an evidencebased 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 assignments simultaneously.
Team player flexible with get it done attitude.
Other Desirable Skills:
Experience automating infrastructure deployment using tools such as Ansible or Terraform
Experience with supporting a multitenanted 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 Data Bricks Grafana
Experience with HITRUST HIPPA Compliance and healthcare field.
MCTS MCITP Certification is a plus.
PointClickCare Benefits & Perks:
Benefits starting from Day 1!
Retirement Plan Matching
Flexible Paid Time Off
Wellness Support Programs and Resources
Parental & Caregiver Leaves
Fertility & Adoption Support
Continuous Development Support Program
Employee Assistance Program
Allyship and Inclusion Communities
Employee Recognition and more!
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 should you require any accommodations.
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.