Note: The job is a remote job and is open to candidates in USA. TrackStreet is a leading SaaS technology company that empowers brands to protect and grow their value in today’s dynamic eCommerce landscape. The Database Administrator will ensure the performance and availability of databases, design ETL pipelines, optimize SQL queries, and collaborate with development teams to support business intelligence and analytics requirements.
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
Skills
- 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 and maintaining systems for HIPAA, HITRUST, or other Cybersecurity Framework
Company Overview