Database Architect - Stemtree of Ashburn

OpenTalent; Baltimore (MD); On-site; USD 130,000 - 190,000; Full time

Job summary

OpenTalent is seeking a Database Architect in Woodlawn, MD to design and manage scalable, secure database solutions on AWS and Snowflake. You will configure EMR clusters, optimize performance and cost, and ensure robust backup and disaster recovery while integrating with multiple AWS services.

The role requires 7+ years in database architecture, strong SQL skills, and expertise in automation and scripting (CloudFormation, Terraform, AWS CLI, Python, Bash, PowerShell).

Qualifications

• Bachelor's degree or higher in a related field with 7+ years as a Database Architect.
• Experience with AWS database and data processing services (RDS, Aurora, DynamoDB, Redshift, ElastiCache, EMR, Neptune).
• Strong knowledge of AWS security best practices and data storage compliance.
• Proficient in automation and scripting (CloudFormation, Terraform, AWS CLI, Python, Bash, PowerShell).

Responsibilities

• Utilize AWS database and data processing services (RDS, AuroraDB, DynamoDB, Redshift, ElastiCache, EMR, Neptune).
• Configure, launch, and manage EMR clusters; optimize for performance and cost; integrate with data sources.
• Architect scalable, high-performance, secure database solutions; integrate with Lambda, S3, EC2, Glue.
• Design backup, DR, high availability, and failover (Multi-AZ, read replicas).
• Write complex SQL queries for data analysis, transformation, and reporting; optimize queries and caching.
• Ensure SSA security, privacy, and data management compliance; mentor junior/mid-level developers.

Skills

Database Architecture

AWS

Snowflake

SQL

Automation

Scripting

Education

Bachelor's Degree in Computer Science, Mathematics, Engineering or related field

Job description

Position Title

Database Architect

Key Required Skills

Database Architecture, experience with AWS, snowflake, SQL, and automation and scripting.

Position Description

• Utilize the AWS database and data processing services, including Amazon RDS, AuroraDB, DynamoDB, Redshift, ElastiCache, EMR, and Neptune.
• Configure, launch, and manage EMR clusters, optimizing for performance and cost, and integrating with various data sources.
• Architect scalable, high-performance, and secure database solutions.
• Integrate databases with other AWS services such as Lambda, S3, EC2, and Glue.
• Utilize AWS security best practices (IAM, encryption, VPC, security groups) and compliance requirements for data storage.
• Design backup, disaster recovery, high availability, and failover solutions (Multi-AZ, read replicas).
• Troubleshoot for AWS related issues and incidents.
• Design, implement, and manage virtual data warehouses in Snowflake.
• Write complex SQL queries for data analysis, transformation, and reporting.
• Optimize queries, manage caching, clustering, and leveraging auto-scaling to handle workloads.
• Ensure compliance with SSA security, privacy, and data management policies.
• Brief management, customer, team, or vendors using written or oral skills at appropriate technical level for audience.
• Provide guidance/support to other junior/mid-level developers.
• All other duties as assigned or directed.

Detailed Skills Requirements

Foundation for Success (Basic Qualifications)

• Bachelor's Degree in Computer Science, Mathematics, Engineering or a related field; Masters or Doctorate degree may substitute for required experience
• 7+ years as a Database Architect.
• Experience in AWS database and data processing services, including Amazon RDS, AuroraDB, DynamoDB, Redshift, ElastiCache, EMR, and Neptune.
• Knowledgeable in AWS security best practices (IAM, encryption, VPC, security groups) and compliance requirements for data storage.
• Strong troubleshooting skills for AWS related issues and incidents.
• Skilled in optimizing queries, managing caching, clustering, and leveraging auto-scaling to handle workloads.
• Proficient in automation and scripting (CloudFormation, Terraform, AWS CLI, Python, Bash, PowerShell) for database and workflow management.

Factors To Help You Shine (Required Skills)

Selected candidate must be able to obtain and maintain a public trust clearance

Selected candidate must be willing to work on-site in Woodlawn, MD 5 days a week

• Skilled in both relational and NoSQL database management, data modeling, normalization, and schema design.
• Experienced in configuring, launching, and managing EMR clusters, optimizing for performance and cost, and integrating with various data sources.