Database Administrator

Summary

Join DreamWorks Animation as a Database Administrator and manage SQL & NoSQL databases (Postgres, Couchbase, Cassandra) in Kubernetes and Docker environments. You will oversee the database lifecycle, prioritize production issues, and provide tier-2/tier-3 support. Continuous process improvement and effective multitasking are key responsibilities. You will also participate in tool selection and implementation to enhance performance and recovery. Maintain and improve the team's stateful architecture, and engage with third-party vendors for production support. This fully remote position offers competitive compensation and benefits.

Requirements

• At least 6+ years experience as Database Administrator (DBA)
• NoSQL Expertise is required (ideally, familiarity with Couchbase and/or CassandraDB)
• 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

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)

Preferred Qualifications

• 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

• Fully Remote: This position has been designated as fully remote, meaning that the position is expected to contribute from a non-NBCUniversal worksite, most commonly an employee’s residence
• This position is eligible for company sponsored benefits, including medical, dental and vision insurance, 401(k), paid leave, tuition reimbursement, and a variety of other discounts and perks