Database Administrator (Remote - LATAM)
R Street Institute
- United States
- United States
À propos
At TrackStreet, we use the latest techniques for analyzing large datasets and applying artificial intelligence and machine learning to predict patterns, trends, and unexpected results. We want committed, free‑thinking individuals to bring their expertise to our growing concerns and problems. You will work in an environment where your ideas are valued and your opinions sought after. We need a strategic mind, not just a pair of hands, to address and solve challenges collaboratively.
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/architecture 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 / 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 DataBrick or similar big data platforms.
Experience with SnowFlake and 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, schema design, administration, and 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 frameworks.
Who We Are
At TrackStreet, we believe that when brands are represented the right way — by the right partners, at the right price — everyone wins. TrackStreet is a leading SaaS technology company that empowers brands to protect and grow their value in today’s dynamic eCommerce landscape. Our platform delivers advanced brand protection, market intelligence, and channel optimization solutions, giving businesses deep visibility across online retailers and marketplaces, enforcing pricing and reseller policies, and turning complex data into actionable insights that drive performance and profitability.
#J-18808-Ljbffr
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.