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. 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. #J-18808-Ljbffr