Operations

Positions

Oracle Database Administrator


Description

The Oracle Database Administrator is a key member of a development effort. The DBA has the opportunity to solve challenging technical issues and advance the mission of a key government customer.

  • Develops infrastructure database routines to support application code
  • Provides day-to-day database support on existing, operational databases that are already in operation, to include troubleshooting, analysis, and resolution of performance and storage issues on legacy/future databases
  • Ensures software code and databases initialize, execute and terminate as specified in the certification and accreditation process for the Agency
  • Provides support and service to organizations Window and Sun servers (installing security patches; COTs software) and other non-operating system software
  • Integrates and supports client-server based COTS database tables interfacing with Government database tables
  • Develops and maintain top-level design and detailed-level designs for the databases (GOTS and COTS); documenting database designs
  • Analyzes ideas and methods, and documenting database design solutions in response to: functional requirements, non-functional requirements, security requirements, and system requirements for new database tables and/or the modification or enhancement of existing database tables in requests for change
  • Researches and develop technology to ensure that software and networks are free of security defects and vulnerabilities
  • Document and deliver data models/entity relationship diagrams/UML class models contextual, conceptual, logical and physical models including entity and attribute definitions
  • Ensures that all the software requirements are allocated from the software components to software units. The detailed design of interfaces will permit coding without the need for further information. The detailed design will be documented
  • Transforms system requirements for software items into an architecture that describes its top-level structure and identifies the software components. Ensure that all the requirements for software items are allocated to its software components and further refined to facilitate detailed design
  • Installs and tesst GOTS and COTS software releases on development, stage, and operational platforms
  • Installs and upgrades database server and database tools, ensure data/media recoverability through system back up and database archive operations, and monitor backups for the servers


Requirements

Qualifications include:

  • Possesses a Bachelors Degree or higher in Computer Science, Computer Engineering, Mathematics, Electrical Engineering or a related discipline. A Bachelors Degree in any discipline with a minor in Computer Science is also acceptable
  • In lieu of a Bachelors Degree, four (4) additional years of experience for a total of eleven (11) years experience in systems administration can be substituted for the degree requirement
  • Minimum of seven (7) years of specialized database and architectural experience in: XML, Oracle 10g and 11g RDBMS using PL/SQL, SQL, Java, HTML, and Java Script
  • Windows 2012R2, 2012, 2008R2, Server environment
  • Writing efficient SQL code for developer to implement into the presentation and/or middle tier code for efficient performance
  • Writing database scripts for tables, constraints, and writing triggers
  • Uses of Rational ClearCase and Rational ClearQuest
  • Working on a full project life cycle from requirements gathering to testing to deployment
  • Develops data migration strategies and present impact analysis to the Government manager for data changes
  • Manages metadata and use of business intelligence tools such as business objects
  • Specifies, architects, designs, verifies, implements, and tests database components in ORACLE 10g, 11g, and newer RDBMS