Castelion
Database/Python Generalist
Allen, TX +3 · Full-time · Posted Oct 20, 2026
- Location
- Allen, TX
Torrance, CA
716 South Greenville, Suite 160, Allen, TX 75002
19951 Mariner Ave, Torance, CA 90503 - Visa sponsorship
- Employment is contingent on being able to access applicable export-controlled information without additional export licensing. If the role is designated as requiring classified access, employment may also depend on obtaining and maintaining required U.S. Government clearance or authorization and satisfying applicable citizenship or eligibility requirements.
About the job
Build and improve calibration automation, PostgreSQL infrastructure, and Python backend services to make seeker calibration and testing faster and more reliable.
What you'll do
- Develop end-to-end calibration tooling, Golden Calibration systems, and a Calibration Dependency Graph.
- Optimize PostgreSQL schemas, queries, indexes, and data pipelines; safely maintain production databases.
- Build Python backend services and support hardware-facing test systems and chamber-testing workflows.
What they ask for
- Strong Python engineering skills, including production services and APIs.
- Experience architecting PostgreSQL schemas and safely modifying production databases, with deep expertise in query optimization, transactions, locking, and performance analysis.
- Experience with EXPLAIN and EXPLAIN ANALYZE, safe migrations and backfills, ingestion pipelines, and multi-database synchronization.
- Experience with ORMs and direct SQL, partitioning and efficient data access, and shared Python types and reusable database tools.
Nice to have
- Experience with calibration, test automation, engineering data-management systems, or hardware-facing Python test systems.
- Experience with dependency-aware data pipelines or supporting algorithm, machine-learning, or other data-intensive engineering workflows.
Tools
Python, PostgreSQL, ORMs, SQL, EXPLAIN, EXPLAIN ANALYZE
Model-written summary · the original posting is authoritative