SQL Data Admin II

SQL Data Admin II

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 DBA II participates in the design, development, implementation, review, and monitoring of all database environments. The SQL Server DBA II works closely with the software development team, the OLAP team, and the QA team to ensure that each has the environments 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 in production, stage, RC, DR, BC, QA, and development environments.
  • Ensure high availability and meet SLAs for production systems.
  • Design and implement monitoring solutions to achieve HA and SLA goals as set by the director.
  • Monitors and audits corporate DBAs during: change planning, scheduling, tracking, implementation, and follow-up.
  • Reviews and audit all environments for best practices in security.
  • Responsible for the lifecycle of TSQL development (check-in, review, build, testing, and deployment). Including automation where appropriate.
  • Drafts documents with TSQL coding guidelines for developers.
  • Assist developers in best practices for writing queries / procedures.
  • Performs tuning in production to identify performance bottlenecks.
  • Ensure future capacity planning and data system performance in expected tolerances.
  • Designs, develops, and implements ETL jobs based on business requirements.
  • Creates and implements new environments based on the needs of the business.
  • Evaluates new acquisition data systems. Designs and implements plans for assimilation.
  • Designs and implements data systems integration.
  • Works closely with the Director of Data Services through preparation of reports, emails, and correspondence.
  • Manages transactional database engineers.

Qualifications

All candidates must meet the following minimum qualifications:

  • 8 years and above of hands on SQL Server transactional experience.
  • Expert knowledge of all aspects of SQL Server Transact SQL.
  • Profound understanding of SQL Server high availability and disaster recovery technologies, such as backups and restores, log shipping, mirroring, and replication.
  • SQL Server administration skills, such as backups, restores, taking and reverting snapshots, user/role security, access permissions, etc.
  • Extensive experience in SQL performance analysis and optimization (tuning / optimization).
  • In-depth knowledge of tuning SQL Server to achieve the maximum performance possible.
  • Profound understanding of SQL Server concurrency features, transactions, and locking.
  • Excellent data modeling and schema design skills, including normalization and de-normalization.
  • Strong experience with SQL Server debugging and tracing.
  • In-depth knowledge of ETL methodologies.
  • Experience using full text search and XML in SQL Server.
  • Full grasp of the pros and cons of table partitioning and distributed partitioned views.
  • Strong familiarity with data access technologies and protocols, such as ODBC, OLEDB, ADO.NET, LINQ to SQL, Entity Framework, JDBC, Hibernate/NHibernate, etc.
  • Strong familiarity with SQL Server Service Broker, MS Sync Framework, and Master Data Service.
  • Strong familiarity with BI technologies, such as ETL, data warehousing, SSAS/OLAP, data mining, and big data technologies.
  • Strong familiarity with .NET, C#, and CLR objects.
  • Experience using Microsoft TFS to maintain source control and deployment scripts of all DB objects highly preferred.
  • Bachelor degree, preferably in Computer Science or equivalent.

Interested candidates must:

  • Submit a resume/CV through www.nbcunicareers.com to be considered.

Additional Requirements:

  • Must be willing to adhere to all Company COVID-19 workplace safety policies and protocols.

  • In select work settings or where jurisdictionally mandated, must submit an attestation disclosing your COVID-19 vaccination status and be fully vaccinated against COVID-19 or adhere to enhanced protocols.

  • 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.

Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.