Company Description
COMPANY DESCRIPTION -
We create world-class content, which we distribute across our portfolio of film, television, and streaming, and bring to life through our theme parks and consumer experiences. We own and operate leading entertainment and news brands, including NBC, NBC News, MSNBC, CNBC, NBC Sports, Telemundo, NBC Local Stations, Bravo, USA Network, and Peacock, our premium ad-supported streaming service. We produce and distribute premier filmed entertainment and programming through Universal Filmed Entertainment Group and Universal Studio Group, and have world-renowned theme parks and attractions through Universal Destinations & Experiences. NBCUniversal is a subsidiary of Comcast Corporation.
Here you can be your authentic self. As a company uniquely positioned to educate, entertain and empower through our platforms, Comcast NBCUniversal stands for including everyone. Our Diversity, Equity and Inclusion initiatives, coupled with our Corporate Social Responsibility work, is informed by our employees, audiences, park guests and the communities in which we live. We strive to foster a diverse, equitable and inclusive culture where our employees feel supported, embraced and heard. Together, we'll continue to create and deliver content that reflects the current and ever-changing face of the world.
SPORTS NEXT
NBC Sports Next is where sports and technology intersect. We're fueled by our mission to innovate, create larger-than-life events and connect with sports fans through technology. We're a subdivision of NBC Sports and home to leading technology platforms and digital applications for Youth & Recreational Sports; Golf; and Emerging Media.
At NBC Sports Next, we equip more than 30MM players, coaches, athletes, sports administrators and fans in 40 countries with more than 25 sports solution products, including SportsEngine , the largest youth sports club, league and team management platform; SportsEngine Play , the first ever streaming service for youth and amateur sports, GolfNow , the leading online tee time marketplace and provider of golf course operations technology; and GolfPass the ultimate golf membership that connects golfers to exclusive content, tee time credits, instructional content and more.
GOLF
Golf fuses the team behind products and services like GolfNow , TeeOff and GolfPass , which better connects golfers and golf facilities around the world through innovative solutions like cloud-based golf course management and SmartPlay contactless technology and services that create optimum golfing experiences.
Job Description
Role Description
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 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.
- 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.
- Assist in system capacity planning.
- Creates and implements new environments based on the needs of the business.
- Asist in Project, Capacity, and Infrastructure Planning
- Mentor & lead team members in best practices for administration and development.
Qualifications
Requirements:
- At least 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 Clouds Service(s) such as RDS and Redshift.
- 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.
- Strong Understanding of SQL Server concurrency features, transactions, and locking.
- Expert Experience in SQL performance analysis and optimization (tuning / optimization).
- Experience with SQL Server debugging and tracing.
- Experience using Atlassian Jira & Confluence
- Familiarity with BI technologies, such as ETL, data warehousing, SSAS/OLAP, data mining, and big data technologies.
- Associates degree, preferably in Computer Science or equivalent experience.
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.
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 by emailing [email protected].
What We Do
From film, television, news, theme parks, interactive media, and streaming, our people are at the center of it all. Here, we solve complex and business-critical problems. That’s why we’re looking for people to help us continue our evolution, imagining and delivering the most innovative and disruptive products and services through the latest tech advancements in the industry.
Here you can develop solutions. You’ll develop solutions that allow engineers to broadcast live TV from the comfort of their homes. These solutions will enable the use of our collection of hundreds of thousands of distinct intellectual properties across our film, television and streaming brands.
Here you can transform. You’ll make decisions and solve complex problems by leveraging insights that come from data, building AI to help enable solutions to optimize every aspect of our content eco-system.
Here you can build. You’ll build emerging immersive technologies that are used to power the broadcasts and streaming of global events like the Super Bowl and Olympics. You can create secure, elastic cloud-based services connecting parts of our global platform ecosystem that effect tens of millions of viewers, consumers and businesses that consume and love NBCUniversal’s content. And while you design, build and architect your career, we have the culture to make sure you’re supported.
Here you can work and still live your best life!
We’re leaders in our fields. We hire smart people and trust them to get the job done. We are never too busy to develop a fellow colleague. We understand our goals – or we ask. When we see something that needs doing – we do it. We make data-driven decisions. We fiercely believe in our talent and their growth. If you're ready to make an impact, here you can.
Why Work With Us
For us, it's more than just a work life. It's a daily passion. We take great pride in our legacy. We find fun in the challenge. We collaborate and inspire others. We're always creating, always solving and always ahead of competition.
Gallery
NBCUniversal Teams
NBCUniversal Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.