TRACTIANData Infrastructure Engineer
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.
Responsibilities
- Architect Single-Tenancy Solutions: Design and implement scalable single-tenancy architectures, transitioning from multi-tenant systems to secure, isolated customer environments with virtual partitioning.
- Empower Customer Data Control: Build infrastructure that enables customers to securely access, analyze, and manage their data independently, ensuring privacy and ownership compliance.
- Optimize Database Performance: Configure, maintain, and optimize SQL-based database systems for high performance and scalability. Resolve complex technical issues to ensure reliability.
- Develop ETL and synchronization systems to seamlessly translate internal data structures into client-facing representations.
- Collaborate Across Teams: Partner with engineering, IT, and product teams to align database solutions with business goals and ensure seamless integration into broader workflows.
- Document and Enhance Processes: Create clear documentation for architecture, workflows, and best practices while identifying opportunities for automation and process improvement.
- Ensure Security and Compliance: Implement robust security measures and maintain compliance with industry standards and customer agreements in all database operations.
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.
Compensation
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.
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.