Senior Database & Data Architect

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 Overview
We are seeking a seasoned Senior Database & Data Architect with principal-level experience to join our innovative IT organization. This full-time role will lead the design, architecture, and strategic implementation of database systems, focusing on high availability (HA), disaster recovery (DR), and scalability to support our business objectives. The ideal candidate brings 10+ years of deep expertise in database architecture, administration, and cloud technologies, with a proven track record in MSSQL, MySQL, PostgreSQL, and AWS RDS. Proficiency in Windows and Linux administration is essential, as is the ability to craft robust, forward-thinking data solutions. You will collaborate with cross-functional teams to shape our data strategy, mentor engineers, and ensure our database infrastructure aligns with long-term organizational goals.

Key Responsibilities 

• Architect and design strategic database solutions using MSSQL Server, MySQL Server, and PostgreSQL Server, emphasizing high availability, disaster recovery, and scalability. 
• Lead the implementation of AWS RDS for multiple database platforms, ensuring optimal configuration, performance, and resilience in cloud environments. 
• Develop and execute comprehensive HA and DR strategies, including failover mechanisms, replication, and backup/recovery processes, to minimize downtime and data loss. 
• Leverage advanced Azure and AWS expertise to design cloud-native database architectures that integrate seamlessly with broader infrastructure and business needs. 
• Provide principal-level guidance on performance troubleshooting and optimization for MSSQL, MySQL, and PostgreSQL databases, resolving complex issues with strategic insight. 
• Oversee the administration and optimization of Windows and Linux server environments hosting database systems, ensuring stability and security. 
• Collaborate with stakeholders to define data architecture standards, policies, and best practices that drive efficiency, reliability, and innovation. 
• Mentor and guide technical teams on database design, cloud adoption, and system administration, fostering a culture of excellence and continuous improvement. 
• Expertise to Oracle EBS environments, advising on architecture and integration as needed. 
• Document architectural designs, strategic plans, and operational processes to support knowledge sharing and compliance. 

Required Skills and Qualifications 

• Experience: 10+ years of principal-level experience in database architecture, data engineering, or related roles, with a focus on strategic design and implementation. 
• MSSQL Server Architecture: Expert-level skills in designing and administering MSSQL Server environments for HA and DR. 
• MySQL Server Architecture: Proven expertise in architecting MySQL solutions with a focus on performance, scalability, and resilience. 
• PostgreSQL Server Architecture: Deep experience designing and managing PostgreSQL databases for enterprise-grade reliability and recovery. 
• AWS RDS Expertise: Extensive experience architecting and managing multiple database types (MSSQL, MySQL, PostgreSQL) within AWS RDS for optimal HA and DR. 
• Azure and AWS Proficiency: Advanced knowledge of Azure Services, AWS services (e.g., EC2, S3, CloudWatch, Route 53) and their application in data architecture—AWS experience is mandatory. 
• Performance Troubleshooting: Strategic expertise in diagnosing and optimizing database performance across MSSQL, MySQL, and PostgreSQL—essential for this role. 
• Windows Administration: Minimum of 5 years of experience architecting and administering Windows Server environments, with a focus on database hosting mandatory. 
• Linux Administration: Minimum of 5 years of experience architecting and administering Linux server environments (e.g., Ubuntu, CentOS, RHEL) for database systems mandatory. 
• High Availability & Disaster Recovery: Demonstrated success in designing and implementing HA/DR solutions, including clustering, replication, and recovery planning. 
• Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent experience). 
• Exceptional problem-solving skills, strategic thinking, and the ability to lead in a collaborative, fast-paced environment. 
• Strong communication skills to articulate complex technical concepts to technical and executive audiences. 
• Oracle EBS Experience: Familiarity with Oracle E-Business Suite architecture, configuration, or support is a plus. 
• Certifications such as AWS Certified Solutions Architect, AWS Certified Database – Specialty, or TOGAF. 
• Experience with data modeling, ETL processes, or big data technologies (e.g., Hadoop, Snowflake). 
• Proficiency with infrastructure-as-code tools (e.g., Azure DevOps, Terraform, CloudFormation) for database and server automation.

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