← Back to all jobs

Senior MS SQL DBA

Fully remote

Added
3 months ago
Location
Type
Full-time
Salary
Not Specified

Related skills

postgresql dba sql mysql postgres

For more than 20 years, PointClickCare has beenthe backbone of senior care. We’ve amassed therichestsenior care dataset making ourmarket 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 onGlassdoorandLinkedIn.

Position Summary:

The Senior MSSQL 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
  • Mentor Intermediate, Junior, or new DBA team members
  • Document operation procedures and processes
  • Required Experience/Skills

  • 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
  • Other Desirable Skills

  • 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
  • Additional Information

    #LI-Remote

    #LI-JP1

    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.

    Share job

    Help us maintain the quality of jobs posted on Remotely!

    Is this position not a remote job?

    Let us know!

    +18161 More Jobs Available!

    Sign up now to unlock all job opportunities.

    Uncover Hidden Jobs

    Browse openings not posted on other job boards.

    Be the First To Know

    Receive daily job alerts with fresh job openings.

    Keep Track of Your Job Hunt

    Save to favorites and track jobs you've already applied to.

    Choose your membership

    Cancel anytime

    It's time to find your dream startup job!
    Loved by job seekers!

    Within a week of using Remotely, I secured three interviews with top-notch companies. The breadth of job opportunities is simply unparalleled.

    Olivier S.

    I took Remotely for a spin on my job search this morning and found a position I'll be applying for today that fits my needs.

    Mia D.

    I've always struggled to find a startup job that aligns with my skill set, but Remotely changed the game for me. The sheer volume of high-quality job listings is mind-blowing!

    Liam R.

    The caliber of companies listed on Remotely is unmatched. It's clear that they prioritize quality over quantity, and that's a game-changer for serious job seekers like me.

    Sophia G.

    THANK YOU for having a dark mode. I'm 100% dark mode everything so I appreciate that setting for a job board.

    Joe C.

    Remotely is the gold standard for startup job platforms. Not only did I find a multitude of roles suited to my expertise, but the companies were reputable and well-regarded in the industry.

    Emma T.

    From tech startups to Fortune 500s, Remotely caters to every job seeker out there. The diversity and quality of companies listed here is fantastic.

    Ethan P.

    After months of fruitless job hunting, I stumbled upon Remotely. I was surprised by the number of listings and the clarity of information. I landed my dream job in just four weeks!

    Isabella K.

    The user experience on Remotely is seamless. With detailed job descriptions and a range of well-known companies, my job search was more efficient and fruitful than ever.

    Noah C.

    Remotely is so easy to navigate and I like that it provides lots of options for filtering based on benefits and more.

    Aval S.

    No other platform comes close to the depth and breadth of job opportunities that Remotely offers. It's now my go-to recommendation for anyone looking to venture into remote work.

    Lucas H.

    If you're seeking quality over quantity in your job search, Remotely is the place to be. The comprehensive job listings paired with top-tier companies made my job hunt a breeze!

    Charlotte E.
    Find your dream job today!

    Choose your membership

    Cancel anytime