Job Title: Data/Information Architect – Advanced
Duration: 12+ Months
Location: Columbia, SC (100% On-site)
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.
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.
3+ years professional data modeling experience (ERwin Data Modeler).
Oracle 19 DBA and/or SQL Server 2019/2022.
SQL Server DBA Certification.
DD Boost support for Oracle backup/restore operations.
Oracle Grid Control.
Oracle ASM.
High School Diploma (required).
✅ Long-term on-site role | 12+ months | Data Modeling & DBA support | Columbia, SC