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.
Top Skills
What We Do
Tractian is a machine intelligence company that offers industrial monitoring systems. Tractian builds streamlined hardware-software solutions to give maintenance technicians and industrial decision-makers comprehensive oversight of their operations. It is democratizing access to sophisticated real-time monitoring and asset operations tools.
Tractian's solutions are used in environments that address a combined total of 5% of global industrial output. The company’s broad market reach is evidenced in its customer base from various industries, such as John Deere, Procter & Gamble, Caterpillar, Goodyear, Carrier, Johnson Controls, and Bimbo, the owner of the brands Little Bites and Thomas Bagels. Tractian's customers see a 6-12x ROI with savings of $6,000 per monitored machine annually on average.
In a major milestone and a first for the industry, Tractian launched the AI-Assisted Maintenance category in the industrial sector. In this new paradigm, artificial intelligence identifies machine problems and suggests preventive actions to be taken, giving invaluable insight and support to maintenance professionals. It is important to highlight that the intent of Assisted Maintenance is firmly rooted in augmenting maintenance professionals to provide more assertive diagnosis with human-in-the-loop feedback.
Tractian's mission is to elevate this category of workers in a highly impactful way. The Assisted Maintenance category will provide unimaginable support for maintenance professionals. By combining shop floor expertise with our technology, maintainers will be able to anticipate and address issues with unprecedented accuracy and speed
