Sr. Database Engineer
Apply NowLocation:
Englewood Cliffs, NJ, US
Company:
NBCUniversal is a premier media and entertainment company producing content across various platforms, including film, television, and streaming services.
Summary:
The Sr. Database Engineer will design and maintain stable and reliable databases, ensuring optimal performance and security. Applicants need a BS in Computer Science or related field and 5+ years of experience in database development/administration.
Requirements:
Technology: AWS Aurora PostgreSQL, PL/SQL, AWS components (RDS, S3, IAM, etc.)
Hard Skills: Database Management, Database Maintenance, Performance Tuning, Backup and Disaster Recovery, User Access Management, Data Security
Credentials: BS degree in Computer Science or relevant field
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, Hands-on experience with SQL and PL/pgSQL, SQL tuning with hands-on experience analyzing query execution plans, Cluster/Instance tuning in an AWS Aurora Environment
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