Position: AWS Database Architect with Snowflake

•  Must be willing to work onsite in Woodlawn, MD 5 days/week.
• Candidates should have 7+ years of database architecture experience, strong AWS data platform expertise, and be comfortable working in a federal environment (must be able to obtain Public Trust).
• Our client is looking for a senior Database Architect with strong AWS and Snowflake experience to design and manage scalable cloud-based data solutions. The ideal candidate will have experience architecting and optimizing databases across AWS services such as RDS, Aurora, DynamoDB, Redshift, and EMR, along with strong SQL and automation/scripting skills (Python, Terraform, CloudFormation, etc.).
• This person will be responsible for designing high-performance, secure database architectures, managing Snowflake data warehouses, optimizing queries/workloads, and integrating databases with AWS services like Lambda, S3, EC2, and Glue. The role also requires experience with backup/DR strategies, security best practices, and performance tuning in cloud environments.

Position Overview

Seeking an experienced Database Architect with strong expertise in AWS, Snowflake, and SQL to design and manage scalable, high-performance data solutions. This role will focus on database architecture, cloud data platforms, automation, and performance optimization in a secure environment.

Key Responsibilities

AWS Database & Cloud Architecture

• Design and architect scalable, high-performance, and secure database solutions within AWS.

• Utilize AWS database and data processing services including:

  • Amazon RDS

  • AuroraDB

  • DynamoDB

  • Redshift

  • ElastiCache

  • EMR

  • Neptune

• Integrate databases with other AWS services such as Lambda, S3, EC2, and Glue.

• Configure, launch, and manage EMR clusters, optimizing for performance and cost.

• Troubleshoot and resolve AWS-related issues and incidents.

Data Platform & Snowflake

• Design, implement, and manage virtual data warehouses in Snowflake.

• Develop and optimize complex SQL queries for data analysis, transformation, and reporting.

• Optimize performance using query tuning, caching, clustering, and auto-scaling.

Security, Reliability & Compliance

• Implement AWS security best practices, including:

  • IAM

  • Encryption

  • VPC

  • Security groups

• Design backup, disaster recovery, high availability, and failover solutions (Multi-AZ, read replicas).

• Ensure compliance with SSA security, privacy, and data management policies.

Collaboration & Leadership

• Provide guidance and support to junior and mid-level developers.

• Communicate technical solutions clearly to management, customers, and vendors.

• Perform additional duties as assigned.

Basic Qualifications

• Bachelor's degree in Computer Science, Engineering, Mathematics, or related field
  
  (Master's or Doctorate may substitute for experience).

• 7+ years of experience as a Database Architect.

• Strong experience with AWS database and data processing services.

• Knowledge of AWS security best practices (IAM, encryption, VPC, security groups).

• Strong troubleshooting skills for AWS environments.

• Experience optimizing queries, caching, clustering, and auto-scaling workloads.

• Experience with automation and scripting, including:

  • CloudFormation

  • Terraform

  • AWS CLI

  • Python

  • Bash

  • PowerShell

• Ability to obtain and maintain a Public Trust clearance.

Location Requirement:

Must be willing to work onsite in Woodlawn, MD – 5 days per week.

Required Skills for Success

Database Architecture

• Expertise in relational and NoSQL databases.

• Strong experience with data modeling, normalization, and schema design.

• Experience designing high availability, backup, disaster recovery, and failover solutions.

AWS Expertise

• Proven ability to architect secure and scalable AWS database environments.

• Strong experience with:

  • Query optimization

  • Indexing

  • Caching

  • Performance tuning

• Experience integrating databases with AWS services (Lambda, S3, EC2, Glue).

• Experience managing IAM roles, encryption, and monitoring using CloudWatch and CloudTrail.

Snowflake Expertise

• Experience designing and managing Snowflake virtual data warehouses.

• Strong understanding of Snowflake micro-partitions and performance tuning.

• Experience with data ingestion, transformation, and loading in Snowflake.

• Knowledge of Snowflake security and role-based access control.

• Experience integrating Snowflake with BI tools (Tableau, Power BI).

• Experience using Python for data pipelines and machine learning workloads.

Preferred / Desired Skills

• Experience leading architecture and solution design initiatives.

• Experience scripting in Linux environments for ETL automation and data migration.

• Knowledge of modern development practices, including:

  • Automated testing

  • Test-driven development

  • Continuous integration

  • Performance analysis

• Ability to assist with data architecture strategy and roadmaps.

• Experience working in federal or public sector environments.

• Strong communication skills with technical and non-technical stakeholders.

• Ability to manage multiple projects and prioritize deadlines.

#IND-Telecom

About INSPYR Solutions

Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.

INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.

Information collected and processed through your application with INSPYR Solutions (including any job applications you choose to submit) is subject to INSPYR Solutions’ Privacy Policy and INSPYR Solutions’ AI and Automated Employment Decision Tool Policy: https://www.inspyrsolutions.com/policies/. By submitting an application, you are consenting to being contacted by INSPYR Solutions through phone, email, or text.

26-155598