Job Description

The OSQL Server DBA I, participates in the design, development, implementation, review, and monitoring of all database environments. They work closely with the software development team, the OLAP team, and the QA team to ensure that each has the environments needed to run efficiently and effectively and to provide guidelines and recommendations on best practices in the field. In delivering the key priorities of the role they will; 

• Design, implement, maintain, and monitor database servers in production, stage, RC, DR, BC, QA, and development environments.
• Ensure high availability and meet SLAs for production systems.
• Design and implement monitoring solutions to achieve HA and SLA goals as set by the director.
• Monitor and audit corporate DBAs during: change planning, scheduling, tracking, implementation, and follow-up.
• Review and audit all environments for best practices in security.
• Be responsible for the lifecycle of TSQL development (check-in, review, build, testing, and deployment). Including automation where appropriate.
• Assist developers in best practices for writing queries / procedures.
• Perform tuning in production to identify performance bottlenecks.
• Ensure future capacity planning and data system performance in expected tolerances.
• Design, develop and implement ETL jobs based on business requirements.
• Create and implement new environments based on the needs of the business.
• Evaluate new acquisition data systems. Design and implement plans for assimilation.
• Design and implement data systems integration.
• Work closely with the Data Services through preparation of reports, emails, and correspondence.

Qualifications

• 3 + years of hands on SQL Server transactional experience.
• Knowledge of all aspects of SQL Server Transact SQL.
• Profound understanding of SQL Server high availability and disaster recovery technologies, such as backups and restores, log shipping, mirroring, and replication.
• SQL Server administration skills, such as backups, restores, taking and reverting snapshots, user/role security, access permissions, etc.
• Experience in SQL performance analysis and optimization (tuning / optimization).
• Knowledge of tuning SQL Server to achieve the maximum performance possible.
• Understanding of SQL Server concurrency features, transactions, and locking.
• Strong experience with SQL Server debugging and tracing.
• Knowledge of ETL methodologies.
• Experience using full text search and XML in SQL Server.
• Understanding of the pros and cons of table partitioning and distributed partitioned views.
• Familiarity with BI technologies, such as ETL, data warehousing, SSAS/OLAP, data mining, and big data technologies.
• Experience using Microsoft TFS to maintain source control and deployment scripts of all DB objects highly preferred.
• Bachelor degree, preferably in Computer Science or equivalent.

Interested candidates must;

• Submit a resume/CV through www.nbcunicareers.com to be considered.

Successful candidates will be required to;

• Submit an attestation disclosing COVID-19 vaccination status and, if partially or fully vaccinated, submitting their vaccination record no later than 7 days following commencement of employment.
• Be fully vaccinated against COVID-19 at the commencement of employment or adhere to enhanced protocols if Company determines your job position requires accessing an NBCUniversal worksite.
• Be willing to adhere to all Company COVID-19 workplace safety policies and protocols.

Additional Information

NBCUniversal's 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. NBCUniversal will consider for employment qualified applicants with criminal histories in a manner consistent with relevant legal requirements, including the City of Los Angeles Fair Chance Initiative For Hiring Ordinance, where applicable.

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.com as a result of your disability. You can request reasonable accommodations in the US by calling 1-818-777-4107 and in the UK by calling +44 2036185726.