Sr Enterprise Database Architect

Hi,

Greetings from DIA SOFTWARE SOLUTIONS LLC!

We reaching out about an exciting Direct client opportunity with one of our clients. Please review the requirements and let me know if you are interested in this position?

Direct client Req:: Need Sr Enterprise Database Architect ,Remote , TX

PLEASE SEND THE RESUMES TO SKUMAR AT DIASOFTWARESOLUTIONS DOT COM !

Job Description:

The Database Architect will implement an enterprise wide Data Catalog/MDM solution covering both structured and unstructured data, and setup and configure the semantic layer and lineage needed for AI tools discovery/enablement. The ideal candidate will bridge data engineering, governance, and AI consumption needs to ensure high-quality, well-documented data assets are available for analytics, machine learning, and generative AI use cases. A continuous process should be established to keep the catalog/mdm solution updated when changes are made, and ensure data quality and consistency is maintained.

This position will perform the following duties, working across various teams.

Enterprise Data Modeling, Semantics & AI Enablement

• Develops conceptual, logical, physical models across domains.
• Maps transformations & integrations, and drive clarity across systems.
• Reverse-engineers legacy data structures to modernize, streamline, and rationalize system designs.
• Uses ER/Studio & model automation to ensure standards and performance.
• Governs design-to-implementation alignment with engineering.
• Expands taxonomy and ontology usage across domains.
• Applies semantic tagging to improve discovery, trust, and reuse.
• Aligns semantic attributes with lineage & classification rules.

Data Governance, Metadata & Catalog Management

• Maintains and enriches data dictionaries while automating metadata ingestion and scanning processes.
• Applies lineage and classification standards (Purview/Unity Catalog).
• Connects catalog to BI and ETL/ELT pipelines.
• Expands glossary coverage with stewards.
• Implements catalog APIs for programmatic queries/updates.
• Trains users on catalog practices and continuously monitors metadata quality KPIs.

Data Strategy & Readiness

• Translates business needs into structured data designs and metadata deliverables
• Prioritizes modeling/governance work with product owners.
• Provides status & risk updates; manage dependencies.
• Supports business-led analytics and stewardship routines.

Team Enablement & Knowledge Transfer

• Facilitates design/model reviews while maintaining standards and templates.
• Supports cross-enterprise stewardship and governance routines.
• Creates training materials and onboarding guides for business users.

SKILLS MATRIX

Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Actual
Years
Experience

Years
Experience
Needed

Required/
Preferred

Skills/Experience

7

Required

Working as an Enterprise Database Architect experience with MDM/Data Catalog implementation

4

Required

Experince as a Data Modeler/DBA with Oracle and SQL Server RDBMS

4

Required

Expertise in various enterprise data catalog platforms like Microsoft Purview, Collibra, Alation, etc.

3

Required

Experience in AI/ML technologies and semantic/context layer design and integration.

3

Required

Experience with cloud technologies and tools in AWS and Azure including data platforms like AWS Data Lake

3

Required

Data Governance, classification and security

2

Required

Data Lineage, Integration and Transformation tools like Informatica, Fivetran, etc.

2

Required

Experience in API design in metadata harvesting, automation and event driven integration

2

Preferred

.Vector databases, feature stores experience preferred

2

Preferred

Experience in scripting using Python preferred.

2

Preferred

Experience working with Texas state government agencies preferred.

1

Preferred

Experience using github

DIA SOFTWARE SOLUTIONS LLC.

HARSHITHA| DIA SOFTWARE SOLUTIONS LLC.

Direct: Two Four Eight Five Three Seven Zero Seven Nine One

DIA SOFTWARE SOLUTIONS is an Affirmative Action/Equal Opportunity Employer that supports workplace diversity. All employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, marital or family status, sexual orientation, gender identity, or genetic information. All Dia soft staff must be able to demonstrate the legal right to work in the United States. DIA SOFTWARE SOLUTIONS is an E-Verify employer