Talent.com
Data/Information Architect
Data/Information ArchitectNovalink Solutions LLC • Blythewood, SC, US
Data / Information Architect

Data / Information Architect

Novalink Solutions LLC • Blythewood, SC, US
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

Job Description

Job Description

Why is this position open (new role, increased work load, new dept, resignation, promotion)?

If backfill Position – What separated the candidate you initially selected from all the other resumes presented?

The SC DMV has begun a system modernization project.

Scope of the project :

This role will be responsible for using data modeling tools on ORACLE and MS SQL databases :

  • Current state assessment report of existing ERwin models.
  • New or updated logical and physical data models in ERwin format (.erwin files).
  • Data dictionaries and model documentation.
  • Version-controlled repository of data models.
  • Identify data integrity and consistency issues.
  • Identify and aid with duplicate data resolution.
  • Provide reporting and recommendations to address these issues.
  • Weekly progress reports.
  • Final summary report at project closeout.

This position will also supplement our current sql dba force with production support activities such as adhoc daily tickets, version updates, security updates, etc. and may require working beyond normal business hours.

Candidate will be working in a team environment consisting of 6 database engineers and administrators and working directly with application architect, application developers, business analysts, and server support team.

Pre-employment Checks (drug, credit, criminal, motor vehicle)?

Drug, Criminal, Credit, e-Verify, NDA

DAILY DUTIES / 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 (rank in order of Importance) :

  • 3 YEARS PROFESSIONAL DATA MODELING with ERWIN Data or similar data modeling tool

    • ORACLE 19 DBA and / or SQL SERVER 2019, 2022

    Preferred Skills (rank in order of Importance) :

  • SQL Server dba certification
  • DD Boost to support backup and restore operations for oracle database
  • ORACLE GRID CONTROL

    • ORACLE ASM

    Required Education : High School Diploma

    Preferred Certifications :

    Oracle Certified Associate or other Oracle certification

    Requirements

    Required Skills

    3+ years of professional data modeling with ERWIN data or similar data modeling tool

    3+ years experience with Oracle 18 / 19 DBA and / or SQL Server 2019, 2022

    Preferred Skills

    3 + years of experience with Database backup and restore

    3+ year Oracle Grid (Control)

    [job_alerts.create_a_job]

    Architect • Blythewood, SC, US

    [internal_linking.similar_jobs]
    Information Systems Architect - Project Lead

    Information Systems Architect - Project Lead

    US Tech Solutions • Columbia, SC, United States
    [job_card.temporary]
    Location : Hybrid (2 days onsite per week & 3 days remote- Columbia SC 29201).Duration : 12 months contract (with possible extension). The Division of Technology Services is responsible for developing...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    IT - SCDHHS - Security Analyst - Consultant

    IT - SCDHHS - Security Analyst - Consultant

    SUNSHINE ENTERPRISE USA LLC • Columbia, SC, US
    [job_card.full_time]
    Position : Security Analyst – Consultant (Information Systems Security Officer – ISSO).Candidate MUST be a SC resident or willing to relocate to SC prior to starting the role at their ow...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Restaurant Delivery - Sign Up and Start Earning

    Restaurant Delivery - Sign Up and Start Earning

    DoorDash • Winnsboro, SC, United States
    [job_card.full_time] +1
    DoorDash is the #1 category leader in food delivery, food pickup, and convenience store delivery in the US, trusted by millions of customers every day. As a Dasher, you’ll stay busy with a variety o...[show_more]
    [last_updated.last_updated_30] • [promoted]
    IT - SCDMV - Data / Information Architect - Advanced

    IT - SCDMV - Data / Information Architect - Advanced

    SUNSHINE ENTERPRISE USA LLC • Blythewood, SC, US
    [job_card.full_time]
    Job Title : Database Administrator - Consultant.Duration of the Contract : 12 months.Additional details : Candidate MUST be a SC resident or willing to relocate to SC prior to starting the role at the...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Information Systems Architect - Immediate Placement

    Information Systems Architect - Immediate Placement

    Inteliblue • Columbia, SC, United States
    [job_card.full_time]
    [filters_job_card.quick_apply]
    This is a very urgent requirement with immediate placement, please apply for immediate consideration.Job Title : Information Systems Architect Location : Colu...[show_more]
    [last_updated.last_updated_variable_days]
    IT - DSS - Information Systems Architect - Project Lead

    IT - DSS - Information Systems Architect - Project Lead

    SUNSHINE ENTERPRISE USA LLC • Columbia, SC, us
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Job Title : Information Systems Architect.Location : Columbia, SC hybrid (2 days onsite per week).Duration of the Contract : 12 months. The Division of Technology Services seeks an experienced Informat...[show_more]
    [last_updated.last_updated_variable_days]
    Data / Information Architect – Advanced

    Data / Information Architect – Advanced

    California Creative Solutions Inc. • Blythewood, SC, United States
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Roles / Responsibilities : • Create and update data models and documentation using ERWIN Performing reverse and forward engineering of data...[show_more]
    [last_updated.last_updated_variable_days]
    Project Architect

    Project Architect

    LaBella Associates • Columbia, SC, US
    [job_card.full_time]
    We are currently hiring a Project Architect in our Architectural division.The Architectural Division at LaBella provides comprehensive planning and design services for a wide variety of markets, in...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Principle IT Architect - SNAP / TNAF Programs - 2 Days Onsite / Week

    Principle IT Architect - SNAP / TNAF Programs - 2 Days Onsite / Week

    RICEFW Technologies Inc • Columbia, SC, United States
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Interview Process : 1 round, virtual Duration of the Contract : 12 months Possibility for Extension : Yes Work Location : Role is hybrid (2 days onsite ...[show_more]
    [last_updated.last_updated_variable_days]
    IT - DSS - Database Administrator - Project Lead

    IT - DSS - Database Administrator - Project Lead

    SUNSHINE ENTERPRISE USA LLC • Columbia, SC, US
    [job_card.full_time]
    IT - DSS - Database Administrator - Project Lead.Columbia, SC (Hybrid / 3 days onsite per week).Candidates local to South Carolina are required. We’re seeking a Senior Database Administrator to ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    IT - SCDOT - GIS Analyst - Project Lead

    IT - SCDOT - GIS Analyst - Project Lead

    SUNSHINE ENTERPRISE USA LLC • Columbia, SC, US
    [job_card.full_time]
    Candidate must be a CURRENT SC resident.The project involves migrating an.Oracle Spatial database (Geomedia).ESRI Roads and Highways (on-premise). Ensuring spatial accuracy and system reliability.Pr...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Delivery Driver - No Experience Needed

    Delivery Driver - No Experience Needed

    DoorDash • Winnsboro, SC, United States
    [job_card.full_time] +1
    DoorDash is the #1 category leader in food delivery, food pickup, and convenience store delivery in the US, trusted by millions of customers every day. As a Dasher, you’ll stay busy with a variety o...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data Architect

    Data Architect

    InsideHigherEd • Columbia, South Carolina, United States
    [job_card.full_time]
    From the Upstate to the Lowcountry, the University of South Carolina system is transforming the lives of South Carolinians through the impact of our eight institutions and 20 locations throughout t...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Information Systems Architect - Project Lead

    Information Systems Architect - Project Lead

    TechNix LLC • Columbia, SC, United States
    [job_card.full_time]
    [filters_job_card.quick_apply]
    MsoNoSpacing"> Position : Information Systems Architect - Project Lead Duration : 12 Months with Extension ...[show_more]
    [last_updated.last_updated_variable_days]
    Assistant to the CEO

    Assistant to the CEO

    Green Energy Biofuel LLC • Winnsboro, SC, US
    [job_card.full_time]
    Were looking for a reliable, flexible, and upbeat individual to join our team as a Full-Time Assistant to the CEO.This isnt your typical desk jobyoull be on the move daily, helping a high-energy CE...[show_more]
    [last_updated.last_updated_30] • [promoted]
    IT - SCDMV - Programmer - Consultant

    IT - SCDMV - Programmer - Consultant

    SUNSHINE ENTERPRISE USA LLC • Blythewood, SC, US
    [job_card.full_time]
    Job Title : PROGRAMMER - CONSULTANT.Location : Blythewood, SC (Onsite).Duration of the Contract : 12 months.This position involves working within a. The selected consultant will be responsible for deve...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Information Systems Architect - Must currently live in South Carolina

    Information Systems Architect - Must currently live in South Carolina

    ZIRLEN TECHNOLOGIES INCORPORATED • Hopkins, SC, US
    [job_card.full_time]
    Need South Carolina Residents Only - Contract - Columbia, South Carolina (Hybrid).Bachelor's degree in computer science, Information Systems, or related field. Familiarity with State and / or fede...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Operational Excellence Leader

    Operational Excellence Leader

    Pure Power Technologies Inc • Blythewood, SC, US
    [job_card.full_time]
    The OPEX Leader is responsible for leading the implementation and advancement of the Stanadyne Production System (SPS) at the site level. This role will develop and execute a local lean roadmap to e...[show_more]
    [last_updated.last_updated_30] • [promoted]