Sr. Data Architect

Charlotte, NC
3525 Whitehall Park Drive
Suite 400
Charlotte, NC 28273, USA

Database Architect to lead database modernization initiatives and design scalable, performant enterprise‑grade database and data lake solutions for large‑scale platforms. This role is primarily focused on designing modern database and data lake architectures, modernizing legacy SQL Server and MySQL database structures to AWS‑based platforms, and architecting integrated solutions combining on‑premise and AWS SaaS services. As a secondary responsibility, the Database Architect will oversee operational database management and lead a team of contract resources supporting 24/7 database operations.

The ideal candidate is deeply hands‑on, with extensive experience designing and implementing complex database and data lake solutions. They will modernize legacy SQL Server and MySQL databases to modern AWS‑based platforms while minimizing downtime and operational risk, and architect scalable data lake solutions integrating existing on‑premise SSIS‑based data warehousing with AWS cloud services.

• Design and architect enterprise database solutions for large‑scale data platforms on AWS
• Lead database modernization initiatives, transitioning SQL Server and MySQL databases from on‑premise to AWS‑based architectures
• Create detailed database design specifications, data models, and performance optimization strategies
• Architect scalable data lake solutions combining on‑premise SSIS‑based data warehousing with AWS cloud services
• Design advanced analytics and reporting databases leveraging AWS services (RDS, Aurora, Redshift, S3, Athena, Glue)
• Architect multi‑source data integration solutions consolidating SQL Server, MySQL, and third‑party data sources
• Design and implement schema optimization, indexing strategies, and query optimization frameworks for high‑performance databases
• Lead database architecture reviews and technical design evaluations prior to implementation

• Develop detailed database design documents, architecture decision records, and technical specifications
• Assess legacy SQL Server and MySQL database environments, identify modernization opportunities, and design AWS‑based solutions (RDS, Aurora, DMS)
• Architect scalable data lake solutions integrating existing on‑premise SSIS data warehousing with AWS SaaS services
• Design multi‑source data ingestion and transformation pipelines consolidating SQL Server, MySQL, and external data sources
• Architect multi‑tier database solutions optimized for performance, scalability, and cost across AWS services
• Design advanced data models, schema patterns, and optimization strategies for complex database and data lake environments
• Create database capacity planning and scalability roadmaps aligned with business growth and data volume projections
• Design disaster recovery and high‑availability architectures at the database level with AWS RDS multi‑AZ and backup strategies
• Collaborate with application, infrastructure, and cloud teams to coordinate database modernization timelines and dependencies
• Ensure data security, compliance, and governance throughout the database architecture lifecycle
• Build and support advanced data engineering tools and frameworks like AWS Firehose, Athena, Glue, EMR, and data lake technologies
• Build and support advanced data engineering tools and frameworks like Firehose, SQTables, Athena, EMR

As a secondary responsibility, the Database Architect will oversee operational database management and manage contract resources to ensure 24/7 database availability and performance.

• Resolve performance issues in large, poorly designed or heavily constrained databases
• Oversee SQL query optimization, indexing strategies, and performance tuning
• Lead operational database management and optimization of AWS‑based cloud platforms
• Manage proactive and reactive…