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]