Job Description
Database Administrator III#26-16839
$76.33-$78.61 per hour
Needham, MA
Hybrid
Job Description
Our client, is a Mass Media and Entertainment company, is looking for a Database Administrator III for their Needham, MA/Hybrid location.
Responsibilities:
Client. 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.
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
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
Requirements:
Experience with AWS data services: Redshift, RDS/Aurora PostgreSQL, S3, EC2, Athena, Glue, Lake Formation 3+ years
Experience with Databricks:
workspace administration, Unity Catalog, cluster management, Spark SQL, Delta Live Tables or similar 2+ years
Experience with PostgreSQL or Aurora PostgreSQL:
query tuning, replication concepts, pg_stat views, parameter groups 2+ years
Experience with AWS Security:
IAM (Users, Groups, Roles, Policies, Instance Profiles), Redshift/RDS security, S3 bucket policies 2+ years
PySpark for data pipeline development
AWS Glue with Iceberg or Delta Lake integration
Snowflake administration
Terraform or AWS CDK for infrastructure as code
DynamoDB experience
Feature Store
Ability to read, understand, debug, and extend complex Python codebases; comfort navigating large repositories with multiple modules and abstractions
Strong analytical and critical thinking skills
Ability to lead projects, prioritize, and multitask
Deadline and detail-oriented
Part of on-call rotation
Experience with Apache Iceberg on S3: partition management, compaction, snapshot management, schema evolution
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
Experience automating database and platform operations using Python, Jenkins, Airflow, Datadog and Git
Experience with Apache Iceberg on S3: partition management, compaction, snapshot management, schema evolution
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
Experience automating database and platform operations using Python, Jenkins, Airflow, Datadog and Git
3+ years' experience with AWS data services: Redshift, RDS/Aurora PostgreSQL, S3, EC2, Athena, Glue, Lake Formation
2+ years' experience with Databricks:
workspace administration, Unity Catalog, cluster management, Spark SQL, Delta Live Tables or similar
2+ years' experience with PostgreSQL or Aurora PostgreSQL:
query tuning, replication concepts, pg_stat views, parameter groups
2+ years' experience with AWS Security:
IAM (Users, Groups, Roles, Policies, Instance Profiles), Redshift/RDS security, S3 bucket policies
Ability to read, understand, debug, and extend complex Python codebases; comfort navigating large repositories with multiple modules and abstractions
Strong analytical and critical thinking skills
Ability to lead projects, prioritize, and multitask
Deadline and detail-oriented
Part of on-call rotation
