Database Administrator

Company: WebMD
Location: Portland
Posted on: March 20, 2023

Job Description:

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 Health Services (WHS) is a division of WebMD whose mission is to provide expert guidance that inspires people to take charge of their health. We do this by helping people understand their health risks, make smart health care decisions, and take active steps toward living healthier lives. Our health, wellness and transparency services power programs from employers, health plans and government organizations are delivered online, onsite, and telephonically. Learn more at webmdhealthservices.com.
WebMD is an Equal Opportunity Employer of Minorities, Females, Protected Veterans, and Individuals with Disabilities.

Position Description: WebMD is looking for a motivated SQL Server Database Administrator to join the Database Operations team. Our primary environment is a VLDB, on-premises MS SQL Server, but some projects may utilize other database products, so a willingness to learn other technologies is highly valued. We are looking for an experienced SQL Server DBA that can install, configure, and maintain mostly virtualized SQL Servers. Other aspects of the job will include requirement gathering, problem solving, troubleshooting / performance tuning, deploying internal scripting packages and working with various teams to keep database operations running smoothly.

Our systems are key here at WebMD Health Services so we are looking for individuals that can take ownership and follow through on problems until they are resolved, big or small.
We offer a competitive compensation package and an engaging company culture working with a team of skilled and invested technology professionals. If you feel that technology should be rewarding and fulfilling as well as challenging and engaging, all while working at a highly respected company, then this is the opportunity for you.

Responsibilities:

• Familiar with basic SQL Server maintenance routines, such as backups, index and statistic maintenance, performance monitoring, etc.
• Responsible for all aspects of database administration for SQL Server including implementation efforts for large and / or complex projects.
• Provide operational excellence as well as efforts for continuous improvement of database related processes and procedures.
• Responsible for ensuring high levels of data availability and database performance.
• Tunes and optimizes SQL Statements, Instance Parameters, and Data Storage, including the identification of performance related issues
• Work in a complex environment with very large, highly secured datasets
• Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data
• Work with multiple teams to deliver top quality solutions
• Work with PowerShell to prepare and deploy database updates (internally developed processes) As a member of WebMD Health Services, you may have access to confidential and sensitive information (including Protected Health Information) that will require you to follow additional protocols to ensure the security of our data. As a core requirement, you must implement and act in accordance with the organization's information security policies; protect assets from unauthorized access, disclosure, modification, destruction, or interference; execute security processes or activities; and report security events or potential events or other security risks to the appropriate parties within the organization.
  
  Required:
  • Minimum of 3 years of SQL Server database administration experience
  • Thorough understanding of T-SQL
  • Experience with some form of HA/DR (replication, mirroring, AG, log shipping, etc.)
  • Experience with query tuning / performance tuning
  • SQL Server 2016 - 2019 experience
  • Experience with SQL backups and other maintenance tasks
  • Comfortable working with PowerShell tool suite
  • SQL Security knowledge
  • A sense of ownership and a desire to make an impact
  • Good interpersonal skills while working with other teams
  • A willingness to create and update department relevant documentation
    Preferred:
    • Experience in SQL Server Replication
    • Experience writing and modifying PowerShell automation scripts (dbatools.io, SMO, etc.)
    • Excellent query tuning skills
    • Previous experience working with VLDB (multi-terabyte tables with billions of rows)
    • SSIS experience
    • Experience with VMware
    • Experience with third party tools such as Grafana, SQLWatch, dbatools, sp_whoisactive, Ola scripts, etc.

Keywords: WebMD, Portland , Database Administrator, IT / Software / Systems , Portland, Oregon