In this role, you will participate in all phases of full life-cycle development / maintenance of systems, including requirements analysis, applications design, implementation, testing, deployment and documentation.
In this role, you will implement data models and database designs, data access and table maintenance codes; resolve database performance issues, database capacity issues, replication, and other distributed data like linked server issues.
The Developer will support the SEC Enterprise Services Mission Area (EMA). EMA provides software engineering, field support services, and solutions for success in the C4ISR Enterprise along with support of SECs customers in other agencies.
Candidate will be responsible for supporting the Business Intelligence efforts to include the COGNOS enterprise reporting environment and will include database programming support, testing developed reports and assessing impacts of changes and troubleshooting to multiple IT projects.
In this role, the selected candidate must have experience in developing, testing, and troubleshooting SQL Server Integration Services (SSIS) packages that implement complex Extract, Transform, and Load (ETL) processes.
In this role, you will design, implement, and maintain new and existing database objects including tables, indexes, constraints, stored procedures, and user-defined functions in support of data conversion projects.
Provide scripting development and support for an established, high visibility client database integration project. Assist with the maintenance of databases, including data integrity assurance, loading, and dissemination. Interface with internal and external clients to develop custom scripting solutions for automated query and distribution of GEOINT data.
In this role, you will be responsible for developing, testing, improving and maintaining new and existing databases to help users retrieve data efficiently and effectively from a high data volume environment.
Develop and maintain complex oracle pl/sql stored procedures and functions. Develop and revise program code based on clearly defined requirements. Test all functionality of applications based on test plan.