Mysql Database Administrator Resume
3.00/5 (Submit Your Rating)
Beachwood, OH
TECHNICAL SKILLS:
Cloud & Virtualization: AWS, VMware, Hyper - V, Ansible
Operating Systems: MS Windows and Linux (Red Hat, CentOS, and Debian)
Programming: PHP, Perl, BASH, HTML, XML, CSS, Javascript, JAVA, C++
Architecture: LAMP (Linux, Apache, MySQL,PHP/Perl)
Databases: MySQL 5 & 8, Memcache, Oracle, SQL, and Cassandra
Monitoring: Nagios, Custom Scripts (Crons, Shell, Application logs)
Backups: LVM, mysqldump and replay of binary logs, SQL server
EXPERIENCE:
Confidential, Beachwood, OH
MySQL Database Administrator
Responsibilities:
- Performance tuning of production systems; identify, evaluate, and create solutions to application bottlenecks
- MySQL Enterprise administration: replication, configuration, version upgrades, and server resource management
- User access control, audit logs, keyring encryption, backup encryption
- Systemd unit programming: multi - instance systemctl, notifications, monitoring
- Code review, mentoring, QA testing, production deployments
- Alternative database evaluation (MariaDB)
- Bash scripting: custom libs, tools, crons, and monitoring programs
- Stored routines for partitioned table maintenance and data updates (8 TB)
- ON-Call and Disaster recovery
Confidential, Wadsworth, OH
Senior Database Administrator & Programmer
Responsibilities:
- Performance tuning of production systems; identify, evaluate, and create solutions to application bottlenecks
- General MySQL administration: replication, configuration, version upgrades, and server resource management
- LAMP stack engineering of architecture and topology in Virtualized and dedicated server environments
- Stored routines, reporting, BI tools integration, and related application and data design
- Manage developer environment and deployments to production
- SQL code review, establish code standards, and mentor developers
- Version control with SVN, schema design with Agilian, GIT
- Utilize and administer Nagios for a customized monitoring solution; notifications, escalations, custom scripts
- Backup & restore with point in time LVM or AWS snapshots, mysqldump and replay of binary logs
Confidential, Kalamazoo, MI
Senior Online Systems Programmer and Administrator
Responsibilities:
- Architected and programmed the MVC framework for the web application API and Request servers
- Trained all new hires and interns for PHP programming
- Installing, configuring, maintaining, security, designing, troubleshooting, performance tuning, and training for large, highly available and robust MySQL databases
- Responsible for NOSQL Cassandra integration, laying the framework and guidelines from MySQL to a distributed Cassandra data layer
- Ability to utilize and operate various flavors of operating system: Redhat, CentOS, Debian, Windows
- Highly proficient PHP web application programmer
- Performance logging, tuning and understanding across all levels of LAMP and Cassandra architecture
- Worked with outsourced personnel in product integration, including custom PHP and Apache modules, payment API and partner services
- Scripting languages: BASH, PHP, Perl, Javascript
- Custom logging and performance monitoring solutions