Microsoft SQL Server PLSQL SQL Database Transact SQL Powerbuilder BCPs Written And   Requirement id 114825 Job title Architect Job location in Portland, OR Skills required Data Analysis, Data Modelling, DBA Skills, Microsoft SQL Server PLSQL SQL Database Open Date 09-Mar-2021 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: Data Analysis, Data Modelling, DBA Skills, Microsoft SQL Server PLSQL SQL Database start date:04/12/2021 End date:10/08/2021 submission deadline:03/15/2021 client info : DHS / OHA Note: * Candidate must be local or willing to commute or relocate. Description: we are a shared service provider for the Oregon Health Authority and Oregon Department of Human Services. we provides the technology systems and services that support more than 11,000 agency staff at local offices and facilities around the state. These systems and services help the two agencies determine client service program eligibility; provide medical, housing, food and job assistance; provide addiction, mental health, vocational and rehabilitative services; protect children, seniors and people with physical and/or developmental disabilities; process claims and benefits; manage provider licensing and state hospital facilities; and promote and protect the state public health. we seeks an experienced Database Architect IV with expertise in analyzing existing Sybase data architectures and performing database migrations between Sybase and MS Sql Server in accordance with business, data security, and regulatory requirements. This contract position will fulfill client objectives of decommissioning existing Sybase databases. For this engagement, this includes the migration of an existing Sybase database and migration of that database to MS SqlServer. This includes Stored Procedures, PowerBuilder objects, joins and transaction objects. The existing Sybase database supports a set of applications within the Nutrition Health Screening section, which includes the Family Net and WIC (Women, Infants, Children) applications. The applications are written in Sybase PowerBuilder. The outcome of this migration project is to have the PowerBuilder applications maintain all existing functionality once migration to MSSql Server is complete. Contractors Key Person will work with OIS technical staff and business program personnel to develop a strategic roadmap to develop and execute the database migration effort. Scope: Contractors Key Person under this WOC will participate in setting the strategic direction for the database migration. Contractors Key Person will provide expertise in the planning efforts to identify tasks and deliverables. The Contractors Key person with then execute those tasks to complete the migration. Tasks: Contractors Key Person shall: Audit existing data systems; models, queries, stored procedures, security, etc. and provide recommendations and a suggested roadmap for migration. Develop and implement recommended strategy for migration of schema. Implement conversion of Power Builder Window Objects. Develop recommended data standards for bulk data migration (e.g. BCP scripts). Modify Transaction objects for new MS SqlServer database. Maintain existing data security and access models. Develop database administration standards and processes, including change control, to inform Agencys SDLC process, and train staff in the application and use of these standards and processes. Develop a data (or database) change request process with the developer and Data Resource Management teams Required skills and experience: Data Analysis Data Modeling Database Migration Sybase MSSql Server Transact SQL Stored procedures In addition, the ideal candidate will have skills and experience in: Experience of familiarity with Power Builder SSMA – SQL Server Migration Assistant BCP scripts Conversion of Power Builder Window Objects   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 114825 while calling.   Other jobs in OR: Orange (1), Portland (22), Salem (38), Tigard (3), Wilsonville (2), Data Analysis job openings in Portland, OR Jobs List Business Analyst IV - REQ-83900-00078177 Create date: 05-Jun-2024 No of Submissions : 1 start date : 08/01/2024 End date :01/31/2025 submission deadline : 07/01/2024 client info : BOLI Note: * Position Location: Remote Description : Seeking individual in this positi.... (This job is for - job Jobs in OR Portland Analyst - (in Portland, OR)) 37525 - Systems Administrator IV Create date: 20-Jun-2011 [Note:Length of initial engagement: 3 months (40 hours per week for 13 weeks)] [Estimated Duration 06/27/2011 - 09/27/2011] Experience, expertise and skills: 1. BS or BA in computer science, business, or equivalent preferred 2. 4+ years experience using Cognos BI suite 3. Demonstrated Cognos technical expertise.... (This job is for - job Jobs in OR Portland Administrator - (in Portland, OR))    Data Analysis job openings in other states Jobs List VDOT Business Analyst 4 (742717) Create date: 23-Jul-2024 * Hybrid No of Submissions : 2 Start date : 07/29/2024 End Date : 06/30/2025 Submission deadline : 7/26/2024 Client Info : VDOT Note: * Agency Interview Type : Both Phone and In Person * This position requires onsite 3 days a week with 2 remote * Lo.... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) VDH Data Scientist REMOTE II (742629) Create date: 17-Jul-2024 Remote No of Submissions : 3 start date :07/01/2024 End date :06/30/2025 submission deadline : 7/22/2024 client info : VDH Note: * Agency Interview Type: Web Cam Interview Only Description : *local candida.... (This job is for - job Jobs in VA RICHMOND Consultant - (in Richmond, VA)) VDH Data Analyst 3 (732560) Create date: 02-Jul-2024 * Remote No of Submissions : 2 Start date : 07/15/2024 End Date : 12/31/2024 Submission deadline : 7/5/2024 Client Info : VDH Note: * Web Cam Interview Only Description : The Virginia Department of Healths Division of Informatics and Information Syste.... (This job is for - Tableau Jobs in VA Richmond Analyst - (in Richmond, VA)) VDOT Data Analyst 2 (735563) Create date: 06-Jun-2024 * Hybrid No of submissions : 2 Start date :06/24/2024 End date :06/30/2024 Submission deadline : 6/11/2024 Client info : VDOT Description : * Data Analyst with proficiency in Power BI to join our team. As a Data Analyst, you w.... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) DBHDS - Data Governance Analyst - 6 Mo C-H (739142) Create date: 30-May-2024 Hybrid No of submissions : 2 Start date :06/17/2024 End date :10/31/2024 Submission deadline : 6/4/2024 Client info : DBHDS * Note : * 2 days/week ON SITE required Description : * Duration expected: 6 mo .... (This job is for - datawarehouse Jobs in VA Richmond Analyst - (in Richmond, VA))    Data Analysis job openings in OR Jobs List Technical Specialist IV - B36991W112 Create date: 28-Aug-2024 No of Submissions : 1 Start date : 09/23/2024 End Date : 09/23/2025 Submission deadline : 09/02/2024 Client Info : Bill Rate : USD 95.00 Per Hour Max Rate : USD 103.00 Per Hour Note: * Position Location : Remote * Candidate must be local or willin.... (This job is for - job Jobs in OR Salem Specialist - (in Salem, OR)) Technical Specialist IV - B36991W111 Create date: 28-Aug-2024 No of Submissions : Start date : 09/23/2024 End Date : 09/23/2025 Submission deadline : 09/02/2024 Client Info : ODOT Bill Rate : USD 95.00 Per Hour Max Rate : USD 103.00 Per Hour Note: * Position Location : Remote Description : Respon.... (This job is for - job Jobs in OR Salem Specialist - (in Salem, OR)) Technical Specialist IV - B36991W110 Create date: 28-Aug-2024 No of Submissions : 1 Start date : 09/23/2024 End Date : 09/23/2025 Submission deadline : 09/02/2024 Client Info : ODOT * Bill Rate : USD 95.00 Per Hour * Max Rate : USD 103.00 Per Hour Note: * Position Location : Remote Description : job Jobs in OR Salem Specialist - (in Salem, OR)) System Specialist IV - B36991W104 Create date: 24-May-2024 * Bill Rate: USD 92.00 Per Hour * Max Rate: USD 113.00 Per Hour No of Submissions : 1 start date : 06/17/2024 End date : 01/18/2025 submission deadline : 05/29/2024 client info : ODOT Note: * Position Location: Remote .... (This job is for - job Jobs in OR Salem Specialist - (in Salem, OR)) System Specialist IV - B36991W105 Create date: 24-May-2024 * Bill Rate :USD 100.00 Per Hour * Max Rate :USD 113.00 Per Hour Max Submittals by Vendor : 1 Start date : 06/17/2024 End date : 01/18/2025 Submission deadline : 05/29/2024 Client info : ODOT Note : * Position Location:Remote .... (This job is for - job Jobs in OR Salem Specialist - (in Salem, OR)) (Architect: Data Analysis, Data Modelling, DBA Skills, Microsoft SQL Server PLSQL SQL Database in Portland, OR)

Featured Jobs Troubleshooting Engineer (Jobs in Des Moines, Iowa) Application Developer (Jobs in Richmond, Virginia) Business Analyst Business Analyst (Jobs in Richmond, Virginia) Consultant (Jobs in Murfreesboro, Tennessee) TFS Automation Analyst (Jobs in Dimondale, Michigan) Cloud Architect (Jobs in Lansing, Michigan) GitHub Consultant (Jobs in Lansing, Michigan) IT Developer (Jobs in Atlanta, Georgia) Microsoft Consultant (Jobs in ANDERSON, South Carolina) Business Analyst JAD SQL Analyst (Jobs in Lansing, Michigan)