Associate Database Systems Engineer

Alturas-Analytics,-Inc.-; Moscow (ID); On-site; USD 58,000 - 70,000; Full time

Benefits offered by this job

Health insurance

Dental & vision

Paid time off

401k with company match

Health Savings Account

Life insurance

Disability insurance

Employee assistance program

Volunteer time off

Monthly catered lunches

Career development

Job summary

Alturas Analytics, Inc. is seeking an Associate Database Systems Engineer to maintain and optimize our database systems, support custom applications and reporting, improve security, and collaborate on IT projects essential to keeping the organization running smoothly.

The role starts at $64,000 on-site in Moscow, Idaho, with DOE. The ideal candidate will work with Microsoft SQL Server and Oracle DB, gain exposure to regulatory compliance, and contribute to daily operations and project work

Qualifications

• Bachelor’s or Associate degree in Computer Science, MIS, Software Engineering or related fields; Associate with internship also considered.
• Experience with enterprise relational database systems such as Microsoft SQL Server and Oracle Database preferred.
• 1–2 years of professional experience in database administration, database development, software development, or related role.
• Equivalent combination of education, training and relevant experience may be considered.

Responsibilities

• Participates in planning, installing, configuring, maintaining, upgrading and migrating database server infrastructure.
• Assists with database performance monitoring and tuning to optimize application performance.
• Patches database backend periodically following established procedures.
• Participates in tests and implements database backup, restoration, and disaster recovery plans.
• Works with senior team members and internal end users to understand user requirements and develop custom applications, reports and queries.
• Participates in designing, testing and deploying databases to ensure normalization, performance optimization and regulatory compliance.
• Codes and tests applications and custom queries.
• Assists in releasing applications and queries for production per software lifecycle management processes.
• Helps maintain database security, access controls, and data integrity.

Skills

Verbal communication

Written communication

Database design

SQL proficiency

Database security

FDA 21 CFR Part 11 knowledge

Analytical thinking

Mentorship/learning

Education

Bachelor’s degree in CS / MIS / SE

Associate degree with internship experience

Tools

Toad

SSMS

SSIS

MS Access Jet SQL

Job description

Description

Love solving problems, working with databases, and learning new technology? Join our team as an Associate Database Systems Engineer! You'll help maintain and optimize our database systems, support custom applications and reporting, strengthen security, and collaborate on exciting IT projects that keep our organization running smoothly. If you're ready to grow your career with a great team, we'd love to hear from you.

Starting Salary: $64,000, DOE

This position is on-site only in Moscow, Idaho 83843.

Why Join Alturas Analytics?

Alturas Analytics, Inc. is a privately owned contract research organization specializing in bioanalytical services for pharmaceutical and biotechnology companies worldwide. Our work supports scientific research that advances the treatment and cure of disease. At Alturas, you'll join a collaborative, supportive team that values quality, encourages professional growth, and takes pride in making a meaningful impact. We're committed to creating an environment where employees feel valued, continue to learn, and have opportunities to grow their careers.

Benefits

• We pay 100% of your premiums for health, dental, and vision insurance and a portion of the premium for dependent coverage
• PTO, paid sick time and paid holidays
• Bonus program based on company-wide goals
• Safe Harbor 401k with an automatic 3% employer contribution with additional 1% match option
• Health Savings Account (HSA) (with company match) and Flexible Spending Account (FSA) options - including Dependent Care
• Life insurance and short- and long-term disability at no cost to you
• Employee Assistance Programs (EAP) focused on mental health
• Voluntary Life, AD&D, Critical Illness and Accident insurance

Perks

• Work-life balance
• Opportunities for continuous learning, professional development and promotion; tuition reimbursement
• Relaxed yet professional environment
• Wellness program including bike/walk to work incentive
• Charitable donation matching and paid time off for volunteering
• Monthly catered lunches, holiday celebrations, unlimited (good) coffee, beverages, snacks and more!

A Day in the Life

You’ll work with databases that support Alturas Analytics’ laboratory and business systems, helping troubleshoot issues, write and test SQL queries, develop internal applications, and maintain database performance and security. You’ll collaborate with senior IT team members and internal users to resolve technical challenges, support system updates, and ensure data remains accurate and reliable.

Essential Duties and Tasks:

• Participates in planning, installing, configuring, maintaining, upgrading and migrating database server infrastructure.
• Assists with database performance monitoring and tuning to optimize application performance.
• Patches database backend periodically following established procedures.
• Participates in tests and implements database backup, restoration, and disaster recovery plans.
• Works with senior team members and internal end users to understand user requirements and to develop custom applications, reports and queries for data export/import.
• Participates in designing, testing and deploying databases to ensure database normalization, performance optimization and regulatory compliance, under the guidance of senior team members.
• Codes and tests the application and custom queries.
• Assists in releasing applications and queries for production per Alturas software lifecycle management processes.
• Helps maintain database security, access controls, and data integrity.

Additional Duties and Tasks:

• Collaborates with validation personnel for application testing and validation activities.
• Participates in troubleshooting technical issues alongside senior team members and application, database, or software vendors.
• Performs other duties as needed or assigned.

Requirements

Education and Experience Requirements:

• Bachelor’s or Associate degree in Computer Science, Management Information System, Software Engineering or related fields. Associates degree with relevant internship or equivalent experience will also be considered
• Experience supporting enterprise relational database systems such as Microsoft SQL Server and Oracle Database is preferred.
• 1-2 years of professional experience in database administration, database development, software development or related role.
• Equivalent combination of education, training and relevant experience may be considered.

Skills and Abilities Requirements:

• Strong verbal and written communication skills
• Ability to gather and assist in analyzing and translating end user requirements into database designs and technical solutions.
• Strong knowledge in relational database architecture and database design principles.
• Experience with database backup, 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 of database connectivity technologies including ODBC, OLEDB and related platforms.
• 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, manage individual daily tasks, and a strong desire to learn and grow under technical mentorship.

Physical Requirements:

• Position requires sitting over 2/3 of the time
• Position requires working in front of a computer monitor over 2/3 of the time
• Position requires walking less than 1/3 of the time between departments/offices
• Position requires standing less than 1/3 of the time
• Position requires use of hands and manual dexterity up to 2/3 of the time
• Position requires talking or hearing less than 1/3 of the time
• Position requires lifting up to 50 lbs. less than 1/3 of the time

Life in the Palouse

Moscow, Idaho, offers a welcoming college-town atmosphere surrounded by the natural beauty of the Palouse. With walkable streets, local restaurants, live music, and abundant outdoor recreation, the area offers a great balance of community, culture, and outdoor adventure. Nearby Pullman, Washington, provides even more dining and entertainment options.

Community Involvement

At Alturas, we believe in building a company that supports both professional growth and community well-being. We are proud to support educational programs that inspire the next generation of scientists through activities such as science fairs, classroom outreach, and university-level engagement. We encourage our employees to make a positive impact both in the workplace and in the communities where they live.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.