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:
Database Analyst Senior
BACKGROUND:
The United States Department of Commerce's (DOC) National Telecommunications and Information Administration (NTIA) is the President's principal adviser on telecommunications and information policy issues. NTIA manages the Federal use of the electromagnetic (EM) spectrum.
NTIA's Office of Spectrum Management (OSM) manages the EM spectrum for the Federal government in the U.S. and its territories. OSM uses multiple national security systems and unclassified systems to assign frequencies; maintain spectrum use databases; review Federal agencies' new telecommunications systems and certify the availability of spectrum; and provide the technical engineering capabilities needed to perform spectrum resources assessments.
NTIA and federal agencies including the Department of Defense (DoD), currently use the Equipment Location- Certification Information Database (EL-CID) Desktop and EL-CID Online applications as automated tools to support electronic preparation of spectrum certification requests. NTIA is planning to retire EL-CID Desktop and only use EL-CID Online, a web application with a browser-based user interface.
Job location is both remote and onsite. The candidate must be on-site at least three times a week to perform deployments and support the high-side (classified) environments. The on-site location is the Herbert C. Hoover Building, 1401 Constitution Avenue, N.W, Washington, DC. 20230.
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.
Years of Experience: Six years of experience, of which at least four years must be specialized.
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 Stylevision 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.
Responsibilities:
Responsible for designing, planning, implementing, and administering databases, including security, access, and documentation.
Participate in the design, maintenance, enhancement, coding and administration of Oracle 19c XML database. Administration will be on several low and high side environments: development, Test, Pre-Production, and Production.
Work closely with development team to ensure system design follows the industry best practices and standards.
Incorporate standards and best practices, including performance, security, scalability, and maintainability.
Create or update stored procedures, triggers, and other DML/DDL.
Update or replace existing database installation scripts.
Perform database installations and upgrades. Include ability to rollback.
Generate an ERD diagram for existing database.
Create and maintain a database design document, including a data dictionary.
Determine storage requirements and perform capacity planning (working with System Administrators).
Tune database for optimal performance.
Install quarterly Oracle patches.
Upgrade Oracle as requested by customer.
Assist with failover activities for both the low and high side.
Participate in continuous improvement efforts in enhancing performance and providing increased functionality, including performing proactive maintenance such as ensuring continued space availability, monitoring activity, and documenting problems, changes, and solutions.
Understand production environments including security hardening, performance tuning, and access control.
Learn some tasks performed by system administrators in case they are not available such as bringing up servers that are down, granting users access and permissions, reading logs for debugging issues, and opening trouble tickets. The system administrator will teach the candidate these tasks.
Participate in special projects as required such as upgrading Bizflow workflow.
Good written and verbal communication skills coupled with strong listening skills.
Ability to contribute on an individual basis as well as demonstrate your strengths as a team player as a member of an agile team.
Required Skills:
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.
Secret clearance required to start.
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
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
