What You Will Do Come join the best and brightest minds in the world at one of the most innovative and creative multidisciplinary research institutions engaged in strategic science on behalf of national security. As part of the Associate Lab Directorate of Weapons Production (ALDWP), the work we do in Production Support Services Division (PSS) directly affects mission success across Los Alamos National Laboratory.
As a Computing Systems Professional 3 for the Online Collaboration and Infrastructure team, you will serve as the SQL Server Database Administrator (DBA) for a multi environment of SQL databases. The DBA will be responsible for the configuration and maintenance of ALDWP's unclassified and classified SQL Databases, to include installation and configuration, database provisioning, maintaining servers and backups, database tuning and monitoring, securing data and access to the SQL Servers and/or databases. As the DBA, you will support the System Administrators and Software Systems Development Team in PSS-1. This work will be performed in a fast-paced environment with the potential for growth in the areas of providing tailored solutions in direct support of specific programmatic needs and mission milestones. Furthermore, be an active participant on a Scrum Team supporting multiple Commercial off the Shelf Software (COTS) and Microsoft IIS websites in an Agile environment. Working on a team, the successful candidate will perform the full spectrum of database administration, including but not limited to the following:
Computing Systems Professional 3 ($99,200 - $164,100) - SQL Database Administration for the unclassified and classified networks.
- Design, develop, modify, test, debug and evaluate SQL databases, tables, queries and permissions to meet functional requirements for functional areas.
- Database structuring and scripting.
- Work with System Administrators and the Software Systems Development Scrum Team to design servers and databases to desired and compliant specifications.
- Develop and maintain database server architecture and reporting processes.
- Mentoring and supporting fellow junior team members.
- Maintain SQL Servers to compliance and insure compatibility with current COTS and Microsoft IIS website environments.
- Configure and maintain Always on Availability Groups and disaster recovery solutions.
What You Need Minimum Job Requirements: - Extensive knowledge and experience in database installations, configurations, and upgrades.
- Strong knowledge of SQL, SQL Server tools, database architecture, normalization, and indexing.
- In-depth understanding and demonstrated experience in database security, backup and recovery, implementing disaster recovery plans, performance monitoring requirements, performance tuning, and optimize queries for maximum efficiency and operations.
- Demonstrated knowledge of Windows Server 2016 and 2019 operating systems, system architectures, network infrastructures, client-server principles, Active Directory and Powershell.
- Experienced in the implementation and maintenance of database security policies and procedures and applying security best practices.
- Demonstrated experienced in database accuracy, testing, data validation, data comparison and data auditing tools.
- Experienced troubleshooting complex technical database problems, examining probable root cause of an issue until a problem's ultimate cause or solution is found.
- Ability to translate technical terms to layperson's terms and present them to non-technical audiences.
- Ability to lead translation of business requirements to technical solutions.
- Excellent collaboration and communications skills with internal and external organizations, defining expectations, mutual responsibilities, and recognizing when software modifications are appropriate as a solution to existing problems.
Education: Computing Systems Professional 3 Position requires a Bachelor's Degree and 8 years related experience; or, an equivalent combination of education and experience directly related to the occupation. At this level, applicable advanced vendor and/or professional certification is desirable.
Clearance: This position requires the ability to obtain a DOE Q clearance, which typically requires US citizenship.
Desired Qualifications: - Experience administrating PostgreSQL or Oracle Database Management Systems.
- Experience working in a Jira or Azure DevOps environment.
- Experience working in a Scrum Team environment.
- Experience in C# or Java
Work Environment: Work Location: The work location for this position is hybrid and is located in Los Alamos, New Mexico. Hybrid is defined as working partially onsite/partially offsite but within 2 hours ground commute of this location. All work locations are at the discretion of management and can change at any time with appropriate notice.
Position commitment: Regular appointment employees are required to serve a period of continuous service in their current position in order to be eligible to apply for posted jobs throughout the Laboratory. If an employee has not served the time required, they may only apply for Laboratory jobs with the documented approval of their Division Leader. The position commitment for this position is 2 years.
Note to Applicants: Please provide a comprehensive resume that details how you meet the qualifications for the position.
Where You Will Work Located in beautiful northern New Mexico, Los Alamos National Laboratory (LANL) is a multidisciplinary research institution engaged in strategic science on behalf of national security. Our generous benefits package includes:
PPO or High Deductible medical insurance with the same large nationwide network
Dental and vision insurance
Free basic life and disability insurance
Paid childbirth and parental leave
Award-winning 401(k) (6% matching plus 3.5% annually)
Learning opportunities and tuition assistance
Flexible schedules and time off (PTO and holidays)
Onsite gyms and wellness programs
Extensive relocation packages (outside a 50 mile radius)
Additional Details Directive 206.2 - Employment with Triad requires a favorable decision by NNSA indicating employee is suitable under NNSA Supplemental Directive 206.2. Please note that this requirement applies only to citizens of the United States. Foreign nationals are subject to a similar requirement under DOE Order 142.3A.
Clearance: Q (Position will be cleared to this level). Selected applicants will be subject to a background investigation conducted by or on behalf of the Federal Government, and must meet eligibility requirements* for access to classified matter. This position requires a Q clearance. and obtaining such clearance requires US Citizenship except in extremely rare circumstances. Dependent upon the position, additional authorization to access classified information may be required, which may or may not be available to dual citizens. Receipt of a Q clearance and additional access authorization ultimately is a decision of the Federal Government and not of Triad.
- Eligibility requirements: To obtain a clearance, an individual must be at least 18 years of age; U.S. citizenship is required except in very limited circumstances. See DOE Order 472.2 for additional information.
New-Employment Drug Test: The Laboratory requires successful applicants to complete a new-employment drug test and maintains a substance abuse policy that includes random drug testing. Although New Mexico and other states have legalized the use of marijuana, use and possession of marijuana remain illegal under federal law. A positive drug test for marijuana will result in termination of employment, even if the use was pre-offer.
Regular position: Term status Laboratory employees applying for regular-status positions are converted to regular status.
Internal Applicants: Regular appointment employees who have served the required period of continuous service in their current position are eligible to apply for posted jobs throughout the Laboratory. If an employee has not served the required period of continuous service, they may only apply for Laboratory jobs with the documented approval of their Division Leader. Please refer to Policy Policy P701 for applicant eligibility requirements.
Equal Opportunity: Los Alamos National Laboratory is an equal opportunity employer and supports a diverse and inclusive workforce. All employment practices are based on qualification and merit, without regard to race, color, national origin, ancestry, religion, age, sex, gender identity, sexual orientation, marital status or spousal affiliation, physical or mental disability, medical conditions, pregnancy, status as a protected veteran, genetic information, or citizenship within the limits imposed by federal laws and regulations. The Laboratory is also committed to making our workplace accessible to individuals with disabilities and will provide reasonable accommodations, upon request, for individuals to par
Los Alamos National Laboratory
