Offer summary

Qualifications:

At least 5 years of hands-on experience with multi-tenant database systems in high-availability environments., Experience with PostgreSQL and cloud providers like AWS or GCP., Strong understanding of database structures, data modeling, and administration best practices., Familiarity with Infrastructure-as-Code systems, preferably Terraform, and NoSQL databases..

Key responsabilities:

Ensure the availability and performance of databases supporting online services and business operations.

Perform capacity planning and enforce best practices for database optimization.

Collaborate with development teams to ensure data consistency and integration.

Participate in on-call rotation to resolve database issues and document disaster recovery functions.

Job description

Database Administrator (Remote - LATAM)

As a Database Administrator at TrackStreet, you will play a critical role in maintaining the performance, availability, and scalability of the databases that power our core products and business operations. You will own database infrastructure and optimization while collaborating cross-functionally to support system reliability, data consistency, and growth.

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
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 the 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.
Knowledge of Policy Management, Resource Governor and dynamic management views
Part of an 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 +
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.
Experience working in a secure regulated or healthcare software sector with experience designing and maintaining systems for HIPAA, HITRUST, or other Cybersecurity frameworks

OUR OFFER

Competitive salary up to $60,000 per year
Work fully remote
Paternity and Maternity leave
Unlimited PTO
Working with international members all across the globe

ABOUT TRACKSTREET

At TrackStreet, we've revolutionized Brand Protection, eCommerce Channel Management, and Optimization, offering manufacturers and brands a distinct competitive advantage that drives more profitable revenue in the dynamic eCommerce landscape.

The TrackStreet Vision

To empower brands with the intelligence to make the smartest, fastest ecommerce decisions on the planet.

The TrackStreet Mission

We leverage an adaptive learning engine that automates and recommends actions based on desired business outcomes, stakeholder roles, and market data to achieve business goals and uncover additional growth opportunities.Our culture is built on collaboration, innovation, and a dedication to excellence. We value each team member's contributions and are committed to fostering an environment where everyone can thrive and make a meaningful impact. Ready to revolutionize eCommerce with us? Join TrackStreet and be part of a dynamic team driving innovation and growth in the industry.

Required profile