SQL Server DBA

Title: SQL Server DBA

Location: Lake Forest, IL(Need Locals)

Length: 2 Months (Potential Extension)

Visa: USC, GC

Skype Interview allowed if candidate can start ASAP

Job Description

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

• Performs database upgrade, install and patching
• Monitors database performance and implements changes necessary to maintain acceptable performance levels.
• Ensures the availability and recoverability of all databases.
• Develops and document processes and procedures for maintenance, installation, upgrade, backups and recoveries of production and test databases as required by the business
• Provides 24x7 production database support on a rotational basis if needed
• Troubleshoots and tracing database related transactions in a multi-tier application across internal and ISP networks, firewalls and different platforms (Unix/Linux/Windows)
• DBA will create documentation and provide Knowledge Transfer (e.g. documentation, training) 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 SQL Server management tools, Configuration tools, Integration services and Reporting services
• Knowledge of Solarwinds DPA monitoring and experience and use to troubleshoot issues.
• Must have worked hands-on in a SQL Server administrator role in implementing database ystems 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 the business representatives.
• An understanding of production environments including the requirement for high availability and team oriented 24x7 support capabilities.
• Must have the 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

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

Bachelors

Required Skills

Job Description

Performs highly complex application programming/systems development and support Performs highly complex configuration of business rules and technical parameters of software products Review business requirements and develop application design documentation Build technical components (Maximo objects, TRM Rules, Java extensions, etc) based on detailed design.

Performs unit testing of components along with completing necessary documentation. Supports product test, user acceptance test, etc as a member of the fix-it team. Employs consistent measurement techniques Include testing in project plans and establish controls to require adherence to test plans Manages the interrelationships among various projects or work objectives