DataInformation Architect – Advanced

California Creative Solutions Inc.

Job Location:

Blythewood, SC - USA

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

Roles/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 modelling 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.

Mandatory Skill:

3 years of professional data modeling with ERWIN data or similar data modeling tool
3 years experience with Oracle 18/19 DBA and/or SQL Server
Education: High School Diploma

Desirable Skills:

3 years of experience with Database backup and restore
3 year Oracle Grid (Control)
SQL server dba certification
DD boost to support backup and restore operations for oracle database
Oracle ASM

Roles/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 mo...