SQL Data Administrator II NBC Sports Next

NBCUniversal; Orlando (FL); On-site; USD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a skilled SQL Database Administrator II to join their team. This exciting fully remote position involves designing, implementing, and maintaining database servers while collaborating closely with software development, data engineering, and QA teams. The ideal candidate will have extensive hands-on experience with SQL Server and a strong understanding of cloud services like AWS. You will play a crucial role in ensuring high availability, optimizing performance, and implementing best practices in database management. If you are passionate about database systems and eager to contribute to a dynamic team, this opportunity is perfect for you.

Qualifications

• 5+ years of SQL Server experience with strong knowledge of TSQL and Power Shell.
• Experience in SQL performance analysis and optimization, along with AWS Cloud Services.

Responsibilities

• Design and maintain database servers across various environments.
• Assist in TSQL development and support SQL CI/CD life cycle.
• Ensure high availability and meet SLAs for database systems.

Skills

SQL Server

TSQL

Power Shell

MySQL

Postgres

AWS Cloud Services

GitHub

SQL performance analysis

Education

Associates degree in Computer Science

Tools

Atlassian Jira

Atlassian Confluence

Job description

Job Description

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.
• Review 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.
• Perform tuning to identify system performance bottlenecks.
• Assist in system capacity planning.
• Create and implement new environments based on the needs of the business.
• Design and implement 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 Cloud 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 non-NBCUniversal worksite, most commonly an employee’s residence.