TRACTIAN · 4 hours ago

Data Infrastructure Engineer

Austin, TX

Full-time

Remote

Mid, Senior Level

5+ years exp

Maximize your interview chances

Artificial Intelligence (AI)B2B

Insider Connection @TRACTIAN

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQL query designPostgreSQLNon-SQL databasesETL toolsData synchronizationAnalytics toolsDatabase securityPythonGolangBashAWS RDSDockerKubernetes

Required

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.