Hopewell Township, NJ
|
Programmer / Developer
|
Contract
|
$47 - $59 (hourly estimate)
{"JobID":472847,"JobType":["Contract"],"EmployerID":null,"Location":{"Latitude":-74.7775,"Longitude":40.3327,"Distance":null},"State":"New Jersey","Zip":"08534","ReferenceID":"NYC-376946b1-680c-4c6a-8df8-ad05dd5c2d46","PostedDate":"\/Date(1764768533000)\/","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 ExcellenceExperienced 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\u0027s Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.","Title":"SQL Database Developer","City":"Hopewell Township","ExpirationDate":null,"PriorityOrder":0,"Requirements":"7+ years? full time experience in MS SQL developmentMSSQL Server 2019 or higherSSIS (SQL Server Integration Services)SSRS (SQL Server Reporting Services)Knowledge of Bit BucketVisual Studio 2019 or higherWriting complex queries and query tuning and troubleshootingAbility to write complex stored procedures, functions as well as support/enhance existingAbility to create/modify database schema, tables, indexes, etc.Knowledge of Indexes, cursors, triggersExperience working with partitioned tables and other database design patterns SQL Database backup, restore experience with working knowledge of log shipping, log mirroringSQL code optimization, tuning with ability to work with large datasetsExtensive knowledge of Data transformation and validationETL Processing (Autosys Preferred)5+ years experience in Microstrategy reporting or similarGood to have: csharp scripting, Tableau","Skills":"","Industry":"Programmer / Developer","Country":"US","Division":"IT","Office":null,"IsRemoteJob":false,"IsInternalJob":false,"ExtraValues":null,"__RecordIndex":0,"__OrdinalPosition":0,"__Timestamp":0,"Status":null,"ApplicantCount":0,"SubmittalCount":0,"ApplicationToHireRatio":0,"JobDuration":null,"SalaryHigh":59.0000,"SalaryLow":47.2000,"PayRateOvertime":0,"PayRateStraight":0,"Filled":0,"RemainingOpenings":0,"TotalOpenings":0,"Visa":null,"ClearanceType":null,"IsClearanceRequired":false,"IsHealthcare":false,"IsRemote":false,"EndClient":null,"JobCreatedDate":"\/Date(-62135578800000)\/","JobModifiedDate":"\/Date(-62135578800000)\/"}
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 ExcellenceExperienced 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/.