ZipRecruiter
Erwin Data/Information Architect - Advanced
ZipRecruiter, Blythewood, South Carolina, United States, 29016
Job Description
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.
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 using ERwin Data Modeler.
Ensure database designs support scalability, integrity, and performance requirements.
Identify data integrity and consistency issues and provide reporting and recommendations to address them.
Identify and assist with duplicate data resolution.
Collaborate with data architects, DBAs, developers, and business analysts to translate business requirements into data models.
Manage version control of data models and maintain model repositories.
Support data governance and compliance initiatives through effective data modeling strategies.
Perform modeling activities for MS SQL databases as needed, including ORACLE and MS SQL production support activities directed by the DBA manager.
Required Skills
3+ years of data modeling experience, specifically with ERWIN.
3+ years of experience with ORACLE 18/19 DBA and/or SQL Server 2019, 2022.
Education Requirement
High School Diploma or higher.
Additional Skills
3+ years of experience with backup and restore of databases.
3+ years of experience with ORACLE Grid Control.
Certifications
Oracle Certified Associate or other Oracle certifications.
#J-18808-Ljbffr
#J-18808-Ljbffr