What are the responsibilities and job description for the MS SQL Database Administrator onsite position at Ztek Consulting?
Job Details
Role: MS SQL Database Administrator onsite in Cincinnati, OH- Full-time
Job description: 357922/BH
- Must have 7 to 19 years of experience
- 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Salary : $80,000 - $130,000
