Logo
job logo

Senior Database Administrator

WebMD, Oregon, Illinois, United States, 61061

Save Job

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

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

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 projects Holistic 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

#J-18808-Ljbffr