Sr. Snowflake Admin

**_Welcome to Warner Bros. Discoverythe stuff dreams are made of._**

**Who We Are **

When we say, “the stuff dreams are made of,” we’re not just referring to the world of wizards, dragons and superheroes, or even to the wonders of Planet Earth. Behind WBD’s vast portfolio of iconic content and beloved brands, are the _storytellers_ bringing our characters to life, the_ creators_ bringing them to your living rooms and the _dreamers_ creating what’s next

From brilliant creatives, to technology trailblazers, across the globe, WBD offers career defining opportunities, thoughtfully curated benefits, and the tools to explore and grow into your best selves. Here you are supported, here you are celebrated, here you can thrive.

Your New Role**:
Our Enterprise Data & Shared Services team is seeking for a highly capable database administrator to support and maintain the daily activity of the database team related to data lakes, data warehouse and databases. You will be administering and implementing standardized database management procedures for Snowflake and Databricks databases. To ensure success as a database administrator, you should possess extensive knowledge of database administration and experience in a similar role.

You will be working with a team of professionals to design and implement the best database practices for Snowflake and Databricks databases, provide guidance to database team on database structures and features. You will create standard procedures to enhance scalability and performance of existing database architecture. Troubleshoot complex database issues in accurate and timely manner. Develop best practices for performance and operational efficiency.

This position offers adequate chances for personal and professional growth and development, while working with a multitalented and supportive team.

Your Role Accountabilities:

- Primarily responsible for administrating Snowflake and Databricks environments.
- Identify, tune, and fix the performance issues on priority.
- Diagnose and troubleshoot Snowflake and Databricks related errors and work with team to raise support tickets, follow ups and help to resolve them.
- Implement security, roles, users and privileges using the best practices.
- Provide database/objects recovery as need on basis.
- Design, identify and implement high performing and highly available data warehouse solutions.
- Create database, schema, tables, views, data sharing, data pipelines.
- Create Snowflake/Databricks utilization and capacity/cost plans, identifies, and provide solution for abnormalities.
- Proactively identify, design, and implement process improvements like automating manual processes, optimizing data flow, increase scalability etc.
- Stay up-to-date with the latest features and best practices in Snowflake/Databricks administration
- Follow existing database runbooks, create and maintain new runbooks for new and improved processes
- Provide 24X7 On-call support by participating in rotation schedule.

Qualifications & Experiences:

- Bachelor's degree in computer science, information systems, or information technology.
- 5+ years of experience as a database administrator.
- Minimum 3 years of hands-on administration experience, from setting up the Databricks/Snowflake environments to successfully administering it (AWS preferred)
- Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting, Windows BAT, Python etc.
- Some experience with AWS with knowledge of S3, EC2, IAM, Security, Lambda, Networking etc.
- Ability and experience with the development of processes and procedures to standardize Database installations and configuration.
- Extensive experience with implementation and maintenance of Disaster Recovery and High availability.
- Ability to work on unusually complex technical problems and provide solutions that are highly innovative and ingenious.
- Ability to provide technical documentation and project plans for technical staff members.
- Excellent communication, presentation, and customer relationship skills.
- Excellent organizational and time management skills to handle multiple tasks simultaneously
- Must have the legal right to work in the United States.
- Ability to provide 24/7 support.

Not Required but preferred experience:

- Experience with the various database platforms like Oracle, SQL Server, SAP Hana, db2, mysql, Potgresql, Mongo will be helpful as well.
- Experience with Jenkins, Terraform, Git/GitHub, Kafka is plus.

**How We Get Things Done**

**Championing Inclusion at WBD