Senior AWS Data Architect: Snowflake & Cloud DBs

INSPYR Solutions

Milford Mill (MD)

On-site

USD 130,000 - 180,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

INSPYR Solutions is seeking a Senior AWS Database Architect to design, implement, and optimize secure, scalable cloud database solutions in AWS and Snowflake. You will lead enterprise data platforms, configure RDS, Aurora, DynamoDB, Redshift, Snowflake, and related services, and collaborate with cross-functional teams to deliver reliable analytics-ready data stores.

The role emphasizes SQL optimization, data modeling, cloud security, IaC automation with Terraform/ CloudFormation, and performance

Qualifications

Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.

Responsibilities

Design, implement, and maintain scalable, secure, and highly available database architectures utilizing AWS database services.
Architect and support AWS database platforms including Amazon RDS, Aurora, DynamoDB, Redshift, ElastiCache, EMR, and Neptune.
Configure, deploy, monitor, and optimize Amazon EMR clusters for performance, scalability, and cost efficiency.
Design and manage Snowflake data warehouse environments, including database architecture, schema design, and performance optimization.
Develop complex SQL queries to support reporting, analytics, data transformation, and business intelligence initiatives.
Optimize database performance through indexing, query tuning, clustering, caching, partitioning, and auto-scaling strategies.
Design backup, disaster recovery, failover, and high-availability solutions utilizing Multi-AZ deployments and read replicas.
Integrate AWS database services with other AWS technologies including Lambda, S3, EC2, Glue, and additional cloud services.
Implement AWS security best practices including IAM, encryption, VPC configuration, security groups, and data governance controls.
Troubleshoot and resolve database performance, availability, and infrastructure-related issues.
Develop automation solutions using Infrastructure-as-Code and scripting technologies.
Support database monitoring, maintenance, upgrades, and continuous performance improvements.
Collaborate with developers, architects, analysts, and business stakeholders to gather requirements and implement scalable data solutions.
Provide technical leadership, mentorship, and guidance to junior team members.
Document architecture, standards, operational procedures, and technical solutions.
Present technical concepts and project updates to both technical and non-technical stakeholders.