Über
As a Senior MySQL DBA, you will be the primary guardian of our data infrastructure, ensuring high availability, performance, and security across our AWS-hosted environments. You will bridge the gap between core database administration and data warehouse operations, managing complex migrations via AWS DMS and supporting our Redshift analytical layers. This role requires a "DevOps mindset," using Bash and Linux expertise to automate routine tasks, manage deployments, and maintain a rigorous monthly patching cycle.
*Key Responsibilities1. Database Administration & Performance*
* Administer and maintain high-performance MySQL instances (RDS, Aurora, and EC2-hosted).
* Optimize database performance through query tuning, indexing strategies, and schema enhancements.
* Manage *Redshift* clusters, including distribution keys, sort keys, and workload management (WLM) to ensure optimal analytical query performance.
*2. AWS Cloud & Data Migration*
* Orchestrate data movement and replication using *AWS Database Migration Service (DMS)*.
* Troubleshoot and resolve *ETL job failures*, ensuring data integrity between operational MySQL databases and the Redshift data warehouse.
* Manage AWS-specific infrastructure including VPC security groups, IAM roles for databases, and CloudWatch alerting.
*3. Automation & Linux Engineering*
* Develop and maintain advanced *Bash scripts* to automate backups, monitoring, and routine maintenance tasks.
* Manage databases within *Linux environments*, including kernel tuning and filesystem management for self-hosted instances.
* Support *Code Deployment* pipelines, ensuring database schema changes are integrated seamlessly into the CI/CD lifecycle.
*4. Maintenance, Security & Compliance*
* Lead *monthly patching and upgrade* cycles to mitigate vulnerabilities and maintain system health.
* Identify and resolve complex server-level issues (OS, hardware, or network-related) impacting database availability.
* Ensure all database systems adhere to federal security standards required for *Public Trust* eligibility.
*Required Qualifications*
* *Experience:* 5+ years of DBA experience, with at least 3 years focused on MySQL and AWS Cloud services.
* *Technical Stack:* \* *Databases:* Expert-level MySQL/Aurora; Proficiency in AWS Redshift.
* *Cloud:* Hands-on experience with AWS DMS, RDS, EC2, S3, and IAM.
* *Scripting:* Strong proficiency in Bash and Linux command-line tools.
* *Operations:* Experience troubleshooting ETL pipelines and complex data synchronization issues.
* *Citizenship/Residency:* Must currently reside in the US.
* *Clearance:* Ability to pass a background investigation for a Public Trust position.
*Preferred Skills*
* Experience with Infrastructure as Code (Terraform or CloudFormation).
* Familiarity with other AWS data tools like Glue, Athena, or Lambda.
* Relevant certifications (e.g., AWS Certified Database – Specialty).
Job Types: Full-time, Contract
Pay: $50.00 - $70.00 per hour
Work Location: Remote
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klicken Sie auf „Jetzt Bewerben“, um Ihre Bewerbung direkt auf deren Website einzureichen.