Sql Server 2000 T-SQL OLTP OLAP Data Warehousing SQL Script Performing Data Analysis   Requirement id 134772 Job title Specialist Job location in Reynoldsburg, OH Skills required Bachelor Degree In Computer Science, Sql Server 2000, T-SQL, OLTP OLAP Data Warehousing SQL Script Pe Open Date 28-Jun-2022 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Specialist: Bachelor Degree In Computer Science, Sql Server 2000, T-SQL, OLTP OLAP Data Warehousing SQL Script Pe Start date :07/18/2022 End Date :06/30/2023 Submission deadline :06/30/2022 Client Info : COM Description : Requirement Description: The candidate will be supporting The Ohio Department of Commerces databases, reports, and integrations. The ideal candidate will provide advanced database development that supports our various applications, integrations, and reports. This position will function as a highly technical database developer with specific qualities that include: • Being a fully autonomous, self-learning, and self-motivated database developer. • In-depth knowledge of Microsoft-based database technologies and tools. • Proven ability to adapt to any database technology as needed. • Ability to identify common support incidents quickly and implement permanent resolutions effectively. • Ability to lead projects from inception to completion either as an individual contributor or as part of a team. • Ability to communicate effectively with users in both IT and the business. Responsibilities: • Filling the role of a database developer and utilizing a toolset listed in the Mandatory Requirements to complete database tasks and projects. • Finding opportunities for automation and improvement in existing database environments. • Helping The Department of Commerce to improve database development processes and standards. • Going above and beyond on all support tasks, by working towards permanent resolutions rather than temporary fixes. Mandatory Requirements/Time • Bachelors degree in computer science or equivalent technical study. • 8 Years or more experience in database design, development, implementation, and support using various Microsoft database technologies, such as: SQL Server, T-SQL in OLTP, OLAP, and data warehousing environments. • Expertise in writing and tuning complex SQL scripts including Indexes, Views, Complex stored procedures, CTE appropriate functions, and effective Triggers to facilitate efficient data manipulation and data consistency in MS SQL server. • Strong technical knowledge in SQL Server BI suite (ETL, Reporting, Analytics, Dashboard) using SSIS, SSRS, and Power BI or other reporting tools. • Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse, Azure Blob, and Azure Storage Explorer. • Strong Azure Data Factory knowledge for deploying SSIS packages using SSIS Integration Runtime, and creating pipelines for CI/CD. • Demonstrated ability to manage and prioritize a large workload. • Strong communication skills. • Proven ability to learn and adapt to new technologies • Proven ability to interact with business or product customers, gather requirements, and deliver complete, scalable, and sustainable solutions. Desired Skills • Experience mentoring and leading a team of database development personnel.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 134772 while calling.   Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2), Bachelor Degree In Computer Science job openings in Reynoldsburg, OH Jobs List COM-Programmer 5 / PR 5 (696291) Create date: 27-Oct-2022 Start date :11/01/2022 End Date :06/30/2023 Submission deadline :10/31/2022 Client Info :COM Description : The candidate will work with The Ohio Department of Commerce development team, database team and architect to develop custom software. This position will function as a Senior .... (This job is for - API Jobs in OH Reynoldsburg Developer - (in Reynoldsburg, OH)) COM-Product Specialist 3/ PS3 (686667) Create date: 28-Jun-2022 Start date :07/18/2022 End Date :06/30/2023 Submission deadline :06/30/2022 Client Info :COM Description : Requirement Description: The candidate will support The Ohio Department of Commerces custom and 3rd-party software applications. The ideal candidate will provide advanced support .... (This job is for - job Jobs in OH Reynoldsburg Specialist - (in Reynoldsburg, OH))    Bachelor Degree In Computer Science job openings in other states Jobs List GA DOR - IT Security Manager 1 (750019) Create date: 30-Oct-2024 Hybrid No of Submissions : 2 start date : 12/02/2024 End date : 06/30/2025 submission deadline : 11/13/2024 client info : DOR - IT Note: * Agency Interview Type: Web Cam Interview Only Description : *Cand.... (This job is for - job Jobs in GA Atlanta Manager - (in Atlanta, GA)) NCDIT - NG911 Administrative Specialist (750015) Create date: 28-Oct-2024 No of Submissions : 2 Start date : 11/01/2024 End Date : 06/30/2025 Submission deadline : 10/29/2024 Client Info : NCDIT Note: * Agency Interview Type : Either Webcam Interview or In Person * Onsite Description : The NC911 NMAC Network Monitoring an.... (This job is for - job Jobs in NC Raleigh Specialist - (in Raleigh, NC)) GA DHS - Sr. Analytics Developer (750007) Create date: 24-Oct-2024 Remote No of Submissions : 2 start date : 11/25/2024 End date : 06/30/2025 submission deadline : 10/30/2024 client info : DHS Note: * Agency Interview Type: Web Cam Interview Only * *DO NOT SUBMIT CANDIDATES PREVIOUSLY SUBMITTED TO #743668* .... (This job is for - BigQuery Jobs in GA Atlanta Developer - (in Atlanta, GA)) Application GIS Developer -63490 Create date: 23-Oct-2024 No of Submissions : 2 start date : 11/15/2024 End date : 06/30/2025 submission deadline : 10/30/2024 client info : NeOCIO Note: * Position Location: On Site * Candidate must be within 100 miles * Position is downtown in Lincoln, Nebraska. * .... (This job is for - job Jobs in NE Lincoln Developer - (in Lincoln, NE)) Solutions Architect - 8627969 Create date: 18-Oct-2024 No of Submissions : 1 Start date : 11/04/2024 End Date : 06/30/2025 Submission deadline : 10/23/2024 Client Info : OIT Note: * Position Location : Remote * Bill Rate : USD 115.00 Per Hour * Max Rate : USD 131.00 Per Hour Description : job Jobs in CO Denver Architect - (in Denver, CO))    Bachelor Degree In Computer Science job openings in OH Jobs List AGE-Program Manager 5/ PM5) (737214) Create date: 16-May-2024 Job Title: AGE-Program Manager 5/ PM5)Data Analytics Solution Manager) (737214) No of Submissions : 3 start date : 07/01/2024 End date : 06/30/2025 submission deadline : 05/20/2024 client info : AGE Description : .... (This job is for - job Jobs in OH Columbus Manager - (in Columbus, OH)) DAS-IT Consultant 2 / ITC2 (725419) Create date: 01-Dec-2023 Start date :12/11/2023 End date :06/30/2024 Submission deadline :12/04/2023 Client info :DAS Description : Preferred Education: Bachelors Degree – Computer Science, IT, or Engineering-Focused Major Job Description: The IOP CX identity platfo.... (This job is for - job Jobs in OH Columbus Consultant - (in Columbus, OH)) DAS-IT Consultant 2/ ITC2 (721622) Create date: 02-Oct-2023 Start date : 10/16/2023 End Date : 06/30/2024 Submission deadline :10/04/2023 Client Info : DAS Description : ------------------------------------------------------ Years of Relevant Experience: 5 Preferred Education: Bachelors Degree – Computer Science, IT, Business, instructional d.... (This job is for - job Jobs in OH Columbus Consultant - (in Columbus, OH)) DODD - Technical Specialist 4 / TS4 (716518) Create date: 02-Aug-2023 hybrid Start date :09/11/2023 End Date :06/30/2024 Submission deadline :08/07/2023 Client Info :DODD Description : ------------------------------------------------------ Hybrid onsite 2 Openings DODD is requesting two (2) Salesforce Developers using the Technical Speci.... (This job is for - job Jobs in OH Columbus Specialist - (in Columbus, OH)) COM-Product Specialist 3 / PS3 (689852) Create date: 09-Aug-2022 Start date :08/29/2022 End Date :06/30/2023 Submission deadline :08/11/2022 Client Info :COM Description : Requirement Description: *NOTE: THIS IS A SUPPORT ROLE - NOT A SOFTWARE DEVELOPMENT ROLE* The candidate will support The Ohio Department of Commerces custom and 3rd-party softw.... (This job is for - job Jobs in OH Columbus Specialist - (in Columbus, OH)) (Specialist: Bachelor Degree In Computer Science, Sql Server 2000, T-SQL, OLTP OLAP Data Warehousing SQL Script Pe in Reynoldsburg, OH)

Featured Jobs Developer (Jobs in Atlanta, Georgia) Data Architect ETL Specialist (Jobs in Raleigh, North Carolina) SQL Architect (Jobs in Richmond, Virginia) Business Analyst Financial Analyst (Jobs in Fredericksburg, Virginia) Cyber Architect (Jobs in Columbia, South Carolina) VxRails Consultant (Jobs in Boise, Idaho) Project Manager Microsoft Manager (Jobs in Raleigh, North Carolina) Agile Jira UAT Manager (Jobs in Atlanta, Georgia) - - Analyst (Jobs in Portland, Oregon) HTMLCSSJavaScript Developer (Jobs in Lincoln, Nebraska)