Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

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... 
    Suggested
    Contract work
    Immediate start
    Remote work

    My3Tech Inc

    United States
    2 days ago
  •  ...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... 
    Suggested
    Contract work
    For contractors
    Work at office
    Local area

    My3Tech Inc

    Richmond, VA
    9 hours ago
  •  ...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... 
    Suggested
    Local area

    Integrated Resources

    Chesterfield, VA
    2 days ago
  •  ...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

    Advance American Tech, Inc.

    Denver, CO
    3 days ago
  •  ...(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 Developer
    Suggested
    Work at office
    Worldwide
    3 days per week

    E-Solutions

    Peoria, IL
    1 day ago
  •  ...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.... 

    Samprasoft

    Griffin, GA
    3 days ago
  • $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 employment
    Full time
    Remote work

    StateJobsNY

    United States
    1 day ago
  •  ...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 time
    Remote work
    Worldwide

    Voodoo.com

    United States
    4 days ago
  • $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 contract
    Full time
    Contract work
    Work experience placement
    Local area
    Worldwide

    HII Mission Technologies Division

    Pensacola, FL
    1 day ago
  •  ...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 work
    Work from home
    Flexible hours

    Sparc Technology Services Inc

    Houston, TX
    1 day ago
  • $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 employment
    Full time
    Work at office
    Remote work

    New York State Civil Service

    Albany, NY
    6 days ago
  •  ...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

    4P Consulting Inc

    Birmingham, AL
    26 days ago
  •  ...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 contractors
    Work at office
    Monday to Friday
    Afternoon shift

    GovernmentJobs.com

    Des Moines, IA
    9 hours ago
  •  ...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 placement
    Work at office
    Night shift
    Afternoon shift

    eTeam

    New York, NY
    5 days ago
  • ( 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 pay
    Temporary work
    Remote work
    Flexible hours

    Experis/Manpower Group

    Mountain View, CA
    1 day ago
  •  ...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 pay
    Contract work
    Temporary work
    Remote work
    Flexible hours

    ManpowerGroup Global, Inc.

    Mountain View, CA
    9 hours ago
  • $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 work
    Work experience placement
    Immediate start
    Flexible hours

    RealmOne

    Annapolis, MD
    2 days ago
  •  ...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

    Insight Global

    Orlando, FL
    3 days ago
  • 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 contractors
    Work at office

    Core One

    Bethesda, MD
    4 days ago
  •  ...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 office
    Visa sponsorship
    Shift work

    New York State Jobs

    Albany, NY
    15 hours ago
  •  ...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... 

    Louisiana State University

    Baton Rouge, LA
    9 days ago
  • $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 pay
    Permanent employment
    Contract work
    Temporary work
    Work experience placement
    Shift work

    Randstad

    Saint Louis, MO
    3 days ago
  •  ...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... 

    Samprasoft

    Brecksville, OH
    3 days ago
  •  ...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 time
    Shift work

    Adaptic LLC

    Maryland
    4 days ago
  • $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 placement
    Immediate start
    Flexible hours

    RealmOne

    Annapolis, MD
    9 hours ago
  •  ...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

    Lifecycle

    Annapolis Junction, MD
    4 days ago
  •  ...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

    Emtak LLC

    Annapolis, MD
    7 days ago
  • $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

    legato

    Annapolis Junction, MD
    4 days ago
  • $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 time
    Temporary work
    Part time
    Work experience placement
    Summer work
    Seasonal work
    Remote work
    Flexible hours
    Night shift

    State of Alaska

    United States
    5 days ago
  • $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 office
    Relocation
    Flexible hours

    Alaska Staffing

    Anchorage, AK
    1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Database Architect 2. Be the first to apply!