Sr. Data Architect

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.

Primary Focus: Database Architecture, Data Lake Design & Modernization

Duties and Responsibilities – Database Design and Architecture

Architecture Focus of the Role:

• 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

Key Responsibilities – Architecture: SQL Server and MySQL migrations to AWS

• 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

Secondary Focus: Database Operations & 24/7 Support Management

Duties and Responsibilities - Operations

Operational Focus:

• 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 troubleshooting and operational risk mitigation

Key Responsibilities - Operations:

• Lead and manage contract resources supporting 24/7 database operations and monitoring
• Develop operational runbooks, playbooks, and escalation procedures for database support
• Oversee database health monitoring, performance analysis, and proactive maintenance
• Establish performance baselines and SLAs for operational databases
• Lead incident response and root cause analysis for critical database issues
• Mentor and support contract resources on database administration best practices
• Coordinate on-call scheduling and resource allocation for 24/7 operations
• Ensure operational issues are documented and fed back into architecture improvements

Contract Resource Management:

• Recruit, onboard, and manage contract resources for 24/7 database operations support
• Develop training programs and documentation for contract database administrators
• Define roles, responsibilities, and escalation paths for contract team members
• Conduct performance reviews and quality assurance of contract resource work
• Manage contract lifecycle, renewals, and resource optimization
• Establish metrics and KPIs for contract resource performance and efficiency

Qualifications

Senior-level experience as a Database Architect or Database Administrator:

• Strong, hands-on expertise designing and implementing enterprise database architectures on AWS (10-15+ years)
• Extensive, proven experience with Microsoft SQL Server and MySQL database design, optimization, and migration( 7+ years)
• Deep experience with AWS database services (RDS, Aurora, DMS) and data lake architecture(7+ years)
• Proven track record designing and optimizing large-scale databases in AWS cloud environments
• Experience designing data lake solutions and integrating on-premise data warehousing with cloud platforms

Experience designing large-scale database architectures and modernization efforts, including:

• SQL Server and MySQL databases in the 10-50TB+ range
• Legacy SQL Server and MySQL on-premise to AWS cloud database migrations
• Complex multi-tier database architectures across AWS services
• Data lake architecture design and implementation on AWS (S3, Glue, Athena, Redshift)
• SSIS-based data warehousing solutions and modernization strategies
• AWS cloud database services (RDS, Aurora, DMS, Redshift, Glue, Athena)

Extensive experience working with:

• Legacy SQL Server and MySQL databases requiring architectural redesign and cloud migration
• Deep expertise in SQL optimization, indexing strategies, and performance tuning for both on-premise and AWS databases
• Large-scale database administration and AWS cloud platform management
• AWS database services and cloud architecture design (RDS, Aurora, DMS, Redshift, S3, Glue, Athena, Firehose)
• SSIS-based data warehousing solutions and modern AWS data lake architectures
• Data integration and ETL pipeline design across heterogeneous database sources

Additional Qualifications

• Ability to articulate complex database architecture concepts to technical and non-technical stakeholders
• Demonstrated leadership in managing technical teams and contract resources
• Strong documentation and communication skills for architecture design and operational procedures
• Ability to balance architecture innovation with operational stability

• AWS Solutions Architect certification is a plus
• Experience with AWS Database Migration Service (DMS) and related migration tools
• Track record of leading successful SQL Server and MySQL to AWS migration programs
• Experience with data warehouse modernization (SSIS to AWS Glue/Athena)
• Experience with database migration tools and frameworks

• Experience designing data lakes on AWS (S3 data lake architecture, Apache Iceberg, Delta Lake)
• Knowledge of polyglot persistence architectures and multi-engine data platforms

• Experience with database cost optimization and resource management
• AWS cost optimization experience for database and data lake services
• Knowledge of database security, compliance, and governance frameworks
• Experience with CI/CD and Infrastructure as Code (IaC) for database deployments

Direct Reports

• TBD

Must be able to pass a pre-employment drug screening.