Senior Database Administrator

Webmd Portland , OR 97228

Posted 11 months ago

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.

Description:

As a Sr. Database Administrator, you'll work in a complex and dynamic environment, with a small but very capable team of seasoned database operations veterans, building and supporting platforms that deliver content and services for the Health Services division of WebMD.

What you'll do at WebMD:

  • Maintain a highly available database platform at the multi-terabyte scale

  • 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

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

  • Working knowledge of advanced SQL (CTE, windowing functions, etc.)

  • Experience with one or more Windows scripting languages (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)

  • Ability to lift weight up to 50 pounds

Relevant Technical Skills:

  • Expert-level SQL Server knowledge; experience with PostgreSQL very desirable

  • 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, maintenance commands, and data replication methods

  • Proficiency authoring and analyzing T-SQL code and schema (stored procedures, functions, tables, views, triggers, indexes, constraints)

  • Experience with Windows Server, familiarity with Linux a plus

  • Experience with developing and implementing alerting/monitoring methodologies

  • Relevant industry certifications

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
IMS Sr Database Administrator Remote/Virtual

Unum Group

Posted 3 weeks ago

VIEW JOBS 1/30/2020 12:00:00 AM 2020-04-29T00:00 Job Posting End Date: 01/27 Our Fortune 500 company is driving a digital transformation and looking for forward-thinking innovators to disrupt how our industry thinks about and uses technology. As one of the world's leading employee benefits providers, we help millions of people gain affordable access to benefits that help them protect their families, their finances and their futures. Are you an asker of questions, a solver of problems, and a challenger of the status quo? Our mission is to provide a differentiated customer experience and exceed the expectations people have of technology at any company — not just insurers. We are seeking individuals to join our team of talented IT professionals who share never-ending passion and an unwavering focus on our customer experience. Team members comfortable working in an agile, fast-paced, and delivery-focused environment thrive in our environment where we value an entrepreneurial spirit and those who challenge the status-quo. Unum is changing, and we're excited about what's next. Join us. General Summary: Individuals in the Senior Database Administrator role operate and maintain database environments. Duties include 24x7 support, change implementation and problem diagnosis. They are responsible for ensuring team members meet delivery timeline. Mentors others and acts as subject matter expert for databases. They represent expert level of knowledge and expertise related to database technologies within Unum Group. The Senior Database Administrator is responsible for the management of various databases supporting applications. This position requires both technical level experience and the ability to interact with all levels of users. It will also require user support as needed. Individuals need to have architectural ability (various IT facets) and be a thought leader; able to lead projects. The Senior Database Administrator performs installation, physical design, analysis, monitoring, administration, tuning, and upgrades for large-scale and complex environments and has demonstrated highly proficient foundation with the following aspects: * database performance monitoring * database security & monitoring * database backup & recovery capabilities * database replication capabilities * database high availability capabilities Principal Duties and Responsibilities * Provides leadership, oversight, governance and strategic direction related to the infrastructure software services that are required to enable the delivery of IT services. * Provides technical leadership, oversight, standardization and validation of the effectiveness of the infrastructure systems. * Conducts research and reviews the design and implementation of infrastructure components to validate that they are standards based, high performing, highly available and secure in delivering the required business functionality. * Educates internal and external users of the technologies to continually improve the knowledge and skill-base of the organization to best operate and support the infrastructure services. * Provides financial stewardship by ensuring that operational and application development activities are implemented within financial guidelines prescribed through the services cost and recovery financial model. * Introduces solutions that grow the bottom line and/or increase time to market. * Provides documents with a focus on how infrastructure services will be leveraged in the solution architecture. * Participates in the evaluation and selection of infrastructure services products. * Works closely with enterprise architects to support alignment of plans with deliverables. * Supports governance based on best practices and ensures alignment to projects and major initiatives. * Leads analysis of the current environment to detect critical deficiencies and recommends solutions for improvement. * Leads analysis of technology industry and market trends to determine their potential impact on the infrastructure architecture. * Supports solution and domain architecture by providing current environment status in terms of technology, software and infrastructure for projects in the delivery life cycle. * Utilizes capability modeling to align systems strategy and planning with business strategy and goals. * Promotes the benefits of infrastructure services to the organization educate the team on infrastructure concepts. * Consults with project teams to identify when to modify infrastructure services to accommodate project needs. * Consults with architecture teams to identify when to modify the technical architecture to accommodate infrastructure needs. * Oversees the documentation of all architecture design and analysis work. Job Specifications * Bachelors degree in computer science, or equivalent relevant business experience * Has 6+ years of related work experience * Industry certification is a plus * Excellent ability to leverage scripting and other tools to automate routine tasks * Through product research and personal experience, able to articulate strategy for appropriating various software and technologies to meet long range computing requirements * Has experience with serverless cloud-based databases such as Azure SQL or AWS Aurora * Has experience in cloud scripting skills * Has a general awareness of cloud setup and options for using various database services (SQL or NoSQL) * Has experience migrating on premise databases to the cloud * Has good human relations skills; able to work productively in team setting * Excellent ability to drive resolution of highly complex technical problems * Excellent ability to effectively summarize and clearly communicate software/hardware problems involving multiple support team(s) * Organized, able to follow through and complete projects with minimal supervision * Systematic, technically curious, self-motivated and able to work independently without direct supervision * Must be comfortable in a fast paced, multiple priority environment * Excellent ability to prioritize and divide time between multiple projects * Demonstrates excellent written and verbal communications skills; able to communicate effectively with systems associates at all levels * Excellent ability to communicate with multiple levels of organizational leadership and deliver impactful presentations * Able to collaborate with and influence others in IT for requirements on the topic of expertise * DB2 for z/OS * DB2 Catalog knowledge [Basic catalog table familiarity, ability to perform querying of dependencies, understanding of DB2 security administration including Grants, Revokes, and a basic knowledge of required authorities for application development including Bind, Plans, Packages, Stored Procedures, and Database level authorities permitting utilities, tablespace and table creation] * Familiarity with DB2 Utility JCL, execution, restart, an understanding of utility impact on DB2 object availability, and Database backup and recovery techniques. * Understanding of DB2 Data Definition Language [DDL] constructs is required and experience with DB2 Administration tool or similar tool is a plus. * Knowledge of SQL and basic DB2 development techniques used in application coding. Ability to understand COBOL and SQL/PL for analysis and partnering with application area personnel. * IMS for z/OS * Knowledge of IMS Database Manager, DBD source and generation, understanding of Database Recovery Control [DBRC] information and commands, BMP and basic DL/I coding imbedded in COBOL source. * Familiarity with IMS Transaction Manager, including basic control region and message region processing, PSB coding and generation, and ACB, MODBLKS, and FORMAT generation. FORMAT coding is a plus, but not required. A basic knowledge of Control Region commands for monitoring Sub-systems, Regions, Databases, and Transaction Queues is required. * Familiarity with IMS Utility JCL, execution, restart, commands for Database allocation changes, and IMS Database backup and recovery techniques. * z/OS, TSO, ISPF, JCL, and SDSF * Coding and debugging z/OS mainframe batch jobs, the applicant's work and for application development team members needing assistance is required. JCL knowledge is a must as is basic ISPF menu and TSO development experience. * Familiarity with RACF, rules protecting datasets, and how RACF interacts with both IMS and DB2 instances is a plus. * Knowledge of source code editor commands, library maintenance, ISPF menus, listing of cataloged dataset information, TSO job scheduling, and the ability to read JES output from jobs to diagnose issues is required. Experience with System Display and Search Facility [SDSF] or other z/OS JES output control facility is a plus. #LI-JG ~IN-1 Our company is built on helping individuals and families, and this starts with our employees. We want employees to maintain a positive balance, which is why we provide access to the benefits and resources they need to invest in themselves. From our onsite fitness facilities and generous paid time off to employee professional development programs, we are committed to helping employees live and work their best – both inside and outside the office. Unum is an equal opportunity employer, considering all qualified applicants and employees for hiring, placement, and advancement, without regard to a person's race, color, religion, national origin, age, genetic information, military status, gender, sexual orientation, gender identity or expression, disability, or protected veteran status. Company: Unum Unum Group Portland ME

Senior Database Administrator

Webmd