Oracle dba Jobs in Mississauga, ON

At PointClickCare our mission is simple : to help providers deliver exceptional care. And that starts with our people. As a leading health tech company thats founder-led and privately held we empower our employees to push boundaries innovate and shape the future of healthcare.

With the largest long-term and post-acute care dataset and a Marketplace of 400 integrated partners our platform serves over 30000 provider organizations making a real difference in millions of lives. We also reinvest a significant percentage of our revenue back into research and development ensuring our employees have the resources to innovate and make a lasting by Forbes as a top private cloud company and honored as one of Canadas Most Admired Corporate Cultures we offer flexibility growth opportunities and meaningful work.

At PointClickCare we empower our people to be the architects of a smarter healthcare future; one that is human-first and accelerated by AI to create meaningful and lasting change. Employees harness AI as a catalyst for creativity productivity and thoughtful decision-making. By integrating AI tools into our daily workflows collaboration is enhanced outcomes are improved and every team member has the proficiency to maximize their impact. It all starts with our hiring practices where we uncover AI expertise that complements our mission and we continue to invest in training and development to nurture innovation throughout the employee journey.

Join us in redefining healthcare so it doesnt just survive it learn more about PointClickCare check out Life at PointClickCareand connect with us on Glassdoor and LinkedIn.

• Travel to Office expectations

For Remote Roles : If this role is remote there will be in-office events that will require travel to and from the Mississauga and / or Salt Lake City office. These will include but not limited to onboarding team events semi-annual and annual team meetings.

For Hybrid Roles : If this role is Hybrid there will be an expectation to reside within commutable distance to the office / location specified in the job listing. This will include but not limited to weekly / bi-weekly / monthly events in the office with your specific team. This is a requirement for this role.

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

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 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 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 multi-tenanted hosting infrastructure with thousands of customers.

Experience in other database systems such as MySQL Postgres and flavors of NoSQL Databases (such as Cassandra 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.

$96000 - $103000 a year

AtPointClickCare base salary is one of the many components that make up our total rewards CAD base salary rangefor this position is $ (not overtime eligible) bonus benefits. Our salary ranges are determined byjob and level. The range displayed on each job posting reflects the target for new hire salaries for the position across all CADlocations. Within the range individual compensation is determined by job-related skills and knowledge relevant experienceincluding professional and lived experience and / or work location. Your recruiter can share more information about ourtotal rewards package during the hiring process.

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.

When you apply for a position your information is processed and stored with Lever in accordance with Levers 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 PointClickCares human resources team :

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.

We may use artificial intelligence (AI) tools to support parts of the hiring process such as reviewing applications analyzing resumes or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed please contact us.

Key Skills

Abinitio,CCNA,Account Development,Cost Estimation,Events Management,Financial Consulting

Employment Type : Full-Time

Experience : years

Vacancy : 1