General Dynamics

Sr. PL/SQL Developer

Posted on: 6 Feb 2021

Wilkes-Barre, PA

Job Description

We are GDIT. We support and secure some of the most complex government, defense, and intelligence projects across the country. At GDIT, cyber security is not just a singular part of our mission-it connects every one of us because it's embedded into every aspect of what we do.

GDIT is your place. You make it your own by bringing your ideas and unique perspective to our culture. By owning your opportunity at GDIT, you are helping us ensure today is safe and tomorrow is smarter. Our work depends on an Sr. Oracle PL/SQL Developer joining our team to support USPS activities in Wilkes-Barre, PA.

At GDIT, people are our differentiator. In this role, your responsibilities will include:
* 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 withcustomers, managers, end-users and GDIT team

WHAT YOU'LL NEED:
* Bachelor's Degree in computer science, Engineering or a related technical discipline, or the equivalent combination of education, technical training, or work/military experience
* 10+ years of related database development experience
* Strong PL/SQL development experience including but not limited to the creation of packages, procedures, tables views, functions, etc.
* Oracle database design and performance tuning
* Seven years of experience in Database Star Schema and or Snowflake 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 SQL Developer, TOAD and ERWIN
* Experience with batch job process, ASP, VB script, and Windows
* Experience with Java, JSP, and VB
* 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

The security clearance for this program requires the selected candidate to have resided in the US for the past five years. The selected candidate cannot have left the country for longer than 90 consecutive days and no more than 180 cumulative days.

Please note: This position is a pipeline requisition and not fully funded by the customer; this may result in delayed responses from the GDIT recruiting team.

Thank you for your interest and we encourage you to continue applying for positions you are interested in at GDIT.

WHAT GDIT CAN OFFER YOU:
* Full-flex work week
* 401K with company match
* Internal mobility team dedicated to helping you own your career
* Collaborative teams of highly motivated critical thinkers and innovators
* Ability to make a real impact on the world around you

GDIT CAREERS
Opportunity Owned

Not sure this job's the one for you? Check out our other openings at gdit.com/careers.

Do you have a friend or colleague this posting describes? Let them know about the opportunity by clicking Share.

Discover more at gdit.com/careers

USPSTSS

OPPORTUNITYOWNED

GDITCAREERS

WEAREGDIT

GDITLIFE

wilkesbarre

scranton

Scheduled Weekly Hours:
40

Travel Required:
None

T elecommuting Options:
Telecommuting Not Allowed

Work Location:
USA PA Wilkes-Barre

Additional Work Locations:

We are GDIT. The people supporting some of the most complex government, defense, and intelligence projects across the country. We deliver. Bringing the expertise needed to understand and advance critical missions. We transform. Shifting the ways clients invest in, integrate, and innovate technology solutions. We ensure today is safe and tomorrow is smarter. We are there. On the ground, beside our clients, in the lab, and everywhere in between. Offering the technology transformations, strategy, and mission services needed to get the job done.nnGDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.

PI129488092

General Dynamics

Falls Church, VA

General Dynamics Corporation operates as an aerospace and defense company worldwide. It operates in five segments: Aerospace, Combat Systems, Information Technology, Mission Systems, and Marine Systems. The Aerospace segment designs, manufactures, and supports business-jet aircraft; and offers business-aviation services, including maintenance, fixed-base operation, government fleet, aircraft management, charter, and staffing services, as well as integrated aviation solutions.

The Combat Systems segment engages in the design, development, production, modernization, and sustainment of combat vehicles, weapons systems, and munitions. This segment offers wheeled combat and tactical vehicles; main battle tanks and tracked combat vehicles; weapons systems, armaments, and munitions; and maintenance, logistics support, and sustainment services. The Information Technology segment provides information technology (IT), IT infrastructure modernization, and professional services, as well as cloud, cyber, software development, systems engineering, and data analytics services and solutions.

The Mission Systems segment offers mission-critical C4ISR products and systems, such as space, intelligence, and cyber systems; ground systems and products; and naval, air, and electronic systems. The Marine Systems segment designs and builds nuclear-powered submarines, surface combatants, and auxiliary and combat-logistics ships for the United States Navy and Jones Act ships for commercial customers.

This segment provides nuclear-powered submarines; surface combatants; auxiliary and combat-logistics ships; commercial product carriers and containerships; design and engineering support services; and maintenance, modernization, and lifecycle support services, as well as repair services for navy ships. The company was incorporated in 1952 and is headquartered in Falls Church, Virginia.