SQL Data Administrator II - NBC Sports Next Job at NBC Sports Group in Orlando

SQL Data Administrator II - NBC Sports Next

• Full-time
• Business Segment: NBC Sports

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. NBCUniversal is a subsidiary of Comcast Corporation.

SPORTS NEXT

NBC Sports Next is where sports and technology intersect. We’re a subdivision of NBC Sports and home to leading technology platforms and digital applications for Youth & Recreational Sports; Golf; and Emerging Media.

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.
• Reviews 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.
• Performs tuning to identify system performance bottlenecks.
• Assist in system capacity planning.
• Creates and implements new environments based on the needs of the business.
• Designs and implements data systems integration.

Minimum Requirements

• 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 Clouds 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.
• Strong SQL Server administration skills.
• Understanding of SQL Server concurrency features, transactions, and locking.
• Experience with SQL Server debugging and tracing.
• Experience in SQL performance analysis and 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.