Data/Information Architect

This is a system data modernization project and is seeking an experienced Data/Information Architect - Advanced with strong hands-on data modeling expertise. The ideal consultant will have proven experience using ERWIN Data Modeler (or similar tools) to create, update, and reverse-engineer data models across Oracle and SQL Server environments. This role will primarily focus on data modeling, metadata management, and documentation, with secondary responsibilities related to Oracle/SQL Server DBA production support. The consultant will work on-site in a collaborative environment alongside database engineers, application architects, developers, business analysts, and server teams., * Create and maintain logical and physical data models using ERWIN Data Modeler.

• Perform reverse and forward engineering of Oracle and MS SQL database structures.
• Conduct current-state assessments of existing ERWIN models and generate updated ERWIN (.erwin) files.
• Develop and maintain data dictionaries, metadata artifacts, and model documentation.
• Maintain a version-controlled repository of data models.
• Analyze and identify data integrity, consistency, and duplication issues; provide detailed reports and recommendations.
• Support SCDMV data governance and compliance initiatives.
• Collaborate closely with database engineers, developers, architects, and business analysts to translate functional requirements into accurate data models.
• Provide best practices related to data modeling, metadata management, database design, and performance tuning.
• Provide supplemental Oracle and SQL Server DBA support as required, including backup/restore, security updates, version upgrades, and daily ticket support (may involve occasional after-hours work).

• 3+ years of professional data modeling experience using ERWIN Data Modeler or similar tool.
• 3+ years of experience with Oracle 18/19 DBA and/or SQL Server 2019/2022.
• Experience performing reverse/forward engineering and maintaining ERWIN model repositories.
• Proven ability to work with cross-functional teams in structured IT environments.

Preferred Skills

• 3+ years of database backup and restore experience, including DD Boost.
• 3+ years of Oracle Grid Control (OEM) experience.
• Experience with Oracle ASM.
• SQL Server DBA certification.
• Background in public-sector or government technology environments (preferred but not required).

Education Requirements

• Minimum: High School Diploma (required).
• Preferred: Oracle Certified Associate (OCA) or other Oracle database certifications.

About US: InterSources Inc. is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18+ years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.