SQL Database Administrator/Developer
Idaho National Laboratory
Idaho National Laboratory's (INL) Enterprise Support group is seeking forward-thinking professionals interested in exploring a career as a SQL Database Administrator/Developer! This team works a hybrid 9x80 schedule located at our Idaho Falls facility with every other Friday off.
- Provide technical expertise and oversight for the INL Identity Management System (IDMS) known as SAFE and serves as the system administrator and vendor coordinator for Personnel Security relationships within this system.
- Build relationships throughout the INL complex to assist with problem solving.
- Serve as the spokesperson and act as the technical point of contact for this business application. Coordinate day-to-day collaboration with developers to ensure reliability, functional and operability of key business system.
- Ensure all associated hardware is functioning to issue the Homeland Security Presidential Directive (HSPD) 12, Local Site Badges, Protective Force Weapons Cards, and Visitor Management credentials at all three Badging offices.
- Provide technical expertise and oversight as a system administrator of the SAFE database
- Write and understand complex queries for validating and modifying data stored within a relational database
- Coordinate with vendor to include upgrades, enhancements, solve and coordination with internal technical staff for integration of data with other applications via APIs, SSIS and other mechanisms.
- Identify, research, and participate in the resolution of complex problems and recommend path forward for system upgrades and fixes.
- Monitor the day-to-day operational activities of support personnel and programmers and solve problems, ensure their resolution and timely communication.
- Enhance and maintain Personnel Security information systems/data bases and implement new system applications,
- Provide technical requirements to customers which includes analysis, design, program enhancements, installations, and application software testing and deployment for Personnel Security databases,
- Perform as IDMS Administrator. Function as the main point of contact between management, vendor, and technical support to ensure that new and ongoing software enhancements are consistent with business applications. Evaluate work processes and user requests to develop software solutions that create process improvements.
- Develop and maintain user access controls and subsequent documentation.
- Collaborate with Information Management on integration of security systems to information management systems including the enrollment certificate authority, electronic directory services, common data store, training, and other systems at the INL. Maintain the service that works with ARGUS for physical access.
- Identify and deliver training for backup system administrator for the purpose of continuity of Personnel Security operations.
- Current database is written in Oracle language; this individual will help migrate to SQL Server.
- deploy SAFE generated reports to the various organizations,
- Conduct complex SQL reporting for management and assessments,
- Establish and maintain reporting/monitoring of established requirement thresholds as set by DOE.
- Procure the equipment or materials to test and maintain the SAFE environment.
- Perform special projects as needed, which may include detailed research and data/cost analysis, report writing, subcontract development, and developing/recommending alternative resolutions to management.
- Bachelor's degree and 5 years' experience or MS and 3 years of experience required OR 13 years education/experience in lieu of a bachelor's degree.
- This position requires the ability to obtain and maintain a Department of Energy "Q" clearance, which requires US Citizenship.
- Ability to maintain/protect confidentiality of sensitive information.
- Solid understanding of general business and specialized Personnel Security fields.
- Ability to develop solutions to significant problems and recommend techniques to meet company/customer initiatives.
- Computer systems administration, applications, access controls, and separations of duties within database functionality permissions.
- Good interpersonal skills and the ability to handle stressful situations is vital!
- Ideal computer skills for this role include the ability to work within a complex database including writing SQL queries, monitoring, and solve the servers, and working with our outside vendor for patching, updates, upgrades, etc.
- Excellent customer communication skills, senior mentoring skills, and results oriented management.
- Sound judgment and decision making is a constant requirement to achieve results.
- Must be able to prioritize activities and resolve complex resource and budget problems.
- Must be self-motivated and able to take the lead for timely resolution of issues.
- Experience with HID SAFE application is recommended but not required.
- Salary Grade 210 ($91,032 - $150,156)
- Chosen applicants are required to show a demonstrated commitment to valuing diversity and contributing to an inclusive working environment.
- TDP: Testing designated position; you will be required to submit to a pre-employment drug screen and periodic drug testing throughout the term of your employment.
INL is a science-based, applied engineering national laboratory dedicated to supporting the U.S. Department of Energy's mission in nuclear energy research, science, and national defense. With more than 5,000 scientists, researchers, and support staff, the laboratory works with national and international governments, universities, and industry partners to discover new science and development technologies that underpin the nation's nuclear and renewable energy, national security, and environmental missions.
Our mission is to discover, demonstrate and secure innovative nuclear energy solutions, other clean energy options and critical infrastructure.
Our vision is to change the world's energy future and secure our nation's critical infrastructure.
Selective Service Requirements:
To be eligible for employment at INL men born after December 31, 1959, must have registered with the Selective Service System (SSS). For more information see www.sss.gov.
Equal Employment Opportunity:
INL is an Equal Employment Opportunity (EEO) employer. It is the policy of INL to provide EEO to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information. Women and People of Color are strongly encouraged to apply.
We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
When applying to positions please provide your resume and answer all questions on the following screens. Applicants, who fail to provide a resume or answer the questions, may be deemed ineligible for consideration.
INL does not accept resumes from third party vendors unsolicited.
Benefits & Salary:
We have an extremely competitive salary structure, robust relocation package, and a phenomenal benefits package. For more information, please visit: https://www.inl.gov/careers/benefits-overview
About this Employer
Part of the U.S. Dept. of Energy’s complex of national laboratories, INL performs work in each of the strategic goal areas: energy, national security, science & environment. INL is the nation’s leading center for nuclear energy research & development.