Database Administrator in Hoffman Estates, IL at Sears Home Services

Date Posted: 1/30/2021

Job Snapshot

Job Description

Req/Job ID: 999392BR
Employing Entity: Transform SR Holding Management LLC
Employment Category: Regular, Full-time
Job Function: Information Technology
Store ID: 58490: Sears Roebuck & Co.

The Database Administration and Architecture team manages data as a vital company asset, to ensure full data integrity, consistency and availability to support Business Unit applications, business consumers and customers. This function retains full integrity of data in the event of a disaster or catastrophe and adopt best practices in a conservative manner in order to deliver services to the corporation.

Job Requirements

Primary responsibilities
  • Work in a globally distributed team to provide robust public Cloud solutions on MySQL
  • Design, optimize and document the operational aspects of supporting the MySQL cloud platform
  • Drives application development projects to evolve the database architecture and operational design
  • Drives the creation of development, staging & production database instances
  • Migrates instances from one environment to another
  • Performs hands-on systems administration to address incidents, triage problems, and deploy changes.
  • Implements tools, alerts, and monitoring capabilities for automating database operations
  • Provides knowledge transfer essentials and SOP instruction to the DBA on-call team and to the ESOC team.
  • Analyzes and responds to performance and other maintenance issues.
  • Tunes the performance of all the staging and production database instances
  • Designs and implements back-up and recovery processes with other support teams and ensures they are functioning correctly
  • Plans and executes tests of fault tolerance capabilities, including backup/recovery; replication; cluster failover, and disaster recovery
  • Included in the on-call rotation to respond to the site incidents.

Required Skills
  • Hands-on experience with MySQL is a MUST!
  • Hands-on experience with AWS design and implementation
  • Experience with Agile and DevOps concepts
  • Strong communication and written skills
  • Experience with architecting and maintaining high availability production systems
  • Developing monitoring architecture and implementing monitoring agents, dashboards, escalations, and alerts

Desired Skills
  • Hands-on experience with Snowflake and Informix
  • Experience in Terraform, Chef, Puppet automation/orchestration (or similar)
  • Knowledge of security controls for the Public cloud (encryption of data in motion/rest and key management)
  • Knowledge of Linux and Windows containers