SQL Server DBA

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.

• 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.

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

• 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.

• SQL Server certification.
• Knowledge of Power Shell.

• 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.

• 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.