| Description
  
 Position at WebMD WebMD Health Services is part of the WebMD family. We have been designing well-being programs for employers and health plans for over 20 years. Our mission is to empower organizations and their populations to improve well-being through personalized, strategic partnerships. Overview: WebMD is the most recognized and trusted brand of health information and the leading provider of health information services, serving consumers, physicians, healthcare professionals, employers and health plans through our public and private online portals and WebMD the Magazine. The WebMD Health Network includes WebMD, Medscape, MedicineNet, eMedicine, RxList, theheart.org and Medscape Education. Our consumer portals and mobile health applications provide engaging, relevant and credible health and wellness information, personalized health assessment tools and access to online communities.
   
   
  WebMD is an Equal Opportunity/Affirmative Action employer and does not discriminate on the basis of race, ancestry, color, religion, sex, gender, age, marital status, sexual orientation, gender identity, national origin, medical condition, disability, veterans status, or any other basis protected by law. This position is an opportunity to join a highly effective and collaborative team that values diversity of perspective, individual responsibility, and mutual respect. We administrate databases for a multi-site high availability SOC 2 SaaS system running 24/7/365 that securely stores and processes large, frequently changing datasets including PHI and PII. We are motivated by our corporate mission to improve our users' lives. Responsibilities: 
  
   Support day-to-day operations and management of over 50 enterprise-level production database instances in development, testing, staging and 24/7/365 production environments
   Manage the backup and recovery program including performing manual as well as scheduled/automated backups and restores of production and non-production databases.
   Conduct routine index and statistics maintenance
   Ensure high levels of data availability and database performance
   Troubleshoot and remediate incidents, sharing in on-call rotations
   Install, configure, update and migrate SQL Server Instances, both standalone and as part of an AG
   Monitor, tune and optimize performance at the server, instance, database and object level including execution plan analysis and optimization.
   Monitor, tune and optimize storage.
   Continuously improve processes and procedures
   Automate administrative processes Qualifications, Skills and Experience: A successful candidate must... 
  
   Excel at working both independently and collaboratively
   Be highly organized and comfortable navigating complex environments and projects
   Readily take ownership and drive to make a positive impact
   Have a minimum 8 years of database administration experience including MSSQL 2017, 2019 and 2022
   Be experienced in
   database backup and other maintenance tasks
   enterprise SQL monitoring tools
   query performance tuning
   replicating data to meet HA/DR objectives, in particular with AlwaysOn Availability Group Clustering
   Have a Bachelor's degree in computer science, MIS, software engineering, similar degree, or comparable work experienc
   Demonstrate strong English written and spoken communication
   Create effective technical documentation and operating procedures related to database administration
   Possess deep SQL and T-SQL knowledge
   Be fluent in database security risks and mitigations
   Have successfully planned and lead projectsHolistic view of Identity Access Management (Authentication and Authorization Data, Endpoint Security, Network Security, Policy Engine)
   Proficient working with User Management and Authentication tools such as Auth0, Okta, Firebase, etc. (Auth0 preferred)
   Strong hands-on experience with industry standard SSO technologies and protocols
   Advanced experience utilizing ticket management system
   Willingness to travel up to 20% of the time Preferred: 
  
   Have configured and managed Merge Replication
   Have administered Azure Managed Instances and AzureDB
   Be able to create and maintain PowerShell automation |