Full-Time Sr. SQL Data DBA - NBC Sports Next

The Sr. SQL Data DBA participates in the design, development, implementation, review, and monitoring of all on-premises and cloud database environments.

Works closely with Software Development, Data Engineering, and QA teams to ensure efficiency and provide best practices.

Responsibilities:

1. Design, implement, maintain, and monitor database servers (Production, QA, Development).
2. Ensure High Availability and meet SLAs for systems across environments.
3. Design and implement monitoring solutions for HA and SLA goals.
4. Review and audit all environments for security best practices.
5. Assist in T-SQL development (check-in, review, build, testing, and deployment) and support of SQL CI/CD lifecycle.
6. Assist developers in best practices for writing queries/procedures.
7. Assist in system capacity planning.
8. Create and implement new environments based on business needs.
9. Assist in Project, Capacity, and Infrastructure Planning.
10. Mentor & lead team members in best practices.

Requirements:

• 10+ years hands-on SQL Server transactional experience.
• Strong knowledge of MS SQL Server, T-SQL, Power Shell, and coding best practices.
• Strong knowledge of MySQL & Postgres (preferred).
• Strong knowledge of AWS Cloud Services (RDS, Redshift).
• Experience using Source Control (GitHub) for scripts and CI/CD pipelines (GitHub Actions).
• Strong understanding of SQL Server high availability and disaster recovery technologies.
• Strong SQL Server administration skills (backups, restores, snapshots, user/role security, permissions).
• Strong understanding of SQL Server concurrency features, transactions, and locking.
• Expert experience in SQL performance analysis and optimization.
• Experience with SQL Server debugging and tracing.
• Experience with Atlassian Jira & Confluence.
• Familiarity with BI technologies (ETL, data warehousing, SSAS/OLAP, data mining, big data).
• Associate's degree (Computer Science preferred) or equivalent experience.

Fully Remote Position:

This position is fully remote and will be expected to contribute from a non-NBCUniversal worksite, primarily an employee's residence.

Important Note: External candidates may be required to attend an in-person interview at an NBCUniversal location prior to a hiring decision.

What is the last date for applying to the job?

Which countries are accepted for this remote job?