Database Architect

The Amatriot Group; Woodlawn (MD); On-site; USD 134,000 - 175,000; Full time

Job summary

The Amatriot Group is seeking an experienced Database Architect to design, implement, and optimize scalable database solutions using AWS services and Snowflake. You will manage SQL development, automation, security, and data availability while collaborating with developers and stakeholders.

Responsibilities include EMR cluster management, data integration, performance tuning, and ensuring disaster recovery and high availability.

Qualifications

• Bachelor's degree in Computer Science, Mathematics, Engineering, or a related field.
• 7+ years of experience as a Database Architect.
• Experience with AWS database and data processing services (RDS, Aurora, DynamoDB, Redshift, ElastiCache, EMR, Neptune).
• Experience designing Snowflake data warehouses and micro-partitions.
• Snowflake schema design, normalization, and data structures.
• Snowflake-integrated data pipelines with BI tools (Tableau/Power BI) and Python.
• Knowledge of AWS security best practices (IAM, encryption, VPC, security groups).
• Ability to architect secure, scalable, high-performance databases and perform optimizations.

Responsibilities

• Architect scalable, high-performance, secure database solutions on AWS and Snowflake.
• Configure, manage, and optimize EMR clusters and integrate with data sources.
• Ensure backup, DR, HA, failover and compliance per SSA guidelines.
• Write complex SQL queries for analysis, transformation, and reporting.
• Provide guidance to junior- and mid-level developers and communicate with stakeholders.

Skills

AWS & database services

SQL & Snowflake

Security best practices

Performance tuning

Automation scripting

Data modeling

Communication

Education

Bachelor's degree in CS/Math/Engineering

Tools

Snowflake

AWS services

Job description

Location: Woodlawn, MD

Security Clearance: Must be able to obtain a CI Poly)

Job Type: Full-Time

Target Salary Range*: $134,000 - $175,000

• This represents the potential salary range for this position depending on education level, years of experience and/or certifications in addition to other position specific requirements which may impact salary

Position Overview

The Database Architect will architect, implement, manage, and optimize scalable, high-performance, and secure database solutions using AWS database and data processing services and Snowflake. The role includes database administration, SQL development, automation and scripting, security and compliance, troubleshooting, and support for other developers.

Key Responsibilities

AWS Database Architecture and Operations

• Utilize AWS database and data processing services, including Amazon RDS, AuroraDB, DynamoDB, Redshift, ElastiCache, EMR, and Neptune.
• Architect scalable, high-performance, and secure database solutions.
• Configure, launch, and manage EMR clusters, optimizing for performance and cost and integrating with various data sources.
• Integrate databases with AWS services such as Lambda, S3, EC2, and Glue.
• Troubleshoot AWS-related issues and incidents.

Security, Compliance, and Availability

• Apply AWS security best practices, including IAM, encryption, VPC, and security groups, and comply with data storage requirements.
• Design backup, disaster recovery, high availability, and failover solutions, including Multi-AZ and read replicas.
• Ensure compliance with SSA security, privacy, and data management policies.

Snowflake and SQL

• Design, implement, and manage virtual data warehouses in Snowflake.
• Write complex SQL queries for data analysis, transformation, and reporting.
• Optimize queries, manage caching and clustering, and leverage auto-scaling to handle workloads.

Communication and Support

• Brief management, customers, teams, and vendors using written and oral communication appropriate to the audience's technical level.
• Provide guidance and support to junior- and mid-level developers.
• Perform all other duties as assigned or directed.

Qualifications

Education

• Bachelor's degree in Computer Science, Mathematics, Engineering, or a related field. A master's or doctorate degree may substitute for required experience. [Required]

Experience

• 7+ years of experience as a Database Architect. [Required]
• Experience with AWS database and data processing services, including Amazon RDS, AuroraDB, DynamoDB, Redshift, ElastiCache, EMR, and Neptune. [Required]
• Experience configuring, launching, and managing EMR clusters, optimizing for performance and cost, and integrating with various data sources. [Required]
• Experience designing backup, disaster recovery, high availability, and failover solutions, including Multi-AZ and read replicas. [Required]
• Experience designing, implementing, and managing virtual data warehouses in Snowflake, including an understanding of micro-partitions. [Required]
• Experience with Snowflake schema design, normalization, and building efficient data structures. [Required]
• Experience with data ingestion, transformation, and loading using Snowflake features and integration tools. [Required]
• Experience integrating Snowflake with BI tools such as Tableau and Power BI and using Python for data pipelines and machine learning applications. [Required]

Skills

• Knowledge of AWS security best practices, including IAM, encryption, VPC, and security groups, and compliance requirements for data storage. [Required]
• Strong troubleshooting skills for AWS-related issues and incidents. [Required]
• Skilled in optimizing queries, managing caching and clustering, and leveraging auto-scaling to handle workloads. [Required]
• Proficiency in automation and scripting using CloudFormation, Terraform, AWS CLI, Python, Bash, and PowerShell for database and workflow management. [Required]
• Skilled in relational and NoSQL database management, data modeling, normalization, and schema design. [Required]
• Advanced skills in writing complex SQL queries for data analysis, transformation, and reporting. [Required]
• Ability to architect scalable, high-performance, and secure database solutions, including query optimization, indexing, caching, and performance tuning using AWS tools. [Required]
• Experience securing AWS clusters, managing IAM roles, implementing encryption, and monitoring jobs using AWS tools such as CloudWatch and CloudTrail. [Required]
• Knowledge of Snowflake role-based access control, data encryption, and security best practices. [Required]

Clearance

• Selected candidate must be able to obtain and maintain a public trust clearance. [Required]

Other Requirements

• Selected candidate must be willing to work on-site in Woodlawn, MD, five days a week. [Required]

Preferred Qualifications

Experience

• Experience identifying requirements, researching options, designing, and implementing solutions at a leadership level on project work.
• Experience scripting in a Linux environment to automate ETL solutions and data migration jobs.
• Prior experience working in a federal agency or public sector environment.

Skills

• Understanding and application of quality techniques and practices, including automated unit testing, Test Driven Design/Development, performance analysis, and continuous integration.
• Ability to assist with architectural tactical thinking, information solutions, and road maps to drive architectural recommendations.
• Detail-oriented approach and commitment to consistently completing repetitive production-like tasks on time and error-free.
• Effective communication skills for working with cross-functional teams, including data scientists, analysts, and business stakeholders.
• Ability to translate technical concepts into non-technical terms for business stakeholders.
• Ability to manage multiple projects, prioritize tasks, and deliver within deadlines.