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
Preferred Skills
- 3 + years of Experience with BACKUP AND RESTORE of Databases
- ORACLE CERTIFIED ASSOCIATE OR OTHER ORACLE CERTIFICATION