AWS Database Architect

Trilogy Federal drives innovative solutions for complex business challenges across financial management, healthcare, and government industries. Our collaborative, client-first service approach, combined with our commitment to the rapid implementation of pragmatic solutions, has earned Trilogy an unparalleled reputation for delivering transformative results. Trilogy Federal is seeking a AWS Database Architect to support the Department of Veterans Affairs (VA) Office of Information & Technology (OIT), Product Delivery Service (PDS), Corporate Service Line. The ideal candidate will design, implement, and optimize cloud-based database solutions that support scalable, secure, and high-performing applications. This role ensures database architectures align with organizational objectives, industry best practices, and AWS Well-Architected Framework standards. The architect collaborates closely with engineering, DevOps, security, and product teams to deliver reliable and resilient data platforms., * Evaluate, recommend, and implement relational (Microsoft SQL Server) and non-relational (DynamoDB, Cosmos DB, MongoDB) database technologies Develop database strategies that support scalability, fault tolerance, data integrity, and high availability.

• Lead migration initiatives from on-premises or legacy databases to AWS using DMS, SCT, or custom data pipelines.
• Design and architect cloud-native database solutions on AWS, with deep expertise in RDS and adjacent AWS data services
• Define standards and best practices for database security, availability, performance, and cost optimization
• Collaborate with application architects and developers to ensure database designs align with application requirements
• Implement disaster recovery, backup strategies, and high-availability configurations using AWS-native tooling
• Provide technical guidance and mentorship to database administrators and engineers
• Evaluate emerging AWS database technologies and make recommendations for adoption
• Produce architectural documentation, and diagrams
• Implement and enforce database security best practices involving IAM, KMS, encryption, networking, and compliance controls.
• Conduct database performance tuning, including index optimization, query analysis, and resource right-sizing.
• Partner with application teams to define data models, schema design, and efficient access patterns.
• Configure and maintain monitoring, alerting, logging, and backup processes using CloudWatch, AWS Backup, EventBridge, and related tools.
• Develop Infrastructure-as-Code templates (CloudFormation, Terraform, or CDK) for consistent database provisioning.
• Participate in architectural reviews, security assessments, and design sessions to ensure adherence to governance standards.

• Bachelor's degree in computer science or equivalent experience.
• 3+ years of experience in database design, development, and administration within AWS, including hands-on experience with AWS RDS and related database services
• AWS certification such as Database - Specialty or Solutions Architect
• Experience designing and supporting large-scale AWS database systems.
• Hands-on expertise with RDS, Aurora, DynamoDB,MongoDB, CosmosDB Redshift, ElastiCache and EMR and other AWS data services.
• Strong proficiency in SQL, NoSQL database paradigms, including document-oriented databases such as MongoDB
• Experience designing and managing caching database solutions (e.g., Redis, Memcached) to optimize application performance and reduce latency
• Experience with performing query optimization, caching strategies and capacity planning using performance insights and CloudWatch.
• Solid understanding of AWS networking, security, and IAM as they relate to cloud data infrastructure
• Experience with migrating applications from one authorization boundary to another in AWS.
• Knowledge of database migration techniques and modernization approaches.
• Understanding of AWS networking, IAM, VPC design, and encryption best practices.
• Experience with Infrastructure as Code tools such as CloudFormation, Terraform, or CDK.
• Familiarity with monitoring and APM tools such as CloudWatch, Datadog, or Dynatrace.
• Strong analytical and problem-solving skills and strong communication skills with ability to translate complex technical concepts for diverse audiences.
• Proficiency in scripting languages (Python) and CICD tools, specifically Jenkins.
• Strong analytical and problem-solving skills.
• Ability to lead complex technical discussions and drive architectural direction.
• Collaborative, team-focused mindset.
• Excellent documentation and presentation abilities.
• Ability to obtain a VA Position of Public Trust

Preferred Qualifications:

• Familiarity with .NET or Java application development - understanding of how applications interact with and consume database layers is a plus
• Experience working with Jira as a data source, including knowledge of its underlying data structures and APIs
• Hands-on experience or interest in migrating project management and workflow data (such as Jira) into SQL or NoSQL database solutions, including data modeling, ETL design, and schema planning for ticket, sprint, and workflow data
• Experience working in enterprise, government, or regulated environments.
• Familiarity with DevOps practices and CI/CD automation for data components.
• Knowledge of FedRAMP, HIPAA, SOC2, or similar compliance frameworks.

Benefits (including but not limited to):

• Health, dental, and vision plans
• Optional FSA
• Paid parental leave
• Safe Harbor 401(k) with employer contributions 100% vested from day 1
• Paid time off and 11 paid holidays
• No cost group term life/AD&D plan, and optional supplemental coverage
• Pet insurance
• Monthly phone and internet stipend
• Tuition and training reimbursement

This range is not a guarantee of compensation or salary, as Trilogy Federal conducts an individual equity review for every candidate based on experience, location, education, industry experience, and comparisons to internal pay bands. In addition to salary, Trilogy offers robust benefits including medical/dental/vision insurance coverage, 401(k) match, paid holidays, paid time off, tuition reimbursement, and a very supportive work/life balance. Trilogy Federal is an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.