Job Details

Email to Friend Save Back

MySQL Database Administrator

WILMINGTON-19806, DE, US
09/13/2019

-

Required Skills

ETL tools

Company

Infinity Consulting Solutions, Inc

Experience

3 to 5 Year(s)

Job Description

ICS can help you attain your dream job! We are a leading staffing firm with a simple focus; excellent candidate experience and excellent client support.

We are focused on one premier client in Wilmington, Delaware.

Our Client is looking for an expert MySQL Database Administrator.

Position Summary

The MySQL Database Administrator is responsible for providing operational database services as well as project-level support to the organization.

This DBA role requires a service-oriented mentality with a high sense of ownership of the problems and requests assigned, the ability to focus on managing and resolving issues within SLAs, establishing and maintaining communication with technology customers to keep them updated with status of their requests, and proactively escalating any issues that cannot be resolved within the established timeframes.

Requirements

Perform day-to-day production MySQL database administration tasks in a Linux environment, including maintenance, troubleshooting, scaling, tuning, optimization, installation, upgrades, backup/recovery, and data migration across multiple data centers and multiple database server architectures/systems.

Troubleshoot and resolve production database issues

Ensure performance, security, and availability of databases

Profile server resource usage, optimize and tweak as necessary

Maintain database design/release documentation

Work closely with Engineering and DBA Team to design and implement optimal solutions

Work with Product teams to enhance the Data warehouse and client reporting solution

Provide Maintenance and Support for Client Reporting Solution

Education/Experience

Bachelor’s degree in computer science or related IT field preferred

3+ years’ hands on experience in designing and administering MySQL databases in a HA Environment.

Knowledge of de-facto standards and best practices in MySQL

Experience with replication configuration in MySQL

Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM

Proficient in writing and optimizing SQL statements

Ability to plan resource requirements from high level specifications

Unix shell scripting and the ability to automate routine tasks

Familiarity with monitoring tools and how to apply to DB environment

Must be ready to support environments remotely while on on-call.

Hands-on experience with NoSQL / non-relational databases

ETL / data migration experience with large data sets

Experience with data modeling in relational databases and writing complex SQL queries

Preferred Qualifications

Experience with Percona for MySQL Server

Experience with MySQL Backup tools and Monitoring tools.

Experience with Reporting/Visualization tools is a plus (Tableau preferred).

Experience with ETL tools and data warehouse concepts is a plus (Talend Preferred)

Proficient understanding of code versioning tools such as git