Database Systems Engineer

This job was posted by https://idahoworks.gov : For more information, please see: https://idahoworks.gov/jobs/2632230 Were hiring a skilled and detail-oriented Database Systems Engineer to join our Information Technology (IT) team. In 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: $95,000+, DOE This position is on-site only in Moscow, Idaho. 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. ### A Day in the Life Youll manage and optimize the database systems that support Alturas Analytics laboratory and business operations, overseeing database configuration, upgrades, migrations, performance tuning, backups, and security. Youll also design and develop database applications, write custom queries, and collaborate with internal teams to meet business needs and resolve technical challenges. Additionally, youll help ensure system reliability, data integrity, and regulatory compliance while providing technical guidance and support to team members as needed. 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.