Database Architect (4551523DA2)

LMG Technology Services LLC

Database Architect (4551523DA2)

austin, TX
Full Time
Paid
  • Responsibilities

    Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will not be considered for this opportunity and the resume will not be submitted to the customer.

    Years Required

    |

    Skills/Experience

    ---|---

    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 a 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 :

    Years

    |

    Skills/Experience

    ---|---

    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

    3

    |

    Appian Record Types

    NOTE :

    1. This is a remote position. Ideal candidates must have a secure, dedicated workspace with Internet service, ability to maintain a reliable consistent work schedule, and be available for weekly meetings and group collaboration via Microsoft Teams and other applications during regular business hours. Position may require team members to come into the office for scheduled meetings, and there may be unscheduled request with seventy-two (72) hour notice for any Texas Workforce Commission (TWC) business need.

    2. The primary work location(s) will be at 101 E. 15th Street, Austin, Texas 78701.

    3. Any and all travel, per diem, parking, and/or living expenses shall be at the Worker’s and/or Vendor’s expense.

    4. The Worker(s) may be required to work outside the normal business hours on weekends, evenings, and holidays, as requested. Payment for work over forty (40) hours will be at the hourly rate quoted and must be coordinated and pre-approved through TWC.