***Please apply directly on the RCUH website to be considered for the position.***

**JUNIOR DATABASE PROGRAMMER** **- ID#** **225255.**

CLOSING DATE: June 2, 2025

, or until filled. Applications received after this deadline may be considered only if the position is not filled or up to the date a selection has been approved by the RCUH (whichever comes first)

INQUIRIES: Masayo Nakajima 808-895-7385 (Hawaii).

Regular, Full-Time, RCUH Non-Civil Service position with National Astronomical Observatory of Japan, Subaru Telescope Project, located in Hilo, Hawaii. Continuation of employment is dependent upon program/operational needs, satisfactory work performance, availability of funds, and compliance with applicable Federal/State laws.

• MONTHLY SALARY:** $3,690/Mon
  
  

Duties

Performs daily operation and maintenance of Observers Proposals Allocations (OPAL) database system, which is used for managing Subaru Telescope Network and Subaru Telescope Archive System (STARS) Lightweight Directory Access Protocols (LDAPs), summit work planning and logging, Subaru vehicle reservations, handling observation and telescope setup schedules, fault tracking system (FATS) for night operations, and other functions necessary to operate Subaru Telescope. Drives to project sites. Performs database programming on OPAL. Keeps its data integrity and security of OPAL. Performs statistical analysis of the data in OPAL as requested to improve the operations of Subaru Telescope. Performs operation, maintenance and database programming on STARS and Mitaka-STARS (MSTARS) in collaboration with staff in Astronomical Data Center (ADC) at Mitaka, NAOJ in order to provide observers with the astronomical data obtained with Subaru Telescope timely and securely. Maintains data compatibility between STARS and MASTARS database. Maintains consistent FITS header of STARS data. Writes operation manuals and facts or troubles report based on daily actions and prepare FAQ for users in html documents corresponding to those manuals. Able to understand both systems as a whole and develop new skills in database management. Expected to understand database systems from a technical viewpoint, as well as the astronomical viewpoint. Contacts with visiting astronomers and Subaru staff for improving the GUIs of the data access, and detailed programming of the database management systems.

Primary Qualifications

**EDUCATION**

Bachelor's Degree from an accredited four (4) year college or university in Computer Science or related science/engineering field, or an equivalent level based on a combination of training/specialized experience that sufficiently enables individual to perform job duties.

**EXPERIENCE**

Up to one (0-1) year of experience on maintenance, operation, and programming on database management system (DBMS).

**KNOWLEDGE**

Knowledge of relational DBMS (e.g., MariaDB) and database language, SQL. Knowledge of programming languages for database handling (Python and shell scripts). Knowledges of at least two (2) of the following five (5) items are necessary; (1) web servers (e.g., Apache, CGI, HTML), (2) FITS (Flexible Image Transport System) for astronomical data, (3) programming languages other than the above (e.g., Java, C, PHP, JavaScript), (4) UNIX (Linux) operating system, (5) network routing including firewall in wide area network configuration.

**ABILITIES and SKILLS**

Ability to handle relational DBMS and SQL. Ability and skills on at least two (2) of the following six (6) items are necessary: (1) web application development with SQL databases, (2) web server management (install and configuration), (3) database management (e.g., import/export data, replication), (4) programming with C, Java, PHP, or JavaScript, (5) install and configure Linux operating system, (6) installing software necessary for database handling in communication with STARS/MASTARS to personal computers, either Linux OS, Windows OS, and Mac oper ting system. Ability to operate and improve database systems through close communications with their users, developers and managers of Subaru Telescope. Must possess thinking to prioritize tasks. Must have strong writing and technical skills to write documents and technical users guides. Effective communication skills. Must have high aptitude for learning new skills to operate, improve and upgrade DBMS. Must possess a valid drivers license (and if use of personal vehicle on the job is required, must also have valid personal drivers insurance equivalent to Hawaiis No-Fault Drivers Insurance) and maintain throughout the duration of employment. Must be able to drive a 4-wheel drive vehicle with automatic transmission.