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 :
Excel at working both independently and collaborativelyBe highly organized and comfortable navigating complex environments and projectsReadily take ownership and drive to make a positive impactHave a minimum 8 years of database administration experience including MSSQL 2017, 2019 and 2022Be experienced in database backup and other maintenance tasksBe experienced in enterprise SQL monitoring toolsBe experienced in query performance tuningBe experienced in replicating data to meet HA / DR objectives, in particular with AlwaysOn Availability Group ClusteringHave a Bachelor's degree in computer science, MIS, software engineering, similar degree, or comparable work experienceDemonstrate strong English written and spoken communicationCreate effective technical documentation and operating procedures related to database administrationPossess deep SQL and T?SQL knowledgeBe fluent in database security risks and mitigationsHave 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 protocolsAdvanced experience utilizing ticket management systemWillingness to travel up to 20% of the timePreferred :
Have configured and managed Merge ReplicationHave administered Azure Managed Instances and AzureDBBe able to create and maintain PowerShell automation#J-18808-Ljbffr