JOBSEARCHER

Data Architect – SQL Database Assessment & Modernization

Arkhya TechDallas, TXL6 LeadSeptember 2nd, 2026
Data Architect – SQL Database Assessment & Modernization
Location: Dallas or Austin, TX (4 days office / week)CTH (3 months max) or FTERole Overview We are looking for an experienced Data Architect to lead SQL Database Assessment and Modernization engagements. The candidate will be responsible for assessing the existing SQL Server landscape, analyzing database architecture, performance, security, scalability, and integration patterns, and defining a future-state architecture aligned with business, analytics, AI, and cloud modernization objectives. The ideal candidate should have extensive experience in SQL Server, database architecture, data modeling, performance optimization, migration strategies, cloud platforms, and enterprise data governance.
Key Responsibilities: Database Assessment Perform comprehensive assessment of SQL Server environments, including:
  • Database architecture
  • Schema design
  • Stored proceduresETL processes
  • Data integration patterns
  • Security and compliance posture
  • High availability and disaster recovery setup
Analyze database workloads, usage patterns, growth trends, and performance bottlenecks. Review database operational processes, maintenance strategies, backup and recovery mechanisms. Conduct database inventory and dependency analysis. Assess data quality, lineage, governance, and metadata management practices. Architecture & Modernization Strategy Define target-state data architecture and modernization roadmap. Recommend modernization approaches: SQL Server upgrade Azure SQL Database Azure SQL Managed Instance Synapse Analytics SnowflakeDatabricksCloud-native data platforms Define migration strategies including rehost, replatform, refactor, and rebuild approaches. Develop phased migration and transformation roadmap. Identify quick wins and long-term transformation opportunities. Data Modeling & DesignReview conceptual, logical, and physical data models. Recommend schema optimization and database design improvements. Define enterprise data models supporting analytics and reporting requirements. Establish data standards and modeling best practices. Performance & Optimization Analyze: Query performance Indexing strategy Partitioning opportunities Resource utilization Database growth trends Recommend performance tuning and optimization initiatives. Provide capacity planning and scalability recommendations. Security & Governance Evaluate database security architecture. Assess: Access controls EncryptionAuditingCompliance requirements Data retention policies Recommend governance framework, metadata management, and data stewardship practices. Stakeholder Management Engage with business stakeholders, application architects, DBAs, and engineering teams. Lead discovery workshops and technical assessment sessions. Present findings and executive-level recommendations. Prepare assessment reports and modernization business cases. Deliverables Current State Assessment Report Database Inventory & Dependency MatrixData Architecture Assessment Document Performance Assessment Report Security & Compliance Assessment Target State Architecture Blueprint Modernization Roadmap Migration Strategy & Effort Estimation Executive Summary & Recommendations Required Technical SkillsSQL & Database Technologies Microsoft SQL Server (2012/2014/2016/2019/2022)T-SQLStored Procedures Query Optimization Index Tuning PartitioningReplicationAlways On Availability GroupsData Architecture Enterprise Data Architecture Data Modeling (Conceptual, Logical, Physical)ERWIN / ER Studio Metadata Management Data Governance Master Data Management Database MigrationSQL Server Assessment & Migration Database Modernization Schema Migration Data Migration Migration Factory Approach Soft SkillsStrong customer-facing communication. Executive stakeholder management. Solution consulting and advisory experience. Ability to create assessment reports and modernization proposals.· Excellent problem-solving and analytical skills.· Experience leading distributed onsite-offshore teams.