Manager, Database Operations

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

Position Overview
The Database Manager is responsible creating and implementing standardized DATA and database management procedures, and the installation, security, migration and upgrading of our databases.
Your primary focus will be to manage and maintain our database applications environment including Oracle, PostgreSQL, and MySQL for our core applications. The role will also design, lead and perform migration efforts to new technologies such as PostgreSQL as well as manage and maintain our global Mongo, SQL Server and MySQL-based applications on-prem and in the cloud both in the US and our India operations.
An outstanding candidate has ability to translate database management expertise into optimal database performance. Extensive knowledge of database architecture and experience in a 24/7 customer facing enterprise organization is a must.

Core Responsibilities Manage and maintain our database applications environment including Oracle, PostgreSQL, MySQL, and Mongo for our core applications. Manage and maintain DATA Support patching cycles for Infrastructure and Oracle CPU patching. Proactively monitor the health of enterprise databases – coordinate and make changes as needed. Database backups, restores, and refreshes. Strong SQL experience, writing and tuning queries based on application requirements. 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. Working knowledge of PL/SQL (designing, developing, and maintaining stored procedures, triggers, and user-defined functions). 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. Develop procedures to ensure data integrity and quality and perform regular audits to ensure data integrity and quality. The position will be part of the on-call rotation and will be expected to respond to critical support issues during non-business hours. Manage Database support relationship. Conduct diagnostic tests and evaluate performance metrics. Prepare and present system performance reports to senior management. Work to control database technology costs throughout the enterprise. Other duties and projects as assigned. Key Qualifications BCS degree or related field, or equivalent work experience. Extensive Postgres database experience, including RDBMS architectures, backups, security, and high availability Advanced proficiency in Structured Query Language (SQL). Advanced analytical, leadership, and problem-solving skills. In-depth hands-on knowledge of database technologies, architecture, and data security. Knowledge of best practices in database management. Enhance the scalability and performance of existing database architecture. Ability to develop database structures and features according to organizational needs. Prior experience hiring, supervising, and/or mentoring database development teams. Adept at data protection by developing data security and restoration policies, procedures, and controls in association with and under the guidance of our ISO. Experience with database maintenance, migration, and software. Experience documenting processes and complying with best practices in database management. Keep up to date with developments and trends in database management. Excellent communication skills with ability to foster and build working relation with all IT colleagues, users, department and executive management, and clients. Must be a self-starter – demonstrates strong follow-up and follow-through ensuring timely completion of resolving technical issues, tasks, and avoid delays in delivery of work product. Demonstrates a continually growing knowledge of Company’s internal business practices, processes, and the daily IT operational needs of the users. Proven ability to effectively document processes, procedures, workflows. Strong Oracle database experience preferred, including RDBMS architectures, backups, security, and high availability 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/

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: $160,000.00 - $175,000.00 per year.