Database Architect/Developer

Ops Tech Alliance (OTA) is seeking a Database Architect/Developer (Data Warehouse) to support the Defense Language Institute Foreign Language Center (DLIFLC) at the Presidio of Monterey, CA. This role performs analysis, modification, documentation, and support of daily operations for the data warehousing and reporting environment., * Support the full data development lifecycle, including data profiling, ETL, and data model design.

• Design and develop dimensional data models and data warehouse structures.
• Plan, install, and maintain database servers and applications, including after-hours work as required.
• Optimize complex SQL queries for performance and scalability.
• Document data models, ETL pipelines, and warehouse processes.
• Collaborate with application developers, BI analysts, and stakeholders on reporting initiatives.

Do you have experience in SQL?, Do you have a Bachelor's degree?, * AA/AS in a related discipline from an accredited college or university, OR 3+ years of related experience in lieu of degree.

• Active IAT Level II certification (one of: CCNA Security, CySA+, GICSP, GSEC, Security+ CE, or SSCP) plus applicable CE/OS certification.
• 5+ years designing and developing data warehouses.
• Demonstrated track record implementing complex data warehouse projects.
• Expert-level SQL coding and query optimization in SQL Server and/or MySQL.
• Familiarity with data modeling concepts (dimensional, star schema, snowflake schema).
• Knowledge of ETL tools and methodologies.
• U.S. Citizenship; ability to obtain and maintain a Common Access Card (CAC).

Desired Qualifications

• BA/BS in Computer Science, Information Systems, or related field.
• Experience with Snowflake, Redshift, or Teradata.
• Programming experience in Python or Java.
• Prior DoD or Army experience.

Pulled from the full job description

• Tuition reimbursement
• Health insurance
• Paid time off
• Vision insurance
• Dental insurance
• Life insurance, * Competitive Pay
• Paid Time Off
• Tuition Assistance
• Medical, Prescription, Dental & Vision Coverage
• Life Insurance
• Work-life Balance

Our employees have achieved incredible things working on some of the most important technology and security projects in locations around the world to safeguard national security. We focus on hiring top talent and we want you to join our team.

Ops Tech Alliance (OTA) was founded by former National Security and Special Operations professionals with over 100 years of combined experience and was formed with a singular focus: to bridge the gap between operations and technology to enable mission success. We are a certified Service-Disabled Veteran-Owned Small Business (SDVOSB).