Sr SQL Server DBA

US-OR-Portland
5 months ago
Job ID
2017-13060
Category
Technology

Overview

WebMD’s Health Services business enables employers and health plans to provide their employees and plan members with access to personalized health and benefit information, decision support technology that helps them make informed benefit, provider and treatment choices and provides telephonic health coaching services.

 

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status

 

Responsibilities

 Responsibilities may include:

 

  • Maintain a highly available database infrastructure.
  • Perform performance tuning and query optimization.
  • Analyze and author T-SQL code and schema.
  • Build and improve database operational automation.
  • Troubleshoot and resolve database issues - database integrity, performance, resource contention, blocking and deadlock occurrences, replication, connectivity, security, etc.
  • Provide and analyze data to support capacity planning and long-term trend analysis.
  • Expand your skills and be constantly challenged as a key part of a highly functional team.
  • Address production issues outside of working hours in 24x7x365 on-call rotation.

 

Qualifications

 Minimum Qualifications:

  • BS in Computer Science, Engineering or Math or related experience.
  • 6+ years of experience in production support of complex MS SQL Server environments.
  • Expert level troubleshooting and problem resolution with SQL Server 2008+.
  • Proficient in High Availability and BCP concepts, VLDBs, database design concepts and data maintenance.
  • Experience with one or more Windows scripting languages (eg: PowerShell, VB Script)
  • Experience documenting operational processes and procedures; creating KBs, run-books, topology diagrams, etc.
  • Ability to learn and adapt new technologies in a fast-paced environment.
  • Experience in Agile work environment (DevOps Experience a plus)

 

Relevant Technical Skills:

  • Expert-level SQL Server knowledge.
  • Experience building and supporting other RDBMs in a production environment.
  • Performance tuning and query optimization using DMVs, Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
  • Expert-level knowledge of backups, restores, recovery models, database maintenance operations, DBCC commands, and merge replication
  • Proficiency authoring and analyzing T-SQL code and schema (stored procedures, functions, tables, views, triggers, indexes, constraints).
  • Experience with Windows Server
  • Experience with developing and implementing alerting/monitoring methodologies
  • Relevant industry certifications

 

  *As a member of WebMD Health Services, you may have access to confidential 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.