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. The Sr. SQL Data DBA will work closely with the Software Development, Data Engineering, and QA teams. This includes providing guidelines and recommendations on best practices.

Responsibilities

• Design, implement, maintain, and monitor database servers across environments (Production, QA, Development).
• Ensure High Availability and meet SLAs for systems.
• Design and implement monitoring solutions for HA and SLA goals.
• Review and audit all environments for security best practices.
• 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.
• Assist in system capacity planning.
• Create and implement new environments based on business needs.
• Assist in Project, Capacity, and Infrastructure Planning
• Mentor & lead team members in best practices for administration and development.

Requirements

• 10+ years of hands-on SQL Server transactional experience.
• Strong Knowledge of MS SQL Server, TSQL, Power Shell, and coding best practices.
• Strong Knowledge of MySQL & Postgres preferred.
• Strong Knowledge of AWS Cloud Services (RDS, Redshift).
• Experience with Source Control (GitHub) for database scripts and CI/CD pipelines (GitHub Actions).
• Strong Understanding of SQL Server HA and DR technologies (availability groups, backups/restores, FCI, log shipping, mirroring, replication).
• Strong SQL Server administration skills (backups, restores, snapshots, user/role security, access permissions).
• Strong Understanding of SQL Server concurrency, transactions, and locking.
• Expert experience in SQL performance analysis and optimization (tuning).
• 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).
• Associates degree in Computer Science or equivalent.
• Fully Remote Position

What is the last date for applying to the job?

Which countries are accepted for this remote job?