Data Platform Engineer / DBA

CareerCircle
Los Angeles, United States of America
2 days ago

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Working hours
Shift work
Languages
English
Experience level
Intermediate
Compensation
$ 164K

Job location

Los Angeles, United States of America

Tech stack

Artificial Intelligence
Airflow
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Data analysis
Apache HTTP Server
Unit Testing
Code Review
Databases
Data as a Services
Data Infrastructure
Data Warehousing
Software Debugging
Digital Assets
Amazon DynamoDB
Video Game Development
Hive
Identity and Access Management
Python
PostgreSQL
Object-Oriented Software Development
Performance Tuning
Query Optimization
SQL Databases
Datadog
Amazon Web Services (AWS)
S3 Bucket
Snowflake
Infrastructure as Code (IaC)
GIT
Data Lake
PySpark
Git Flow
Amazon Web Services (AWS)
Codebase
Terraform
Software Version Control
Data Pipelines
Jenkins
Redshift
Databricks

Job description

Database Administration, Authorization (Computing) SQL (Programming Language) Product Family Engineering Snowflake (Data Warehouse) Git (Version Control System) Employee Assistance Programs Infrastructure as Code (IaC) Amazon Elastic Compute Cloud Python (Programming Language) AWS Cloud Development Kit (CDK), The Data Platform Engineer / DBA manages our database and data platform fleet, maintaining secure, optimized, and highly available databases, data warehouses, and lakehouses. Our stack is evolving: Redshift remains a core platform, and we are actively expanding into Databricks and open table format (Apache Iceberg on S3). The Data Platform Engineer / DBA works closely with engineering and analytics teams to design, implement, and maintain these systems., * Operate Redshift clusters, Databricks workspaces, RDS/Aurora PostgreSQL instances, and supporting AWS infrastructure

  • Perform user/security tasks across platforms: Redshift user/group management, Databricks Unity Catalog access controls, IAM Roles/Policies, RDS parameter and access management
  • Design and maintain open table format data lakes using Apache Iceberg on S3, including compaction, snapshot management, partition strategies, and schema evolution
  • Profile production workloads and develop strategies to run optimized clusters and workspaces with scale and efficiency
  • Provide architecture guidance and support to technical leads; help develop code and SQL for data assets, identify performance tuning opportunities, and work with developers to improve production systems
  • Contribute to and maintain automation scripts and internal tooling with production-quality code standards (unit tests, peer review, documentation, Git-based workflows)
  • Develop monitoring and recovery automation to identify and resolve issues to meet our high SLA
  • Research new technologies and develop proofs of concept; propose technical improvements and new capabilities, San Francisco Candidates only: Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

City of Los Angeles Candidates only: We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring.

Related Jobs Database Administrator III AGS - Warner Bros Discovery Needham, MA*Hybrid Writing Datadog Tooling Jenkins PySpark Research Codebase AWS Glue Marketing Debugging Telemetry Terraform Operations Management Automation Data Lakes Databricks PostgreSQL Code Review Peer Review Testability Multitasking Unit Testing Query Tuning Unity Engine Abstractions Data Analysis Data Pipelines Apache Airflow Apache Iceberg Detail Oriented Amazon DynamoDB Amazon Redshift Data Warehousing Critical Thinking Amazon S3 Buckets Performance Tuning Workflow Management Amazon Web Services Object-Oriented Design Video Game Development Artificial Intelligence Database Administration Authorization (Computing) SQL (Programming Language) Product Family Engineering Snowflake (Data Warehouse) Git (Version Control System) Employee Assistance Programs Infrastructure as Code (IaC) Amazon Elastic Compute Cloud Python (Programming Language) AWS Cloud Development Kit (CDK) +0

Requirements

Datadog Tooling Jenkins PySpark Research Codebase AWS Glue Marketing Debugging Telemetry Terraform Operations Management Automation Data Lakes Databricks PostgreSQL Code Review Peer Review Testability Multitasking Unit Testing Query Tuning Unity Engine Abstractions Data Analysis Data Pipelines Apache Airflow Apache Iceberg Detail Oriented Amazon DynamoDB Amazon Redshift Data Warehousing Critical Thinking Amazon S3 Buckets Performance Tuning Workflow Management Amazon Web Services Object-Oriented Design Video Game Development, 1) Experience with AWS data services: Redshift, RDS/Aurora PostgreSQL, S3, EC2, Athena, Glue, Lake Formation a. 3+ years 2) Experience with Databricks: workspace administration, Unity Catalog, cluster management, Spark SQL, Delta Live Tables or similar a. 2+ years 3) Experience with PostgreSQL or Aurora PostgreSQL: query tuning, replication concepts, pg_stat views, parameter groups a. 2+ years 4) Experience with AWS Security: IAM (Users, Groups, Roles, Policies, Instance Profiles), Redshift/RDS security, S3 bucket policies a. 2+ years

Nice to Have Skills / Preferred Requirements

  1. PySpark for data pipeline development
  2. AWS Glue with Iceberg or Delta Lake integration
  3. Snowflake administration
  4. Terraform or AWS CDK for infrastructure as code
  5. DynamoDB experience
  6. Feature Store

Soft Skills:

  1. Ability to read, understand, debug, and extend complex Python codebases; comfort navigating large repositories with multiple modules and abstractions
  2. Strong analytical and critical thinking skills
  3. Ability to lead projects, prioritize, and multitask
  4. Deadline and detail-oriented
  5. Part of on-call rotation

Technology Requirements:

  1. Experience with Apache Iceberg on S3: partition management, compaction, snapshot management, schema evolution
  2. Proficiency in Python for automation and shared tooling: object-oriented design, writing maintainable and testable code, participating in code review, and contributing to a shared Git-based codebase
  3. Experience automating database and platform operations using Python, Jenkins, Airflow, Datadog and Git, Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

Benefits & conditions

Additional Notes

  • Sourcing in MA - Needham (WB Games Boston) or NY - Troy (WB Games NY)
  • Hybrid role - 3-days on-site preferred.

Please note that this is a contract role providing services to Warner Bros. Discovery through external staffing partners of Allegis Global Solutions. If you are selected for this role, you will be employed by AGS and will not be an employee of Warner Bros. Discovery.

This role is eligible for the following benefits:

Medical, dental & vision Hospital plans 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available Life Insurance (Company paid Basic Life and AD&D as well as voluntary Life & AD&D for the employee and dependents) Company paid short and long-term disability Health & Dependent Care Spending Accounts (HSA & DCFSA) Employee Assistance Program Time Off/Leave(PTO, Allegis Group Paid Family Leave, Parental Leave

Benefits are subject to change and may be subject to specific elections, plan, or program terms.

About the company

Warner Bros. Central Technology and Services team (CTS) provides data analytics services that support game teams and analysts across the WB Games organization. As players perform actions in-game, our platform collects telemetry in real-time. The data collected provides insights for guiding game development, marketing, and monetization. Some of our featured games include Game of Thrones: Conquest, Injustice 2, Mortal Kombat, Batman: Arkham Knight, Hogwarts Legacy.

Apply for this position