Database Systems Engineer

Alturas Analytics•Moscow, ID

13h•Onsite

About The Position

Alturas Analytics is hiring a Database Systems Engineer to support and optimize laboratory and business systems. The role manages database infrastructure, develops custom applications and queries, and helps ensure data performance, security, reliability, integrity, and regulatory compliance. The position is on-site in Moscow, Idaho, with a starting salary of $95,000+, depending on experience. The engineer works with internal teams and end users to understand business needs, address technical challenges, and maintain systems that support scientific work. The role may also provide technical leadership and supervise, train, or mentor database or IT staff as assigned.

Requirements

Bachelor’s or associate degree in Computer Science, Management Information System, Software Engineering, or a related field; an equivalent combination of education, training, and relevant experience may be considered.
At least 4 years of work experience in database administration, database development, or a related role.
Excellent verbal and written communication skills.
Ability to analyze and translate end-user requirements into database designs and technical solutions.
Advanced knowledge of relational database architecture and database design principles.
Experience with database backup and disaster recovery strategies, including transaction logs and point-in-time recovery.
Proficiency in Microsoft SQL Server T-SQL and Oracle SQL and PL/SQL.
Proficiency in Microsoft Access Jet SQL and VBA/VB.
Experience with database administration tools such as Toad, SSMS, SSIS, or similar platforms.
Advanced knowledge of database connectivity technologies, including ODBC, OLEDB, and related platforms.
Ability to work independently and manage multiple priorities.
Ability to sit and work in front of a computer monitor for more than two-thirds of the time; walk, stand, and talk or hear for less than one-third of the time; use hands and manual dexterity for up to two-thirds of the time; and lift up to 50 pounds for less than one-third of the time.

Nice To Haves

Experience supporting enterprise relational database systems such as Microsoft SQL Server and Oracle Database.
Understanding of regulated data environments and FDA requirements such as 21 CFR Part 11, GLP, and GCP; training may be provided.

Responsibilities

Plan and maintain database server infrastructure, including hardware, operating systems, and database software.
Install, configure, and upgrade database systems, including Microsoft SQL Server and Oracle Database.
Perform data migrations and ensure compatibility with existing systems and applications.
Monitor and tune database performance to optimize application performance.
Periodically patch database backends.
Create, test, and implement database backup, restoration, and disaster recovery plans.
Work with internal end users to understand requirements and develop custom applications, reports, and data export/import queries.
Design, test, and deploy databases for normalization, performance, and regulatory compliance.
Code and test applications and custom queries using good programming practices.
Release applications and queries to production in accordance with Alturas software lifecycle management processes.
Maintain database security, access controls, and data integrity.
Provide technical leadership and, as assigned, supervise, train, and mentor database or IT staff.
Collaborate with validation personnel on application testing and validation activities.
Work with application, database, and software vendors to troubleshoot and resolve technical issues.
Perform other duties as needed or assigned.

Benefits

100% of employee premiums paid for health, dental, and vision insurance, with a portion of dependent coverage premiums paid.
Paid time off, paid sick time, and paid holidays.
Bonus program based on company-wide goals.
Safe Harbor 401(k) with automatic 3% employer contribution and an additional 1% match option.
Health Savings Account with company match and Flexible Spending Account options, including Dependent Care.
Life insurance and short- and long-term disability coverage at no cost to the employee.
Employee Assistance Programs focused on mental health.
Voluntary life, AD&D, critical illness, and accident insurance.
Opportunities for continuous learning, professional development, and promotion.
Tuition reimbursement.
Wellness program, including a bike/walk-to-work incentive.
Charitable donation matching and paid time off for volunteering.
Monthly catered lunches, holiday celebrations, coffee, beverages, and snacks.