Company Description

Krasan Consulting Services is a Chicago boutique management consulting and technology solutions integrator. As a certified BEP WBE with the State of Illinois and a certified WBE, MBE, and DBE recognized by the City of Chicago, Krasan provides complex technology solutions and services for clients in the Public and Commercial sectors. With decades of experience, Krasan specializes in end-to-end technology solutions, integration, and implementation services and is proud to enable the success of our customers.

Role Title: Senior Platform Administrator – Database, SQL Server, DB2, IMS

Type of contract: W2

Location: Remote with Occasional travel to Springfield, IL

Client: State of Illinois—Illinois Department of Children and Family Services

Project: Platform Operations and Administration Team

Job Description:

The Platform Administrator – Database role requires advanced technical skills in administering Microsoft SQL Server, mainframe IMS, and DB2 databases. The ideal candidate will oversee complex database administration tasks, including tuning and maintenance, developing maintenance plans, and managing database objects and access rights. They will also provide technical consultation on new software products and support the creation and modification of reports using Crystal Reports and SQL reporting tools.

Additionally, the role involves participating in large-scale database design reviews, establishing regular backups, and managing user accounts.

In this position, the candidate will be responsible for scheduling and managing intricate data transfers and procedures while utilizing database tools for performance monitoring and SQL statement tuning. The successful individual will ensure the databases support mission-critical applications effectively and provide strategic insights for database performance optimization.

Top 5 Required Technical Skills:

• Bachelor's degree in computer science or a related field.
• Three years of professional experience in systems services or a related IT field
• Skilled in Mainframe IMS and DB2 Database Administration
• Advanced skills Microsoft SQL Server Administration
• Proficient with Crystal Reports and SQL Reporting Tools Expertise

Additional 5 Skills:

• Three years of professional experience in Microsoft SQL/Legacy database administration.
• Two years of professional experience with mainframe IMS and DB2 databases.
• Proficiency in SQL/Legacy, Crystal Reports, VB 6.0, .NET, COBOL, and Easytrieve Plus.
• Strong analytical skills and the ability to evaluate operational and procedural problems.
• Effective verbal and written communication skills

Job-1453