The systems were part of a project that involved Web based applications providing Verizon's service functions that allow business and residential customers to view online various products available, bills, customer service reports, service orders.
Provided both development support and maintenance for six databases (databases size around 5 GB each).
Handled complete Oracle related requirements involving Oracle installation, management of databases creation and maintenance, user management.
Installed, and developed new PL/SQL procedures and packages.
Handled complete Oracle related requirements to function with WEB-based front end, data maintenance cron-jobs/SQL queries.
Handled complete database backups and Disaster Recovery Site setup/maintenance.
Involved with performance tuning and trouble shooting as required.
Optimization of data extraction process with advanced PL/SQL techniques, hash partitioning, parallel query servers.
Used micro strategy for data mining and reporting with the meta data repository residing within a SQL Server database.
Two databases (Production and DR) were configured as Master-to-Master definition sites for replication process using Oracle 8.0.4.1.0. It was configured using Oracle provided stored procedures; catrepl.sql was used to load replication option. The databases are close to 4 GB each. 10 tables were replicated using one replication group, set columns for defining primary keys, asynchronous mode was setup over SQL-Net with time interval set to 3 seconds. No conflict resolution rule sets were used.
