MySQL Aurora Database Architect
MySQL Aurora Database Architect
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Solution IT Inc. is looking for an MySQL Aurora Database Architect for one of its clients in Charlotte NC / Remote
Job Title: MySQL Aurora Database Architect
Required Skills:
Need a Senior candidate Architect level who can manage offshore team and has very strong communication skills. We are seeking a skilled MySQL Aurora Database Administrator to manage monitor and optimize our AWS Aurora MySQL database environments. The ideal candidate will have handson experience in database administration performance tuning security and high availability setups. Consultant will work closely with development operations and architecture teams to ensure the smooth operation of our database systems meeting business requirements and maintaining system integrity.
Responsibilities:
Database Administration:
- Install configure and manage MySQL Aurora database clusters in AWS.
- Perform database upgrades patches and migrations as required.
Performance Tuning and Optimization:
- Analyze database performance and implement tuning measures.
- Optimize queries indexes and schema designs for improved efficiency.
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
High Availability and Scalability:
- Design and maintain faulttolerant and highly available database solutions using Aurora replicas and other AWS features.
- Support autoscaling and other Aurora scaling configurations.
Security and Compliance:
- Ensure database environments meet security and compliance standards.
- Implement access controls encryption and secure configurations.
Collaboration:
- Work closely with infrastructure and shared services teams networking system admins etc. including other DBA teams
- Work closely with DevOps and development teams to integrate databases with CI/CD pipelines.
- Provide technical support for databaserelated issues in production and nonproduction environments.
-
Documentation and Reporting:
- Maintain comprehensive documentation for database configurations processes and changes.
- Provide regular status updates and performance reports to stakeholders.
-
Required Skills and Qualifications:
- Bachelors degree in Computer Science Information Technology or related field.
- 5 years of experience in MySQL database administration. Handson 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 or MySQL Performance Schema based monitoring and tuning.
- Proficiency in AWS services related to RDS. Experience with high availability replication and disaster recovery strategies.
- Familiarity with database security best practices including encryption and access control.
- Experience with scripting languages (e.g. Python Shell) for automation tasks.
-
Preferred Skills:
- Knowledge of other AWS databases (e.g. DynamoDB Redshift) or RDBMS (e.g. PostgreSQL).
- Experience with enterprise monitoring tools like Dynatrace Splunk Zabbix Datadog Prometheus or Grafana.
- Familiarity with containerization (e.g. Docker Kubernetes) and cloudnative architectures.
- AWS Certified Database Specialty or other relevant AWS certifications.
Work Site: Charlotte NC / Remote
Duration: 6 Months Contract
Expected Start Date: Immediate
Number of Positions: 01
Please send your responses back to
About Solution IT
Employment Type
Full Time
