SQL DBA

TEKsystems - Milwaukee, WI

Full-time

Milwaukee, WI

10,001+ employees

Professional, Scientific, and Technical Services

About the position

The SQL DBA position at TEKsystems involves engineering and supporting SQL Server database systems, focusing on analysis, planning, design, development, implementation, and upgrades. The role emphasizes automation, security, and performance optimization to meet strategic objectives and ensure high availability of database environments.

Responsibilities

• Develop and maintain automation scripts using PowerShell, Ansible, and other tools to streamline database management tasks.
• Plan and execute database upgrades and migrations with minimal downtime.
• Monitor and optimize database performance through indexing, query optimization, and resource management.
• Develop and implement robust backup and recovery procedures.
• Ensure database security through the application of best practices and adherence to compliance requirements.
• Proactively monitor production databases to ensure high availability and performance.
• Observe key database metrics such as performance, storage, and memory utilization.
• Set up and manage automated alerts to identify and address issues proactively.
• Perform regular health checks and maintenance to prevent potential problems.
• Work collaboratively within and outside the team and other departments to support application development, deployment, and maintenance.
• Share knowledge and mentor junior team members, fostering a culture of continuous learning and improvement.
• Act as a point of escalation for complex database issues, providing expert-level troubleshooting and resolution.

Requirements

• Minimum of 10 years of experience administrating SQL Server databases and MSBI components.
• Hands-on expertise with SQL Server Always On Availability Groups (AOAG).