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.)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 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.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.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.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 OUR OFFER Competitive salary up to $80,000 USD per year Work fully remote Paternity and Maternity leave Unlimited PTO Working with international members all across the globe ABOUT TRACKSTREET We're a leading high-growth SaaS platform that protects the margin, reputation, and relationships of the best brands in the world.Our clients depend on us to see into the future in ways that enable them to straddle the worlds of eCommerce and retail, and to flourish in a quickly changing landscape.We've got a tremendous team and we're looking for that special someone who enjoys taking on a lot of responsibility in a dynamic, high-growth startup environment to join us.A recent finalist in the Codie Awards in the categories of Best eCommerce Solution and Best Sales and Marketing Intelligence Solution, TrackStreet is comprised of 6 modules (with more releasing shortly) which integrate to end surprises about the internet sales channel that erode customer confidence, reduce sales, and destroy brand equity.Our systems put brands back in control of their markets while enabling them to focus on building relationships and driving sales.TrackStreet seeks a diverse pool of applicants and considers all qualified candidates regardless of race, ancestry, color, gender identity or expression, sexual orientation, religion, national origin, citizenship, disability, Veteran status, marital status, or any other protected status.If you have a special need or disability that requires accommodation, please let us know.Learn more about us at https://www.trackstreet.com Powered by JazzHR
