Database Administrator (Remote - LATAM)
Database Administrator (Remote - LATAM)
Are you looking to join a team of highly motivated, dedicated and intelligent developers solving real world problems in the eCommerce space that protect manufacturers AND consumers?
At TrackStreet , we do this by using some of the latest and greatest techniques available 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 provide their experiences and expertise to our growing concerns and problems. You will consistently find an environment where your ideas are valued, and your opinions are actively sought after. We are not merely seeking a pair of hands but rather a strategic mind to collaboratively address and solve the challenges at hand.
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/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