Specifications include, but are not limited to: 2.3.1 Oracle Database Administrator A. General Responsibilities The tasks to be accomplished by the Contractor’s personnel under this Contract will include, but not limited to the following: • Propose and implement database management policies, procedures, and standards. • Provide database monitoring and statistical reports using Oracle Enterprise Manager Grid Control 19C. Monitor alerts, schedule daily, weekly, and monthly backups. • Coordinate the installation and implementation of database management system software and related software tools with vendors, other data processing staff, and systems users. • Maintain security and integrity of data access policies, standards, and methods by establishing recovery plans to minimize data losses and system downtime and by performing back up routines for the database management system software and the stored data. • Monitor database performance and make modifications and adjustments to database architecture, storage methods and management system software to fine tune the database for optimum response time. • Monitor database capacity and allocate space according to overall needs of systems users, available data storage, and database management system requirements. • Maintain hourly, daily, weekly, monthly, and yearly test backup and recovery process for Disaster Recovery readiness using Oracle RMAN, data pump, and cold and hot backups. • Provide support in Oracle Golden Gate configuration, implementation, and conflict resolutions for data replication. • Perform periodic database refreshes, cloning from Production to Development, and Test environments. • Provide database support during full development cycle of application from design to testing and implementation, on-call production, test and development support. • Proactively research the latest database technologies and perform lab tests as needed/requested, document and make recommendations by performing return on investment analysis for higher management. • Create new Oracle databases using DBCA, as per the standards to upgrade existing Oracle databases and/or apply the latest Oracle Security patches. • Migrate data and database objects from Oracle to MS SQL Server database. • Migrate and configure Oracle application and database servers to the latest Oracle version as needed. • Design, build, and manage cluster and virtual machine environments. • Evaluate and recommend new database technologies. • Manage and integrate various database platforms. • Manage and maintain Windows, Linux, and environments. • Develop and implement flexible database management policies, procedures, and standards. • Manage and resolve database and application systems failure and provide alternate solutions. • Train database system users on the use of database management systems. • Develop database recovery plans. • Prepare statistical reports of database management activities and special purpose report. • Coordinate the database management system interfaces with other data processing units. • Troubleshoot problems related to database file space, database software, data flow, and data storage or data access. • Manage web database security. • Perform other duties as assigned. • Manage access control security systems. • Provide working experience to implement and manage Oracle stand by databases. • Provide working experience to implement and manage Oracle database encryption methodologies preferably with Transparent Data Encryption (TDE) and Oracle Wallet. • Procure, manage, and install Oracle Forms JAVA jar files as required. • Manage Trucker Verification E-Modal system. • Manage MPA Oracle databases with Oracle Enterprise Manager tools. • Provide database maintenance activities, such as monitoring, space management, and support, as well as extended hours of support for database systems when required.
