Senior Database Engineer

Summary

Join NBCUniversal's Ad Sales Engineering team as a Sr. Database Engineer and build world-class technical solutions. You will design, develop, test, and maintain databases, ensuring data integrity, performance, and security. Collaborate with developers and users to optimize systems and troubleshoot issues. Responsibilities include database management, performance tuning, backup/recovery strategies, security implementation, and documentation. The ideal candidate possesses a BS in Computer Science or equivalent experience, 5+ years of relevant experience, and expertise in AWS Aurora PostgreSQL, SQL, and PL/pgSQL. This fully remote position offers competitive benefits, including medical, dental, vision, 401k, 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

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