We have an opening for a Senior Database Administrator. You will support the database administration activities required to manage the database infrastructure that underpin multiple program applications. This position is in the Enterprise Infrastructure Services (EIS) Division within the Computing Directorate, supporting the Livermore Information Technology (LivIT) and NNSA programs.
Business needs dictate that this position requires an on-site presence multiple days a week. Therefore, telecommuting options will be limited.
You will
- Support our internal transition towards data virtualization and data analytics by leveraging tools such as Denodo, Databricks etc., to help decouple applications from data layer integrations in and across the environment.
- Provide database administration support to our current suite of Oracle, MySQL, MS SQL Server, Mongo, Casandra, PostgreSQL, and DynamoDB databases.
- Provide technical, in-depth analysis on overall database management system designs and architectures and provide guidance and expertise in supporting our database services migration to leveraging cloud-based database PaaS services, containerization, and migration from existing Oracle database technology into other competing database technologies.
- Support development staff by creating and maintaining current, non-production database environments to support development and quality assurance activities, while also encouraging proper utilization of database features to better meet application and business process needs and helping to tune and rewrite query logic to access underlying data structures more efficiently.
- Review and help optimize database data models within and across the various databases we support and help maintain/enhance our database cyber security posture.
- Support enterprise COTs application implementation, configuration, triage, and customization efforts, and resolve issues introduced by our infrastructure patching and security efforts.
- Assist in the design, implementation and maintenance of database access through account management, object authorization, authentication mechanisms, data encryption, and protocol encryption.
- Perform other duties as assigned.
- Ability to obtain and maintain a US DOE Q-level security clearance which requires U.S. Citizenship.
- Bachelor’s degree in Computer Science, Software Engineering, Management Information Systems, or a related field, or the equivalent combination of education and experience.
- Significant prior experience in leveraging automation and orchestration to build, provision, patch, and/or secure database services within a production environment.
- Significant hands-on experience utilizing data virtualization and analytics platforms such as Denodo, Databricks, Apache Spark, or AWS Glue for building scalable data pipelines, integrating diverse data sources, and enabling advanced data engineering solutions.
- Advanced background in administering application servers such as WebLogic and Tomcat, including installation, configuration, patching, deployment, performance tuning, and troubleshooting
- Multi-year applied experience in administering Oracle, MS SQL Server, PostgreSQL, My-SQL databases in a production environment and significant experience with one or more development tools and languages, such as SQL, Oracle Forms/Reports, PL/SQL, Java, Python.
- Significant applied experience in UNIX and Windows operating system administration, security, performance tuning, enterprise-class storage array usage and integration within a database environment, and database backup and recovery procedures, software, strategies, and verification methodologies.
- Significant hands-on experience utilizing observability and infrastructure monitoring tools, such as Oracle Enterprise Manager, Datadog, Grafana, SQL Server Management Studio, and/or Icinga, for proactive system monitoring, alert management and database administration.
- Advanced verbal and written communication skills necessary to effectively collaborate in a team environment, author technical and scientific reports and papers, and deliver scientific presentations.
- Ability to work outside normal business hours to provide support for production infrastructure patching, upgrades, testing, and the ability to work on-premises to support job duties.
Qualifications We Desire
- MS degree in Computer Science, Computer Engineering, or Management Information Systems and significant experience integrating and managing application authentication/authorization and identity management technologies with database and application infrastructures.
- Experience in the development and utilization of Ansible, SCCM, Python, and Unix/PowerShell Shell scripting for automation and orchestration of database and application infrastructures.
- Experience leveraging containerization to deliver database and mid-tier services to meet customer needs, and with managing database and application infrastructures within a highly secure and compliance-driven environment.
#LI-Hybrid
Position Information
This is a Career Indefinite position, open to Lab employees and external candidates.
Why Lawrence Livermore National Laboratory?
Security Clearance
This position requires a Department of Energy (DOE) Q-level clearance. If you are selected, we will initiate a Federal background investigation to determine if you meet eligibility requirements for access to classified information or matter. Also, all L or Q cleared employees are subject to random drug testing. Q-level clearance requires U.S. citizenship.
Pre-Employment Drug Test
External applicant(s) selected for this position must pass a post-offer, pre-employment drug test. This includes testing for use of marijuana as Federal Law applies to us as a Federal Contractor.
Wireless and Medical Devices
Per the Department of Energy (DOE), Lawrence Livermore National Laboratory must meet certain restrictions with the use and/or possession of mobile devices in Limited Areas. Depending on your job duties, you may be required to work in a Limited Area where you are not permitted to have a personal and/or laboratory mobile device in your possession. This includes, but not limited to cell phones, tablets, fitness devices, wireless headphones, and other Bluetooth/wireless enabled devices.
If you use a medical device, which pairs with a mobile device, you must still follow the rules concerning the mobile device in individual sections within Limited Areas. Sensitive Compartmented Information Facilities require separate approval. Hearing aids without wireless capabilities or wireless that has been disabled are allowed in Limited Areas, Secure Space and Transit/Buffer Space within buildings.
How to identify fake job advertisements
Please be aware of recruitment scams where people or entities are misusing the name of Lawrence Livermore National Laboratory (LLNL) to post fake job advertisements. LLNL never extends an offer without a personal interview and will never charge a fee for joining our company. All current job openings are displayed on the Career Page under “Find Your Job” of our website. If you have encountered a job posting or have been approached with a job offer that you suspect may be fraudulent, we strongly recommend you do not respond.
To learn more about recruitment scams: https://www.llnl.gov/sites/www/files/2023-05/LLNL-Job-Fraud-Statement-Updated-4.26.23.pdf
Equal Employment Opportunity
We are an equal opportunity employer that is committed to providing all with a work environment free of discrimination and harassment. All qualified applicants will receive consideration for employment without regard to race, color, religion, marital status, national origin, ancestry, sex, sexual orientation, gender identity, disability, medical condition, pregnancy, protected veteran status, age, citizenship, or any other characteristic protected by applicable laws.
Reasonable Accommodation
Our goal is to create an accessible and inclusive experience for all candidates applying and interviewing at the Laboratory. If you need a reasonable accommodation during the application or the recruiting process, please use our online form to submit a request.
California Privacy Notice
The California Consumer Privacy Act (CCPA) grants privacy rights to all California residents. The law also entitles job applicants, employees, and non-employee workers to be notified of what personal information LLNL collects and for what purpose. The Employee Privacy Notice can be accessed here.
