SQL Database Admin II - NBC Sports Next
Company Description
NBC Sports Next is where sports and technology intersect. We're a subdivision of NBC Sports and home to all NBCUniversal digital applications in sports and technology within our three groups: Youth & Recreational Sports; Golf; and Betting, Gaming & Emerging Media.
At NBC Sports Next, we make playing sports better through innovative technology and immersive experiences for athletes, coaches, players and fans. 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; GolfNow, the leading online tee time marketplace and provider of golf course operations technology; GolfPass the ultimate golf membership that connects golfers to exclusive content, tee time credits, and coaching, tips; TeamUnify, swim team management services; GoMotion, sports and fitness business software solutions; and NBC Sports Edge, a leading platform for fantasy sports information and betting-focused tools.
At NBC Sports Next we're fueled by our mission to innovate, create larger-than-life events and connect with sports fans through technology that provides the ultimate in immersive experiences.
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.
Come join us as we work together as one team to innovate and deliver what's Next.
Job Description
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.
Qualifications
All candidates must meet the following minimum qualifications:
- At least 5+ years of hands on SQL Server transactional experience.
- Strong Knowledge of SQL Server Transact SQL, Power Shell, and coding best practices.
- Familiarity with BI technologies, such as ETL, data warehousing, SSAS/OLAP, data mining, and big data technologies.
- 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.
- Expert Experience in SQL performance analysis and optimization (tuning / optimization).
- Strong Understanding of SQL Server concurrency features, transactions, and locking.
- Experience with SQL Server debugging and tracing.
- Strong Knowledge of using full text search and XML in SQL Server.
- Familiarity with .NET, C#, and CLR objects.
- Expert Experience using Source Control to maintain scripts of all DB objects highly preferred.
- Associates degree, preferably in Computer Science or equivalent experience.
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.
Additional Information
NBCUniversal's policy is to provide equal employment opportunities to all applicants and employees without regard to race, color, religion, creed, gender, gender identity or expression, age, national origin or ancestry, citizenship, disability, sexual orientation, marital status, pregnancy, veteran status, membership in the uniformed services, genetic information, or any other basis protected by applicable law. NBCUniversal will consider for employment qualified applicants with criminal histories in a manner consistent with relevant legal requirements, including the City of Los Angeles Fair Chance Initiative For Hiring Ordinance, where applicable.
If you are a qualified individual with a disability or a disabled veteran, you have the right to request a reasonable accommodation if you are unable or limited in your ability to use or access nbcunicareers.com as a result of your disability. You can request reasonable accommodations in the US by calling 1-818-777-4107 and in the UK by calling +44 2036185726.