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
About Cast & Crew
We grew from a modest small business in 1976 to be the premiere provider of entertainment technology and solutions, staying true to our mission of modernizing content production and leading the digital transformation within the industry. Our cloud-based solutions and industry expertise help streamline the entire production lifecycle and have revolutionized how content is made. We now have a global workforce across a host of storied brands, spanning all areas of produced and live entertainment, from film, television, streaming, to advertising, live events, and short-form.
Sr. Database Administrator (DBA)
Regular Full-Time
Position Overview
The Sr. Database Administrator (DBA) is responsible for the operational support of our database environments. The role supports our PostgreSQL, Oracle & Oracle Financial Accounting System (e-Business Suite Release 12), MS SQL Server, MySQL, and MongoDB based applications on-prem and in the cloud.
Core Responsibilities
- Proactively monitor the health of enterprise databases – coordinate and make changes as needed.
- Database backups, restores, and refreshes.
- Document processes and complying with best practices in database management.
- Develop procedures to ensure data integrity and quality.
- Conduct diagnostic tests and evaluate performance metrics.
- Enhance the scalability and performance of existing database architecture.
- Support patching cycles for Infrastructure and DB patching.
- Develop database structures and features according to organizational needs.
- Prepare and present system performance reports to senior management.
- Protect data by developing data security and restoration policies, procedures, and controls in association with and under the guidance of our ISO.
- Perform database maintenance, migration, and software.
- Train new hires, and mentor database development teams.
- Participate on development teams providing advice on design and tuning of database objects, queries, and overall data architecture.
- Use of tools and utilities to load and unload data, generate, and edit test data.
- Work with the various technology and business teams to ensure that the associated hardware resources are allocated to the databases and to ensure high availability and optimum performance.
- Provide trend analysis to the operations team to enable them to make informed decisions regarding resource management.
- Provide query and performance expertise in support of code development.
- Monitor long running transactions and can optimize query executions.
- Problem escalation to development team and third parties as appropriate.
- Implementation and release of database changes as submitted by the development team.
- Documenting technical environments and processes.
- Perform regular audits to ensure data integrity and quality.
- Respond to critical support issues during non-business hours as part of the on-call rotation.
- Builds excellent working relations with all IT colleagues and users, works effectively with department and executive management, and maintains a professional relationship with outside clients.
- Work to control database technology costs throughout the enterprise.
- Other duties as assigned.
Key Qualifications
- Strong PostgreSQL database experience, including RDBMS architectures, backups, security, and high availability – minimum 4+ years’ experience.
- Strong SQL experience, writing and tuning queries based on application requirements.
- Advanced proficiency in Structured Query Language (SQL) preferred.
- Advanced analytical, leadership, and problem-solving skills.
- Ability to effectively document processes, procedures, and workflows.
- In-depth hands-on knowledge of database technologies, architecture, and data security.
- Knowledge of best practices, trends, and developments in database management.
- Demonstrates strong follow-up and follow-through skills in ensuring timely completion of tasks.
- Working knowledge of PL/SQL (designing, developing, and maintaining stored procedures, triggers, and user-defined functions).
- Self-starter who proactively resolves technical problems or escalates to avoid major delays in delivery of work product.
- Ability to work occasional on-call rotation during non-business hours to respond to critical support issues.
- Experience with AWS, Azure DevOps.
- Oracle & Oracle Financial Accounting System (e-Business Suite Release 12) preferred
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.
Compensation is commensurate with various factors including, but not limited to, relevant experience, qualifications, skills, training, licensure, certifications, geographic cost of labor, and other business and organizational needs. Compensation range for candidates in other locations may differ based on the cost of labor in that location.
The compensation range for this position is:
$120,000—$150,000 USD
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.
Due to the high volume of applicants, it is likely that only shortlisted candidates will be contacted.
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/
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.
