What are the responsibilities and job description for the Data Architect SQL Database Assessment & Modernization :: Dallas/Austin, TX position at Arkhya Tech?
Data Architect SQL Database Assessment & Modernization
Location Dallas or Austin, TX
(4 days office / week)
Key Responsibilities
Database Assessment
Perform comprehensive assessment of SQL Server environments, including:
o Database architecture
o Schema design
o Stored procedures
o ETL processes
o Data integration patterns
o Security and compliance posture
o 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:
o SQL Server upgrade
o Azure SQL Database
o Azure SQL Managed Instance
o Synapse Analytics
o Snowflake
o Databricks
o Cloud-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.
Thanks,
Have a great day!!
Milind Pandey
Arkhya Tech INC.
1020 Elden St, Suite #102, Herndon, VA 20170