Database Administrator - GCCA Remote at TransUnion

What You'll Bring:

3+ years of hands-on experience as a MySQL DBA, with deep expertise in:

• Database architecture, query optimization, and transaction/locking mechanisms.
• Storage engines (InnoDB, MyISAM) and replication (GTID, binlog).
• Proven experience with AWS RDS, including:
• Configuration of parameter groups, Multi-AZ deployments, and Performance Insights.
• Backup/Restore (snapshots, PITR) and cross-region replication.
• Scalability expertise:
• Designing sharding, partitioning, and read/write splitting for high-traffic systems.
• Familiarity with sharding tools (e.g., Vitess, ShardingSphere) is a plus.
• Security & Compliance:
• Implementing TLS encryption, IAM-based access control, and data masking.
• Monitoring & Automation:
• Tools: CloudWatch, Prometheus/Grafana, Percona PMM.
• Scripting skills (Python/Shell) for automation.
• Nice-to-Have:
• Experience with Redis, DynamoDB, or other NoSQL solutions.
• Knowledge of Aurora or data warehousing (Redshift).

Impact You'll Make:

• Perform day-to-day MySQL database administration (deployment, monitoring, backup/restore, performance tuning) on AWS RDS.
• Design and implement high-availability architectures (master-slave replication, failover) and sharding strategies for large-scale datasets.
• Optimize AWS RDS resource allocation (instance types, storage, IOPS) to balance performance and cost efficiency.
• Develop and enforce database security policies (access control, encryption, compliance with GDPR/HIPAA).
• Lead disaster recovery (DR) planning, including RTO/RPO definitions and regular drills.
• Collaborate with developers to review SQL queries, schema designs, and resolve performance bottlenecks.
• Automate routine tasks (backups, scaling) using AWS Lambda, Terraform, or scripting (Bash/Python).

End Date: September 12, 2025