Database Engineer (Data Analytics)

Job Description 

• Design, develop and maintain database systems for Unmanned Air Systems (UAS) and their sub-systems. 

• Design, develop and maintain database-application interfaces between: 

  • UAS and its sub-systems 

  • Data/video analytics applications 

• Develop database modules and prototype applications according to system requirements. 

• Perform fault diagnosis, emergency response, analysis and resolve database performance issues while accurately identifying root causes in a timely manner. 

• Optimize SQL by providing suggestions for improvement and optimization of problematic SQL queries to application developers. 

• Implement and enforce security for deployed database systems. 

• Assist in development of interfaces between ground control systems and machine learning models. 

• Work with other members in Data Analytics group (DAG) to support projects. 

• Maintain and update related technical documentation (DB Policies, procedures and standards, architecture etc). 

• Assist in selecting, configuring and installing the following based on project database requirements: 

  • Edge computing devices 

  • Workstations / servers 

  • Relational database management systems (RDBMS) and related tools 

• Participate in flight tests or demonstrations for model evaluation. 

Requirements

• Experience in relational database design and development. 

• Experience in using and deploying MS SQL Server, MongoDB, MySQL, PostgreSQL or Oracle. 

• Experience in database application/library development in C#, C++ or Python. Please state preferred programming language if none of the above. 

• Proficiency in Structured Query Language (SQL) is required. 

• Strong problem solving, analytical and conceptual skills, with good communication skills. 

• A good team player who can work independently with minimum guidance and monitoring. 

• Able to travel overseas (short-term) 

• Preferable: 

  • Experience in embedded platforms (e.g. Nvidia Jetson, Intel UP Squared) 

  • Experience in porting flat tables (e.g. spreadsheets or JIRA) or unstructured data (e.g. aircraft data or imagery) into RDBMS 

  • Experience in Linux-based operating systems such as Ubuntu or RedHat 

  • Knowledge in various data-interchange formats (e.g. JSON) and concepts (e.g. KLV, data payload) 

  • Knowledge in UAS is preferable but not required 
  • Experience in providing database solutions for data/video analytics highly preferred