SQL Server DBA

Scadea Solutions Inc; Chicago (IL); On-site; USD 80,000 - 100,000; Full time

Job summary

Scadea Solutions Inc is looking for an SQL Server DBA in Lake Forest, IL, to provide database consulting and support for various internal databases. You will perform upgrades, monitor performance, and ensure the security and recoverability of databases.

The ideal candidate must have over 5 years of SQL Server administration experience and familiarity with VM environments. Strong problem-solving skills, time management, and the ability to communicate technical issues are essential for success in this role.

Qualifications

• 5+ years of experience in SQL Server database administration.
• Hands-on experience in a SQL Server administrator role implementing database systems.
• Familiarity with VM environments and Always On configuration.

Responsibilities

• Perform database upgrades, installations, and patching.
• Monitor database performance and implement necessary changes.
• Provide 24x7 production database support on a rotational basis.

Skills

SQL Server administration

Performance monitoring

Problem analysis and resolution

Time management

Communication skills

Tools

Solarwinds DPA

PowerShell

Job description

Title: SQL Server DBA

Location: Lake Forest, IL (Need Locals)

Length: 2 Months (Potential Extension)

Visa: USC, GC

The DBA provides production and project support for designated databases deployed throughout the company. The DBA must also provide database consulting/guidance services to other Grainger business areas. Works with project teams to design and deploy databases.

Responsibilities

• Perform database upgrade, install and patching.
• Monitor database performance and implement changes necessary to maintain acceptable performance levels.
• Ensure the availability and recoverability of all databases.
• Develop and document processes and procedures for maintenance, installation, upgrade, backups and recoveries of production and test databases as required by the business.
• Provide 24x7 production database support on a rotational basis if needed.
• Troubleshoot and trace database related transactions in a multi-tier application across internal and ISP networks, firewalls and different platforms (Unix/Linux/Windows).
• Create documentation and provide Knowledge Transfer to other Grainger DBAs.

Major Responsibilities and Duties

• All aspects of SQL Server database and associated technologies.
• 5 years in SQL Server database administration.

Mandatory Technical Skills

• Must have SQL Server experience with SQL 2008 through current versions and editions and support experience from Development to Production landscapes.
• Experience with SQL Server management tools, configuration tools, integration services, and reporting services.
• Knowledge of Solarwinds DPA monitoring and use to troubleshoot issues.
• Must have worked hands‑on in a SQL Server administrator role implementing database systems and providing VPT and production support in large active environments.
• Familiarity with VM environments.

Nice to have Technical Skills

• SQL Server certification.
• Knowledge of PowerShell.

Soft Skills

• Strong problem analysis and resolution (debugging) skills.
• Time management skills to balance priorities and deliver assignments on time and within budget.
• Ability to effectively communicate technical issues to software suppliers and to business representatives.
• Understanding of production environments including the requirement for high availability and team‑oriented 24x7 support capabilities.
• Ability to multi‑task in a very fast‑paced environment.
• Ability to handle high pressure situations and quickly respond and resolve production problems.

Additional Job Requirements

• Must have worked in Microsoft SQL 2012 using Always On configuration with at least one implementation.
• Must have experience with SQL Server and Active Directory security configuration.