Principal Database Administrator at Cast & Crew

Burbank, California, United States

Cast & Crew Logo
Not SpecifiedCompensation
Senior (5 to 8 years), Expert & Leadership (9+ years)Experience Level
Full TimeJob Type
UnknownVisa
Entertainment, TechnologyIndustries

Requirements

  • 10+ years of principal-level experience in database architecture, data engineering, or related roles, with a focus on strategic design and implementation
  • Expert-level skills in designing and administering MSSQL Server environments for HA and DR
  • Proven expertise in architecting MySQL solutions with a focus on performance, scalability, and resilience
  • Deep experience designing and managing PostgreSQL databases for enterprise-grade reliability and recovery
  • Extensive experience architecting and managing multiple database types (MSSQL, MySQL, PostgreSQL) within AWS RDS for optimal HA and DR
  • 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 expertise (implied for MSSQL, MySQL, and PostgreSQL)
  • Proficiency in Windows and Linux administration
  • Expertise in Oracle EBS environments for architecture and integration

Responsibilities

  • Architect and design strategic database solutions using PostgreSQL Server, MSSQL Server, MySQL Server, and modern database platforms, 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
  • Provide 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

Skills

MSSQL
MySQL
PostgreSQL
AWS RDS
Windows
Linux
High Availability
Disaster Recovery
Database Architecture
Scalability

Cast & Crew

Digital solutions for entertainment production management

About Cast & Crew

Cast & Crew provides a range of digital solutions tailored for the entertainment industry, focusing on production management for film, television, and live events. Their tools help streamline administrative tasks such as payroll, human resources, and production management, making it easier for production companies, studios, and independent filmmakers to operate efficiently. The company's offerings include payroll management tools, purchase order management, screenwriting software, and digital onboarding solutions, all designed to simplify complex processes. Unlike many competitors, Cast & Crew emphasizes a comprehensive suite of services that integrate various aspects of production management, ensuring accurate and timely payments, efficient document handling, and insightful data reporting. The goal of Cast & Crew is to enhance the operational efficiency of entertainment productions while supporting the industry, including initiatives for the Canadian entertainment sector.

Burbank, CaliforniaHeadquarters
1976Year Founded
ACQUISITIONCompany Stage
Data & Analytics, Enterprise Software, EntertainmentIndustries
1,001-5,000Employees

Benefits

PTO
Family-leave time off
401(K)
Hybrid & remote work flexibility
Health, dental, & vision insurance
Employee referral program
Tuition reimbursement
Health and wellness programs

Risks

Shift towards blockchain solutions may disrupt traditional services like Cast & Crew.
WGA strike in 2023 causes production delays, impacting Cast & Crew's revenue.
AI-driven scriptwriting tools threaten traditional software like Final Draft.

Differentiation

Cast & Crew offers 24/7 online support and electronic payroll interfacing.
PSL3 software integrates internet convenience into production accounting.
Cast & Crew's staff expertise is a hallmark of their service quality.

Upsides

Increased demand for remote production tools boosts Cast & Crew's digital solutions.
Expansion of tax incentive programs enhances demand for tax credit management services.
Rise of independent creators increases need for scalable production management solutions.

Land your dream remote job 3x faster with AI