SQL Server DBA

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

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.

ESSENTIAL JOB FUNCTIONS:

§ 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:

§ 6 years of experience developing, maintaining and administering MS SQL Server databases.

§ 2+ years developing, maintaining and administering Oracle 9g/10g/11g/12c databases.

§ Experience configuring SQL Server replication required.

§ Experience with IBM CDC preferred

§ Experience with Business Intelligence and Data Warehouse products preferred.

§ ETL development experience with complicated SSIS Package coding and maintenance a plus

§ Experience with Data Modeling Tools as well as creating and maintaining data models preferred.

§ Goal driven, highly motivated, with a desire to take the lead and learn new skills.

§ Experience working with IBM InfoSphere Products (DataStage, QualityStage, Metedata Workbench, etc.) preferred.

§ Strong customer service skills and passion to work through obstacles to produce results.

§ Able to work in a projects-based, team environment.

§ IBM PDA/Netezza experience preferred.

§ Proficient in multi-tasking and managing multiple projects, able to meet target completion dates.

§ Able to be flexible and adapt to change.

The key qualifications are

1) 6 year experience as SQL Server DBA

2) 2 year Oracle DBA experience preferred not necessary

3) Good experience on Data warehouse including SSIS ETL experience

4) Experience with IBM Netezza a plus but not mandatory

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