SQL QA SQL Data Architect Administrator (Jobs in Albany, NY)   Requirement id 116222 Job title Administrator Job location in Albany, NY Skills required SQL Queries, SQL Server, QA, SQL Data Architect Open Date 22-Apr-2021 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Administrator: SQL Queries, SQL Server, QA, SQL Data Architect Description: Day-to-Day Tasks include, but not limited to: Build and maintain a data architecture based on the requirements. Design and develop Logical and Physical Data Model using ER Studio Data Architect. Create DDL scripts to establish and maintain necessary databases. Write complex SQL queries against SQL Server and DB2 databases. Create DML scripts to manipulate data. Work with project managers, solution architects, business analysts, application development teams and QA to ensure the quality of DDL and DML scripts. Performance tuning SQL to improve efficiency. Working with NYS Agency representatives to develop gap analysis specifications and understand Agency business rules. Provide guidance and hands-on development for developing and maintaining queries in QMF for Workstation. Create clear and accurate documentation on data models, and description of data usage in the application process flow. Preferred Qualifications: Uses specialized software to store and organize data, which may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, and troubleshooting, as well as backup and data recovery. 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. Mandatory Qualifications: 84 months of Experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, stored procedures. 84 months of Experience designing and developing Data Conversion Strategy Plan, Data Mapping Documents, Gap Analysis. 84 months of Experience writing complex DML SQL against enterprise SQL Server and DB2 databases. 84 months of Experience working with the tools like SQL Server Management Studio, SSMS Job Scheduler, SSIS, SSRS, Export/Import, ER Studio Data Architect, QMF for Workstation, Redgate SQL Compare, TSO. 72 months of experience using programming languages such as SQL, PL/SQL. 60 Months of experience performance tuning complex SQL against enterprise SQL Server and DB2 databases.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 116222 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), SQL Queries job openings in Albany, NY Jobs List Expert Software Analyst - 7311 Create date: 14-Oct-2022 start date: 12/07/2022 End date: 12/07/2024 submission deadline: 10/21/2022 Note: * On-site/Remote : On-site * Interview : Phone or video call; then in-person Description: Qualifications: Software Analyst - Studies.... (This job is for - job Jobs in NY Albany Analyst - (in Albany, NY)) Senior IT Specialist - 6334 Create date: 08-Apr-2022 Description: Day-to-Day Tasks include, but not limited to: Providing Application backend system support and being on call as required. Support application backend in Windows Server 2016-2019 environments, production on-call / off-hours support, troubleshooting, system issue analysis & resolution, and developing te.... (This job is for - job Jobs in NY Albany Specialist - (in Albany, NY)) Expert Database Architect-5865 Create date: 28-Dec-2021 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 - job Jobs in NY Albany Architect - (in Albany, NY)) Expert Software Developer - 5800 Create date: 07-Dec-2021 Description: Day-to-Day Tasks include, but not limited to: Create/Modify Oracle stored procedures, packages, and triggers as necessary to eliminate redundancy and facilitate information sharing between systems. Modify ASP.Net application to provide better integration and implement a common look-and-feel to the var.... (This job is for - SDLC Jobs in NY Albany Developer - (in Albany, NY)) QA Analyst/Test Lead - 5032 Create date: 27-May-2021 Description: Day-to-Day Tasks include, but not limited to: Test Strategy document detailing how quality will be infused throughout the Software Development Life Cycle (SDLC) process Test Scenarios (business entities/objects and their relationships) Traceability matrix outlining the correlation between bus.... (This job is for - SDLC Jobs in NY Albany Analyst - (in Albany, NY))    SQL Queries job openings in other states Jobs List Programmer Analyst 6 -134720 Create date: 06-Sep-2024 Bid Limit Per Vendor : 1 Start date : 10/07/2024 End Date : 09/30/2025 Submission deadline : 9/12/2024 at 10am EST. Client Info : DIFS Note : * Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Use of headphone.... (This job is for - Powerbuilder Jobs in MI Lansing Analyst - (in Lansing, MI)) NCDIT - Applications System Analyst (735593) Create date: 18-Jun-2024 * Remote No of Submissions : 2 Start date :06/01/2024 End Date :10/29/2024 Submission deadline :06/20/2024 Client Info :NCDIT Note: * Webcam Interview Only Description : · The primary purpose of this position is to work in partnership with exte.... (This job is for - Jira Jobs in NC Raleigh Analyst - (in Raleigh, NC)) Programmer/Developer -62703 Create date: 08-May-2024 No of Submissions : Start date : 06/01/2024 End Date : 06/01/2025 Submission deadline : 05/20/2024 Client Info : CT DCF Position Location : Hybrid Description : ------------------------------------------------------ The Department of Children and Families depends on th.... (This job is for - job Jobs in CT Hartford Developer - (in Hartford, CT)) NCDA CS - Technical Architect- Expert (728547) Create date: 03-Apr-2024 Remote start date :04/29/2024 End date :04/27/2025 submission deadline :04/08/2024 client info :NCDA&CS Description : ***This is a remote position, but the candidate has to be located in either the Eastern or Central time zones. .... (This job is for - SSRS Jobs in NC Raleigh Architect - (in Raleigh, NC)) DBHDS - Data Analyst 3 - (729231) Create date: 16-Feb-2024 Job Title: DBHDS - Data Analyst 3 - IN PERSON INTERVIEWS ONLY! (729231) Hybrid start date :03/04/2024 End date :06/28/2024 submission deadline :2/21/2024 client info :DBHDS Description : IN PERSON INTERVIEWS ONLY! No excepti.... (This job is for - Tableau Jobs in VA Richmond Analyst - (in Richmond, VA))    SQL Queries job openings in NY Jobs List Splunk Analyst - 84558 Create date: 05-May-2022 Description: Requirements Minimum education: Bachelor Years of work experience: 3 year(s) Remote conditions Candidates must be located in Oklahoma, Texas, Kansas, Missouri or New Mexico IT skills Must have SPLUNK 3 year(s) of experience SQL Query Vi.... (This job is for - SplunkVirtualization Jobs in NY NewYork Analyst - (in Newyork, NY)) Senior Software Architect - 5644 Create date: 27-Oct-2021 Description: Day-to-Day Tasks include, but not limited to: Review existing data model and recommend changes to support new and existing data requirements. Analyze source system data to uncover data redundancy and duplication. Maintain conceptual, logical and physical data models along with corresponding m.... (This job is for - Metadata Jobs in NY Menands Architect - (in Menands, NY)) Senior Data Warehouse/ODI/BI Developer - 5393 Create date: 25-Aug-2021 Description: Day-to-Day Tasks include, but not limited to: Review existing data model and recommend changes to support new and existing data requirements. Analyze source system data to uncover data redundancy and duplication. Maintain conceptual, logical, and physical data models along with corresponding .... (This job is for - DDL Jobs in NY Menands Developer - (in Menands, NY)) Software Analyst - 4892 Create date: 22-Apr-2021 Description: Day-to-Day Tasks include, but not limited to: Analysis, design, and development of enhanced features for the application. Work with business users for developing business analysis, documentation, and validation. Develop and execute SQL queries to extract data providing reports to business use.... (This job is for - Documentation Jobs in NY Rensselaer Analyst - (in RENSSELAER, NY)) ETL Lead Developer Create date: 08-Apr-2021 Description: We are looking for an Extract, Transform, and Load (ETL) Developer with extensive experience in Snaplogic/Informatica to support the Enterprise Data Warehouse (EDW) program. This individual will serve as the Snaplogic/Informatica ETL Senior Developer to lead. In this role you will participate in project teams to design, deve.... (This job is for - ETLCI CD Jobs in NY NewYork Developer - (in New York, NY)) (Administrator: SQL Queries, SQL Server, QA, SQL Data Architect in Albany, NY)

Featured Jobs AWS .NET FRAMEWORK UI CSS Tester (Jobs in Little Rock, Arkansas) Microsoft Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Nashville, Tennessee) Written Specialist (Jobs in Salem, Oregon) VLAN Subnets Routing Engineer (Jobs in Staunton, Virginia) Training Specialist (Jobs in Atlanta, Georgia) Adobe Analyst (Jobs in Jackson, Mississippi) MS Office EHR Consultant (Jobs in Richmond, Virginia) Information Manager (Jobs in Madison, Wisconsin) Jira UFT Defect Tester (Jobs in Raleigh, North Carolina)