Database Administrator - PostgreSQL / MySQL
Description
Responsibilities
- Act as first line of support for troubleshooting and resolving MySQL service and performance issues
- Work with service consumers to coordinate periodic DB management operations and upgrades
- Perform on call rotations, serving as MySQL SME and initial contact for other DB platforms
- Monitoring of the MySQL footprint using Percona Monitoring
- Install, configure, upgrade, and maintain/administer MySQL clusters
- Perform administrative tasks in the MySQL environment including but not limited to user administration, permissions, schema and instance creation, security adjustments, storage administration, backup/recovery, and service tickets
- Create basic automation scripts (bash, Perl, python)
- Jenkins and GitHub experience is a plus
- Additional responsibilities as assigned by Manager
- Some travel may be required
Qualifications
- Proactive and thorough communication skills with teammates, service consumers, and management are required to succeed in this role
- 2+ years supporting, maintaining MySQL databases in an enterprise environment
- Experience with installing MySQL 5.7-8.0 and its derivatives
- Experience with installing and maintaining PostgreSQL a plus
- Experience with management of open-source database management technologies in a public cloud environment such as AWS is a plus
- Operational experience with Linux operating system derivatives
- Experience scripting in a Linux or open source-based technology such as bash, Perl, and/or python
- Must be able to participate in on-call rotation
- must have experience and be able to support operational tasks such as patching and administration that may be done outside of conventional business hours
- Should have experience in a 24x7x365 enterprise environment meeting uptime SLAs of 99.99% or greater.