TRACTIAN
Enterprise • Industrial • Energy
TRACTIAN is a company specializing in Asset Performance Management, providing industry-leading solutions to ensure zero downtime for manufacturing plants. With products like Smart Trac Condition Monitoring & Auto Diagnosis and TracOS™ Maintenance Management Software, TRACTIAN enables plant managers to predict failures, avoid downtime, and manage assets efficiently. Their solutions also focus on energy efficiency, transforming energy consumption data into profit. TRACTIAN collaborates with industries such as automotive, mining, oil and gas, and pharmaceuticals, offering advanced insights and AI-powered diagnostics to enhance machine reliability and operational efficiency.
Data Infrastructure Engineer
Job not on LinkedIn
December 19, 2024
TRACTIAN
Enterprise • Industrial • Energy
TRACTIAN is a company specializing in Asset Performance Management, providing industry-leading solutions to ensure zero downtime for manufacturing plants. With products like Smart Trac Condition Monitoring & Auto Diagnosis and TracOS™ Maintenance Management Software, TRACTIAN enables plant managers to predict failures, avoid downtime, and manage assets efficiently. Their solutions also focus on energy efficiency, transforming energy consumption data into profit. TRACTIAN collaborates with industries such as automotive, mining, oil and gas, and pharmaceuticals, offering advanced insights and AI-powered diagnostics to enhance machine reliability and operational efficiency.
📋 Description
• Engineering at TRACTIAN • The Engineering team at TRACTIAN is at the forefront of developing cutting-edge infrastructure, technologies, and products to harness the power of IoT data. Our team of talented engineers collaborates to build robust systems, innovative solutions, and scalable platforms that drive Tractian's success. We are instrumental in shaping the company's decision-making process, optimizing operational efficiency, and delivering exceptional experiences to our consumers. • What you'll do • As a Data Infrastructure Engineer, you will design and implement single-tenancy database solutions, giving customers secure control over their data. You’ll transition our multi-tenant infrastructure to a partitioned architecture, optimize SQL performance, and resolve complex database challenges. Your work will ensure scalable, reliable systems that empower customers with secure, reliable solutions and drive innovation.
🎯 Requirements
• Expert in SQL query design (normalization), optimization, indexing, and performance tuning with extensive experience managing relational databases like PostgreSQL in large-scale environments. • Expertise with non-SQL databases (MongoDB).Experience with CDC (Debezium) and data synchronization. • Experience with ETL tools such as Spark, Airflow, Pandas and Polars. • Knowledge of analytics and integrations tools like Airbyte, Grafana and Power BI. • 5+ years of SQL-focused database engineering experience and a bachelor’s degree in Computer Science or equivalent work experience. • Proven ability to design and manage multi-tenant and single-tenant database models, implement secure virtual partitioning, and optimize schemas for scalability and reliability. • Strong troubleshooting skills to resolve complex database issues and develop innovative, efficient solutions for data infrastructure challenges. • Coding skills (such as Python and Golang). • Experience building database systems that enable secure customer access, data control, and compliance with privacy regulations. • Effective team player who collaborates with engineering and IT teams and translates technical database concepts into actionable strategies for stakeholders. • Knowledge of Python or Bash for automation, cloud database platforms like AWS RDS, and containerized environments, such as Docker or Kubernetes.
🏖️ Benefits
• Competitive Salary • Premium Medical, Dental, and Vision Coverage • Paid Time Off (PTO): 15 Days • 401(k) Retirement Plan • Language Learning Opportunities - Take advantage of optional, fully funded Portuguese or Spanish courses to enhance your skills and global reach. • Birthday Time Off - Celebrate your birthday with a paid day off during your birthday week. • Gympass Membership - Access a wide range of gyms and training programs. • Sports Incentive - Receive a monthly bonus when you regularly participate in physical activities. • Long-Term Benefit - After four years of service, earn a fully funded trip anywhere in the world.
Apply Now