Database Administrator - PostgreSQL / MySQL

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.