What are the responsibilities and job description for the MySQL Database Administrator position at PRO IT Inc.?
Install, configure, and maintain MySQL database instances (on-premises and cloud-based).
Monitor database performance and optimize queries, indexing, and schema design.
Implement backup, restore, and disaster recovery procedures.
Configure and manage replication (Master-Slave, Group Replication, MySQL Cluster).
Troubleshoot and resolve database issues, including performance bottlenecks and outages.
Implement security best practices, including access control, encryption, and compliance (GDPR, PCI-DSS).
Automate database administration tasks using scripts (Shell, Python, SQL).
Perform database migrations, upgrades, and patching with minimal downtime.
Monitor system health, storage, and capacity utilization using MySQL tools and third-party solutions.
Work with development teams to optimize queries and design scalable solutions.
Physical Requirements - Ability to work in a standard office environment and May also need to provide support after regular hours, including on-call assistance.
Job Type: Full-time
Pay: $90,000.00 - $130,000.00 per year
Benefits:
- 401(k)
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
Schedule:
- 8 hour shift
- Day shift
- Monday to Friday
Work Location: In person
Salary : $90,000 - $130,000
