Sr. Database Engineer

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 by visiting the Benefits page of the Careers website. Salary range: $115,000- $145,000.

We are accepting applications for this position on an ongoing basis.

Additional Information

As part of our selection process, external candidates may be required to attend an in-person interview with an NBCUniversal employee at one of our locations prior to a hiring decision. 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.

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].

For LA County and City Residents Only:  NBCUniversal will consider for employment  qualified applicants with criminal histories, or arrest or conviction records, in a manner  consistent with relevant legal requirements, including the City of Los Angeles' Fair Chance Initiative For Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers, and the California Fair Chance Act, where applicable.