Data Architect (Database Administration & Optimization) at ApplaudoStudios

ApplaudoStudios

Guatemala City, Guatemala Department, gt·8h ago

SeniorFull-timeAWSGit

Salary Range

$59,670 - $80,730 /year

Estimated

This salary is estimated based on similar roles. The actual salary may vary.

About the Role

We are looking for a Data Architect to join our team at Applaudo. This role focuses on designing, optimizing, and scaling high-performance data solutions on AWS.

Key Responsibilities

→Design, evolve, and maintain data architectures that prioritize performance, scalability, and reliability on AWS RDS and Aurora
→Analyze and optimize database workloads through SQL performance tuning, query refactoring, and advanced indexing strategies
→Identify architectural and infrastructure-level bottlenecks related to CPU, memory, storage, and I/O, proposing scalable solutions
→Define and enforce data modeling and architectural standards for high-performance transactional and analytical workloads
→Collaborate closely with software engineers and technical teams to ensure strong alignment between application and data layers
→Establish and promote best practices for database performance monitoring, optimization, and reliability across environments
→Review and optimize stored procedures and complex SQL logic from an architectural and performance perspective
→Document data architecture decisions, performance guidelines, and optimization strategies
→Act as a technical reference and advisor for data architecture and performance topics across teams
→Support technical discussions with stakeholders by providing clear recommendations and trade-off analyses

Requirements

✓Bachelor’s Degree in Computer Science, Software Engineering, Data Engineering, or a related field (preferred), or equivalent professional experience
✓5+ years of experience in data architecture, database architecture, or similar roles with a strong focus on performance optimization
✓Hands-on experience designing and operating data solutions on AWS, with strong preference for RDS and Aurora
✓Advanced expertise in SQL, including complex query optimization, execution plan analysis, indexing strategies, and stored procedure development
✓Deep understanding of how CPU, memory, storage, and I/O constraints impact database and data architecture performance
✓Experience defining and applying architectural best practices for high availability, scalability, and performance
✓Strong proficiency using GitHub for version control, collaboration, and documentation
✓Ability to work independently, take ownership of architectural decisions, and drive improvements end to end
✓Strong analytical, problem-solving, and communication skills
✓High attention to detail and a strong commitment to data quality and system performance
✓Advanced English proficiency, as you will collaborate with distributed and US-based teams