Location NJ-New Jersey/ Wayne
Duration 12 month
Least 10 Years of experience in SQL Server & SSIS.
Hands on Experience in MS SQL Server Integration Services 2005/2008/2012 (SSIS)
Functional requirements gathering, analysis, designing data model and SSIS packages etc
Significant development experience in SSIS is preferred.
Experience in database-related performance tuning.
Working knowledge in data modeling.
Experience in SQL Server T-SQL database development (data modeling, stored procedures, functions and query optimization).
Experience in ETL Processing using the MS SSIS packages, the transactional data processing in various formats like flat files, excel files, direct db pull etc.
Experience in the data extraction, cleansing, transformation, lookups etc using SSIS packages the data then pushed into the data marts or central DB.
Experience in designing Source & Fact tables.
Design and development of job control mechanism to control the execution of the packages in sequence.
Design and creation of the audit and event mechanism.
Additional responsibilities include tuning the ETL processes, creation of the technical and system specification documents necessary to support ETL processes and participate in
development and execution of unit and system test plans.
Installation and configuration of SQL Server 2005, 2008 (Standalone & Cluster Environment) and ensuring all aspect of database maintenances
Perform Full and Differential backup of database using query
DB tuning using various tools available in SQL Server.
Backup and Recovery of the database and restoration of the databases.
Analysis of locks, isolation levels and index maintenance.
Hands on experience on Log Shipping, Mirroring Replication & Failover Clustering
Hands on Experience in SP Upgrade and SQL Upgrade
MCITP/MCSE certification is an added advantage.
--
-----
Please send the resumes to kevin@questinfosoft.com )
Regards,
Kevin | Questinfosoft |
Direct : 512-553-7942 | kevin@questinfosoft.com | www.questinfosoft.com
-- Duration 12 month
Least 10 Years of experience in SQL Server & SSIS.
Hands on Experience in MS SQL Server Integration Services 2005/2008/2012 (SSIS)
Functional requirements gathering, analysis, designing data model and SSIS packages etc
Significant development experience in SSIS is preferred.
Experience in database-related performance tuning.
Working knowledge in data modeling.
Experience in SQL Server T-SQL database development (data modeling, stored procedures, functions and query optimization).
Experience in ETL Processing using the MS SSIS packages, the transactional data processing in various formats like flat files, excel files, direct db pull etc.
Experience in the data extraction, cleansing, transformation, lookups etc using SSIS packages the data then pushed into the data marts or central DB.
Experience in designing Source & Fact tables.
Design and development of job control mechanism to control the execution of the packages in sequence.
Design and creation of the audit and event mechanism.
Additional responsibilities include tuning the ETL processes, creation of the technical and system specification documents necessary to support ETL processes and participate in
development and execution of unit and system test plans.
Installation and configuration of SQL Server 2005, 2008 (Standalone & Cluster Environment) and ensuring all aspect of database maintenances
Perform Full and Differential backup of database using query
DB tuning using various tools available in SQL Server.
Backup and Recovery of the database and restoration of the databases.
Analysis of locks, isolation levels and index maintenance.
Hands on experience on Log Shipping, Mirroring Replication & Failover Clustering
Hands on Experience in SP Upgrade and SQL Upgrade
MCITP/MCSE certification is an added advantage.
--
-----
Please send the resumes to kevin@questinfosoft.com )
Regards,
Kevin | Questinfosoft |
Direct : 512-553-7942 | kevin@questinfosoft.com | www.questinfosoft.com
--
All Job Openings : http://groups.google.com/group/jobjunction/topics?hl=en
You received this message because you are subscribed to the Google
Groups "Job Junction" group.
Send us your resume to jobjunction.global@gmail.com, we will post you updated openings.
To post to this group, send email to jobjunction.global@gmail.com
To unsubscribe from this group, send email to jobjunction+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jobjunction?hl=en
---
You received this message because you are subscribed to the Google Groups "Job Junction" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jobjunction+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment