SQL DBA
TEKsystems
Posted Friday, September 27, 2024
Posting ID: JP-004779570
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)
Hybrid