DATABASE ENGINEER WITH SECURITY CLEARANCE
Executive Management Services, LLC
Dayton OH 45390 US
Federated IT seeks a highly qualified Database Engineer to 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 it 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. Responsibilities:
1. 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
2. Develops relational and/or Object-Oriented databases, database parser software, and database loading software
3. Projects long-range requirements for database administration and design
4. 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
5. The DBE works primarily at the front end of the lifecycle-requirements through system acceptance testing and Initial Operational Capability (IOC)
6. 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)
7. Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts 8. Participates in developing and delivering training as requested by the government to support applications
9. 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, and Abilities
Security clearance status of TS/SCI with a CI polygraph test, must be DoD 8570 compliant at IA Technical (IAT)/IA Management (IAM) Level 2, experience working on a development team under DoD/DIA Risk Management Framework, understanding of Oracle and/or CENTOS based architecture, Cloud, full-stack, OpenShift, and Java. Must know PostgreSQL and Oracle. Required Education and Experience: Education Experience High School Diploma/ GED 12 Associates Degree 10 Bachelors’ Degree 6 Masters’ Degree 3 PhD 2 Preferred Education, Experience, Skills, and Abilities: Bachelor’s degree in information technology, or information management and eight years of comparable work experience. Desired skills include up to ten or more years of program/application operations experience. Prefer candidates who have experience in the Intelligence Community. Candidate must be analytical and effectively able to prioritize needs, requirements, and other issues. Prospective candidates should have strong risk management skills, excellent communication, teamwork and conflict management skills.
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 it 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. Responsibilities:
1. 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
2. Develops relational and/or Object-Oriented databases, database parser software, and database loading software
3. Projects long-range requirements for database administration and design
4. 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
5. The DBE works primarily at the front end of the lifecycle-requirements through system acceptance testing and Initial Operational Capability (IOC)
6. 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)
7. Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts 8. Participates in developing and delivering training as requested by the government to support applications
9. 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, and Abilities
Security clearance status of TS/SCI with a CI polygraph test, must be DoD 8570 compliant at IA Technical (IAT)/IA Management (IAM) Level 2, experience working on a development team under DoD/DIA Risk Management Framework, understanding of Oracle and/or CENTOS based architecture, Cloud, full-stack, OpenShift, and Java. Must know PostgreSQL and Oracle. Required Education and Experience: Education Experience High School Diploma/ GED 12 Associates Degree 10 Bachelors’ Degree 6 Masters’ Degree 3 PhD 2 Preferred Education, Experience, Skills, and Abilities: Bachelor’s degree in information technology, or information management and eight years of comparable work experience. Desired skills include up to ten or more years of program/application operations experience. Prefer candidates who have experience in the Intelligence Community. Candidate must be analytical and effectively able to prioritize needs, requirements, and other issues. Prospective candidates should have strong risk management skills, excellent communication, teamwork and conflict management skills.