25 Oct
Oracle PL/SQL Developer - SECRET (Telecommute)
District of Columbia, Washington , 20230 Washington USA

Vacancy expired!

Oracle PL/SQL Developer - currently telecommute - after COVID - onsite 3 days.

Please note, we are looking for a candidate that can code PL/SQL stored procedures, triggers, other DML/DDL and can perform light DBA work such as installing patches, doing export/imports, understands database structures and can perform some tuning. But the DBA activities are very minimal. The candidate will mostly be coding in PL/SQL. The database is an oracle XML database, so knowledge of that database is a huge plus. ASD is seeking an Oracle Developer to support a DoC program with GDIT. ASD is a sub to GD on multiple programs. This is currently 100% remote.

SUMMARY 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; and performs cutting-edge telecommunications research and engineering, including resolving technical telecommunications issues for the Federal Government and private sector. 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 to include the Department of Defense (DoD), use the antiquated Equipment Location- Certification Information Database (EL-CID) Desktop application as an automated tool to support electronic preparation of spectrum certification requests. NTIA is in process of replacing the antiquated, MS Access/Visual Basic EL-CID Desktop application with EL-CID Online. The first objective of this task order is to complete the EL-CID Online web application to allow NTIA to retire the desktop application. Follow-on task orders will address additional functionality and interfaces to other systems.The qualified candidate will provide Oracle 12c 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 also serve as the database administrator a fourth of the time. 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 may be complex. The candidate is also expected to perform database administration activities such as tuning, installing quarterly Oracle patches, 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 the unclassified side. It will need to obtain an ATO on the classified side. 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 Authority to Operate (ATO) package for the classified side.

Job location is both remote and on-site. The candidate must be on-site at least 3 or 4 days a week to support the high side (classified) environments, once Covid restrictions are lifted. The on-site location is the Herbert C. Hoover Building, 1401 Constitution Avenue, N.W, Washington, DC. 20230.

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 12c 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.
  • 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.

REQUIREMENTS
  • 4+ years experience writing Stored Procedures and SQL, including optimizing CRUD performance.
  • 2+ years experience conducting performance measurements and determining options for increasing efficiency.
  • 2+ years performing restorations and backups.
  • 4+ years 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.

Vacancy expired!


Related jobs

Report job