Erwin Data/Information Architect - Advanced

United Global Technologies

Erwin Data/Information Architect - Advanced

Blythewood, SC
Full Time
Paid
  • Responsibilities

    Interview will be onsite in Columbia, SC

    12 Months

    Work Location: 100% On-site in Columbia SC, Monday - Friday

    Candidate Location: Local OR candidate must relocate to SC Prior to Starting role.

    Key duties and Responsibilities

    • Create and update data models and documentation using ERWIN
    • Performing reverse and forward engineering of database structures.
    • Providing best practices for data modeling, metadata management, and documentation.
    • Designing, developing, and maintaining logical and physical data models using ERwin Data Modeler.
    • Ensuring database designs support scalability, integrity, and performance requirements.
    • Identify data integrity and consistency issues.
    • Provide reporting and recommendations to address the issues.
    • Identify and aid with duplicate data resolution.
    • Collaborating with data architects, DBAs, developers, and business analysts to translate business requirements into data models.
    • Managing version control of data models and maintaining model repositories.
    • Supporting data governance and compliance initiatives through effective data modeling strategies.
    • Same modeling activities may be required for MS SQL databases. ORACLE and MS SQL production support activities as needed and directed by the DBA manager.

    Required Skills

    • 3 + years of DATA MODELING EXPERIENCE. ie ERWIN
    • 3 + ORACLE 18/19 DBA and/or SQL SERVER 2019, 2022

      Education Requirement

    • High School Diploma

      Preferred Skills

    • 3 + years of Experience with BACKUP AND RESTORE of Databases
    • 3+ year ORACLE GRID (CONTROL)

      Preferred Certifications:

    • ORACLE CERTIFIED ASSOCIATE OR OTHER ORACLE CERTIFICATION