Apply on Employer Site

Lawrence Livermore National Laboratory · 5 hours ago

Senior Database Administrator

Livermore, CA

Full-time

Onsite

Senior Level

$176K/yr - $223K/yr

Lawrence Livermore National Laboratory (LLNL) is seeking a Senior Database Administrator to manage the database infrastructure for multiple program applications. The role involves supporting database administration activities, transitioning to data virtualization and analytics, and ensuring optimal database performance and security.

Information TechnologyMarket ResearchSecurity

Growth Opportunities

No H1B

Security Clearance Required

U.S. Citizen Only

Responsibilities

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

Qualification

Database AdministrationData VirtualizationCloud Database ServicesUNIX AdministrationOracle DatabaseSQL ServerPostgreSQLAutomation ToolsContainerizationCommunication SkillsTeam Collaboration

Required

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

Preferred

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