Database Administrator - MySQL
Layered Technologies - Kansas City, MO

This job posting is no longer available on Layered Technologies. Find similar jobs: Database Administrator jobs - Layered Technologies jobs

Job Title:
Database Administrator, MySQL

Job Category:
Operations Administrators

Department:
Operations Center

Location:
Kansas City

Position Type:
Skilled – Non-Managerial

Reports To:
Director of Implementations & Operations Engineering

Summary

As the Database Administrator, you will be the go-to person for all Managed MySQL Databases instances. This activity includes the primary responsibility of the day-to-day DB maintenance and operation of the MySQL environments to include performance diagnosis and tuning, operations monitoring, backups, application tuning, troubleshooting, and application-level change control migration.

Job Responsibilities

Manage 60+ MySQL database instances spanning 40+ servers

Set up new MySQL database instances

Perform or coordinate database backup/restore operations as appropriate

Recommend reconfiguration and perform upgrades of database servers

Monitor production MySQL instances and maintain infrastructure for facilitating ongoing automated database monitoring, statistics gathering, and alerting

Work with clients to facilitate database performance optimization

Work with development teams to design proper database schemata that are aligned with business application requirements

Perform database schema changes and data mass updates as requested by clients and approved and scheduled through change management

Perform data archive activities and maintain related infrastructure to support established data retention policies

Job Requirements

3-5+ years MySQL database administration experience in a high-volume transactional environment

High volume MySQL database administration

MySQL replication (multi-master, master-slave)

Experience with High Availability architectures (LVS, heartbeat, DRBD)

Database backup and recovery

Experience in administration of multiple database engines

Possess excellent MySQL troubleshooting and debugging skills

Experience with Linux/x86_64 server administration (network, storage, file system, memory and performance)

Understanding of SAN architecture and basic ability to configure its connectivity, storage, and features a plus

Experience with MySQL Clustering a plus ( DRBD )

Ability to write utility scripts in Perl and/or other scripting language and possess the ability to comprehend existing Perl and PHP scripts a plus

Other duties as assigned

Critical Skills

Ability to quickly adapt to advancing technologies and procedural changes

Proven incident and problem solving (troubleshooting) skills with an emphasis on a timely resolution

Ability to coordinate and communicate effectively with other technologists and business partners to maintain high service levels in a demanding environment

Ability to work well in team environment

Must have verbal, written and analytical skills

Familiarization with SAS-70, ITIL and PCI guidelines and practices

Experience in administration of Oracle and PostgreSQL Database servers a plus

Education

Associate’s Degree or equivalent education in related fields / or 3 years’ experience in related field

1+ years’ experience working in IT Service Provider industry at enterprise level

ITIL Foundation Training and/or Certification preferred

Current/Active Database Certifications

Layered Technologies - 19 months ago - save job - block
Recommended Jobs
Administrator Process Systems & Equipment
Garmin - Olathe, KS
Garmin - 5 days ago

Linux Systems Administrator
RiverPoint Group LLC - Lenexa, KS
RiverPoint Group LLC - 3 days ago

Senior Linux/Cisco Sys Admin - Pinsight Media...
Sprint - Kansas City, MO
Sprint - 26 days ago
About this company
3 reviews