Senior SQL Server Database Administrator 6 month contract to hire Hybrid, onsite 1-2 days/week in Janesville, WI Brooksource is looking for a Senior SQL Server Database Administrator to help support and improve an established SQL Server environment across on-prem and Azure. This is a hands-on role for someone who enjoys being the go-to resource for database administration, troubleshooting, performance, and ongoing improvements. You'll work closely with development, data, infrastructure, and other technical teams to keep the environment running reliably while identifying opportunities to improve and modernize it. In the first 30 days, you'll focus on learning the environment, understanding the current SQL Server landscape, building relationships with the teams supporting it, and jumping into day-to-day troubleshooting and operational needs. Over the first 60 - 90 days, you'll take increasing ownership of the environment, identify areas of risk and opportunity, and help establish a practical path forward for improving performance, reliability, processes, and overall database operations. Day to

Day Responsibilities:

SQL Server Administration:

Administer and support SQL Server environments across production and non-production, including configuration, maintenance, upgrades, troubleshooting, and ongoing health of the environment.

Backup & Restore:

Manage database backup and recovery processes, including monthly restore testing to validate recoverability and identify potential issues before they become production problems.

Performance & Troubleshooting:

Monitor and troubleshoot database performance, including query performance, blocking, locks, indexing, and other issues impacting applications and users.

SSIS & Database Jobs:

Support and troubleshoot SSIS packages, SQL Server Agent jobs, and other database-related processes to ensure reliable data movement and processing.

Database Architecture & Improvement:

Help evaluate the existing database environment and identify opportunities to improve performance, reliability, scalability, and maintainability.

Azure & Cloud:

Support SQL Server environments in Azure and contribute to cloud initiatives as the organization continues to evolve its database environment. Experience with Azure SQL Managed Instance and/or migrating SQL Server from on-prem to Azure is a plus.

Collaboration:

Partner with development, data, infrastructure, and other technical teams to troubleshoot issues, support applications, and provide database expertise throughout development and production.

Documentation:

Build and maintain documentation, processes, and standards that help improve consistency and knowledge sharing across the environment.

Automation:

Identify opportunities to automate routine DBA activities and improve operational efficiency through scripting and other automation tools.

Minimum Qualifications:

Strong hands-on experience administering Microsoft SQL Server in a production environment Senior-level experience with SQL Server administration, troubleshooting, and performance tuning Experience with database backup, restore, and recovery Strong understanding of SQL Server performance, including blocking, locks, query performance, and indexing Hands-on experience supporting SSIS packages and SQL Server Agent jobs Experience troubleshooting complex database and application issues Experience working closely with development and/or data teams Ability to work independently, take ownership, and become a trusted database resource

Preferred Qualifications:

Experience with Azure SQL / Azure SQL Managed Instance Experience migrating SQL Server databases from on-prem to Azure Experience with SQL Server high availability technologies such as Always On Availability Groups or clustering Experience with PowerShell or other scripting/automation Experience with Terraform Experience with Azure DevOps / CI/CD pipelines Experience with SQL Server architecture and modernization Experience in a retail, distribution, manufacturing, or other enterprise environment About Us At Brooksource, relationships are the foundation of everything we do. Since 2000, we've built lasting partnerships with clients, consultants, and internal teams to deliver an exceptional experience across every engagement. As a trusted IT and Engineering services provider, Brooksource supports Fortune 500 organizations through Experience-Driven Staffing, Professional Services, and Elevate, our proprietary Workforce Transformation program. Whether you're hiring for software development, cloud computing, cybersecurity, data analytics, or enterprise IT, our customized staffing solutions are designed to align with your company's unique goals, culture, and technology stack. We offer flexible hiring models, including contract, contract-to-hire, and direct placement to meet your evolving business needs. We are a certified partner of leading platforms, including Salesforce, AWS, Microsoft, and Google Cloud, enabling us to deliver scalable, end-to-end technology solutions. With a growing national footprint, Brooksource is redefining expectations in IT consulting, engineering services, and technology workforce solutions. EEO Statement Brooksource is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, lactation and related medical conditions), gender identity or gender expression, sexual orientation, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances. Benefits & Perks Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee's needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc. Pay Disclaimer The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.

Pay:

$100,000.00 - $125,000.00 per year

Benefits:

Dental insurance Health insurance Vision insurance

Work Location:

Hybrid remote in Janesville, WI 53547