SQL Data Administrator II - NBC Sports Next

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 (checkin 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 :

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 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 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 nonNBCUniversal worksite most commonly an employees residence.

Additional Information :

As part of our selection process external candidates may be required to attend an inperson interview with an NBCUniversal employee at one of our locations prior to a hiring decision. NBCUniversals 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.  

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 as a result of your disability. You can request reasonable accommodations by emailing

Although youll be hired as an NBCU employee your employment and the responsibilities associated with this job likely will transition to SpinCo in the future. By joining at this pivotal time youll be a part of this exciting company as it takes shape.

For LA County and City Residents Only:  NBCUniversal will consider for employment  qualified applicants with criminal histories or arrest or conviction records in a manner  consistent with relevant legal requirements including the City of Los Angeles Fair Chance Initiative For Hiring Ordinance the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act where applicable.

Remote Work :

Yes

Employment Type :

Fulltime