Associate Database Systems Engineer

Alturas Analytics, Inc.•Moscow, ID

1d•Onsite

About The Position

Alturas Analytics is hiring an Associate Database Systems Engineer to help maintain and optimize database systems that support its laboratory and business operations. The role supports custom applications and reporting, database security and performance, and IT projects. The engineer works with senior IT team members and internal users to troubleshoot issues, write and test SQL queries, develop internal applications, support system updates, and help maintain accurate and reliable data. The position is on-site in Moscow, Idaho. Starting salary is $64,000, depending on experience.

Requirements

Bachelor’s or associate degree in Computer Science, Management Information Systems, Software Engineering, or a related field; an associate degree with a relevant internship or equivalent experience may also be considered.
One to two years of professional experience in database administration, database development, software development, or a related role.
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 with 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.
Willingness to learn FDA regulatory requirements such as 21 CFR Part 11, GLP, and GCP; on-the-job training will be provided.
Ability to follow instructions and manage individual daily tasks, with a strong desire to learn and grow under technical mentorship.

Nice To Haves

Experience supporting enterprise relational database systems such as Microsoft SQL Server and Oracle Database is preferred.
Equivalent combinations of education, training, and relevant experience may be considered.

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 following 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 data export/import queries.
Participate in designing, testing, and deploying databases for normalization, performance, and regulatory compliance, with guidance from senior team members.
Code and test applications and custom queries.
Assist with releasing applications and queries to production according to software lifecycle management processes.
Help maintain database security, access controls, and data integrity.
Collaborate with validation personnel on application testing and validation activities.
Troubleshoot technical issues alongside senior team members and application, database, or software vendors.
Perform other duties as needed or assigned.

Benefits

Company pays 100% of employee premiums for health, dental, and vision insurance, and a portion of dependent coverage premiums.
Paid time off, 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 employees.
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.