MySQL Database Administrator at Charlotte, NC (Onsite)

  • Posted 1 day ago | Updated 10 hours ago

Overview

Accepts corp to corp applications
Contract - 12 month(s)

Skills

Aurora

Job Details

Required Skills and Qualifications:

Bachelor's degree in Computer Science, Information Technology, or related STEM field

08+ years of experience in MySQL database administration

Hands-on experience managing AWS Aurora MySQL clusters

Strong knowledge of database design, indexing, query optimization, monitoring and tuning

Experience with MySQL Monitoring tools such as MySQL EM, PMM, CloudWatch or MySQL Performance Schema based monitoring and tuning

Proficiency in AWS services related to RDS and Aurora

Experience with high availability, replication, and disaster recovery strategies

Familiarity with database security best practices, including encryption and access

Experience with scripting languages (e.g., Python, Shell) for automation tasks

1. Database Administration:

Install, configure, and manage MySQL Aurora database clusters in AWS

Perform database upgrades, patches, and migrations as required

2. Performance Tuning and Optimization:

Analyze database performance, provide recommendations and perform tuning

Optimize queries, indexes, and schema designs for improved efficiency

3. Monitoring and Maintenance:

Monitor database health and performance using Enterprise monitoring tools (e.g., CloudWatch, Performance Insights, PMM, MEM, Performance Schema).

Implement business and environment continuity procedures, regular backups & restore processes, and disaster recovery procedures.

Maintain proper DB health through regular index and table maintenance, data archiving and various reliability related tasks

4. High Availability and Scalability:

Design and maintain highly available database solutions

Support auto-scaling and other Aurora scaling configurations

5. Security and Compliance:

Ensure database environments meet security and compliance standards

Implement access controls, encryption, and secure configurations

6. Collaboration:

Work closely with infrastructure and shared services teams, networking, system admins, etc. including other DBA teams to perform architectural, maintenance and configuration related activities

Work closely with DevOps and development teams to integrate databases with CI/CD pipelines.

Provide technical support for database-related issues in production and non-production environments.

7. Documentation and Reporting:

Maintain comprehensive documentation for configuration, processes, and changes

Provide regular status updates and performance reports to stakeholders.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.