DataInformation Architect – Advanced at California Creative Solutions Inc.

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 Key Skills Fund Management,Drafting,End User Support,Infrastructure,Airlines,Catia Employment Type : Full Time Experience: years Vacancy: 1