Sr. Database Engineer
NBCUniversal - Englewood Cliffs, New Jersey, United States, 07632
Work at NBCUniversal
Overview
- View job
Overview
NBCUniversal is one of the world's leading media and entertainment companies. 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. Our impact is rooted in improving the communities where our employees, customers, and audiences live and work. We have a rich tradition of giving back and ensuring our employees have the opportunity to serve their communities. We champion an inclusive culture and strive to attract and develop a talented workforce to create and deliver a wide range of content reflecting our world. Comcast NBCUniversal has announced its intent to create a new publicly traded company ('Versant') comprised of most of NBCUniversal's cable television networks, including USA Network, CNBC, MSNBC, Oxygen, E!, SYFY and Golf Channel along with complementary digital assets Fandango, Rotten Tomatoes, GolfNow, GolfPass, and SportsEngine. The well-capitalized company will have significant scale as a pure-play set of assets anchored by leading news, sports and entertainment content. The spin-off is expected to be completed during 2025. Job Description
The NBCU Ad Sales Engineering team is involved in building world class technical solutions that enables the NBCU Ad Sales to optimize and scale the commercial sales as well as delivery experience for the advertisers and agencies invested in the platform. We are looking for a qualified Sr. Database Engineer to design stable and reliable databases, according to our company's needs. They will be responsible for developing, testing, improving, and maintaining new and existing databases to help users retrieve data effectively. As part of the development team, they will work closely with developers to ensure system consistency. They will also collaborate with other administrators and clients to provide technical support and identify new requirements. Communication and organization skills are key for this position, along with a problem-solving attitude. Ultimately, they should be able to ensure our database systems run effectively and securely. Responsibilities Ensure database structures follow data integrity, performance, security, and ease of maintenance. Optimize and maintain legacy database systems. Well versed with Database Management and Maintenance includes installing, configuring, and maintaining database systems, managing database objects, and performing database housekeeping tasks like tuning and indexing. Monitor database performance, conduct regular performance tuning, and optimize queries for maximum efficiency. Developing and implementing robust backup and disaster recovery strategies Implement security measures, manage user access permissions, and ensure compliance with company cyber policies. Diagnose and troubleshoot database errors, resolve issues, and contribute to continuous improvements. Collaborate closely with developers and database users to understand their needs and provide technical expertise that will improve applications and establish best practices. Create and maintain technical and training database documentation, standards, and policies to ensure consistency and best practices. Stay informed about emerging database technologies and recommend implementations to improve performance and security. Modify databases according to requests and perform tests. Ensure all database programs meet company and performance requirements. Solve database usage issues and malfunctions. Gather user requirements and identify new features. Contribute to development of features using PL/SQL/PostgreSQL Assist with and address where applicable production support issues during business and off business hours. Perform database upgrades/deployments off business hours or over the weekend (if required) either independently or with a team of developers Qualifications
BS degree in Computer Science or a relevant field or equivalent years of experience 5+ years of experience as a Database developer/administrator Experience working with AWS Aurora PostgreSQL database. Experience developing database applications in an AWS environment Experience with Scaling databases/partitioning/debugging performance. Experience utilizing AWS components, e.g., RDS, S3, Secret Manager, IAM, CloudWatch, etc. In-depth understanding of data management (e.g., permissions, recovery, security, and monitoring) Hands-on experience with SQL and PL/pgSQL Experience developing stored procedures/functions/triggers using PL/pgSQL SQL tuning with hands-on experience analyzing query execution plans Cluster/Instance tuning in an AWS Aurora Environment Experience with schema evolution tools like Flyway Experience with Git Excellent analytical and organization skills Problem-solving attitude Excellent verbal and written communication skills Desired Requirements: Python is nice to have ty Familiarity with developing applications utilizing Scala/Spark Experience with orchestration tools - Airflow Experience utilizing AWS components, e.g., ECS, ECR, EMR, Glue. Additional Requirements: 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. Willingness to work overtime and on weekends during key business cycles This position is eligible for company sponsored benefits, including medical, dental and vision insurance, 401(k), paid leave, tuition reimbursement, and a variety of other discounts and perks. Learn more about the benefits offered by NBCUniversal.