What are the responsibilities and job description for the Database Architect position at INSPYR Solutions?
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
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.