Cast & Crew LLC Logo

Cast & Crew LLC

Principal Database Administrator

Reposted Yesterday
In-Office or Remote
2 Locations
165K-175K Annually
Expert/Leader
In-Office or Remote
2 Locations
165K-175K Annually
Expert/Leader
Lead the design and implementation of high availability and disaster recovery database solutions. Mentor engineers and collaborate on data strategy.
The summary above was generated by AI

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

We are seeking a Principal Database Administrator (DBA) to join our innovative IT organization. This 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.

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. 

  • 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 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.

Top Skills

AWS
Aws Rds
Azure
Linux
Mssql
MySQL
Postgres
Windows

Similar Jobs

5 Minutes Ago
Easy Apply
Remote
2 Locations
Easy Apply
144K-199K Annually
Senior level
144K-199K Annually
Senior level
Artificial Intelligence • Fintech • Machine Learning • Social Impact • Software
As an IT DevOps Engineer, you'll design and implement scalable, secure infrastructure, automate workflows, enhance security, and mentor junior engineers while collaborating with various teams.
Top Skills: AnsibleAWSBashCi/CdCloudFormationGoogle SuiteJAMFOktaPalo Alto FirewallsPythonSlackTerraform
7 Minutes Ago
Remote or Hybrid
4 Locations
73K-189K Annually
Junior
73K-189K Annually
Junior
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
The Neuroscience HSP drives territory sales and develops customer relationships through product promotion and strategic business management, utilizing both in-person and virtual engagements.
Top Skills: Digital ToolsVirtual Tools
7 Minutes Ago
Remote or Hybrid
Illinois, USA
115K-125K Annually
Senior level
115K-125K Annually
Senior level
AdTech • Big Data • Digital Media • Software
The Account Director, Agency Development will manage relationships with digital ad agency buyers, structure deals, and exceed revenue targets for programmatic advertising.
Top Skills: Analytics PlatformExcelGoogle SuiteSalesforce

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account