MySQL DBA

Cary, NC

Company Name :IBA Infotech LLC

Type : Contract

Primary Skills : Database Management, Data Recovery, Database DR, Operating Systems, MySQL

Location : Cary

CTC : DOE

Job Description:

 

Desired Experience / Attributes include:

  • MySQL DBA experience is required (experience with Percona, or MariaDB, or Oracle 11g or higher, Exasol or MSSQL is preferred but not required)
  • MySQL disaster recovery
  • MySQL database backup procedures
  • Linux
  • Reporting tools
  • Experience with Analytics, or Data Warehousing, or NoSQL databases would be helpful but is not required.

This is a Senior MySQL DBA role performing a range of duties such as customer production support, preventative interactions, operational recovery and escalation resolution. Implementations will include hosted, enterprise and appliance models. Other job aspects include:

  • Database Performance Tuning, Database Security, Promoting Process Improvement, Problem Solving, Presenting Technical Information, Quality Focus, Database Management, Data Maintenance, Data Recovery, Database DR, Operating Systems, Attention to Detail, Information Security Policies
  • MySQL’s underlying storage engines
  • Standards and best practices in MySQL
  • Limitations in MySQL and their workarounds in contrast to other popular relational databases
  • Percona Toolkits
  • Identifies database requirements by interviewing customers; analyzing department applications, programs and operations; evaluating existing systems and designing proposed systems.
  • Recommends solutions by analyzing database physical structure and functional capabilities, database security, data back-up, and recovery speciation’s.
  • Installs revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements.
  • Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products. Prepares users by conducting training; providing information; resolving problems.
  • Provides information by answering questions and requests. Supports database functions by designing and coding utilities.
  • Installing and upgrading the database server and application tools
  • Allocating system storage and planning future storage requirements for the database system
  • Enrolling users and maintaining system security
  • Ensuring compliance with database vendor license agreement
  • Make performance optimization recommendations to customers
  • Provide end-to-end technical support and problem resolution
  • Design backup processes for server and associated data working with Percona Xtrabackup
  • Recovers corrupted databases utilizing diverse approaches
  • Create accounts for all users and assign security levels
  • Contacting database vendor for technical support
  • Generating various reports by querying from database as per need
  • Maintains quality service by establishing and enforcing organization standards. Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.