Aarnest Inc

Role Overview

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