InfoVision Inc. · 12 hours ago
Database Architect/ Data Modeler (Onsite)
Dallas, TX
Contract
Onsite
Senior Level, Lead/Staff
10+ years expInfoVision Inc. is seeking an experienced Database Architect / Data Modeler to design, implement, and maintain scalable and efficient database systems. The ideal candidate will create robust data models that align with organizational needs and ensure optimal data storage and access, particularly focusing on SQL-based database systems and .NET application modernization initiatives.
Information Technology & Services
Responsibilities
Design and implement robust and scalable database systems to support application and business needs
Establish standards for database design, access, and maintenance
Define and implement data security protocols, backup strategies, and disaster recovery plans
Evaluate and implement database technologies for structured and unstructured data (e.g., SQL, NoSQL, Azure Datastore)
Define and optimize database schemas, indexes, and partitioning strategies
Optimize database performance, scalability, and reliability
Define the overall structure for how data is collected, stored, and accessed as per enterprise-wide data strategies and governance policies
Develop data integration workflows and pipelines
Ensure compliance with data privacy (PII) and security regulations (e.g., GDPR, CCPA)
Establish data quality standards and validation processes
Create conceptual, logical, and physical data models to meet business and technical requirements
Conduct detailed Fit-Gap analysis on data models to identify discrepancies between current and target states
Optimize existing data models to enhance performance and scalability within SQL databases
Design and maintain entity-relationship (ER) diagrams, metadata repositories, data dictionaries and definitions
Define data relationships, primary/foreign keys, and constraints to ensure integrity
Collaborate with stakeholders to align data models with reporting and analytical needs
Design the architecture focused on modernizing legacy .NET systems and leveraging Azure services (e.g., Azure SQL, Azure Cosmos DB, ADLS, and Azure functions etc.)
Design and deploy solutions in cloud-based environments using best practices
Monitor and troubleshoot Azure data workflows to ensure reliability and efficiency
Qualification
Required
Minimum 10 years of experience with 5+ years of experience in database design, data architecture, and data modeling
Hands-on experience with relational and NoSQL databases (e.g., MySQL, PostgreSQL, MongoDB)
Proficiency with data modeling tools (e.g., ERwin, ER/Studio, PowerDesigner, Visio)
Strong knowledge of SQL, database design principles, and optimization techniques including performance tuning
Expertise in data integration tools (e.g., Talend, Apache Kafka, Informatica)
Hands-on experience with Azure SQL, Data Factory, Synapse, and related services
Prior experience in Agile/Scrum development methodologies is mandatory - sprint planning, stand-ups, and retrospectives
Familiar with Azure DevOps and other Azure services
Proficiency in creating and presenting documentation, diagrams, and reports
Strong communication, interpersonal and stakeholder management skills
Ability to work with cross-functional teams and drive consensus
Strong analytical and problem-solving skills
Work effectively in an onshore-offshore model, facilitating seamless collaboration and communication
Ability to provide technical guidance and mentor junior team members
Preferred
Familiarity with big data and data warehouse technologies (e.g., Hadoop, Spark, Redshift, BigQuery) and ETL processes
Familiarity with cloud data platforms (e.g., Snowflake, AWS Redshift, Azure SQL)
Knowledge of data governance frameworks and regulatory compliance
Proficiency in scripting languages (e.g., Python, Shell) for automation and ETL processes
Company
InfoVision Inc.
Infovision, founded in 1995, is a leading global IT services company offering enterprise digital transformation and modernization solutions across business verticals.
1001-5000 employees
H1B Sponsorship
InfoVision Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (94)
2024 (59)
2023 (59)
2022 (72)
2021 (65)
2020 (90)
Funding
Current Stage
Late StageLeadership Team
Mohit Punj, CFA, CPA
Chief Financial Officer
Sampath Paranavitane
Vice President | Senior Client Partner
Recent News
2023-02-01
2022-04-08
Business Wire India
2022-03-24
Company data provided by crunchbase