Description
Database installation, configuration, upgrade, patching (knowledge in IBM/AIX platforms preferred)
Database administration
- Extensive knowledge and experience to build and automate scripts in a UNIX environment for streams on Oracle 11g at a table level and schema level.
- Ability to setup, automate, document and troubleshoot the Streams Replication at schema level and table level to capture, propagate and apply the DML, DDL changes to the replicated database.
- Automate error checking, document and troubleshoot and resolve problems in Oracle streams.
- Use DATA PUMP/export import to instantiate SCN to avoid conflict at destination.
- Ability to clone databases.
- Monitor and manage Production and Development databases and also monitor instances locks, long running queries, listener, free space, extents growth and space management etc.
- Troubleshoot database issues/error.
- Responsible for maintaining 24x7 database uptime.
- Deploying and managing fault-tolerance and high-availability and DR (Disaster Recovery) solutions including Oracle Streams and others.
- Backup and recovery strategy and insure recoverability of Oracle databases.
- Administering and enforcing database and user security policies and standards including privacy regulations.
- Develop, maintain and improve efficient database processes, accurate documentation and best practices.
- SQL and PL/SQL, UNIX Shell Scripting.
- Importing and Exporting data using Data Pump, data replication, data loading and extraction.
- Scheduling jobs and Automating tasks.
- Knowledge of Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Active Session History (ASH).
- Proficiency with Tuning - SGA, Monitoring and Detecting Locks.
Position Overview
Currently in the 5th month of a 15th month Phase 1 project of a CIS upgrade from PeopleSoft Enterprise Revenue Manager (PS-ERM) to Oracle's Customer Care and Billing (CC&B).
The goals of this Phase 1 project are to:
- Successfully upgrade PS-ERM to CC&B retaining current functionality, reporting, queries, and interfaces
- Utilize new functionality offered
- Maximize the functionality of CC&B baseline
- Configure and/or develop plug-ins, algorithms, scripts, or other Products, Codes, Components, and works for existing modifications and/or to achieve the existing functionality of the current CIS Solution.