What are the responsibilities and job description for the Data Modeler (In-person Interview) position at RedSalsa Technologies, Inc.?
Job Details
Interview Process: Interviews will take place on-site at the Blythewood Headquarters, Blythewood, SC 29016.
Work Location: 100% On-site in Blythewood SC, Monday - Friday
**********************************************************************************************************************************
Title : Data/Information Architect - 8891
Location : Columbia, SC
Duration : 12 Months
Job Type : C
Description :
The State of South Carolina is looking for a Data/Information Architect - Advanced
Why is this position open: The SC DMV has begun a system data modernization project. The team is looking for strong Data Modeling experience - This role will focus on Data Modeling using ERWIN or a similar tool and Reverse Engineering and requires at least 3 years of experience. DBA experience is a plus but not the main focus of the role.
Daily Duties / 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
Skills :
Required Skills (rank in order of Importance):
- 3YEARS PROFESSIONAL DATA MODELING with ERWIN Data or similar data modeling tool
- ORACLE 19 DBA and/or SQLSERVER 2019, 2022
Preferred Skills (rank in order of Importance):
- SQL Server dba certification
- DD Boost to support backup and restore operations fororacle database
- ORACLE GRID CONTROL
- ORACLE ASM
Preferred Certifications:
Oracle Certified Associate or other Oracle certification