General Dynamics Information Technology PL/SQL Developer (must have Public Trust/Position of Trust clearance) in Seaside, California

Clearance Level Must Currently Possess:

Public Trust

Clearance Level Must Be Able to Obtain:



No Suitability Required

Job Family:

Data Analysis

Job Description:

General Dynamics Information Technology (GDIT) is seeking a strong PL/SQL Developer ideally in Seaside, California; however may be remote anywhere.

Key responsibilities would be the following: develops, enhances, debugs, supports, maintains and tests Oracle SQL and PL/SQL code, including procedures and functions. Routine accountability is for technical knowledge and capabilities. Find, investigate, and map out strategies to correct data quality issues that impact identity duplicate resolutions; develops, inspects, mines, transforms, and models data to raise productivity, improve decision making, and gain competitive advantage. Conducts statistical analysis on data and information to ensure correct predictive forecasting or classification. Manages all aspects of end-to-end data processing utilizing customized report building functions of systems. Maintains analytical systems, verifies the accuracy of the data, and acts as liaison with business. Works under minimal supervision, with general guidance from more seasoned Subject Matter Experts. Typically requires 5-7 years of experience.

Job Description:

We are looking for a highly motivated developer with the ability to enhance, debug, support, maintain and tests PL SLQ tool scripts used to identify and resolve identity duplicates for a large database of more than 55 million records. Participates in the design, development and implementation of complex tool scripts. Candidate must be a self-driven individual, who can work on many concurrent projects and deliver results on each, whether working independently or collaborating with other members of the team. Role has potential for advancement for high-achieving individuals.

Role / Responsibilities / Key objectives

  • Ability to come up with technical design based on business requirements.

  • Design, develop, and maintain tools and scripts to help unit testing, development and QA.

  • Completes application coding assignments that meet provided technical specifications and end-user requirements.

  • Participates in the design process that generates application functional and technical specifications.

  • Documents application design specifications and implementation procedures to improve application quality and reuse of code.

  • Assists in the creation of unit, integration, function, and performance test scripts to improve application quality and ensure fulfillment of requirements.

  • Participates in both peer design and code reviews.

  • Other duties assigned by management.

Required Skills

  • Hands on coding experience with Oracle PL/SQL and performance tuning of SQL queries.

  • Experience with large, distributed, RAC databases.

  • Oracle stored procedure, packages, functions, ref cursors, dynamic SQLs etc.

  • Strong in debugging and looking at existing code for modifications.

  • 3+ years of experience with Oracle PL/SQL development.

  • 3+ years of experience with UNIX/Linux scripting & batch processing.

  • 3+ years of experience using Oracle database.

  • Ability to work independently to research issues.

  • Ability to work with end users to troubleshoot production issues.

  • Ability to document solutions/processes as needed.

  • Agile experience.

Desired Skills

  • Must have proven strong analytical and problem skills.

  • Ability to learn new application from business and technology perspective.

  • Able to communicate effectively across varied area including technology, business units and leadership.

  • Demonstrated flexibility in a new environment.

  • It is preferable to at least have the ability to use Oracle’s command line product, SQL*PLUS.


  • BA or equivalent + 6 yrs related experience, or MA + 4 yrs related experience




# of Openings:


Scheduled Weekly Hours:


T elecommuting Options:

Some Telecommuting Allowed

Work Location:

USA CA Seaside - 400 Gigling Rd (CAC001)

Additional Work Locations:

For more than 50 years, General Dynamics Information Technology has served as a trusted provider of information technology, systems engineering, training, and professional services to customers across federal, state, and local governments, and in the commercial sector. Over 40,000 GDIT professionals deliver enterprise solutions, manage mission-critical IT programs, and provide mission support services worldwide. GDIT 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.


CSRA is tomorrow’s thinking, today. To “Think Next. Now.” is to imagine a better future and to deliver it, today. For our customers, our partners, and ultimately, all the people our mission touches, CSRA is realizing the promise of technology to change the world through next-generation thinking and meaningful results.

We understand that our customers' missions require new methods and imaginative thinking. We bring together government IT professionals, emerging technologies, and the brightest, cutting-edge advisors in the industry to deliver a broad range of innovative, next-generation IT solutions and professional services to help our customers modernize their legacy systems, protect their networks and assets, and improve the effectiveness and efficiency of mission-critical functions for our warfighters and our citizens.

Everywhere you look, CSRA is there. We’re in our nation’s infrastructure, in training and education, in cyber security, in serving veterans who served us—and, so much more. Take some time to learn more about CSRA. You might be surprised to learn how we touch your life.

We are a company of 18,000+ smart, talented individuals, yet we enjoy a start-up culture that inspires us to make a difference while delivering results in this rapidly evolving world. Join our team and use your skills and expertise to support the safety, security, health and well-being of the nation.