Database Administrator

Comcast Business offers a suite of Connectivity, Communications, Networking, Cybersecurity, Wireless, and Managed Solutions to help global organizations of all sizes prepare for what's next. Powered by the nation's largest Gig-speed broadband network and backed by 24/7 customer support, Comcast Business is the nation's largest technology provider to small businesses and one of the leading service providers to the Enterprise market. Comcast Business has been consistently recognized by industry analysts and associations as a leader and innovator, and one of the fastest growing providers of Ethernet services.

Job Summary
Responsible for coordinating the operation of several complex data base files. Under minimal supervision performs aspects of Database Administration including, hardware and software evaluation and installation, logical and physical database design and implementation, structured testing of database designs, security administration, backup and recovery planning, performance and tuning, research and evaluation of new tools and techniques and development of policies, standards and procedures. Participates with the implementation and support of development systems, QA systems and production systems at data centers, including all network and systems-related infrastructure components. Has in-depth experience, knowledge and skills in own discipline. Usually determines own work priorities. Acts as a resource for colleagues with less experience.

Job Description

Core Responsibilities

• Communicates and understands impact of database changes to affected parties and makes recommendations, as appropriate. Maintains hardware platforms to perform at optimum response, capacity planning and implementation of new databases due to conversions.
• Consults with Project Managers to design appropriate solutions. Assists the development teams with application schema designs and applies best practices.
• Commissions and installs new applications.
• Assists with leading a task force to develop and implement a database that addresses business needs. Advises on new database technologies, trends and features.
• Develops, revises and implements policies, standards, procedures and guidelines necessary to effectively administer the database environment.
• Develops, manages and tests backup and recovery plans.
• Designs/tunes, maintains and supports database systems for highly available, high-volume internet applications.
• Consistent exercise of independent judgment and discretion in matters of significance.
• Regular, consistent and punctual attendance. Must be able to work nights and weekends, variable schedule(s) and overtime as necessary.
• Other duties and responsibilities as assigned.

BDI Core Responsibilities:

• Core DBA Responsibilities include but are not limited to:
  • Database Administration Support: monitor job performance and database servers, optimization
  • Monitor servers (database, admin, lower environment and production)
  • Daily Review of Database and Server Health, sending alerts and notifications to management where appropriate (i.e., M-S 6am EST)
  • Daily Review of DevOps Envt Alerts channel and action taken where needed
  • Create additional Monitoring, Health Checks, and Alerts where needed to proactively seeks issues before they occur
  • Provide Trending of specific issues, identify root cause, and recommend solutions, report out to team monthly
  • Off hours support for Monthly Patching (Weekday evenings, ensure BXT patching is successful and BDI servers rebooted in maintenance window) and other off hours support as needed
  • Database Health
  • Manage/Monitor Production Database health; i.e., Application or SQL Server Instance level. Tasks include but not limited to:
  • Base performance; i.e., index management, blocks, wait type management, sync management, etc.
  • Database storage management
  • Database accessibility/state
  • Manage SQL Instance failovers
  • Monitor Always On latency between primary and secondary replicas
  • Priority is Production, but this applies to all environments in priority order (Production, PreProd/Staging, QA, Development)

Additional Responsibilities:

• Server Health
• Manage/Monitor Production Server health; i.e., OS or Cluster level. Tasks include but not limited to:
• Server performance i.e., CPU, Disk I/O, Network Latency, etc.
• Drive storage management
• Cluster role management
• Server/Cluster accessibility/state
• Manage Node Failover

• Regular, consistent and punctual attendance. Must be able to work nights and weekends, variable schedule(s) and overtime as necessary. Support hours include responding to alerts during off-hours and on weekends, in addition to validating planned maintenance.
• Other duties and responsibilities as assigned.
• Required Skills: Microsoft SQL Server; SQL Server Integration Services (SSIS); Microsoft PowerShell; Python; T-SQL; Automation Solutions; Scripting
• Optional Skills: Oracle Enterprise Manager, Atlassian JIRA; Distributed File System (DFS); FTP Server; GlobalSCAPE: Oracle Business Intelligence (OBI); Tableau, Databricks, AWS, Azure

Employees at all levels are expected to:

• Understand our Operating Principles; make them the guidelines for how you do your job.
• Own the customer experience - think and act in ways that put our customers first, give them seamless digital options at every touchpoint, and make them promoters of our products and services.
• Know your stuff - be enthusiastic learners, users and advocates of our game-changing technology, products and services, especially our digital tools and experiences.
• Win as a team - make big things happen by working together and being open to new ideas.
• Be an active part of the Net Promoter System - a way of working that brings more employee and customer feedback into the company - by joining huddles, making call backs and helping us elevate opportunities to do better for our customers.
• Drive results and growth.
• Respect and promote inclusion & diversity.
• Do what's right for each other, our customers, investors and our communities.

Disclaimer:

• This information has been designed to indicate the general nature and level of work performed by employees in this role. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications.

Skills
Microsoft SQL Server, Microsoft SQL Server Administration, Microsoft SQL Server Management Studio (SSMS), SQL Script, SQL Server Performance Tuning, SQL Server Security, TSQL

Compensation
National Pay Range: $65,965.21 USD-$154,605.96 USD Illinois Pay Range: $70,088.04 USD - $136,053.24 USD Colorado Pay Range: $74,210.86 USD - $142,237.48 USD Hawaii Pay Range: $86,579.34 USD - $129,869.01 USD Washington DC Pay Range: $94,824.99 USD - $142,237.48 USD Maryland Pay Range: $78,333.69 USD - $142,237.48 USD Minnesota Pay Range: $74,210.86 USD - $129,869.01 USD New York Pay Range: $78,333.69 USD - $154,605.96 USD Washington Pay Range: $74,210.86 USD - $148,421.72 USD California Pay Range: $74,210.86 USD - $154,605.96 USD New Jersey Pay Range: $82,456.51 USD - $148,421.72 USD Vermont Pay Range: $78,333.69 USD - $123,684.77 USD

Comcast intends to offer the selected candidate base pay dependent on job-related, non-discriminatory factors such as experience. Base pay is one part of the Total Rewards that Comcast provides to compensate and recognize employees for their work. Most sales positions are eligible for a Commission under the terms of an applicable plan, while most non-sales positions are eligible for a Bonus. Additionally, Comcast provides best-in-class Benefits to eligible employees. We believe that benefits should connect you to the support you need when it matters most, and should help you care for those who matter most. That's why we provide an array of options, expert guidance and always-on tools, that are personalized to meet the needs of your reality - to help support you physically, financially and emotionally through the big milestones and in your everyday life. Please visit the compensation and benefits summary on our careers site for more details.

The application window is 30 days from the date job is posted, unless the number of applicants requires it to close sooner or later.

Education
Bachelor's Degree

While possessing the stated degree is preferred, Comcast also may consider applicants who hold some combination of coursework and experience, or who have extensive related professional experience.

Certifications (if applicable)

Relevant Work Experience
5-7 Years

Comcast is proud to be an equal opportunity workplace. We will consider all qualified applicants for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, genetic information, or any other basis protected by applicable law. Comcast will consider for employment applicants with arrest or conviction records in accordance with the requirements of applicable law, including the San Francisco Fair Chance Ordinance, the Los Angeles Fair Chance Initiative for Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Please note that federal state, or local laws and regulations may restrict or prohibit Comcast from hiring individuals convicted of certain crimes. Additionally, an applicant's criminal history may have a direct, adverse, and negative relationship on the job duties of this position, which may result in the withdrawal of a conditional offer of employment.