SQL Data Administrator II

Summary

Join NBCUniversal as a SQL Database Administrator II and participate in the design, development, implementation, review, and monitoring of all database environments. Collaborate with software development, data engineering, and QA teams to ensure efficient operations. This fully remote position requires 5+ years of hands-on SQL Server experience and strong knowledge of MS SQL Server, TSQL, PowerShell, and coding best practices. You will design, implement, and maintain database servers, ensuring high availability and meeting SLAs. Responsibilities include database security reviews, assisting with TSQL development and CI/CD, and performing system tuning and capacity planning. The role also involves creating and implementing new environments and designing data systems integration. Although you'll be hired as an NBCU employee, your employment and the responsibilities associated with this job likely will transition to SpinCo in the future.

Requirements

• At least 5+ years of hands on SQL Server experience
• Strong Knowledge of MS SQL Server, TSQL, Power Shell, and coding best practices
• 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

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

Preferred Qualifications

Knowledge of MySQL & Postgres preferred

Benefits

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