Key Responsibilities: Database Management: Install, configure, and upgrade MySQL database servers and related tools. Design and implement database schemas, tables, indexes, views, stored procedures, functions, and triggers. Manage database capacity planning, storage, and space utilization. Implement and manage MySQL replication strategies (e.g., master-slave, GTID-based, semi-synchronous, Percona/Galera Cluster) for high availability and disaster recovery. Oversee data migration activities between different database systems. Develop and maintain documentation for database architectures, processes, and best practices. Performance Tuning and Optimization: Monitor database performance using tools like Percona Monitoring and Management (PMM), Query Profiler, slow query logs, Prometheus, and Grafana. Proactively identify and resolve database performance bottlenecks, including optimizing SQL queries, index design, and storage engine configurations. Analyze execution plans and recommend improvements. Configure database parameters for optimal performance. Backup and Recovery: Design, implement, and test comprehensive backup and recovery strategies to ensure business continuity and data integrity. Perform regular and ad-hoc full, differential, and log backups. Manage point-in-time recovery operations. Develop and maintain disaster recovery plans and participate in disaster recovery drills. Security and Compliance: Implement and enforce database security measures, including user access control, permissions, roles, and encryption. Conduct regular security audits and vulnerability assessments. Apply database patches and updates to address security vulnerabilities. Ensure compliance with data protection regulations and company policies. Troubleshooting and Support: Diagnose and resolve complex database issues, including latency, downtime, and scalability challenges. Provide proactive and reactive data management support to development teams and end-users. Participate in on-call rotation for production support as needed. Automation and Scripting: Automate routine database administration tasks using scripting languages (e.g., Bash, Python, Perl). Contribute to CI/CD pipelines for database deployment and management. Utilize infrastructure-as-code (IaC) tools like Terraform or Ansible for database provisioning and configuration. Collaboration and Communication: Collaborate effectively with developers, system administrators, and other IT teams to ensure seamless application integration and support. Translate business requirements into technical design specifications. Provide guidance and mentorship to junior DBAs and team members.
