Erwin Data/Information Architect - Advanced

Job DescriptionJob 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
• 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

• 3 + years of DATA MODELING EXPERIENCE. ie ERWIN

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

  Education Requirement

• High School Diploma

  Skills

• 3 + years of Experience with BACKUP AND RESTORE of Databases

• 3+ year ORACLE GRID (CONTROL)

  Certifications:

• ORACLE CERTIFIED ASSOCIATE OR OTHER ORACLE CERTIFICATION