*Hi...* I hope you are doing well. I am sending the new requirement, please go through it and let me know if you are comfortable and send me the *resumes to **james.mil...@itbtalent.com* <james.mil...@itbtalent.com>
*MUST be LOCAL to IA or Near By Who Can do Inperson* *Position = SQL DBA (2012 Experience)Location = Des Moines, IA (Local or near BY)Duration =12 Months Rate Max = $45/hr. C2C* Interview Process:* In Person* The Department has an enterprise data warehouse currently begin *migrated from SQL Server 2005 to SQL Server 2012.* The Department is in need of a SQL developer to support; 1The migration of the existing environment to SQL 2012, 2.Work with data warehouse analysts, policy and field staff to design, develop and implement data mart databases that are dimensionally modeled around line of business reporting/analytic needs. 3.Work with DHS staff in the development of Analytics (SPSS and other statistical tools), structured reporting (e.g. trends, metrics) and ad-hoc reporting solutions. 4.Design and development of data cubes 5.Design and development of highly-automated ETL packages. The Department predominately uses SQL Server Integration Services (SSIS) with complex T-SQL as its ETL tool. Data Sources include mainframe, IDMS (via extracts), other SQL Server databases, and Oracle. 6. Assist Data Warehouse Analysts and other power users of the data warehouse in the design and development of complex queries spanning multiple tables and databases. Extensive experience with SQL Server Integration Services along with Dimensional modeling skills is paramount for this position. Experience using *SQL Server Integration Services (SSIS) with complex T-SQL as its ETL tool* Design, develop and implement data mart databases that are dimensionally modeled around line of business reporting/analytic needs Migration experience from current (SQL 2005 or 2008) environment to SQL 2012 Query Analyzer for direct query Assist power users of the data warehouse in the design and development of complex queries spanning multiple tables and databases Design and development of data cubes Query Analyzer for direct query Analytics (SPSS and other statistical tools), structured reporting (e.g. trends, metrics) and ad-hoc reporting solutions. Experience using *SSRS to create reports* ____________________________________________________________________________________________________________________________________________________________________________ *Thanks & Regards,James Miller Sr. IT Recruiter |ITBrainiac Inc,*Princeton Forrestal Village116 Village Blvd, Suite 200 Princeton, NJ 08540 Tel *609 - 423 - 4899* Fax 312.582.2699 | Email:james.mil...@itbtalent.com Gtalk: james.usrecruiter Website: www.itbrainiac.com Notice: This email contains confidential or proprietary information which may be legally privileged. It is intended only for the named recipient (s). If an addressing or transmission error has misdirected the email, please notify the author by replying to this message by "REMOVE". If you are not the named recipient, you are not authorized to use, disclose, distribute, copy, print or rely on this email, and should immediately delete it from your computer system. it from your computer system. -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.