"Alerted.org

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 [email protected] 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/.

Skills and Requirements

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