SQL Server DBA

Confidential; Oak Brook (IL); On-site; USD 90,000 - 115,000; Full time

Job summary

A leading IT firm in Oak Brook, IL, is looking for an experienced SQL Server DBA to manage and support their data environment. Key responsibilities include designing and implementing database architecture, enhancing existing solutions, and providing 24/7 support for critical applications. The ideal candidate should have over 6 years in SQL Server administration and some experience with Oracle databases. This role offers a contract-to-hire opportunity with competitive pay.

Qualifications

• 6 years of experience developing, maintaining, and administering MS SQL Server databases.
• 2 years Oracle DBA experience preferred.
• Experience with complicated SSIS Package coding and maintenance.
• Able to work in a projects-based, team environment.

Responsibilities

• Provide thought leadership on database architectural design.
• Evaluate and implement products to enhance existing database solutions.
• Develop and administer complex ETL using SQL Server (SSIS).
• Ensure High Availability solutions including replication, clustering.
• Participate in 24 X 7 Support of production environment.

Skills

SQL Server database administration

Oracle DBA experience

ETL development with SSIS

Capacity planning

Data modeling tools

Business Intelligence products

IBM CDC

Strong customer service skills

Tools

IBM InfoSphere Products

SQL Server Management Studio

Job description

Need for SQL Server DBA with experience in SQL Server Data Warehouse. Oracle skill is a definite plus.

Site: Oak Brook, IL

Contract to Hire (ONLY USC, GC/GC EAD)

JOB DESCRIPTION

Overview

Position Title: Database Administrator

Department: Information Technology

JOB SUMMARY: The DBA is a member of the IT Business Intelligence team and is responsible for directly supporting the daily administration of the SQL Server and Oracle databases used at our Client. He/she will manage and support our Client’s Data environment.

Responsibilities

• Provide thought leadership on database architectural design of existing and new systems, database administration, performance monitoring tuning, troubleshooting problems and expansion.
• Evaluate and implement products to enhance existing database solutions (reduce costs, improve efficiency, improve performance).
• Review, enhance and develop backup and recovery strategies depending on SLA requirements.
• Capacity planning and monitoring database growth.
• Develop, maintain, and administer complex ETL using SQL Server (SSIS).
• Design, maintain and ensure High Availability solutions including replication, clustering etc.
• Design, implement and document Disaster Recovery strategies for critical business servers.
• Perform capacity planning work on Production, UA, QA, DEV and DR environments.
• Research improvements to improve overall system performance.
• Participate in 24 X 7 Support of production environment and mission-critical applications with the Database Technology team on a rotational schedule.
• Communicate and coordinate with other IT teams to successfully resolve support and maintenance issues.
• Develop and enforce database standards and best practices including performance, security, monitoring policies and procedures.
• Other duties as assigned.

Minimum Qualifications

1. 6 years of experience developing, maintaining and administering MS SQL Server databases.
2. 2 years Oracle DBA experience preferred (not necessary).
3. Experience with IBM CDC preferred.
4. Experience with Business Intelligence and Data Warehouse products preferred.
5. ETL development experience with complicated SSIS Package coding and maintenance a plus.
6. Experience with Data Modeling Tools as well as creating and maintaining data models preferred.
7. Goal driven, highly motivated, with a desire to take the lead and learn new skills.
8. Experience working with IBM InfoSphere Products (DataStage, QualityStage, Metadata Workbench, etc.) preferred.
9. Strong customer service skills and passion to work through obstacles to produce results.
10. Able to work in a projects-based, team environment.
11. Proficient in multi-tasking and managing multiple projects, able to meet target completion dates.
12. Able to be flexible and adapt to change.

Additional Information

Qualified prospect kindly share your updated resume to smano(@)divihn.com / can reach me on [phone] if you would like to learn more about this opportunity over a quick phone call.