Jr. Database Developer

Location
Elizabeth City, NC
Posted
Feb 15, 2017
Closes
May 01, 2017
Hours
Full Time
The Database Developer supports the USCG Engineered System Support Services (ESSS) for Asset Logistics Management Information System (ALMIS) at the USCG Aviation Logistics Center (ALC) in Elizabeth City NC.

 

 

The Database Developer is responsible for for designing; planning; developing; implementing databases; including back end rules and procedures; data scripts; security; access; and documentation.

 

  • Participates in the design; coding and enhancement of relational databases in a client/server environment 
  • Coordinates new data development ensuring consistency and integration with existing data warehouse structure 
  • Analyzes and determines information needs and elements; data relationships and attributes; data flow and storage requirements; and data output and reporting capabilities 
  • Participates in continuous improvement efforts in enhancing performance and providing increased functionality
  • Creates test plans and completes pre production testing with user for modified rules, procedures and front end applications
  • Assignments may include design and maintenance of data dictionaries; database structure and layout; developing, modifying and testing rules and procedures in a transactional database;  creating sql scripts to modify or create data in a transactional database 
  • Designs; implements; and maintains complex databases with respect to JCL; access methods; access time; device allocation; validation checks; organization; protection and security; documentation; and statistical methods 
  • Applies knowledge and experience with database technologies; development methodologies; backend programming languages (e.g.; SQL)
  • Stays current on vendors' best security practices in relation to organizational requirements and maintains current knowledge of relevant technologies as assigned 
  • Participates in special projects as required.
 

 

Education Bachelors Degree in a Computer Science or related technical discipline; or the equivalent combination of education; technical certifications or training; or work experience.

Qualifications
  • 1-4 years of related database analysis and/or database development experience.
  • Must be eligible for a secret clearance.
Experience with SQL

Familiarity with Oracle; Ingres and/or Informix Databases highly desired

Familiarity with COGNOS desired

Familiarity with USCG ALMIS/ACMS/EAL and/or CGLIMS helpful

  • Develop and maintain database objects; to include coding; table structures; procedures; views; indexes; and constraints in support of overall asset management within; but not limited to; Ingres; Oracle; and lnformix
  • Manage all changes to data dictionaries; and entity relationship diagrams for the ALMIS and CG-LIMS systems and related sub-systems
  • Author internal validation documentation to include; but not limited to; technical specifications; special instructions; and regression test plans
  • Debug software and identify required corrections to meet specified requirements.
*GDITHCSD

 

#eg


As a trusted systems integrator for more than 50 years, General Dynamics Information Technology provides information technology (IT), systems engineering, professional services and simulation and training to customers in the defense, federal civilian government, health, homeland security, intelligence, state and local government and commercial sectors.With approximately 32,000 professionals worldwide, the company delivers IT enterprise solutions, manages large-scale, mission-critical IT programs and provides mission support services.GDIT is an Equal Opportunity/Affirmative Action Employer - Minorities/Females/Protected Veterans/Individuals with Disabilities.