Database Administrator (Remote - LATAM)

Database Administrator (Remote - LATAM)

Roles and Responsibilities

• Ensure availability and performance of the databases that support Trackstreet online services and business operations (e.g. system monitoring, performance tuning, routine maintenance tasks, etc.)
• Design, implement, and maintain ETL pipelines and data transformation workflows to support business intelligence and analytics requirements
• Optimize complex SQL queries and develop advanced SQL solutions for data extraction, transformation, and reporting
• Perform capacity planning to properly identify required hardware, software, database configuration/architect necessary to support application needs.
• Enforce best practices for improving performance, scalability and operational manageability of production databases.
• Create and perform database and system maintenance policy and procedures.
• Perform and document disaster recovery functions.
• Work with the development team to coordinate new data development ensuring consistency and integration.
• Work with Database Analyst to optimize all database objects, stored procedures, tables, views, triggers, indexes, user-defined functions and SSIS packages.
• Manage containerized database environments using Docker and orchestration tools
• Knowledge of Policy Management, Resource Governor and dynamic management views
• Part of on‑call rotation to respond to and resolve database issues to ensure production applications are online

Experience and Requirements

• At least 5 years’ hands‑on experience supporting multi‑tenant database systems in a high‑availability and high‑volume environment.
• Advanced SQL skills with proven experience writing complex queries, stored procedures, functions, and optimizing query performance.
• Hands‑on experience designing, building, and maintaining ETL processes and data transformation pipelines.
• Strong experience with AWS cloud services, including RDS, Redshift, S3, Lambda, and other data‑related AWS services.
• Basic knowledge of Docker containers and container orchestration (Docker Compose, ECS, or Kubernetes).
• Experience supporting PostgreSQL systems in cloud or data center environments.
• Experience with YellowBrick +++ l DataBrick or similar big data platforms.
• Experience with SnowFlake +.
• Experience with BigQuery +.
• Detailed understanding of PostgreSQL architecture and internals.
• At least 3 years’ experience working in a DevOps/SRE environment.
• Primary focus on AWS, with additional experience in Azure or GCP considered a plus.
• Experience with cloud providers such as AWS, Azure, or GCP, especially working with virtual machines in AWS or GCP.
• Experience with cloud‑native database systems such as AWS RDS, GCP CloudSQL, etc.
• Experience and strong understanding of database structures, data modeling, database schema design, database administration, best‑practices.
• Experience supporting, monitoring, and configuring Linux environments for database systems.
• Experience with Infrastructure‑as‑Code systems, preferably Terraform.
• Experience with NoSQL databases such as MongoDB, Redis, ElasticSearch, or DynamoDB.
• Hands on experience with MySQL Server.
• Experience designing and maintaining systems for HIPAA, HITRUST, or other Cybersecurity Framework.