Senior Database Administrator
WebMD, Madison, WI, United States
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.
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 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
Compensation $123,000 - $130,000
Benefits
Employees in this position are eligible to participate in the company sponsored benefit programs, including the following within the first 12 months of employment:
Health Insurance (medical, dental, and vision coverage)
Paid Time Off (including vacation, sick leave, and flexible holiday days)
401(k) Retirement Plan with employer matching
Life and Disability Insurance
Employee Assistance Program (EAP)
Commuter and/or Transit Benefits (if applicable)
Eligibility for specific benefits may vary based on job classification, schedule (e.g., full-time vs. part-time), work location and length of employment.
#J-18808-Ljbffr
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.
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 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
Compensation $123,000 - $130,000
Benefits
Employees in this position are eligible to participate in the company sponsored benefit programs, including the following within the first 12 months of employment:
Health Insurance (medical, dental, and vision coverage)
Paid Time Off (including vacation, sick leave, and flexible holiday days)
401(k) Retirement Plan with employer matching
Life and Disability Insurance
Employee Assistance Program (EAP)
Commuter and/or Transit Benefits (if applicable)
Eligibility for specific benefits may vary based on job classification, schedule (e.g., full-time vs. part-time), work location and length of employment.
#J-18808-Ljbffr