Sign upLog in

Database Administrator III

Iconma

Needham, MA

Apply
JOB DETAILS
SKILLS
Access Control, Amazon Elastic Compute Cloud (EC2), Amazon Relational Database Service (RDS), Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Apache, Apache Spark, Automation, Cisco Unity, Code Reviews, Data Analysis, Data Collection, Data Formats, Data Management, Data Warehousing, Database Administration, Debugging Skills, Detail Oriented, Documentation, Entertainment and Media, Establish Priorities, Games Programming, Git, Health Plan, High Availability, Identify Issues, Jenkins, Leadership, Machine Tool, Management Strategy, Marketing, Multiplatform/Cross-Platform, Multitasking, Object Oriented Design (OOD), On Call, Performance Tuning/Optimization, PostgreSQL, Problem Solving Skills, Production Systems, Proof of Concept, Python Programming/Scripting Language, Quality Metrics, Replication and Remote Mirroring, SQL (Structured Query Language), Scripting (Scripting Languages), Security Infrastructure, Service Level Agreement (SLA), Strategic Planning, Systems Maintenance, Team Lead/Manager, Technical Leadership, Technical Research, Technical Support, Telemetry, Time Management, Unit Test, Vehicle Fleets
LOCATION
Needham, MA
POSTED
Today
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
 
Why Should You Apply?
  • Health Benefits
  • Referral Program
  • Excellent growth and advancement opportunities
 

About the Company

I

Iconma

ICONMA is a global information consulting management firm providing Professional Staffing Services and Project-Based Solutions for organizations in a broad range of industries.

  • Corporate Headquarters in Troy, Michigan; 20+ locations worldwide.
  • Certified Woman-Owned Business Enterprise (WBE); certified by Women’s Business Enterprise National Council, National Women Business Owners Corporation (NWBOC); and California Public Utilities Commission (CPUC).
  • Founded in 2000
  • 2000+ Employees

The company was founded on the principle that success is derived from delivering high quality service and resources in the most responsive, flexible, and innovative way. ICONMA invests in people and resources with a single goal: To provide our customers with the highest quality service in the most responsive manner. Through its network of offices, ICONMA provides the resources to help clients maintain their competitive advantage.

COMPANY SIZE
2,000 to 2,499 employees
INDUSTRY
Management Consulting Services
EMPLOYEE BENEFITS
401K, Employee Referral Program, Life Insurance
FOUNDED
2000
WEBSITE
https://www.iconma.com/

Resume Resources

Free Resume TemplatesFree Resume Builder