Data/Information Architect Advanced - IA 25-28306

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
No Travel Required

Skills

SQL
Oracle Grid Control
Production Support
Version Control
Recovery
Regulatory Compliance
Meta-data Management
Microsoft SQL Server
Oracle
Oracle ASM
Database
Database Administration
Documentation
ERwin
Management
Backup
Boost
Collaboration
Data Governance
Data Integrity
Data Modeling
Modeling
Reporting
Scalability
Server Administration

Job Details

Job Title: Data/Information Architect Advanced
Duration: 12+ Months
Location: Columbia, SC (100% On-site)

Project Scope

This role supplements the current SQL DBA team with production support activities, including ad hoc daily tickets, version updates, and security updates. Candidates may be required to work outside of normal business hours. The position operates within a collaborative team environment consisting of database engineers, administrators, architects, developers, business analysts, and server support staff.

Key Responsibilities:

  • Use data modeling tools on Oracle and MS SQL databases.

  • Conduct current state assessments of existing ERwin models.

  • Create or update logical and physical data models in ERwin format (.erwin files).

  • Develop and maintain data dictionaries and model documentation.

  • Manage a version-controlled repository of data models.

  • Identify data integrity and consistency issues; provide reporting and recommendations.

  • Assist with duplicate data resolution.

  • Deliver weekly progress reports and a final summary report at project closeout.

Daily Duties & Responsibilities

  • Create and update data models and documentation using ERwin.

  • Perform reverse and forward engineering of database structures.

  • Provide best practices for data modeling, metadata management, and documentation.

  • Design, develop, and maintain logical and physical data models.

  • Ensure database designs support scalability, integrity, and performance.

  • Collaborate with architects, DBAs, developers, and business analysts to translate business needs into data models.

  • Manage version control of data models and maintain repositories.

  • Support data governance and compliance initiatives.

  • Perform modeling activities for both Oracle and MS SQL databases.

  • Provide Oracle and MS SQL production support as directed by DBA management.

Required Skills

  • 3+ years professional data modeling experience (ERwin Data Modeler).

  • Oracle 19 DBA and/or SQL Server 2019/2022.

Preferred Skills

  • SQL Server DBA Certification.

  • DD Boost support for Oracle backup/restore operations.

  • Oracle Grid Control.

  • Oracle ASM.

Education

  • High School Diploma (required).

Long-term on-site role | 12+ months | Data Modeling & DBA support | Columbia, SC

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.