What are the responsibilities and job description for the SQL Database Administrator position at SRM Digital LLC?
Key Responsibilities:
- Install, configure, and maintain MySQL database instances (both on-premises and in the cloud).
- Monitor and fine-tune database performance, indexing, and schema design.
- Implement and manage backup, restore, and disaster recovery processes.
- Set up and maintain replication solutions (Master-Slave, Group Replication, MySQL Cluster).
- Troubleshoot and resolve performance issues, system outages, and database failures.
- Ensure database security through access controls, encryption, and compliance with standards (e.g., GDPR, PCI-DSS).
- Automate routine database administration tasks using Shell, Python, and SQL scripting.
- Perform version upgrades, patching, and database migrations with minimal service disruption.
- Monitor system health, storage, and capacity utilization using MySQL native tools and third-party monitoring solutions.
- Collaborate with development teams to optimize SQL queries and design scalable database solutions.
Required Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience as a MySQL DBA in production environments.
- Strong understanding of MySQL architecture, replication, and performance tuning.
- Experience with cloud platforms (e.g., AWS RDS, Google Cloud SQL, Azure Database for MySQL).
- Proficient in scripting languages such as Shell and Python.
- Knowledge of database security principles and compliance frameworks.
- Experience with MySQL monitoring tools (e.g., Percona Monitoring, Nagios, Zabbix).
