Contract position for a SQL DBA hybrid in Milwaukee, Wi. No relocation for this position. As a SQL Server Database Systems Engineer, you will engineer and support database systems including analysis, planning, design, development, implementation, and upgrades. Applying established architectural and engineering best practices, you will take charge of complex systems to achieve strategic objectives in the areas of solving for client, infrastructure availability and automation, as well as a strong focus on database environment security. Key Responsibilities & Duties: Automation and Scripting: Develop and maintain automation scripts using PowerShell, Ansible and other tools to streamline database management tasks. Database Migrations: Plan and execute database upgrades and migrations with minimal downtime. Performance Tuning: Monitor and optimize database performance through indexing, query optimization, and resource management. Backup and Recovery: Develop and implement robust backup and recovery procedures. Security Management: Ensure database security through the application of best practices and adherence to compliance requirements. Monitoring and Maintenance:o Proactively monitor production databases to ensure high availability and performance.o Observe key database metrics such as performance, storage, and memory utilization.o Set up and manage automated alerts to identify and address issues Proactively.o Perform regular health checks and maintenance to prevent potential problems. Collaboration: Work collaboratively within and outside the team and other departments to support application development, deployment, and maintenance. Mentorship: Share knowledge and mentor junior team members, fostering a culture of continuous learning and improvement. Incident Response: Act as a point of escalation for complex database issues, providing expert-level troubleshooting and resolution.Qualifications: Experience: Minimum of 10 years of experience administrating SQL Server databases and MSBI components. Hands-on expertise with SQL Server Always On Availability Groups (AOAG)About TEKsystems: We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
