Database Engineer
Job Overview
The Database Engineer will join a mission-focused team that maintains applications, services, microservices, Platform as a Service (PaaS), and support services. The effort requires the maintenance and enhancement of an application and underlying services/microservices' application's current capability while identifying future capability needs and eliminating overlaps. The team will continuously improve sustainment and development in order to reinvest resources to provide new capabilities and improve the effectiveness, quality, and robustness of the underlying technology. Our applications are focused on intelligence analysis and collection management directly supporting intelligence analysts and operators across the intelligence community and Combatant Commands. The Database Engineer leads development of databases, database parser software, and database loading software; leads development of database structures that fit into the overall architecture of the system under development; develops requirement recommendations from a project’s inception to its conclusion for a particular Business and IT subject matter area (i.e., simple to complex systems); directs the overall database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls. Direct fulfillment of requirements from a project’s inception to its conclusion, directs organization of requirements and data into a usable database schema by directing development of ad hoc queries, scripts, macros, updates to existing queries; direct the development of complex systems using queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies.
Essential Duties
- Provides technical expertise for database design, development, implementation, information storage and retrieval, data flow and analysis to include using Oracle, SQL Server, SYBASE, and other DBMS Database and Applications
- Develops relational and/or Object-Oriented databases, database parser software, and database loading software
- Projects long-range requirements for database administration and design
- Responsible for developing a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls
- The DBE works primarily at the front end of the lifecycle - requirements through system acceptance testing and Initial Operational Capability (IOC)
- Develops requirements from a project’s inception to its conclusion for a particular business and IT subject matter area (i.e., simple to complex systems)
- Affixes with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts
- Participates in developing and delivering training as requested by the government to support applications
- Translates a set of requirements and data into a usable document by creating or recreating ad hoc queries, scripts, and macros; updates existing queries, creates new ones to manipulate data into a master file; and builds complex systems using queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies
Required Knowledge, Skills, & Abilities
- Security clearance status of TS/SCI with a CI polygraph
- Must be DoD 8570 compliant at IA Technical (IAT)/IA Management (IAM) Level 2
- Have experience working on a development team under DoD/DIA Risk Management Framework, understanding of Oracle and/or CENTOS based architecture
Required Education and Experience
- High School Diploma/GED plus 12 years of experience
- Associates Degree plus 10 years of experience
- Bachelor’s Degree plus 8 years of experience
- Masters’ Degree plus 6 years of experience
- PhD plus 4 years of experience