Database Systems Engineer

Were hiring a skilled and detail-oriented Database Systems Engineer to join our Information Technology (IT) this role youll support and optimize Alturas Analytics laboratory and business systems by managing database infrastructure developing custom applications and queries and ensuring data performance security and reliability. Youll play an important role in maintaining efficient high-performing systems that enable our team to focus on delivering high-quality scientific work.

Starting salary: $95000 DOE

This position is on-site only in Moscow Idaho.

About Us

Alturas Analytics Inc. is a contract research organization bioanalytical laboratory providing personalized MS/MS bioanalytical services to the pharma and biotech industries worldwide. We are a growing privately owned company working with our collaborators to aid in the treatment and cure of disease.

Joining the Alturas team means becoming a part of a supportive and passionate community. Our staff consists of talented dedicated individuals who are committed to delivering the highest quality of service to our clients. Our goal is simple to ensure that Alturas employees thrive so that we can do the best possible work in our field ensuring greater care for our world.

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
• 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
• Safe Harbor 401k with an automatic 3% employer contribution
• Employee Assistance Programs focused on mental health
• Voluntary Life AD&D Critical Illness and Accident insurance

Perks

• Work-life balance
• Tuition reimbursement
• Opportunities for continuous learning professional development and promotion
• 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!

Position Summary:

The Database Systems Engineer supports the IT Department and reports to the Chief Information Officer. This role combines the responsibilities in both DBA (Database Administrator) and DB Dev (Database Developer) to support the companys laboratory and business systems. This position is responsible for the planning implementing configuring testing maintaining performance tuning backup/recovery and troubleshooting for database systems as well as developing in-house database applications and writing custom queries.

Essential Duties and Tasks:

• Plans and maintains database server infrastructure including hardware operating systems and database software.
• Installs configures and upgrades databases systems including but not limited to Microsoft SQL Server and Oracle Database.
• Performs data migrations and ensures compatibility with existing systems and applications.
• Performs database performance monitoring and tuning to optimize application performance.
• Patches database backend periodically.
• Creates tests and implements database backup restoration and disaster recovery plans.
• Works with internal end users to understand user requirements and to develop custom applications reports and queries for data export/import.
• Designs tests and deploys databases to ensure database normalization performance optimization and regulatory compliance.
• Codes and tests the application and custom queries with excellent understanding of good programming practices.
• Releases applications and queries for production per Alturas software lifecycle management processes.
• Maintains database security access controls and data integrity.
• Provides technical leadership and may supervise train and mentor database or IT staff as assigned.

Additional Duties and Tasks:

• Collaborates with validation personnel for application testing and validation activities.
• Works with application database and software vendors to troubleshoot and resolve technical issues.
• Performs other duties as needed or assigned.

Education and Experience Requirements:

• Bachelors or Associate degree in Computer Science Management Information System Software Engineering or related fields.
• Experience supporting enterprise relational database systems such as Microsoft SQL Server and Oracle Database is preferred.
• Minimum of 4 years of work experience in database administration database development or related role.
• Equivalent combination of education training and relevant experience may be considered.

Skills and Abilities Requirements:

• Excellent verbal and written communication skills.
• Ability to analyze and translate end user requirements into database designs and technical solutions.
• Advanced knowledge in relational database architecture and database design principles.
• Experience with database backup disaster recovery strategies including transaction logs and point-in-time recovery.
• Proficient in Microsoft SQL Server T-SQL and Oracle SQL and PL/SQL.
• Proficient in Microsoft Access Jet SQL and VBA/VB.
• Experience with database administration tools such as Toad SSMS SSIS or similar platforms.
• Advanced knowledge with database connectivity technologies including ODBC OLEDB and related platforms.
• Understanding of regulated data environments and FDA regulatory requirements such as 21 CFR Part 11 GLP and GCP is preferred (training provided).
• Ability to work independently and manage multiple priorities.

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

About the Area

Located in a vibrant town and home to the University of Idaho Moscow Idaho is a friendly community with beautiful natural surroundings and a lively cultural scene. Youll enjoy walkable streets live music and access to some of the best outdoor recreation opportunities in the country. The Palouse area is made up of several neighboring towns including Pullman Washington where youll find a bustling college town environment with diverse dining options events for everyone and the Washington State University campus.

Community Involvement

Our goal is to build an enduring company of integrity in an environment that provides rewarding career paths and empowers individuals to engage in the well-being of the communities in which they reside. We seek to inspire the next generation of scientists through involvement of educational programs at every level. From making science fun for elementary-aged students active participation in science fairs and guest lecturing at the undergraduate university level we are stepping towards fostering a generation where science is exciting and an integral component of everyday life.

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.