SSIS ETL Data Integration Planning Architect (Jobs in Albany, NY)   Requirement id 134465 Job title Architect Job location in Albany, NY Skills required MS SQL, SSIS, ETL, Data Integration Planning Open Date 13-Jun-2022 Close Date Job type Contract Duration 24 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: MS SQL, SSIS, ETL, Data Integration Planning Description: Qualifications Database Architect- Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems. Expert (84+ months) - Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field. 84 months experience in design and development of advanced SQL queries, stored procedures, triggers, scripts, cursors, and views 84 months experience in MS SQL Server Management Studio (MS SQL Server version 2012+, and upgrade to MS SQL 2019) and proficient use of standard business and database software (including SSRS, SSMS, SSIS), and strong understanding of ETL concepts (Extract, Transform and Load) 84 months of experience in designing data architecture and data modelling (data dictionary and system documentation), including the ongoing maintenance of an existing data model 84 months of experience supporting day-to-day database operations, including: monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization, tuning, consolidating views and tracking and improving database performance metrics 60 months of experience with geocoding processes (importing GIS data to database, data modeling) and experience with Geographic Information Systems (i.e. ArcGIS Pro, Google Maps) Day-to-Day tasks Build complex SQL queries, stored procedures, functions, views, and reports. Understand the business needs and work with developers to design modern and effective database architectures. Analyze functional requirements to perform ad-hoc Extract, Transform and Load (ETL) processes involving data analysis, data manipulation and setting up SSIS packages. Review performance logs to track and analyze production issues, identify and eliminate obsolete DB objects, and optimize stored procedures and jobs to improve database responsiveness. Participate in unit and regression testing by assisting business analysis team to mine and translate complex dataset. Work with data modelling team to draft/maintain system data model and data dictionary. Establish standards for system documentation and advise other team members. Participate in planning and transformation of UIS to new platform. Participate in data integration activities for PBS E-Registration and for mobile field inspection project.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 134465 while calling.   Other jobs in NY: Albany (4), Bethpage (6), BUFALLO (1), Buffalo (6), Commack (4), Commack Long (1), Jericho (5), Long Island (4), Long Island City (2), Manhattan (5), Midtown NYC (1), New York (41), New York City (8), NYC (2), MS SQL job openings in Albany, NY Jobs List Expert Software Architect - 6829 Create date: 13-Jun-2022 Description: Qualifications Software Architect - Makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large scale software system. Expert (84+ months) - Candidate is able to pro.... (This job is for - job Jobs in NY Albany Architect - (in Albany, NY)) Expert Software Architect - 6120 Create date: 03-Mar-2022 Description: Day-to-Day Tasks include, but not limited to: Mentoring and guiding team members through the development process. Working with project managers and business analysts to understand the schedule, scope, requirements and deliverables. Design software components that address scope and requirement.... (This job is for - Oracle Design Jobs in NY Albany Architect - (in Albany, NY)) Senior Software Developer - 5356 Create date: 10-Aug-2021 Description: Day-to-Day Tasks include, but not limited to: Primarily responsible for Supporting and Maintaining MS Access Applications. Assist with modernizing MS Access Database applications written in MS Access, to other technologies (Oracle, MS SQL, Java). Manage and develop data extracts and reporting.... (This job is for - OracleJava Jobs in NY Albany Developer - (in Albany, NY)) Microsoft SQL Server Database Administrator - 4817 Create date: 06-Apr-2021 Description: Day-to-Day Tasks include, but not limited to: Install, configure, administer, and manage MS SQL Server databases including high availability and disaster recovery configurations. Assist in Developing and implementing appropriate high availability and disaster recovery solutions. P.... (This job is for - MS SQL Server Jobs in NY Albany Administrator - (in Albany, NY)) MSSQL Database Administrator - 4795 Create date: 01-Apr-2021 On-site/Remote: On-site Description: Responsibilities TVT is a NYS HBITS Prime Vendor! Are you Tech Terrific, an innovative thinker, and have great interpersonal skills? We have a 30-month project with our client in Albany, NY that requires a MSSQL Database Administrator, Expert. Day-to-Day Tasks.... (This job is for - Developing Jobs in NY Albany Administrator - (in Albany, NY))    MS SQL job openings in other states Jobs List SharePoint Administrator - SME - 130055 Create date: 06-May-2024 No of Submissions : 1 Start date : 5/20/2024 End date : 9/30/2024 Submission deadline : 5/8/2024 3:00:00 PM Client info : MDEK12 Note : * Onsite Description : The SharePoint Administrator will be responsible for .... (This job is for - job Jobs in MS Jackson Administrator - (in Jackson, MS)) WEB/INTERNET ENGINEER-CONSULTANT - 11198-1 Create date: 24-Apr-2024 Candidate Submission Limit Per Supplier : 2 Start date :5/17/2024 Submission deadline : 5/1/2024 Client info : Health & Environmental Control Department (DHEC) Note : * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? - An interview panel will.... (This job is for - job Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) Security Architect - 11168-1 Create date: 25-Mar-2024 Start date : 5/2/2024 Submission deadline : 4/1/2024 Client Info : Department of Motor Vehicles Note : Q) Interview Process (who will conduct i/v, phone or in-person, how many rounds of i/vs)? A) • Eric Crane, Security Team Manager • In-person preferred but will be willing to accommoda.... (This job is for - job Jobs in SC Blythewood Architect - (in Blythewood, SC)) SYSTEMS ANALYST-11159-1 Create date: 12-Mar-2024 start date :APRIL 9, 2024 submission deadline :3/19/2024 client info :Department of Health and Human Services Note: Q) INTERVIEW PROCESS (WHO WILL CONDUCT I/V, PHONE OR IN-PERSON, HOW MANY ROUNDS OF I/VS)? A) HIRING MANAGER WILL CONDUCT MICROSOFT TEAMS INTERVIEWS Q) SCHEDULE INTE.... (This job is for - job Jobs in SC COLUMBIA Analyst - (in Columbia, SC)) DATABASE DEVELOPER (SQL) - ADVANCED - 11149-1 Create date: 05-Mar-2024 Start date : 3/4/24 Submission deadline : 3/12/2024 Client info : Department of Transportation Description : RE-DEVELOPMENT AND INTEGRATION OF MULTIPLE DATABASE SYSTEMS SERVING INTERFACING BETWEEN THE AGENCY PERSONNEL INFORMATION SYSTEM, CLOUD HOSTED ENTERPR.... (This job is for - job Jobs in SC COLUMBIA Developer - (in Columbia, SC))    MS SQL job openings in NY Jobs List AWS Sr. Java Developer Create date: 08-Jul-2022 Description: Responsibilities · Develop JSON RESTful web service APIs for Digital Banking Platform. · Participate in complete project life cycle. Provide technical requirements/specifications, project estimates, and system design configuration for simple to complex projects. Complex projects may include multiple bus.... (This job is for - TOMCATJava Jobs in NY NewYork Developer - (in New York, NY)) Expert Database Architect. - 6513 Create date: 27-Apr-2022 Description: Day-to-Day Tasks include, but not limited to: Build complex SQL queries, stored procedures, functions, views, and reports. Understand the business needs and work with developers to design modern and effective database architectures. Analyze functional requirements to perform ad-hoc Extract, T.... (This job is for - ETL Jobs in NY Rensselaer Architect - (in RENSSELAER, NY)) Database Developer - 63746 Create date: 02-Jun-2020 Note: * Candidate must be your W2 Employee. * We should submitt only GC, GC EAD, L2 EAD, H4 EAD and Citizen. * We should take signed RTR form from the candidate (Candidate RTR form should be only on the name of Apex Systems) Job Description : Database Developer 24 MONTHS P.... (This job is for - SSIS Tableau Jobs in NY NewYork Developer - (in New York, NY)) SQL Database Developer - 60661 Create date: 05-Mar-2020 Job Description : It combines with parent company On Assignment to make it the 2nd largest IT staffing agency in the country. Here are the details: Position: SQL Database Developer Location: Buffalo, NY Rate: Negotiable Duration: 6+ Month Contr.... (This job is for - SSIS Jobs in NY Buffalo Developer - (in Buffalo, NY)) Senior MySQL Admin Create date: 16-Dec-2014 Note: End Client Name : McGrawHill Education Description: Hands-on experience in database administration of MySQL. Hands-on experience with various MySQL engine types, include InnoDB, MyISAM, MEMORY. Hands-on experience with setup, configuration, maintenance, trouble-shooting MySQL replication environments. Hand.... (This job is for - job Jobs in NY Hightstown Administrator - (in Hightstown, NY)) (Architect: MS SQL, SSIS, ETL, Data Integration Planning in Albany, NY)

Featured Jobs Self Developer (Jobs in Atlanta, Georgia) Cisco Routers Network Consultant (Jobs in Virginia Beach, Virginia) Java J2EE HTML/CSS SQL Consultant (Jobs in Richmond, Virginia) Troubleshoot Analyst (Jobs in Hamilton, New Jersey) Stakeholders Project Consultant (Jobs in Hartford, Connecticut) Cybersecurity SIEM Linux Analyst (Jobs in Jackson, Mississippi) VLAN Cisco Routers Routing Consultant (Jobs in Fairfax, Virginia) Project Consultant (Jobs in Lincoln, Nebraska) JavaScript Spring Analyst (Jobs in Richmond, Virginia) Strong Analyst (Jobs in North Chesterfield, Virginia)