Vacancy expired!
- Experience in monitoring, troubleshooting, and maintaining of the various Oracle databased.
- Timely alerts to the designated Government representative when additional hardware or software is required to maintain the availability or performance of database functionality.
- Support activities throughout the implementations of Program projects to include:
- Oracle database installation, configuration, and technical support
- Coordinate and support Oracle database and application upgrades
- Plan, coordinate, design, develop, test, and implement Oracle database backup and disaster recovery routines.
- Create and maintain Oracle physical database structures based on logical design specifications provided by the application developers.
- Provide technical and functional analysis in the Oracle database environments.
- In collaboration with the application developers, plan, coordinate, design, develop, test, and execute data migrations to/from Oracle databases. Requirements Analysis: Conduct a thorough analysis of operational, technical, and systemic requirements for any required modification to maintain the Oracle databases.
- Perform modifications to Oracle environments to support changes to the applications, reporting requirements, and user requests.
- Development of Oracle databases to support new or current applications, ensuring physical or virtual database configuration and storage needs are met.
- Experience with Tomcat or Apex is required
- Experience with database administration for existing database and future database systems:
- Administration of access control for Oracle database systems
- Administration of Oracle databases
- Ensure compliance with established Oracle database standards and propose new/revised standards as necessary.
- Monitor existing Oracle databases' storage needs and perform fine-tuning to ensure the databases are running efficiently.
- Assist with Oracle database upgrades and patches.
- Provide support for data migrations from legacy systems into Oracle databases utilizing readily available tools such as Oracle export/import datapump.
- Experience with Oracle's Application Express Administration (APEX) and Oracle REST Data Services (ORDS). Integration of Oracle APEX with BI Publisher.
- Develop using SQL queries, Materialized views, database links, PL/SQL procedures, functions, packages, triggers, cursors.
- Coordinate and support APEX upgrades, both minor and major.
- Experience utilizing Amazon's AWS Cloud environment and to include, but not limited to the ability to create, maintain and work efficiently with RDS, EC2, S3 services.
- Working knowledge and the ability to maintain Tomcat Apache/Catalina.
- Ability to work with PKI, server certs, both JAVA Keystores and Oracle Wallets.
- Knowledge of SSL Encryption protocols and the ability to support both Encryption at Rest and Encryption at Transit.
- Familiar with the Security Technical Implementation Guidelines (STIGs) regarding security of databases. Support Certification & Accreditation (C&A) activities based on defined Security Division (SecD) policies and instructions. Support may be provided during multiple phases of the C&A process including definition, verification, validation, and post-accreditation.
- Excellent communicator (written and verbal)
- Critical thinker
- Demonstrated ability to interact with high level clients and a proven track record of performing database maintenance and administration, such as space allocations, and reorganizations, and implementing database changes in response to changes in an enterprise environment.
Vacancy expired!