"Alerted.org

**Req ID:** RQ204105

**Type of Requisition:** Regular

**Clearance Level Must Be Able to Obtain:** Secret

**Public Trust/Other Required:** None

**Job Family:** Database Analysis/Design

Skills:

Database Design,Database Management,Entity Relationship Diagrams (ERD),Oracle

Experience:

5 + years of related experience

US Citizenship Required:

Yes

Job Description:

General Dynamics Information Technology (GDIT) is seeking a qualified, motivated individual to join GDIT as Oracle Database Administrator to support our federal government mission in the District of Columbia.

Job Description

GDIT is seeking an experienced Oracle Database Administrator to work with our customer and the Department of Defense (DOD). The Oracle Database Administrator is responsible to use the online applications as automated tools to support electronic preparation of spectrum certification requests to modify the existing platform. This position is in Washington, DC and duties will be performed onsite.

The qualified candidate will provide Oracle 19c database application support and database administration support for both the software development and maintenance areas of the project. The ideal candidate will have significant experience working with an Oracle XML database. The candidate will serve as the PL/SQL developer and database administrator. As a member of the agile team, the candidate will participate in the architecture, design, development, testing, and deployment of the system and is expected to assist the development team by creating and updating a few stored procedures, triggers, and the like; some of which are complex. The candidate is also expected to perform database administration activities such as performance tuning, monitoring tablespaces, installing quarterly Oracle patches, upgrades, and performing backups. The database is relatively small and standalone. The candidate will also need to review and update scripts for installing the database from scratch as well as installing sprint changes. The candidate must also create and maintain a database design document; this will involve generating and maintaining an ERD diagram. The EL-CID Online application uses XML extensively. The system uses Google Web Toolkit (GWT) for the user interface, Altova Style vision to create PDFs, Bizflow for workflow, WorldWind and Bing Tile server for maps, and Oracle XML for the database in a Windows virtualized environment. For the EL-CD Online system to operate in a production environment, the system has obtained an Authority to Operate (ATO) on both the unclassified and classified sides. The qualified candidate will need to assist with reviewing and generating technical documentation for the EL-CID Online System to be submitted to the government’s Information Assurance (IA) team as a part of the continuous Authority to Operate (ATO) package for both the unclassified and classified sides.

Required Knowledge, Skills, and Abilities:

+ 5+ years’ DBA experience with Oracle 12c/Oracle 19c XML database

+ 5+ years of experience with XSD, XSLT, XML

+ 5+ years of experience writing Stored Procedures and SQL, including optimizing CRUD performance.

+ 5+ years of experience conducting performance measurements and determining options for increasing efficiency.

+ 5+ years’ performing restorations and backups.

+ 5+ years of experience writing technical documentation

+ Ability to learn simple system administration tasks.

+ Knowledge of Subversion, GIT, or Team Foundation Server (TFS) version control system a plus.

+ Knowledge of JIRA and Confluence a plus.

+ Six years of experience, of which at least four years must be specialized.

Deliverables:

+ PL/SQL stored procedures, triggers and other DML and DDL developed and configured from requirements adhering to acceptance criteria and design, assessed for potential security weaknesses, with no high vulnerabilities found by scans and tools

+ Database conversions

+ High availability databases for user access, development, testing, and training

+ Installation and configuration of quarterly Oracle updates and patches for on-going maintenance

+ Database backup and recovery plans and procedures and schedule; in the case of server failure or other form of data loss, successful restoration from backups

+ Database access and permissions

+ On-going database performance monitoring and database tuning

+ Creation of a database design document in government specified format

+ Creation of a database Entity-Relationship-Diagram (ERD)

+ Addressing/applying Oracle STIGs

+ Monitoring and ensuring tablespaces are not exceeding capacity

**Minimum Education:** Bachelor’s degree in computer science/systems, information systems/technology, engineering/engineering technology, software engineering/programming, management, natural sciences, social sciences, mathematics, or business/finance. Three years of additional applicable experience may be substituted for a bachelor’s degree.

**Security Clearance** : Secret clearance required to start.

**Location** : Remote and onsite-Washington. DC: The candidate must be on-site at least three times a week to perform deployments and support the high-side (classified) environment.

GDIT Is Your Place:

+ Full-flex work week to own your priorities at work and at home

+ 401K with company match

+ Comprehensive health and wellness packages

+ Internal mobility team dedicated to helping you own your career

+ Professional growth opportunities including paid education and certifications

+ Cutting-edge technology you can learn from

The likely salary range for this position is $123,250 - $166,750. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.

Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.

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 50 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.

Join our Talent Community to stay up to date on our career opportunities and events at https://gdit.com/tc.

Equal Opportunity Employer / Individuals with Disabilities / Protected Veterans