Associate Database Systems Engineer

Alturas Analytics•Moscow, ID

11h•Onsite

About The Position

The Associate Database Systems Engineer helps maintain and optimize database systems supporting Alturas Analytics’ laboratory and business systems. The role involves troubleshooting issues, writing and testing SQL queries, developing internal applications and reports, and helping maintain database performance, security, accuracy, and reliability. The engineer works with senior IT team members, internal users, validation personnel, and application, database, or software vendors to address technical challenges and support system updates. This is an on-site position in Moscow, Idaho. The starting salary is $64,000, DOE. Alturas Analytics is a privately owned contract research organization providing bioanalytical services to pharmaceutical and biotechnology companies. The company describes its environment as collaborative and supportive, with an emphasis on quality, professional growth, learning, and work that supports scientific research.

Requirements

Bachelor’s or associate degree in Computer Science, Management Information System, Software Engineering, or a related field; an associate degree with relevant internship or equivalent experience will also be considered.
One to two years of professional experience in database administration, database development, software development, or a related role; an equivalent combination of education, training, and relevant experience may be considered.
Strong verbal and written communication skills.
Ability to gather and help analyze and translate end-user requirements into database designs and technical solutions.
Strong 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.
Academic exposure or foundational knowledge in Microsoft SQL Server T-SQL and Oracle SQL and PL/SQL.
Academic exposure to or experience in Microsoft Access Jet SQL and VBA/VB.
Familiarity with database administration tools such as Toad, SSMS, SSIS, or similar platforms.
Familiarity with database connectivity technologies including ODBC and OLEDB.
Ability to follow instructions, manage individual daily tasks, and learn and grow under technical mentorship.
Ability to sit and work in front of a computer monitor for over two-thirds of the time; walk and stand for less than one-third of the time; use hands and manual dexterity for up to two-thirds of the time; talk or hear for less than one-third 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 is preferred.
Willingness to learn FDA regulatory requirements such as 21 CFR Part 11, GLP, and GCP; on-the-job training will be provided.

Responsibilities

Participate in planning, installing, configuring, maintaining, upgrading, and migrating database server infrastructure.
Assist with database performance monitoring and tuning to optimize application performance.
Periodically patch database backends according to established procedures.
Participate in testing and implementing database backup, restoration, and disaster recovery plans.
Work with senior team members and internal end users to understand requirements and develop custom applications, reports, and queries for data export and import.
Participate, under senior team members’ guidance, in designing, testing, and deploying databases for normalization, performance, and regulatory compliance.
Code and test applications and custom queries.
Assist with releasing applications and queries to production under Alturas software lifecycle management processes.
Help maintain database security, access controls, and data integrity.
Collaborate with validation personnel on application testing and validation activities.
Help troubleshoot technical issues with senior team members and application, database, or software vendors.
Perform other duties as needed or assigned.

Benefits

100% of employee premiums paid for health, dental, and vision insurance, plus a portion of dependent coverage premiums.
PTO, paid sick time, and paid holidays.
Bonus program based on company-wide goals.
Safe Harbor 401(k) with an 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.
Work-life balance.
Continuous learning, professional development, promotion opportunities, and 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.