What are the responsibilities and job description for the Senior Database Engineer position at 401 Cast & Crew LLC?
About Us
At Cast & Crew, we’ve empowered creativity and supported the global entertainment industry for decades. Together with our family of brands - Backstage, CAPS, Checks & Balances, Final Draft, Media Services, Sargent-Disc, and The TEAM Companies – we operate as a combined entertainment technology and services provider offering industry standard screenwriting accounting software, digital payroll products, data & reporting, and a host of creative tools. The industry continues to move faster than ever, and the need for our expertise, our technology, and our people has never been greater. We are a production’s best ally every step of the way. #OneCastOneCrew
Job OverviewWe are seeking an experienced and highly skilled Senior Database Engineer to join our dynamic IT organization. This full-time role will play a critical part in designing, managing, and optimizing our database infrastructure to ensure scalability, performance, and reliability. The ideal candidate will bring 5-7 years of hands-on experience in database administration and cloud technologies, with a focus on MSSQL, MySQL, PostgreSQL, and AWS RDS. You will work closely with cross-functional teams to troubleshoot performance issues, architect robust solutions, and contribute to our mission of delivering high-value technical outcomes.
Key Responsibilities
- Administer, maintain, and optimize MSSQL Server, MySQL Server, and PostgreSQL Server environments, ensuring high availability, security, and performance.
- Leverage AWS RDS to manage and support multiple database platforms, including deployment, configuration, and monitoring.
- Utilize deep AWS expertise to architect, deploy, and maintain cloud-based database solutions that align with business needs.
- Perform advanced performance troubleshooting and tuning for MSSQL, MySQL, and PostgreSQL databases to resolve bottlenecks and ensure optimal operation.
- Collaborate with development and operations teams to design and implement scalable database solutions.
- Monitor database health, implement backup and recovery strategies, and ensure data integrity and compliance with organizational standards.
- Provide technical guidance and mentorship to junior team members on database best practices and cloud technologies.
- (Optional) Support Oracle EBS environments, including administration and integration, as needed.
- Document processes, configurations, and troubleshooting steps to maintain a knowledge base for the team.
Required Skills and Qualifications
- Experience: 5-7 years of professional experience in database engineering or administration roles.
- MSSQL Server Administration: Proven expertise in managing, configuring, and optimizing MSSQL Server environments.
- MySQL Server Administration: Strong hands-on experience with MySQL deployment, maintenance, and performance tuning.
- PostgreSQL Server Administration: Demonstrated ability to administer and support PostgreSQL databases effectively.
- AWS RDS Expertise: Extensive experience managing multiple database types (MSSQL, MySQL, PostgreSQL) within AWS RDS.
- AWS Proficiency: Advanced knowledge of AWS services (e.g., EC2, S3, CloudWatch) and their integration with database systems—AWS experience is mandatory.
- Performance Troubleshooting: In-depth skills in diagnosing and resolving performance issues across MSSQL, MySQL, and PostgreSQL databases—expertise in this area is essential.
- Linux Administration: Minimum of 5 years of experience administering Linux server environments (e.g., Ubuntu, CentOS, RHEL), including scripting, system optimization, and security mandatory.
- Experience with automation tools (e.g., Azure DevOps, Terraform, Ansible) for database provisioning and management.
- Oracle EBS Experience: Familiarity with Oracle E-Business Suite administration, configuration, or support is a plus.
- Certifications such as AWS Certified Database – Specialty, Microsoft Certified: Azure Database Administrator Associate, or similar.
- Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent experience).
- Strong problem-solving skills and the ability to work independently or collaboratively in a fast-paced environment.
- Excellent communication skills to interact with technical and non-technical stakeholders.
Special Work Conditions
- Sedentary – Involves sitting most of the time but may involve walking or standing for brief periods of time. Some positions may entail exerting up to 15 lbs. of force occasionally and/or a negligible amount of force to lift, carry, push, or pull.
Benefits
Cast & Crew provides a comprehensive package of employee benefits including: Medical, Dental, Vision, PTO, health and wellness programs, employee discounts, and more! Note: Cast & Crew benefits are subject to eligibility requirements.
Cast & Crew is an equal opportunity employer committed to hiring a diverse workforce and sustaining an inclusive culture. It is our policy to provide equal employment opportunities to all individuals based on job-related qualifications and ability to perform a job, without regard to age, gender, gender identity, sexual orientation, race, color, religion, creed, national origin, disability, genetic information, veteran status, citizenship or marital status, and to maintain a non-discriminatory environment free from intimidation, harassment or bias based upon these grounds.
CA residents
Your personal information may be collected in connection with certain services provided by Cast & Crew or its affiliated companies. A summary of your California privacy rights can be found at: https://www.castandcrew.com/privacy-policy/
Salary : $135,000 - $145,000