Data / Information Architect [Oracle / MS SQL]

Job Summary (List Format) Data / Information Architect [Oracle / MS SQL]

• Utilize data modeling tools (primarily ERwin) for Oracle and MS SQL databases.
• Perform professional data modeling, including creation and maintenance of logical and physical data models.
• Supplement the SQL DBA team with production support (ad hoc tickets, version / security updates, etc.).
• Conduct current state assessments and generate reports on existing ERwin models.
• Develop and update data dictionaries, model documentation, and maintain a version-controlled repository for data models.
• Identify data integrity and consistency issues; provide reporting, recommendations, and aid in remediation.
• Assist with duplicate data resolution.
• Generate weekly progress reports and a final summary report at project closeout.
• Perform reverse and forward engineering of database structures.
• Ensure database designs support scalability, integrity, and performance requirements.
• Apply best practices for data modeling, metadata management, and documentation.
• Collaborate with database engineers / administrators, application architects / developers, business analysts, and server support teams to translate business requirements into data models.
• Support production environments for Oracle and MS SQL databases as directed.
• Support data governance and compliance initiatives through strategic data modeling.
• Participate in after-hours work as needed.

Required Skills / Qualifications :

Team Environment :