- Company Name
- Contact One Communications, Inc.
- Job Title
- 3474 Database Assistant (MySQL)
- Job Description
-
**Job Title:** Database Assistant – MySQL
**Role Summary:**
Operational MySQL Database Administrator responsible for installation, configuration, maintenance, and performance optimization of production, staging, and development environments, while ensuring availability, security, and compliance.
**Expectations:**
- Minimum 5 years of hands‑on MySQL DBA experience in production environments.
- Currently hold a NATO SECRET clearance.
- Demonstrated ability to support business‑critical systems with defined SLAs.
- Proactive, automation‑focused mindset applying SRE principles.
**Key Responsibilities:**
1. **Installation & Upgrades** – Deploy and upgrade MySQL 8.0+ instances (standalone or clustering), manage patches, and plan change windows.
2. **Database Configuration & Tuning** – Tune InnoDB parameters, buffer pools, log handling, and connection settings to meet performance targets; implement indexing strategies.
3. **Maintenance & Housekeeping** – Perform routine schema housekeeping, index management, statistics updates, and data retention operations.
4. **Capacity Planning** – Monitor storage growth, forecast capacity, and recommend partitioning or archiving strategies.
5. **Security Hardening** – Apply secure configurations, TLS in‑transit, optional encryption at rest, privilege management, and remote‑access restrictions.
6. **Backup & Recovery** – Design and operate logical/physical backup strategies, binlog retention, and point‑in‑time recovery; execute periodic restore tests to verify RPO/RTO.
7. **Replication & Failover** – Manage replication topologies, monitor lag, and implement failover procedures.
8. **Monitoring & Alerts** – Configure monitoring tools (PMM, Prometheus/Grafana), define thresholds, and reduce alert noise; maintain escalation paths.
9. **Incident Response & RCA** – Triage incidents, resolve within SLA, and produce root‑cause analyses with corrective actions.
10. **Documentation** – Maintain operative documentation for backup/restore, failover, replication, and performance troubleshooting.
**Required Skills:**
- Deep expertise in MySQL 8.0+ administration, backup/restore tools (mysqldump, mysqlpump, Percona XtraBackup), and point‑in‑time recovery.
- Advanced SQL optimization, indexing, and query plan analysis.
- Linux administration fundamentals (I/O, file systems, networking) related to DB performance.
- Strong security practices: TLS/SSL, privilege minimization, audit logging, secure config.
- Familiarity with at least one other database system (PostgreSQL, MS SQL Server).
- Scripting languages (Bash, Python, Perl) for automation.
- Experience with monitoring stacks and incident management.
**Required Education & Certifications:**
- Bachelor’s degree in Computer Science, Information Technology, or allied field (or equivalent professional experience).
- NATO SECRET clearance (must be current).
- Preferred certifications: MySQL Enterprise DBA, Oracle DBA, or equivalent database‑related credential.