Position: AWS Database Architect

•  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