SQL Data Administrator II - NBC Sports Next

NBC Sports Group; Orlando (FL); Remote; USD 80,000 - 110,000; Full time

Job summary

An innovative company is seeking a SQL Database Administrator II to enhance database environments and ensure optimal system performance. In this fully remote role, you'll collaborate with development and engineering teams to design and implement robust database solutions. Your expertise in SQL Server, TSQL, and AWS Cloud Services will be essential in maintaining high availability and meeting service level agreements. This position offers a unique opportunity to contribute to a dynamic team committed to leveraging technology in the sports and entertainment sectors, making a significant impact on how fans engage with their favorite sports.

Qualifications

• 5+ years of SQL Server experience with strong TSQL and Power Shell knowledge.
• Familiarity with AWS services and CI/CD pipelines using GitHub.

Responsibilities

• Design, implement, and maintain database servers across various environments.
• Ensure high availability and meet SLAs for systems.
• Assist in TSQL development and SQL CI/CD lifecycle support.

Skills

SQL Server

TSQL

Power Shell

MySQL

Postgres

AWS Cloud Services

GitHub

SQL performance analysis

Education

Associates degree in Computer Science

Tools

Atlassian Jira

Atlassian Confluence

Job description

SQL Data Administrator II - NBC Sports Next

• Full-time
• Business Segment: SpinCo DTC Sports & Entertainment

We create world-class content, which we distribute across our portfolio of film, television, and streaming, and bring to life through our theme parks and consumer experiences. We own and operate leading entertainment and news brands, including NBC, NBC News, MSNBC, CNBC, NBC Sports, Telemundo, NBC Local Stations, Bravo, USA Network, and Peacock, our premium ad-supported streaming service.

Here you can be your authentic self. As a company uniquely positioned to educate, entertain and empower through our platforms, Comcast NBCUniversal stands for including everyone. Our Diversity, Equity and Inclusion initiatives, coupled with our Corporate Social Responsibility work, is informed by our employees, audiences, park guests and the communities in which we live. We strive to foster a diverse, equitable and inclusive culture where our employees feel supported, embraced and heard.

SPORTS NEXT

NBC Sports Next is where sports and technology intersect. We’re fueled by our mission to innovate, create larger-than-life events and connect with sports fans through technology. We’re a subdivision of NBC Sports and home to leading technology platforms and digital applications for Youth & Recreational Sports; Golf; and Emerging Media.

At NBC Sports Next, we equip more than 30MM players, coaches, athletes, sports administrators and fans in 40 countries with more than 25 sports solution products, including SportsEngine, the largest youth sports club, league and team management platform; SportsEngine Play, the first ever streaming service for youth and amateur sports; GolfNow, the leading online tee time marketplace and provider of golf course operations technology; and GolfPass, the ultimate golf membership that connects golfers to exclusive content, tee time credits, instructional content and more.

GOLF

Golf fuses the team behind products and services like GolfNow, TeeOff and GolfPass, which better connects golfers and golf facilities around the world through innovative solutions like cloud-based golf course management and SmartPlay contactless technology and services that create optimum golfing experiences.

The SQL Database Administrator II participates in the design, development, implementation, review, and monitoring of all database environments. The SQL Database Administrator II will work closely with the software Development, Data Engineering, and QA teams to ensure that each team has the resources needed to run efficiently and effectively and to provide guidelines and recommendations on best practices in the field.

Responsibilities

• Design, implement, maintain, and monitor database servers across environments including but not limited to Production, QA, and Development Environments.
• Ensure High Availability and meet SLAs for systems across environments.
• Design and implement monitoring solutions to achieve HA and SLA goals.
• Review and audit all environments for best practices in security.
• Assist in TSQL development (check-in, review, build, testing, and deployment) and support of SQL CI/CD life cycle.
• Assist developers in best practices for writing queries / procedures.
• Perform tuning to identify system performance bottlenecks.
• Assist in system capacity planning.
• Create and implement new environments based on the needs of the business.
• Design and implement data systems integration.

Minimum Qualifications:

• At least 5+ years of hands-on SQL Server experience.
• Strong knowledge of MS SQL Server, TSQL, Power Shell, and coding best practices.
• Knowledge of MySQL & Postgres preferred.
• Strong knowledge of AWS Cloud Service(s) such as RDS and EC2.
• Experience using Source Control (GitHub) to maintain scripts and CI/CD pipelines (GitHub Actions) of databases throughout SDLC.
• Strong understanding of SQL Server high availability and disaster recovery technologies, such as availability groups, backups and restores, FCI, log shipping, mirroring, and replication.
• Strong SQL Server administration skills, such as backups, restores, taking and reverting snapshots, user/role security, access permissions, etc.
• Understanding of SQL Server concurrency features, transactions, and locking.
• Experience with SQL Server debugging and tracing.
• Experience using full text search and XML in SQL Server.
• Experience in SQL performance analysis and optimization (tuning / optimization).
• Associates degree, preferably in Computer Science or equivalent experience.
• Experience using Atlassian Jira & Confluence.

Fully Remote: This position has been designated as fully remote, meaning that the position is expected to contribute from a non-NBCUniversal worksite, most commonly an employee’s residence.