Database Architect 2
My3Tech Inc
Database Architect 2
Austin, TX (Remote within US)
8 months Contract with possibility to extension
Client is migrating one of its high-usage transactional system from a legacy platform to newer technologies in the cloud and requires a Database Architect with proven experience to:
- Document the “as is” schemas currently in use at Client in SQL Server databases and Oracle databases.
- Document existing data interfaces in the legacy system.
- Document existing downstream impacts of the legacy system.
- Document database process that currently extract the data from the existing system for reporting purposes.
- Create data models and reverse and forward engineer data models in an AWS SQL Server environment.
- Define and document the technical architecture of the new transactional system, including the physical components and their functionality.
- Perform other analysis and documentation tasks as required to facilitate and support this migration project.
- Provide oversight and design of the migration and conversion of legacy data to the new database.
- Create scripts for data conversion and migration from legacy systems to new database platform.
Required Skills and Qualifications:
- 3 - Data Architect Role
- 5 - Data modeling in SQL Server Enterprise Edition
- 5 - Analyzing and generating technical requirements and design
- 7 - Creating and maintaining data models
- 7 - Database development experience utilizing RDBMS
- 7 - Design a SQL Server database for high usage/high availability transactional system
- 5 - Database tuning techniques
- 7 - Analyzing source databases, source data, source database referential integrity and profiling source data
- 3 - Experience with data mining and archiving
- 7 - Experience with MS SQL Server DBMS
- 3 - Experience with managing RDBMS in AWS
- 5 - Creating source to target mapping database documentation
- 5 - Assist with migrating data from legacy database to new target database
Preferred Skills and Qualifications:
- 5 - More than one type of RDBMS (DB2, SQL Server, Oracle)
- 5 - Experience with case management or educational systems
- 3 - Experience with REST API Services
- 3 - Experience in Amazon Web Services
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Database Architect 2 in United States vacancy
- ...Database Architect 2 Austin, TX (Remote within TX) 6 months Contract with possibility to extension The Information Technology (IT) Applications, Medicaid/CHIP Systems (IT-MCS) team has initiated the MCS – SAVERR to TOA Remediation – PPS & TMTS project. This project...SuggestedContract workImmediate startRemote work
- ...Enterprise Data Modeler Location: Richmond, VA (Hybrid - ONSITE 2-3 days/wk.) Local Richmond, VA candidates required... ...evaluating existing systems and working with a business and data architect to create conceptual data models, data flows. Develop best practices...SuggestedContract workFor contractorsWork at officeLocal area
- ...Job Title: Data Warehouse Architect 2 Location: Chesterfield, VA (Hybrid) Duration: 6+ months (High Possibility of Extension) Interview Process: In Person Only Local Richmond, VA candidates required for onsite work. Only submit candidates able to interview...SuggestedLocal area
- ...Number Name Deliverables Description Start Date End Date 1 Initial Plans and Documentation 11/18/2019 12/06/2019 2.1 DG Process Completion 12/09/2019 01/03/2020 2.2 Development Environment Completion 01/05/2020 01/31/2020 3.1 Production Environment Completion, Release...Suggested
- ...(for example, BA, BS) or certification that is equivalent with 0-2 years' experience. Master's Degree is not considered overqualified... .... Travel: 0-25% within USA Required Skills : Data Analysis,SQL Additional Skills : Business Analyst,Database DeveloperSuggestedWork at officeWorldwide3 days per week
- ...Database Analyst/Programmer The main function of a database analyst/programmer is to coordinate changes to computer databases, test, and... ...requirements: ~ Associate's degree in computer programming or equivalent training required. ~2-4 years experience required....
$86.68k - $109.65k
...Data Analyst 2 - 91503 Occupational Category: Financial, Accounting, Auditing Salary Grade: 23 Bargaining Unit: PS&T - Professional, Scientific, and Technical (PEF) Salary Range: From $86681 to $109650 Annually Employment Type: Full-Time Appointment...Permanent employmentFull timeRemote work- ...This position can be full remote within CET time ±3h. Role Autonomously take ownership of the A/B testing cycle on Paper.io 2, validating feature values, refining key parameters, and optimizing monetization to drive core KPIs. Lead analysis of large, complex...Full timeRemote workWorldwide
$62.31k - $85k
...learning management system (LMS) while contributing to a wide range of database and systems engineering activities. This role includes analyzing... ...effect on the operating environment. Minimum Qualifications 2 years relevant experience with Bachelors in related field; 0 years...Ongoing contractFull timeContract workWork experience placementLocal areaWorldwide- ...Job Title: Data Governance Analyst / Data Governance Technologist (Level 2) Location - Downtown Houston, TX Hybrid: 4 days onsite, 1 day remote Employment Type: C2C Interview Process Virtual interview (up to 1 hour) Face-to-face interview only if required...Remote workWork from homeFlexible hours
$86.68k - $109.65k
...HELP No Agency Mental Health, Office of Title Data Analyst 2, Central Office Occupational Category Other Professional Careers... ...timeframes.- Using plans submitted data and State provider database to monitor children provider network adequacy and access to behavioral...Permanent employmentFull timeWork at officeRemote work- ...Data Analyst 2 Location: Birmingham, AL 35203 (Onsite) Contract: 6-Months Skills and Responsibilities ~3-5 Years... ...loading (ETL) processes, working with various data sources and databases to prepare data for analysis. ~ Statistical Analysis: Proficiency...Contract work
- ...Data Analyst 2 Help strengthen the systems that support Iowa students At the Iowa Department of Education, our mission is... ...Reporting: Gather, organize, and analyze information from databases, spreadsheets, and other data sources Develop reports, visualizations...For contractorsWork at officeMonday to FridayAfternoon shift
- ...Job Title: Senior Data Analyst-2 Location: Chicago IL, Iselin NJ, New York NY, Charlotte NC (Hybrid 3 days) Duration: 24 Months Job Description: CW-Data Analyst The Data Analyst identifies current market sector trends and customer patterns through statistical...Work experience placementWork at officeNight shiftAfternoon shift
- ( NO C2C ) Our client, a leading organization in the technology and support services industry, is seeking a Data Analyst 2 to join their team. As a Data Analyst 2, you will be part of the Microsoft Digital Global Support department supporting IT helpdesk operations....Weekly payTemporary workRemote workFlexible hours
- ...Our client, a leading organization in the technology support sector, is seeking a Data Analyst 2 to join their team. As a Data Analyst 2, you will be part of the global support team supporting internal data-driven decision-making processes. The ideal candidate will have...Weekly payContract workTemporary workRemote workFlexible hours
$7.5k
...functions in discrete sessions and autonomous AI agents that maintain persistent states and can alter their workflows. The Level 2 Data Analyst shall possess the following capabilities: Python data analysis (pandas, scikit-learn, numpy). Statistical...Contract workWork experience placementImmediate startFlexible hours- ...review Insight Global's Workforce Privacy Policy: Required Skills & Experience - Bachelors Degree - IT Focus preferred - 2+ years experience in Data Analytics/BI - 2+ years experience SQL Coding - Intermediate - Experience with PowerBI or Tableau -...Work at office
- THIS POSITION REQUIRES A CURRENT Top Secret / SCI w/ Poly . Core One seeks an experienced Information Analyst - Level 2 to support the Classification Management Branch of the Office of Policy and Strategy (P&S) within the Office of the Director of National Intelligence...For contractorsWork at office
- ...Data Analyst 2 The DA 2 will support the Bureau of Staffing Operations and Support in the Office of Health Insurance Programs (OHIP). Key responsibilities include: Compile and analyze personnel and non-personnel cost allocation data to support federal claiming, reporting...Work at officeVisa sponsorshipShift work
- ...Data Analyst 1/2 This position, reporting to the Analytics Manager, is responsible for maintaining and improving analysis tools for traffic safety data that provide actionable insights that support decision-making and strategic planning. This role involves working...
$37 - $41.1 per hour
...initiatives and identify opportunity for process improvements within Database Engineering. Review and analyze basic or tactical Database... .... Skills ~ Scrum ~ Agile experience ~$1 - 2 billion Qualifications Years of experience: 2 years Experience...Hourly payPermanent employmentContract workTemporary workWork experience placementShift work- ...Database Developer Core competencies: Accountability, Collaboration, Critical Thinking, Detailed Orientation, Drive for results, Initiative... ...support requests to determine the technical solution. 2. Develops and tests database software code for technical solutions...
- ...Shift Type Job Title Database Engineer 2 Location Fort Meade, MD - Ft. George G. Meade, MD 20755 US (Primary) Category Database Administrator (DBA) Salary Grade Date Needed By Job Type Full-time Travel Job Description Summary...Full timeShift work
$7.5k
...come join us! Job Description: ~ We are seeking a Database Engineer / Full-Stack Developer with hands-on experience in... ...modern cloud-based environments. The Database Engineer Level 2 shall possess the following capabilities: Database experience...Work experience placementImmediate startFlexible hours- ...Job Description We are looking for a Database Engineer Level 2 with technical experience with: Active TS/SCI with Polygraph Clearance Familiarity with relational and non-relational databases to include but not limited to Oracle, Postgres, Mongo and Redis...Temporary work
- ...Database Engineer Level 2 (TS/SCI w/ Poly) Location: Annapolis Junction, MD We are actively hiring a Database Engineer Level 2 to support mission-critical programs in a fully cleared environment . This role requires hands-on database engineering experience...Temporary work
$175k - $205k
...) would love to speak with you regarding the following position: Database Engineer in Hanover, MD. Security Clearance Required: TS/SCI w... ...optimization, large data sets and organization of data. IAT Level 2 Certification required at start date At least five (5) years...Bank staff$3,459.75 - $5,919.75 per month
...Department of Transportation and Public Facilities (DOT&PF), Southcoast Region Design & Engineering Services is looking for an Engineer/Architect 1/2 Flex located anywhere in Alaska to help us Keep Alaska Moving! Base Salary Information: Pay will be based on the...Full timeTemporary workPart timeWork experience placementSummer workSeasonal workRemote workFlexible hoursNight shift$1,000 - $3,776 per month
...Engineer/Architect 1/2 Flex (Utility Lead/Manager) The Department of Transportation and Public Facilities (DOT&PF), Central Region, is looking for two (2) Engineer/Architect 1/2 Flex's (Utility Lead/Manager) in Anchorage to help us Keep Alaska Moving! Base Salary...Work at officeRelocationFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Database Architect 2. Be the first to apply!
Related searches
- azure data architect United States
- sr data modeler United States
- data architect United States
- remote data architect United States
- junior data architect United States
- big data architect United States
- hadoop big data architect United States
- data center architect United States
- database designer United States
- enterprise data architect United States

