Previous Job
Previous
Sr. PL/SQL Developer
Ref No.: 18-02677
Location: Wilkes Barre, Pennsylvania
Start Date: 04/16/2018
Shift Start Time: 8:00:00 AM
 
  First Day Shift Start Time: 7:00:00 AM
 
  Shift End Time: 5:00:00 PM
Specific Questions
Question 1: Is candidate a US Citizen/Perm Res/Green Card Holder (NO EAD HOLDER) with the ability to obtain Position Of Public Trust Clearance; AND worked in the USA for the last 7 years and verifiable? MUST
 
Question 2: Did candidate include ALL date (months and years) AND location (city and state); AND accounted for ALL employment gap (must include location if unemployed)? MUST
 
Question 3: CTH position - annual salary requirements? include in resume comment to client (110K to 115K MAX Provided)
 
Question 4: Holds a Bachelor's degree in Computer Science, Information Technology or related field? MUST
 
Question 5: Have 20+ years IT experience with at least seven years of SQL development experience including but not limited to the creation of packages, procedures, tables views, functions, etc.? MUST
 
Question 6: Have 7 years of experience in Database Star Schema and or Snow flake schema in First, Second and Third normal form; AND 6 years of experience in PL/SQL tuning including knowledge of Explain Plans AWR, ASH and TKPROF? MUST
 
Question 7: Have knowledge on how to build/maintain efficient database tables structure for both transactional and warehouse data; oracle partitioning practices and data archival structures and processes; Oracle 11g and 12c with use of tools such as SQL Developer, TOAD and ERWIN; AND experience in the Agile programming framework? MUST
 
Question 8: 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; work in a dynamic environment; adapt to sudden modifications; work independently or with a team; AND make educated decisions regarding their projects? MUST
Assignment
  Sector: IT     # of Openings: 1
   
  Category: IT   Filled Positions: 0
   
  Region: PA-Pennsylvania   Duration: 6 months, CTH
   
  City: Wilkes Barre   Clearance: Obtain/Maintain
   
  Department:     Client Job Title: Sr. PL/SQL Developer
 
  Keywords: PL/SQL Developer, Agile, Database Star Schema, Snow Flake Schema, Explain Plans AWR, ASH, TKPROF, SQL Developer, TOAD, ERWIN, Oracle 11g and 12c
 
  Responsibilities: Northrop Grumman Technology Services sector is seeking a Senior PL/SQL Developer to join our team of qualified, diverse individuals. This position will be supporting the US Government Client ETS contract at the US Government Client Wilkes -Barre, PA location. Roles and Responsibilities: Ability to work with the system analysts to translate business requirements to database structure as well as communicate the design to the front end development staff. Responsible for following project management and lifecycle development processes, procedures, and standards to meet extremely high quality assurance goals. Knowledge and development experience using Agile methodologies. Demonstrated knowledge of terminology, usage, and operating characteristics of hardware, software, and operating system components within the client server environment. Must live within 1 hour of Wilkes Barre, PA or willing to relocate within 60 days of starting job. HOURS: 5/40 workweek
 
  Requirements: Candidate must be a US Citizen/Perm Res/Green Card Holder (NO EAD HOLDER) with the ability to obtain Position Of Public Trust Clearance; AND worked in the USA for the last 7 years and verifiable. And included ALL date (months and years) AND location (city and state); AND accounted for ALL employment gap (must include location if unemployed). Please confirm ALL resources have been in the US for at least 5 years and have not been out of the country for more than 6 months or more (total) in the last 5 years. Bachelor's degree in Computer Science, Information Technology or related field with 20+ years IT experience with at least 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. Must have 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 SQL Developer, 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. The ability to work in a dynamic environment. The ability to adapt to sudden modifications. The ability to work independently or with a team. The ability to make educated decisions regarding their projects.
 
  Education: Bachelor's degree in Computer Science, Information Technology or related field.