IT - SCDMV - Data/Information Architect - Advanced

Job Description Job Title: Database Administrator - Consultant Location: Blythewood, SC Position Type: C2C/W2 Years of Experience:10+ years 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 their own expense. Project Scope: The Database Administrator (Consultant) will be responsible for performing advanced data modeling and production database support in both Oracle and MS SQL environments. Key deliverables include: Current-state assessment report of existing ERwin data models New or updated logical and physical data models in ERwin (.erwin files) Data dictionaries and full model documentation Version-controlled data model repository Identification of data integrity, consistency issues, and duplicate data Reporting and recommendations to address identified issues Weekly progress reports Final project summary at closeout In addition, this role will supplement the existing DBA team with production support tasks, including: Daily tickets Version updates Security updates After-hours work as required You will collaborate with a team of six database engineers/administrators and work closely with application architects, developers, business analysts, and server support teams. Key Responsibilities: Create and maintain logical and physical data models using ERwin Data Modeler Update model documentation and manage metadata Perform reverse and forward engineering of database structures Provide data modeling best practices and documentation standards Ensure models support scalability, performance, and integrity requirements Identify and resolve data integrity and duplication issues Produce reports and recommendations based on findings Collaborate with data architects, DBAs, developers, and business analysts Maintain version control of models and manage repositories Support data governance and compliance efforts Perform similar modeling tasks for MS SQL databases as needed Provide Oracle and MS SQL production DBA support as directed by the DBA Manager Required Skills & Experience: • 3+ years of professional Data Modeling experience using ERwin (or similar tools) • Oracle 19c DBA and/or SQL Server 2019/2022 experience Preferred Skills: • SQL Server DBA Certification • DD Boost for Oracle backup/restore operations • Oracle Grid Control • Oracle ASM Certifications: • Oracle Certified Associate (OCA) or equivalent Oracle certification

Created: 2026-03-04