Lawrence Livermore National Laboratory
Senior Database Administrator
Lawrence Livermore National Laboratory, Livermore, California, United States, 94551
Company Description
Join us and make YOUR mark on the World!
Are you interested in joining some of the brightest talent in the world to strengthen the United States' security? Come join Lawrence Livermore National Laboratory (LLNL) where our employees apply their expertise to create solutions for BIG ideas that make our world a better place.
We are committed to a diverse and equitable workforce with an inclusive culture that values and celebrates the diversity of our people, talents, ideas, experiences, and perspectives. This is essential to innovation and creativity for continued success of the Laboratory's mission.
Pay Range:
$159,330 - $204,636 Annually
This is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting; pay will not be below any applicable local minimum wage. An employee's position within the salary range will be based on several factors including, but not limited to, specific competencies, relevant education, qualifications, certifications, experience, skills, seniority, geographic location, performance, and business or organizational needs.
Job Description
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. Contribute to the development and deployment of a DBaaS service within a newly created private cloud infrastructure to ensure security standards are maintained while providing a highly automated and orchestrated process for database creation through to operational and lifecycle management. In this role you will: Contribute to the development and deployment of a DBaaS service within a newly created private cloud infrastructure to ensure security standards are maintained while providing a highly automated and orchestrated process for database creation through to operational and lifecycle management. Support our internal transition towards data virtualization by leveraging the Denodo data virtualization toolset 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.
Qualifications
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 prior experience in leveraging data virtualization, ETL, web services, or data warehousing and reporting products to help decouple hard database data integration dependencies. Multi-year, applied experience in administering Oracle and MS SQL Server 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, Oracle ADF, JDeveloper, and/or Visual Basic. 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 prior experience in administering Oracle E-Business Suite (EBS), patching processes including ADOP and hot patching for minimal downtime. Applied experience in leveraging infrastructure monitoring and administration tools, such as Oracle Enterprise Manager, SQL Server Management Studio, SCOM and/or Icinga, to monitor and conduct alert escalation and database administration. 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 your 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. Experience/Knowledge in migration of Oracle databases 23ai Pluggable Databases (PDBs) as part of Oracle 23ai upgrade strategies, ensuring seamless consolidation of multiple databases into a single container database (CDB).
Additional Information
All your information will be kept confidential according to EEO guidelines. #smartjobs Position Information This is a Flexible Term appointment, which is for a definite period not to exceed six years.If final candidate is a Career Indefinite employee, Career Indefinite status may be maintained (should funding allow). Why Lawrence Livermore National Laboratory? Included in 2024 Best Places to Work by Glassdoor! FlexibleBenefits Package 401(k) Relocation Assistance Education Reimbursement Program Flexible schedules (*depending on project needs) Inclusion, Diversity, Equity and Accountability (IDEA) - visithttps://www.llnl.gov/diversity Our core beliefs - visithttps://www.llnl.gov/diversity/our-values Employee engagement - visithttps://www.llnl.gov/diversity/employee-engagement Security Clearance This position requires a Department of Energy (DOE) Q-level clearance.If you are selected, wewill initiate a Federal background investigation to determine if youmeet 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 useand/or possession ofmobile devices in Limited Areas. Depending on your job duties, you may be required to work in a Limited Area whereyou are not permitted to have a personal and/or laboratory mobile devicein your possession. This includes, but not limited to cell phones, tablets, fitness devices, wireless headphones, and other Bluetooth/wireless enabled devices. Ifyou useamedical device, whichpairs with a mobile device,you must still follow the rules concerningthe mobile device in individual sections within Limited Areas. Sensitive Compartmented Information Facilities requireseparate 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. We invite you to review the Equal Employment Opportunity posters which include EEO is the Law and Pay Transparency Nondiscrimination Provision. 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. CaliforniaPrivacy Notice The California Consumer Privacy Act (CCPA) grants privacy rights to all California residents. The law also entitlesjob 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.
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. Contribute to the development and deployment of a DBaaS service within a newly created private cloud infrastructure to ensure security standards are maintained while providing a highly automated and orchestrated process for database creation through to operational and lifecycle management. In this role you will: Contribute to the development and deployment of a DBaaS service within a newly created private cloud infrastructure to ensure security standards are maintained while providing a highly automated and orchestrated process for database creation through to operational and lifecycle management. Support our internal transition towards data virtualization by leveraging the Denodo data virtualization toolset 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.
Qualifications
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 prior experience in leveraging data virtualization, ETL, web services, or data warehousing and reporting products to help decouple hard database data integration dependencies. Multi-year, applied experience in administering Oracle and MS SQL Server 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, Oracle ADF, JDeveloper, and/or Visual Basic. 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 prior experience in administering Oracle E-Business Suite (EBS), patching processes including ADOP and hot patching for minimal downtime. Applied experience in leveraging infrastructure monitoring and administration tools, such as Oracle Enterprise Manager, SQL Server Management Studio, SCOM and/or Icinga, to monitor and conduct alert escalation and database administration. 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 your 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. Experience/Knowledge in migration of Oracle databases 23ai Pluggable Databases (PDBs) as part of Oracle 23ai upgrade strategies, ensuring seamless consolidation of multiple databases into a single container database (CDB).
Additional Information
All your information will be kept confidential according to EEO guidelines. #smartjobs Position Information This is a Flexible Term appointment, which is for a definite period not to exceed six years.If final candidate is a Career Indefinite employee, Career Indefinite status may be maintained (should funding allow). Why Lawrence Livermore National Laboratory? Included in 2024 Best Places to Work by Glassdoor! FlexibleBenefits Package 401(k) Relocation Assistance Education Reimbursement Program Flexible schedules (*depending on project needs) Inclusion, Diversity, Equity and Accountability (IDEA) - visithttps://www.llnl.gov/diversity Our core beliefs - visithttps://www.llnl.gov/diversity/our-values Employee engagement - visithttps://www.llnl.gov/diversity/employee-engagement Security Clearance This position requires a Department of Energy (DOE) Q-level clearance.If you are selected, wewill initiate a Federal background investigation to determine if youmeet 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 useand/or possession ofmobile devices in Limited Areas. Depending on your job duties, you may be required to work in a Limited Area whereyou are not permitted to have a personal and/or laboratory mobile devicein your possession. This includes, but not limited to cell phones, tablets, fitness devices, wireless headphones, and other Bluetooth/wireless enabled devices. Ifyou useamedical device, whichpairs with a mobile device,you must still follow the rules concerningthe mobile device in individual sections within Limited Areas. Sensitive Compartmented Information Facilities requireseparate 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. We invite you to review the Equal Employment Opportunity posters which include EEO is the Law and Pay Transparency Nondiscrimination Provision. 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. CaliforniaPrivacy Notice The California Consumer Privacy Act (CCPA) grants privacy rights to all California residents. The law also entitlesjob 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.