MS Word SQL Database Data Modeling Architect (Jobs in Remote, OR)   Requirement id 67133 Job title Architect Job location in Remote, OR Skills required Database Analyst, MySQL Experience, Relation Database Experience Expert, MS Word SQL Database Data Modeling Open Date 26-Jan-2018 Close Date Job type Not specified Duration 3 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: Database Analyst, MySQL Experience, Relation Database Experience Expert, MS Word SQL Database Data Modeling Start date : 02/12/2018 Deadline : 02/02/2018 Client : Lieutenant Governors Office Description : SCOPE OF THE PROJECT: This work is part of the start-up phase of overlapping information system projects. • Identify and map existing data / information systems • Create data schema of existing databases in Database Design software; e.g., Datanamic, ER/Studio, MySQL Workbench, etc. o Legacy: Sybase, Access, Excel, MySQL o Developing: PostgreSQL, MongoDB, Neo4j, MySQL • Develop new DB Schema and physical DB for new Information Systems • Initial focus will be to translate, enhance and migrate existing schema and data to a new DB. This will be followed by additional enhancement to capture aspects of the legacy system that are not present. This phase may entail creating &/or translating conceptual and logical models to the physical model. • Generate appropriate documentation for the enterprise data architecture, including glossary definitions suitable for business level consumption DAILY DUTIES / RESPONSIBILITIES: Work with team to • Document existing Database(s) • Document, cull, and generate schema from current database(s) using SQL and DB tool(s) o Clean and validate data o Generate anomaly reports for others to act upon • Analyze, design and document updated DB schema with industry standard features and create a map from current to new DB • Design, implement and test migration from current DB to the new DB; scheduled migration update • Assist other DB staff with similar duties • Document tasks and provide up-to-date status through the project collaboration tools • Assist and develop SQL views for forms and reports REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE): • Accounting & Financial knowledge & experience in connection with DB and application development • Database experience (5 years min.) of at least two (2) databases o MySQL o Sybase or MS SQL Server o Other • Database tools, at least one of the following (1-year min.) o ER/Studio o MySQL Workbench o TOAD o or equivalent • Experience implementing up-to-date industry standard procedures and schemas for the majority of the following: o Naming conventions o Revising DB schemas for consistent use of terminology, naming, etc. o Update history o Logging o HIPAA compliance o Security and access control o Data exchange protocols o Cross platform integration • Strong knowledge and use of SQL; multi table JOINS, functions, procedures, triggers, etc. • Experience creating SQL views for the foundation of reports and forms; anticipate needs of coders/programmers • Excellent listening and communication (written & verbal) skills; ability to discuss and present information logically and concisely • Ability to work individually and as part of a team. Willing to share knowledge & experience with others • Flexible problem solver; use of previous knowledge & experience, yet open to alternative methods when made available PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE): • Additional Database tools experience; e.g. o Datanamic tool Suite o ER/Studio, ErWin, etc. • Experience with Data Governance and related documentation requirements • Database experience o Sybase o PostgreSQL o MS Access o MongoDB (document DB, nice bonus) o Neo4j (Graph DB, nice bonus) • Experience with Platforms as a Service (PaaS) and Software as a Service (SaaS) o Data transfers, APIs, etc. o Data integration across systems • Knowledge of container technology • Survey application DB schema with update history capacity • Open Source development experience; e.g., Python, PHP, JavaScript, & other Web coding • Experience with disconnected (store & forward) database a   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 67133 while calling.   Other jobs in OR: Orange (1), Portland (22), Salem (38), Tigard (3), Wilsonville (2),    Database Analyst job openings in other states Jobs List Database Analyst - Cloud Solution Analyst Create date: 12-Dec-2024 * Bill Rate: USD 75.00 Per Hour * Max Rate: USD 91.00 Per Hour No of Submissions : 1 Start date : 02/01/2025 End Date : 01/31/2026 Submission deadline : 12/17/2024 Client Info : CO CDPHE Note: * Position Location: Hybrid * Candidate Must Be Lo.... (This job is for - MS SQL Server Jobs in CO Denver Analyst - (in Denver, CO)) Database Analyst - 52264 Create date: 05-Sep-2019 Notes : LOOKING FOR: BACHELORS DEGREE SYSTEMS AUTOMATION EXPERIENCE AWS EXPERIENCE WITH PaaS AND IaaS Description:* Cloud Database Engineer As a member of the Data Management - Platform team, youll be responsible for designing, developing, and enforcing the standards and practices that support all ph.... (This job is for - OracleAWS Jobs in MN Minneapolis Analyst - (in Minneapolis, MN)) Database Analyst - 48734 Create date: 18-Jun-2019 Candidate must be our W2 Employee Description: Database Analyst / Database Developer Location: 2600 South Price Road, Chandler, AZ Duration: 12 + months Extensive Knowledge of Database development for web based applications using Entity Framework and Microsoft SQL Server, developing schemas, store.... (This job is for - SQL SCRUM Jobs in AZ Chandler Analyst - (in Chandler, AZ)) Database Reporting Analyst - 47385 Create date: 16-May-2019 Candidate must be our W2 Employee We should submit only GC, GC EAD, L2 EAD, H4 EAD and Citizens. Description: The Virtual Channels Group (VCG) manages the delivery of financial products and services to consumer and business customers via virtual channels (online, mobile, phone) and leads Wells Fargos online ch.... (This job is for - FTE Jobs in CA SanFrancisco Analyst - (in San Francisco, CA)) Database Analyst 6 - 31620 Create date: 02-Feb-2018 Candidate must be our own W2 Employee Responsibilities: Analyzing database performance Database design/planning Capacity planning Resolution and tracking of the most complex Oracle issues Communicating critical support issues identified to Oracle Support Services .... (This job is for - ASM Jobs in IA WestDesMoines Analyst - (in West Des Moines, IA))    Database Analyst job openings in OR Jobs List Database Analyst IV - 20013-23 Create date: 08-Feb-2024 start date : 03/01/2024 End date :03/31/2025 submission deadline : 02/20/2024 client info : DHS / OHA Description : The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and Department of H.... (This job is for - MS SQL Server Jobs in OR Salem Analyst - (in Salem, OR)) Database Analyst IV - 2023-01 Create date: 18-Apr-2023 Start date :05/01/2023 End Date :11/01/2023 Submission deadline :04/24/2023 Client Info : OLCC Note: * Position Location Hybrid Description : The database analyst will be responsible for supporting a Sybase system hosted on Linux based servers in a mixed physical and VMWare v.... (This job is for - SupervisionAnalytical Skills Jobs in OR Portland Analyst - (in Portland, OR)) Database Analyst - 36665 Create date: 18-Jul-2018 **Candidate must be our own W2 Employee. Required Skills : - Excellent Database Analyst skills - SAS Skills (Regression skills, Enterprise miner, Proc Skills) - Experience with Tabular Report in SAS, Excel Reporting - SQL Skills - Financial Services experience is required - Fraud Detection skills/experience .... (This job is for - SAS Jobs in OR Portland Analyst - (in Portland, OR)) Database Analyst IV - 10241-17 Create date: 21-Sep-2017 Start Date : 11/01/2017 End Date : 04/30/2018 Submission Dead Line : 09/22/2017 Description : Reviews, evaluates, designs, implements and maintains company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. .... (This job is for - Business Analyst Jobs in OR Salem Analyst - (in Salem, OR)) (Architect: Database Analyst, MySQL Experience, Relation Database Experience Expert, MS Word SQL Database Data Modeling in Remote, OR)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)