REQ#: RQ173814 Requisition Type: Regular Your Impact Own your opportunity to work with the largest government agency in the nation. Make an impact by advancing the Department of Defense's mission to keep our country safe and secure. Job Description Join GDIT and be a part of the team of men and women that solve some of the world's most complex technical challenges. The Defense Threat Reduction Agency (DTRA) Defense Stockpile Management Systems (DSMS) support is searching for a Software Developer to join their team in Fort Belvoir, VA. DTRA is the Executive Agent for the Joint Staff Nuclear Weapons Stockpile Manager and is assigned the responsibility for maintaining the DoDs national nuclear weapons stockpile database using the Defense Integration and Management of Nuclear Data Services (DIAMONDS) application. Individual needed to develop SQL databases and integrate with a C# application that interfaces with them. Ability to design tables, stored procedures, views, and functions. Our development process consists of designing: tables, storing procedures, views, and functions. They create custom reports and modify user forms to enhance organizational productivity. Sometimes they design databases and ensure their stability, reliability, and performance. SQL developer must develop high-quality database solutions to implement and optimize with stored procedures and functions using Oracle PL/SQL. They will review and interpret ongoing business and functional requirements and research the required data structures. They must build appropriate and effective reporting deliverables with existing SQL and analyze existing SQL queries for performance improvements. They will investigate exceptions concerning asset movements. * Create and manage data flow and data models for various systems.
* Provide troubleshooting and support for database instances in dedicated and multi-node clustered SQL Server environments.
* Participate in identifying stored procedure enhancements for database performance, reliability, and stability.
* Respond to client requests for data by mining a data warehouse.
* Develop requirements from data requests and develop necessary SQL queries to produce output.
* Act as a liaison between the development team leadership, coding teams, and support teams.
* Provide guidance to software engineers, architects and additional team members.
* Perform QA tests to ensure data integrity and quality.
* Review workflow charts developed by business analysts and programmers.
* Design and document database architecture using logical and physical data modeling tools and utilities.
* Run routine and ad-hoc queries as requested by the client.
* Conduct data exploration of new tables and schema in a data warehouse environment.
* Participate in technical design and requirements gather meetings with stakeholders.
* Assist with mapping activities to assist with data normalization activities.
* Demonstrate ability to analyze resource bottlenecks and provide suggestions to team, management, and internal customers on how to alleviate pressure and plan for capacity. Qualifications * BS degree and 5 years of experience; additional years of experience, certifications, and training may be considered in lieu of degree,
* Required: Active Secret clearance to start w/TS SCI eligibility.
* Required: DOD 8570 IAT Level II, ex. CompTIA Security w/CE.
* Experience with Oracle, PL/SQL, SQL Server software and systems.
* Experience with TOAD and TOAD data modeler
* Experience with Microsoft Team Foundation Server.
* Experience with C# coding language
* Preferred: Oracle Database SQL Certified Associate
* Preferred: Agile methodologies
* Fluency in scripting, debugging and relational databases.
* Comfortable running analysis services.
* Preferred experience with DoDAF documentation.
* Telework eligible, this is system and project specific. #armajobs #GDITpriority Work Requirements .cls-1{fill:none;stroke:#5b6670;stroke-miterlimit:10;stroke-width:2px} Years of Experience 5 years of related experience * may vary based on technical training, certification(s), or degree .cls-2{fill:none;stroke:#5b6670;stroke-miterlimit:10;stroke-width:2px} Certification Security , CE - CompTIA-Security CE Travel Required Less than 10% .cls-3{fill:none;stroke:#5d666f;stroke-miterlimit:10} Citizenship U.S. Citizenship Required About Our Work We are GDIT. A global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government, defense and intelligence community. Our 30,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 30 countries worldwide, offering leading capabilities in digital modernization, AI/ML, Cloud, Cyber and application development. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology. 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.