Jobe Details


MySQL Database Administrator Posted on: 09/13/2019

Infinity Consulting Solutions, Inc
  • 3 to 5 Year(s)
  • -
  • WILMINGTON-19806, DE, US

ETL tools

  • 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


  • Database Administrators
    Information Technology
  • No Preference
    FullTime Job
    Other
    1
  • Candidate Requirements
    -
    Bachelors
  • Walkin Information
    -
    9/9/2019
    -
Recruiter Details
Doug Klares
1350 Broadway, Suite 2205, NEW YORK-10018, NY
- 
Advertise with Us,

Size:120X120