Solutions Architect

We are seeking an experienced IT Database Architect / Administrator (job title: Solutions Architect) to join our dynamic, multi-disciplinary 24/7/365 Mission Support Operations Center team. You will be responsible for the design, implementation, maintenance, and security of our database systems. You will work closely with application developers, system architects, and other IT staff to ensure optimal database performance and reliability. This role requires a deep understanding of database technologies, strong problem-solving skills, and the ability to manage multiple projects simultaneously. In this position you will be supporting the daily operations of complex mission critical capabilities and providing cross discipline expertise and perspective to the entire IT team. Additionally, you will continually evaluate new technologies/approaches and make strategic design recommendations.

On any given day you may be called on to:

Design, install, configure, and maintain database management systems (DBMS) such as Oracle, Cassandra, SQL Server, MySQL, or PostgreSQL (or other similar technologies)

Monitor database performance, troubleshoot issues, and implement performance tuning measures (SolarWinds, Splunk, and/or similar type technologies)

Ensure data integrity, security, and availability through effective backup and recovery strategies

Collaborate with development teams to optimize database queries and improve application performance

Develop and maintain database documentation, including data models, schemas, and procedures

Implement and manage database security policies and access controls

Participate in capacity planning and database scaling efforts to accommodate growth

Stay current with industry trends and emerging technologies related to database management

Due to the nature of the work, the selected applicant must be able to work 100% onsite in Livermore, CA.

This position requires willingness and ability to work in a 24/7/365 on-call operational environment.

Qualifications we Require:

13 years of directly related experience; or Associate's degree in Computer Science, Information Technology, or related discipline and 9 years of directly related experience; or Bachelor's degree in related discipline and 5 years of directly related experience. Equivalent experience in lieu of degree must be directly related experience that demonstrates the knowledge, skills, and ability to perform the duties of the job

Experience with SQL (or equivalent) such as performance tuning and query optimization

Ability to obtain and maintain CompTIA Security + certification

Ability to obtain and maintain a DOE Q-level and SCI-level security clearance, which may require a polygraph test

Qualifications we Desire:

Install, configure, maintain, monitor and troubleshoot Netapp storage systems, HP Blade systems (including chassis, blades and switches), VMWare vSphere and Oracle Linux hosts

Familiarity with other IT technologies (Windows, Oracle Linux/RedHat)

Familiarity with database security practices and compliance standards

Experience with database backup and recovery strategies, including disaster recovery planning

Prior experience working on classified, government systems

Maintain custom applications in Oracle Application Express (APEX)

Excellent problem-solving skills and the ability to work independently and as part of a team

Strong communication skills, both verbal and written

About Our Team:

The Special Programs Operations (SPO) Department is responsible for executing and coordinating a variety of classified efforts at SNL's California site. These critical efforts entail providing communications services to multiple customers. We work closely with the National Nuclear Security Administration (NNSA), Department of Defense (DoD), and Intelligence Community (IC) to accomplish these efforts. The centerpiece to this effort is the manning and support of an on-site 24/7/365 Mission Support operations center. We also have charters to 1) Develop processes and procedures for the acceptance, operationalization, and accreditation of new capabilities. 2) Manage ongoing accreditation of the IT and software systems, 3) Develop of innovative IT systems to reduce the total lifecycle costs for the broad range of capabilities being executed.