Job Description:

• Experienced MS SQL database developer who will be responsible for developing / maintain TSQL code. .
• Experience with Autosys, BIDS/SSIS, TFS, C# and familiarity with object oriented database design and development.
• Experience in database and query optimization will be important. Must have familiarity with IT Infrastructure management domain.
• Candidate is expected to have good communication and documentation skills. Solid understanding of data architecture, efficient database design, writing complex queries and query tuning and troubleshooting.
• Resource will be responsible for creating the table structures and will process data that is required to meet a critical reporting need within the technology group.
• In addition, resource should able to work independently with minimal guidance, in understanding requirements provided by Business Analysts and writing ETL programs to source data from upstream database systems as well as data sourced with various file formats such xml, csv etc.

Required Skills:

• 7+ years' full time experience in MS SQL development
• MSSQL Server 2012 or higher
• SSIS (SQL Server Integration Services)
• SSRS (SQL Server Reporting Services)
• Knowledge of TFS (Team Foundation Service) or a similar service like Bit Bucket
• Visual Studio 2013 or higher
• Writing complex queries and query tuning and troubleshooting
• Ability to write complex stored procedures, functions as well as support/enhance existing
• Ability to create/modify database schema, tables, indexes, etc.
• Knowledge of Indexes, cursors, triggers
• Experience working with partitioned tables and other database design patterns
• SQL Database backup, restore experience with working knowledge of log shipping, log mirroring
• SQL code optimization, tuning with ability to work with large datasets
• Extensive knowledge of Data transformation and validation
• ETL Processing (Autosys Preferred)

Desired Skills:

• Good to have: C# scripting, Tableau

Shift:
1st shift (United States of America)
Hours Per Week:
40