SQL Server DBA

Scadea Solutions is a global talent acquisition and executive search company. We work exclusively with some of the most reputed and admired clients across various sectors and geographies. This is a very urgent role.

Job Description

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.

1. Performs database upgrade, install and patching.
2. Monitors database performance and implements changes necessary to maintain acceptable performance levels.
3. Ensures the availability and recoverability of all databases.
4. Develops and documents processes and procedures for maintenance, installation, upgrade, backups and recoveries of production and test databases as required by the business.
5. Provides 24×7 production database support on a rotational basis if needed.
6. Troubleshoots and traces database related transactions in a multi-tier application across internal and ISP networks, firewalls and different platforms (Unix/Linux/Windows).
7. Creates documentation and provides 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:

1. Must have SQL Server experience with SQL 2008 through current versions and editions and support experience from Development to Production landscapes.
2. Experience with SQL Server management tools, Configuration tools, Integration services, and Reporting services.
3. Knowledge of Solarwinds DPA monitoring and experience and use to troubleshoot issues.
4. Must have worked hands-on in a SQL Server administrator role in implementing database systems and providing VPT and production support in large active environments.
5. Familiarity with VM environments.

Nice to have technical skills:

SQL Server certification, knowledge of Powershell.

Soft Skills:

1. Strong problem analysis and resolution (debugging) skills.
2. Time management skills to balance priorities and deliver assignments on time and within budget.
3. Ability to effectively communicate technical issues to software suppliers and to the business representatives.
4. An understanding of production environments including the requirement for high availability and team-oriented 24×7 support capabilities.
5. Must have the ability to multi-task in a very fast-paced environment.
6. 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.

Qualifications

Additional Information

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. Reviews business requirements and develops application design documentation. Builds 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. Includes testing in project plans and establishes controls to require adherence to test plans. Manages the interrelationships among various projects or work objectives.

#J-18808-Ljbffr