Other
This job posting has expired and is no longer accepting applications. Check out similar jobs
Job description
Role: Database Architect - SQL Server (AWS Migration)
Location: Irvine, CA (Onsite)
Experience: 8-12 Years
Job Summary
We are seeking an experienced Database Architect with deep expertise in Microsoft SQL Server and AWS cloud migration. The ideal candidate will lead database modernization initiatives, including migrating SQL Server environments from on-premises data centers to AWS. This role requires strong hands-on experience in database administration, performance tuning, high availability, and enterprise-scale migration programs.
Key Responsibilities
Database Architecture & Migration
- Lead and execute migration of SQL Server databases from on-premises environments to AWS EC2
- Assess current database environments and define migration, upgrade, and optimization strategies
- Design target-state database architecture aligned with AWS best practices
- Support data center exit and cloud transformation initiatives
- Perform installation, configuration, patching, upgrades, and performance tuning of SQL Server
- Optimize database performance, query execution, and resource utilization
- Conduct performance benchmarking and validation post-migration
- Implement and manage HA/DR solutions including:
- Always On Availability Groups
- Failover Clustering
- Backup and Restore strategies
- Ensure business continuity and minimal downtime during migration
- Work with AWS services including:
- EC2, EBS, S3, IAM, CloudWatch, VPC
- Support hybrid environments during transition from on-prem to cloud
- Collaborate with application teams supporting Java and .NET workloads
- Ensure seamless integration with middleware systems such as TIBCO ESB
- Implement database security controls including access management, encryption, and auditing
- Ensure compliance with enterprise security and governance standards
- Coordinate with infrastructure, cloud, DevOps, and application teams
- Document database architecture, configurations, and operational procedures
- Support testing, validation, troubleshooting, and hypercare activities
Database Expertise
- Strong hands-on experience with Microsoft SQL Server in enterprise environments
- Expertise in:
- Database tuning and optimization
- SQL performance troubleshooting
- Installation, upgrades, and patching
- Hands-on experience with SQL Server on AWS EC2
- Strong understanding of AWS services:
- EC2, EBS, S3, IAM, CloudWatch, VPC
- Experience in on-prem to AWS migration programs
- Deep knowledge of:
- Always On Availability Groups
- Failover Clustering
- Backup and Recovery strategies
- Experience with Windows Server environments (2016/2019/2022/2025)
- Knowledge of hybrid architectures and cloud networking
- Experience supporting applications built on Java and .NET
- Familiarity with middleware such as TIBCO ESB
- Strong SQL and database troubleshooting skills
- Experience with Infrastructure as Code (Terraform or similar tools)
- Exposure to DevOps and CI/CD pipelines for database deployments
- Experience in large-scale enterprise migration or data center exit programs
- AWS or Microsoft SQL Server certifications
Most Popular Jobs Similar to Sql Data Architect
sql architect
sql database architect
sr sql developer
sql server architect
sql consultant
senior sql developer
sql engineer
lead sql developer
data architect
etl data architect
Other Helpful Pages Related To Database Architect - SQL Server (AWS Migration)
Azure Database Administrator Salaries
Frequently asked questions
Q: What skills or qualities help someone succeed as a SQL Data Architect?
A: To succeed as a SQL Data Architect, key technical skills include proficiency in database management systems (DBMS), data modeling, and data warehousing, as well as expertise in SQL programming languages such as SQL Server, Oracle, or MySQL. Additionally, soft skills like effective communication, problem-solving, and collaboration are crucial for working with cross-functional teams, stakeholders, and developers to design and implement data architectures that meet business needs. These strengths enable Data Architects to drive data-driven decision-making, improve data quality, and ensure data security, ultimately supporting career growth and effectiveness in the role.
Q: What is the career path for a SQL Data Architect?
A: A SQL Data Architect's career path typically begins with entry-level roles such as Junior Database Administrator or Data Analyst, where they develop foundational skills in database design, data modeling, and SQL programming. As they progress to mid-level roles like Senior Database Administrator or Data Architect, they take on more complex projects, lead teams, and develop expertise in data governance, security, and scalability. Senior roles such as Enterprise Data Architect or Chief Data Officer often involve strategic decision-making, overseeing large-scale data initiatives, and driving business growth through data-driven insights, offering opportunities for long-term career advancement and leadership opportunities.