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.
