Solution IT Inc. is looking for a MySQL Aurora Database Architect one of its clients in Charlotte, NC
Only locals
Job Title: MySQL Aurora Database Architect
Job Description
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 hands-on experience in database administration, performance tuning, security, and high availability setups. You 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
Key Responsibilities:
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 and implement tuning measures.
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 fault-tolerant and highly available database solutions using Aurora replicas and other AWS features.
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
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 database configurations, processes, and changes.
Provide regular status updates and performance reports to stakeholders.
Required Skills
Bachelor's degree in Computer Science, Information Technology, or related field.
5+ 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 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 cloud-native architectures.
AWS Certified Database Specialty or other relevant AWS certifications.
Work Site : Charlotte, NC
Duration: 6 months
Expected Start Date : Immediate
Number of Positions: 01
Please send your responses back to [email protected]
About Solution IT
Solution IT is a national IT consulting company specializing in: Technology Staffing and Oracle E-Business Solutions based in Boston, Massachusetts.
...* Trach* Feeding tube* Vent *All hours days/nights/weekends M-F $35.00 to $37.00 LPNM-F $45.00 to $47.00 RN... ...Chesterfield)-Adult* Trach* Vent * Quadriplegic *Hours overnight Saturday & Sunday Weekend Rates - $35.00 LPN / $45.00 RN...
...professional services firm with over 30 years of experience in the Maltese market. As part of a leading global network of independent accounting and advisory firms operating in over 145 countries, they are known for their strong commitment to client service. Their portfolio...
...additional carpet cleaning aftercare instructions for customers. Carpet Cleaning Technician Requirements ~No high school diploma or GED needed ~ Valid drivers License a plus but not required as we provide company vehicles with licensed company drivers.~ Must...
...English fluency Benefits: Healthcare, vision and dental, 20 days accrued PTO annually, retirement plan. The Bilingual Trauma Therapist will provide trauma-based psychotherapy to children, adolescents, adults, and families in English and Spanish. Under the...
...Click this link to apply: POSITION TITLE: Hospice CNA REPORTS TO: Director of Nursing JOB SUMMARY: The Hospice Aide is responsible for providing hospice services consistent with the mission, vision, and goals of the Agency. The Hospice Aide is a member...