SSIS Developer / DBA - Chillicothe, OH - Georgia IT Inc.

Job Title: SSIS Developer / DBA
Location: Chillicothe, OH
Position Type: Contract

US Citizen/ GC and GC EAD
Job Description

• Manage SSIS Package/Job schedules and troubleshooting
• Troubleshoot SSIS packages to address critical production issues
• Develop SSIS packages both from scratch, as well as utilizing best practices for process optimization of the current environment
• Develop complex queries and stored procedures using T-SQL
• Performance tuning
• Maintain Test, Cert and Production Environments for package testing
• Comply with the change control process
• Maintain Audit Compliance
• SQL Design and Development Consulting
• Create and maintain detailed standard work/procedure documents
• Provide technical support and guidance to end users
• Complete daily operating system health checks
• Support scheduled after-hours maintenance and deployments

Skills Required:

• 3– 5 Years' recent experience administering SQL Server databases/instances and working with SSIS
• 3-5 Years' of ETL (Extract, Transform, and Load) Programming experience with strong analytical skills
• Ability to create transformations and mappings with minimal supervision
• Ability to troubleshoot issues in ETL jobs and reports
• Strong experience in data cleansing ETL performance tuning
• Experience with automation and deployment of ETLs
• Experience in scheduling SSIS batch jobs using SQL Server Agent
• In-depth knowledge of installing, troubleshooting, and administering SQL Server 2008+
• In-depth experience with SQL Server Integration Services (SSIS) including script tasking and use of the Integration Services catalog and package configuration
• Strong documentation, organizational, and administration skills
• Strong oral and written communication skills
• Experience with Windows Server considered a plus

Education/Training: Bachelor's degree in Information Technology or related field required. MCSE or related SQL certification preferred.