Job Description
Database Developer for strategic program. Resource will allow program to meet delivery targets.
The objective of the program is to Provide Actionable Informational Dashboards to our TI and Business Partners. Ultimately this effort would drive Operational Excellence
Experienced MS SQL database developer who will be responsible for developing / maintain TSQL code. 7+ years of full time experience as MS SQL / TSQL Developer with stored procedures, views, triggers, cursors, tables and index creation. 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 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.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
7+ years’ full time experience in MS SQL development
MSSQL Server 2019 or higher
SSIS (SQL Server Integration Services)
SSRS (SQL Server Reporting Services)
Knowledge of Bit Bucket
Visual Studio 2019 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)
5+ years experience in Microstrategy reporting or similar
Good to have: C# scripting, Tableau
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.