DB Architect SQL Server SSIS
Location : Wayne, NJ
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.
-- Location : Wayne, NJ
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.
--
The Most Active and Happening #1 ERP/SAP Jobs Listserve for SAP Jobs in the US.
LIKE our Facebook page : https://www.facebook.com/ERPJobs
https://groups.google.com/group/sapjobs-usa
Follow us on Twitter:
https://twitter.com/sapjobsusa
Post your Jobs at SAP JOBS USA Linkedin Group by clicking this link
https://www.linkedin.com/groups/SAP-JobsUSA-4081187/about
Join our Professionals Networks in Linkedin
https://www.linkedin.com/groups/SAP-JobsUSA-4081187/about
https://www.linkedin.com/groups/Global-Network-SAP-Professionals-4081179/about
https://www.linkedin.com/groups/Network-SAP-Professionals-3874920/about
http://finance.groups.yahoo.com/group/SAPJobs-USA/
https://www.facebook.com/groups/mysapfico/
---
You received this message because you are subscribed to the Google Groups "SAP JOBS USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to SAPjobs-USA+unsubscribe@googlegroups.com.
To post to this group, send email to SAPjobs-USA@googlegroups.com.
Visit this group at http://groups.google.com/group/SAPjobs-USA.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment