DreamWorks Technology - Database Administrator

$105,000 - $150,000/Yr

NBC - Glendale, CA

Full-time - Mid Level

Glendale, CA

Broadcasting and Content Providers

About the position

The Database Administrator at DreamWorks Animation is responsible for managing SQL and NoSQL databases, ensuring their performance, reliability, and security. This role involves overseeing the lifecycle of database clusters, troubleshooting production issues, and facilitating continuous process improvements within the team. The position requires collaboration with internal support teams and vendors, as well as participation in the evaluation and implementation of database tools to enhance performance monitoring and management.

Responsibilities

• Database administration for SQL & NoSQL DB (Postgres, Couchbase & Cassandra) running in Kubernetes and Docker.
• Managing the life cycle of database clusters (Upgrade & Patching).
• Prioritizing production issues with other internal support teams, support vendors and documenting solutions.
• Work with the team's on-call tier-2/tier-3 break-fix support for production services while adhering to best practices.
• Actively facilitate continuous process improvement within the team.
• Effectively multi-task handling day-to-day duties while receiving minimal direction and supervision.
• Participate in the evaluation, selection, and implementation of DBA tools to improve performance monitoring and tuning, recovery, and database change management processes.
• Maintain and continuously improve team's stateful architecture and systems (legacy and current gen Database-as-a-Service).

Requirements

• Minimum 6+ years experience as Database Administrator (DBA).
• NoSQL Expertise (ideally Couchbase and/or CassandraDB) preferred.
• Managing Postgres databases in production environment is required.
• Experience with managing stateful applications on Kubernetes.
• Solid grasp of distributed systems and stateful applications.
• Experienced at leading performance/scale testing and tuning for relational and NoSQL databases.
• Worked on a production database with rotating on-call support.
• Good understanding of Linux administration with respect to supporting databases.
• Experience engaging with third party vendors for production incidents requiring their support and involvement.
• Sound knowledge of standard methodologies of SDLC as it pertains to data services tasks and schema applications from dev to production roll out.
• Articulate and personable with strong spoken and written language skills.
• Ability to communicate effectively with non-technical audiences.
• Ability to work independently and cross-functionally.
• Responsible, self-motivated, and highly dependable.
• Great teammate with a customer service orientation.
• Ethical, honest, fair and of high integrity.
• Ability to think through problems and visualize solutions.
• Proficient in Unix shell scripting.
• Knowledge of table architecture, index use, query plan analysis, and performance improvement.

Nice-to-haves

• B.S. in Computer Science or equivalent experience.
• Experience with public or private cloud services (AWS, Azure, Google Cloud, OpenStack).
• Familiarity with Storage solutions such as Trident / Portworx.
• Familiarity with SQL & NoSQL databases such as Oracle, Redis & ElasticSearch.
• Familiarity with continuous integration/deployment tools and platforms (Spinnaker, Drone, Jenkins, Ansible, Terraform).
• Natural leadership skills.
• Broad and deep knowledge of operations and relevant technology stacks with an ability to learn quickly.
• Ability and desire to quickly learn new or unfamiliar technology and products using documentation and internet resources.

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• 401(k)
• Paid leave
• Tuition reimbursement
• Variety of discounts and perks