Database Engineer

The Database Engineer provides technical expertise in database design, development, implementation, information storage and retrieval, data flow, and data analysis. This role spans early lifecycle phases-from requirements through system acceptance testing and Initial Operational Capability (IOC).

The engineer develops relational and/or object-oriented databases, parser software, loading software, and database structures that fit into the system's overall architecture. Responsibilities include making design trade-offs related to data volume, user load, distribution, response time, retention, security, and domain controls.

The role also includes support for system improvement recommendations, optimization efforts, development, and maintenance activities., Database Design & Development- Design, develop, and implement databases, information storage systems, retrieval mechanisms, and data flow structures. Develop relational and object-oriented databases, database parser software, and loading software. Create database structures aligned with overall system architecture, considering: Data volumes Number of users Logical/physical distribution Response times Retention rules Security and domain controls

Requirements & Analysis- Work at the front end of the lifecycle: requirements, design, integration, and system acceptance. Derive requirements from business and IT needs for systems ranging from simple to complex. Analyze and evaluate system improvements, optimization opportunities, and development/maintenance activities.

Data Manipulation & Automation- Translate requirements and datasets into usable documentation and database schemas. Create or modify ad hoc queries, scripts, and macros. Build complex systems using queries, tables, ODBC connections, and cloud-based storage/retrieval methodologies.

Engineering Capabilities- The Database Engineer shall possess the ability to: Support database design, development, implementation, storage/retrieval, and data analysis activities. Support long- and short-term requirements planning for database administration and design. Support analysis and evaluation of system improvements and optimization. Create or modify ad hoc queries, scripts, and macros, and manipulate data into master files. Assist in developing databases, parser software, and loading software. Assist in developing database structures aligned with system architecture.

Lead: Development of databases, parser software, and loading software Database structural design aligned with system architecture

Direct: Overall database structural design within the system architecture Organization of requirements and data into usable database schemas Development of ad hoc queries, scripts, macros, and updates Development of complex systems using ODBC, cloud storage/retrieval, and database technologies Development and integration of messaging protocols/services (e.g., Java Messaging Protocol, RabbitMQ) Stay current with new and emerging database, messaging, and software technologies and recommend adoption strategies.

Experience developing SQL Server database architectures of significant complexity. DoD 8570 compliance: Information Assurance Technical (IAT) Level II or higher. Bachelor's degree in an IT discipline from an accredited institution Four (4) additional years of database engineering experience may substitute for a degree.