Hi Friends, *NEED DATA WAREHOUSE DBA, SSIS*
*Please respond to** [email protected] **with all the skills mentioned on the resume** * Location: Olympia, Washington Duration: 3+ months *Required skills** –MUST HAVE ALL*** · MS SQL Server 2005/08 · SQL Server Integrated Services (SSIS) 2005/08 · Visual Basic · VB Script · SQL/Transact SQL · OLE/DB · ODBC · Power Designer or Case tool · WinZip or compression utility · BriQuery, Hyperion, Business Objects, Excel or MS Access · Data Warehouse DBA expert § Partitioning tables, cluster indexing § DB/Table/Index Performance Tuning § Create, maintain, multiple DB and Tables, stored procedures, triggers, security roles, macros, views · SQL Server Integrated Services (SSIS) expert § Full & Incremental Fact Dimension ETL SSIS package development § Slowing changing dimensions of Type 1, 2 § Performance tuning of SSIS packages § Robust SSIS packages with row counts, verifications, notifications, security, runs on test and production servers, ftp, compress txt files, indexing, constraints, § Drop tables, truncate tables, create and modify tables within SSIS package § SSIS packages executes VBScript, Visual Basic, stored procedures, scripting tasks · Experience scheduling and deploying using package configuration · Experience creating user defined data types (UDDT) · Experience documenting unique features of SSIS packages, DB maintenance, programs, and systems · Experience in Knowledge transfer of DB maintenance · Knowledge of reading and creating database designs and schemas · Experience migrating DBMS to DW SQL Server · Working knowledge of Data Warehouse architectures · Knowledge of best practices and fit of Data Warehouse architectures. -- Thanks & Regards James Astoline Inc Phone : 732-658-9252 E-mail : [email protected] www.astoline.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Mainframe1952" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/mainframe1952?hl=en -~----------~----~----~----~------~----~------~--~---
