Client

Compensation

Full Description

Sr Database Design Engineer Location: Rochester NY / REMOTE Full-Time Employment with CLIENT This position is remote eligible but candidates local to Rochester, NY are highly desirable. NOTE: If you are working remotely, you must be able to travel to Rochester, NY on as-needed basis (about once a quarter) . This role serves as the Subject Matter Expert for relational database design and tuning for Linux-based medical devices with on-device databases, with ongoing stewardship of the database architecture over the product lifecycl e. The successful candidate will own database schema design, query strategy, and cross-component data access patterns to ensure long-term maintainability, performance, and regulatory compliance. This is an opportunity to shape the data backbone of safety-critical systems that must operate reliably for years in the field, often without frequent upgrades or migratio ns. The Responsibilit ies This role will focus on the design and implementation of robust applications for distributed Linux-based software systems while leading efforts in database schema and integration. Candidates should demonstrate expertise in relational database design and on-device database integrat • ion.Serve as the database architecture owner for PostgreSQL or equivalent database instances embedded within medical devices running Linux on workstation-class hardw • are.Design relational schemas, views, indexes, and constraints that balance performance, maintainability, and regulatory traceabil • ity.Own and maintain the database design over time, including governance of schema changes, technical debt management, documentation, and coordination of design evolution across relea • ses.Act as the central design authority for how multiple software components read from and write to shared database resour • ces.Design database interfaces and usage patterns that minimize the need for future migrations, while still enabling safe, versioned evolution when requi • red.Lead query optimization and performance tuning, including execution plan analysis, indexing strategy, and long-term capacity plann • ing.Define standards for database versioning, migration strategy, and backward compatibility suitable for regulated, fielded syst • ems.Collaborate with system architects, middleware developers, and UI teams to ensure database access patterns are well-defined, testable, and sta • ble.Provide technical leadership in design reviews related to data modeling, persistence strategy, and cross-process communication via the datab • ase.Support backup, restore, and recovery strategies appropriate for on-device databases in production medical equipm • ent.Participate in requirements, architecture, design, verification, and validation activities within a regulated quality management system (FDA, IEC 62304, ISO 134 • 85).Perform other work-related duties as assig ned. Requir • ed :B.S. or M.S. Degree in Computer Science, Computer Engineering or a related discipline requ • ired.Minimum of 5 years required with bachelor's or 3 years with master's degree, preferably leading in a medical device environment or equivalent combination of education and experi • ence.Demonstrated expertise in designing and evolving relational schemas; optimizing queries through execution plan analysis; and defining indexing, view, and data-access layers that support multiple consu • mers.Experience supporting on-device or embedded databases, where the database runs locally on a deployed system rather than as a managed cloud ser • vice.Strong understanding of data evolution strategies, including migrations, versioned schemas, and backward compatibi • lity.Experience working in regulated or safety-critical environments (medical devices strongly prefer • red).Working knowledge of C++ or similar programming language sufficient to collaborate with application developers and review database interaction • code.Strong analytical skills and ability to reason about system-wide performance and data integrity trade • offs.Ability to travel 5% or less, domestic ally. Prefer • red :Experience tuning databases for non-cloud, appliance-style deploy • ments.Familiarity with Linux-based embedded or semi-embedded systems (Yocto, Ubuntu, or sim • ilar).Experience designing database schemas that support concurrent access by multiple services or proc • esses.Knowledge of database migration tools and strategies suitable for deployed products with limited upgrade wi • ndows.Prior experience executing database migrations (including planning, risk mitigation, validation, and rollback) and applying lessons learned to improve future migration prac • tices.Familiarity with scripting or automation (SQL, Python, Bash) for diagnostics, profiling, and maintenance to • oling.Understanding of observability concerns related to databases (logging, metrics, tra • cing).Experience collaborating across software, systems, quality, and regulatory teams.