Senior Database Engineer

Summary

Join NBCUniversal's Ad Sales Engineering team as a Sr. Database Engineer and design stable, reliable databases. You will develop, test, improve, and maintain databases, ensuring users can retrieve data effectively. Collaborate with developers to maintain system consistency and provide technical support to administrators and clients. Strong communication and problem-solving skills are essential. This fully remote position offers competitive compensation and benefits, including medical, dental, vision insurance, 401(k), paid leave, and tuition reimbursement.

Requirements

• 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
• 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

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

Preferred Qualifications

• Python is nice to have
• Familiarity with developing applications utilizing Scala/Spark
• Experience with orchestration tools - Airflow
• Experience utilizing AWS components, e.g., ECS, ECR, EMR, Glue

Benefits

• Medical, dental and vision insurance
• 401(k)
• Paid leave
• Tuition reimbursement
• A variety of other discounts and perks