What are the responsibilities and job description for the Solutions Architect position at Spectra Tech, Inc.?
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.
Spectra Tech’s policy is to give equal opportunity to all qualified persons without regard to race, color, religion, sex, age, national origin, individuals with a disability, genetic information, sexual orientation, protected veteran status, or any other basis prohibited by applicable law.
