What are the responsibilities and job description for the MS SQL Database Administrator (Only open for Full Time) position at Key Infotek LLC?
Job Details
MS SQL Database Administrator
Job Description
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.
