Must-Haves (Concepts & Tools): - 5+ years of experience in MySQL; PostgreSQL is a plus
- Automation and scripting (bash, PERL, python) to develop DBA applications
- Azure
- Complex data tier architecture, including replication, clustering (Percona) and system automation and integration
Project Scope / Components: We are actively searching for a candidate who is a subject matter expert with hands-on experience supporting all distributions of MySQL databases, including, but not limited to MySQL, Percona XTraDB Cluster, PostgreSQL, and cloud offerings such as Microsoft Azure and Amazon AWS. This role will be primarily focused on day-to-day production database administration for these databases.
High-Level Individual Duties: • Implement backup and recovery processes, provide system and SQL performance tuning, and assist in business process integration with various data sources.
• Fulfills user requests ranging from access control, backup, restore, refresh to non-production to performance tuning.
• Provides online & on call coverage for production support and administration of MySQL, PostgreSQL and support our production and redundant environments.
• Contribute to automated processes, including Optum-developed automation as well as third party tools.
• Manage internal customer requests through tickets and following through to completion
• Thoroughly document and improve operational practices and procedures
• Troubleshoot and resolve issues in all environments
• Participate in other projects and duties as assigned as well as on-call rotation