Database Architect/Data Modeler

Position: Database Architect/Data Modeler

Location: Dallas, TX

Duration: Long term

Job Summary:

We are seeking an experienced Database Architect / Data Modeler to design, implement, and maintain scalable and efficient database systems while creating robust data models that align with organizational needs. The ideal candidate will have a deep understanding of database technologies, data architecture, data modeling principles, data security and business requirements, particularly in SQL-based database systems and .NET application modernization initiatives, ensuring data is stored, structured, and accessed optimally.

Key Responsibilities:

Database Architecture:

• 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.

Data Architecture:

• 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.

Data Modeling:

• 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.

Azure Data Ecosystem:

• 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.

Must have Qualifications:

• 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 DepOps and other Azure services.

• Proficiency in creating and presenting documentation, diagrams, and reports.

Nice to have:

• 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

Thanks,

Raja Srinivas

Sr. US IT Recruiter

Email: raja.srinivas@stiorg.com