PL / SQL Developer

General Dynamics   •  

Wilkes Barre, PA

Industry: Aerospace & Defense

  •  

5 - 7 years

Posted 48 days ago

Job Description

General Dynamics Information Technology (GDIT) has an immediate need for two PL/SQL Developers to lead, analyze, design, develop, implement, and support code development. The individual will work under limited supervision and perform additional duties as assigned to include, but not limited to:

  • Leads, analyzes, designs, develops, and implements modules relating to fulfillment, supply chain planning
  • Designs, develops, codes, tests, and debugs complex new software products, or makes significant enhancements to existing
  • Researches and integrates design strategies, product specifications, development schedules, and user expectations into product capabilities
  • Resolves complex hardware/software compatibility and interface design considerations
  • Lead and participate in highly complex projects with customers, managers, end-users and GDIT team



Education

Education:

  • Bachelors Degree in business, Information Technology, Computer Science or related field is required.



Qualifications

Qualifications:

  • Seven years of SQL development experience including but not limited to the creation of packages, procedures, tables views, functions, etc.
  • Seven years of experience in Database Star Schema and or Snow flake schema in First, Second and Third normal form
  • Knowledge on how to build/maintain efficient database tables structure for both transactional and warehouse data
  • Six years of experience in PL/SQL tuning including knowledge of Explain Plans AWR, ASH and TKPROF
  • Knowledge of oracle partitioning practices and data archival structures and processes
  • Knowledge of Oracle 11g and 12c with use of tools such as SQLDeveloper, TOAD and ERWIN
  • Must have the ability to work with the system analysts to translate business requirements to database structure as well has communicate the design to the front end development staff
  • Experience in the Agile programming framework
  • Ability to work in a dynamic environment
  • Ability to adapt to sudden modifications
  • Ability to work independently or with a team
  • Ability to make educated decisions regarding their projects
  • Ability to obtain a Public Trust clearance




Requisition ID 2019-54462