Home » Other » Marketplace » Urgent Req for an Oracle/Peoplesoft DBA 6+month contract
Urgent Req for an Oracle/Peoplesoft DBA 6+month contract [message #106247] Thu, 09 January 2003 02:02 Go to next message
J
Messages: 16
Registered: April 2001
Junior Member
Will not entertain agencies!!

A 6+ month Peoplesoft/Oracle DBA contract position in Switzerland, to be starting immediately.
Requirement:
- Strong (5+ years exp) Oracle DBA on Unix platform
- Strong (3+ years exp) Peoplesoft Oracle DBA
- Extensive Peoplesoft Application, Web Server (web logic) experience
- Extensive Peopletools experience
- Excellent troubleshooting and analytic skill
- Good communication skill
- DB2 DBA experience helpful
- German speaking helpful

Interested please email resume and phone contact number to dj_wong@yahoo.com.
Interview immeidately
Re: Urgent Req for an Oracle/Peoplesoft DBA 6+month contract [message #106600 is a reply to message #106247] Tue, 02 March 2004 06:53 Go to previous messageGo to next message
venkatesh babu
Messages: 4
Registered: February 2002
Junior Member
I am looking for peoplesoft DBA position.I am having exp. of 6 years.I am working for IBM client in Bangalore.reply.
Re: Urgent Req for an Oracle/Peoplesoft DBA 6+month contract [message #106681 is a reply to message #106247] Sun, 21 March 2004 15:00 Go to previous message
RAMANA SIVARCHAKA
Messages: 1
Registered: March 2004
Junior Member
Mr. Ramana Sivarchaka
PeopleSoft & Oracle Applications Database Administrator
E-Mail: sivarchaka@yahoo.com
Phone: 609-731-2812

Over Nine years of experience in Relational Database systems with special expertise in Installation, Implementation, maintenance upgrades and administration of Oracle Applications, PeopleSoft ERP/CRM and Data Warehouse applications.

CAREER PROFILE:

 Installation, Configuration, Migration, upgrades of Oracle 8.x & 9i and DB2 udb 7,8.x databases for Small, medium and large OLTP, DSS applications.
 Installation, Configuration, Customization and upgrades of Oracle Applications from 10.7 to 11.0.5 with web self-service and server partitioning on 8/8i Oracle versions.
 Installation, Configuration, Customization and upgrades of PeopleSoft, ERP/CRM solutions from 7 to 7.5 and 7.5 to 8 on Unix and NT servers.
 Installation and configuration of 9ias, OAS/OWS, Apache, and weblogic web servers.
 Installation, Configuration of Clarify CRM, Primus knowledge base applications.
 Administration of NT/2000 and UNIX servers and Networks.
 Monitor Host System performance.
 Database Performance tuning.
 Implemented different backup methods and scenarios for recovery.
 Designed implemented and configured data warehouse / reporting and standby databases, automated ELT process using SQL*LDR, snapshots and advanced replication techniques.
 Client-server programming SQL, PL/SQL (DB Triggers and Packages), Cobol, Pro*C, C, Perl and Shell Scripts.

Education & Professional Training:

 BS in Engineering (B.E), India
 MBA, India
 Post Graduate Diploma in Computer applications, Institute of Information Technology, India
 Diploma in Oracle client/ server Applications and RDBMS, India
 Diploma in Oracle Financials, Biological Events Ltd., India
 Unix Sun Solaris 2.8 System Administration
 Oracle enterprise DBA (Oracle corporation)
 Configuration & Administration of People soft on Oracle/Unix 7.5 (PeopleSoft Corporation)
 People soft server administration on Unix/Oracle 8.12 (PeopleSoft Corporation)

Skills & Software:

PeopleSoft Product Components: 7.x, 8.3, 8.4, PORTAL sp2

PeopleSoft People Tools: 7.x/ 8.x, Tuxedo 6.5/Jolt 1.2 SQR, Nvision,
Upgrade assistant, Data Management tools

Oracle applications: Oracle Financials (10.7/11.0.5/11i)

Other ERP/CRM Products: Clarify Software 7.0 /10.0,10.1
Primus software 4.0b/ 5 versions, Xpercom 5.x, Tead

RDBMS Oracle7.x, 8.x, 8i, 9i, DB2 UDB v7.x, 8.x, MS-Access

Database Utilities: Oracle Enterprise Server & Server Manager, Oracle
Recovery Manager, Oracle Enterprise, Backup Utility,
SQL Loader, Oracle Import/Export Utilities, Oracle
SQL*Net, Net8

Third Party Database Tools: Quest Software ( iwatch, Spotlight, Foglight,
Spacemanager, SQLLab, Livereorg, Shareplus,
SQLnavigator, Toad) Platinum SQL-Station /Desktop DBA

GUI Tools: Developer/2000 (1.5 & 2.1,6i) forms and Reports, Visual
Basic 6.0, PeopleSoft People Code, SQR, Oracle 9iAS,
Control Center

CASE TOOLS: CASE Tools -Designer/ 2000, ERWIN

Web Application: Oracle Application Server (OAS/OWS), 9iAS Apache,
Web Logic, HTML and Java Script.

Reports: Crystal Reports, Oracle Report Writer, Brio

Programming Languages: SQL, PL/SQL, Pro*C, C, COBOL, Perl,Shell, sed, awk, clp

Hardware: Sun Ultra60, Sun e3000 Sun ultra e450, Sun 4000, Sun
e5500, Sun e10K, sun fire v880, HP-9000 serials, IBM RS
6000, IBM PC & Compatible, Compaq Tru 64

Operating Systems: Unix, SunOS 5.6,5.7,5.8, HP-UX (COMPAQ thr 64), red hat
Linux, Veritas Cluster Server and EMC advanced storage
Technology (Time Finder) /Windows NT/2000, Windows 95
/98, Novell NetWare


Professional Experience:

RCN Corporation, Inc., Princeton, NJ Sep 99 – Till date
Currently, Working as a Senior/Lead DBA with the RCN Infrastructure Technology Team, implementing / supporting Oracle Applications (Financials), PeopleSoft Human Resource, Clarify E-Front office Application, Primus knowledge Base Web Application in 24x7 production environment.

PeopleSoft HRMS implementation, Lead DBA:

 Installation and Configuration of PeopleSoft, Oracle 9.2.0.4, Tuxedo 6.5 /Jolt 1.2, Cobol merant server express 1.1/ 2.0.11on Sun fire V880 Solaris 2.8 with EMC disks setup.
 Installation and configuration of PeopleSoft Upgrade assistant, sqr, crystal reporting server on NT, PeopleSoft tools 8.20.02.Hrms SP1 and portal SP2 application, batch and PIA apache/weblogic web servers on NT and Unix servers.
 Upgraded PeopleSoft 7.0 to 7.5 and to 8 versions on sun e10k sun Solaris 2.6
 Configured employee and enterprise portal Databases, message nodes report nodes for both Portal and Hrms Databases.
 Implemented high availability load balancing setup and standby/ reporting Database
 Created and automated backup procedures and recovery scenarios using veritas netback and rman, shell/awk/perl scripts, Oracle import/export.
 Used Quest live reorg to minimize data fragmentation and contention, and eyewatch for monitoring Database performance.

Oracle Financials Application, Sr. DBA:

 Involved with the infrastructure group in finalizing the Database, Application, LAN and WAN architecture for 11.0.5 NCA with Load Balancing, High Availability, Hot Standby and Reporting Database option for Production.
 Installed and configured Oracle Database 8x/8i, Oracle Developer/2000 1.6.1.
 Installed and configured Oracle Web Server 3.0.1, Apache servers on Sun Solaris 2.6 e10k Servers and OAS 4.0.8(for imaging and bar-coding workflow server (markview 170 systems) On NT servers.
 Installed and configured Oracle Applications 10.7/11.0.5 and 11i versions.
 Migration of 10.7 NCA Applications from Sun Solaris 2.6, Oracle 7.3.4 to 11.0.5 NCA Sun Solaris 2.8 e10k 32-bit Oracle 8.0.6 with Oracle 8.1.7.4 Interoperability.
 Migrated all development instances to NCA environment, Created development instances by cloning copy of production Database.
 Troubleshoot, monitor concurrent manager, workflow batch processes forms/reports servers, java administration and apache web servers.
 Tuned application and database performance using Quest database tools, sql/plsql and shell scripts, defragging tables that are fragmented with Quest live reorg.
 Created and automated backup procedures and recovery scenarios using, shell/awk/perl scripts, Oracle import/export, hot backup and other Oracle tools.

Data Warehouse, Sr. DBA:

 Implemented 3 major Data warehouse environments/instances for PeopleSoft HR, Oracle financials and ICOMS AS400/DB2 database RCN customer billing database on Sun Enterprise 4000 Solaris 5.8 servers and Oracle 8i/9i version databases.
 Designed and developed operational systems and decision support systems (Client/Server & Web environments).
 Responsible for the design, development and management of the star schemas, Oracle Advanced Replication/ snapshots and Materialized Views. Created parallel queries and partitions, bitmap indexes.
 Created the extraction, transformation and cleansing processes required for loading & validating data from multiple sources.
 Reviewing and suggesting corrections for more effective code routines, wrote UNIX shell scripts to verify and cleanse the data prior to loading and PL/SQL scripts to validate data after the load.
 Devised error handling routines that reduce the number of rejected records from as high as 95% to an average of less than 0.5% and automated the data load using dbms_jobs database triggers, SQL*LOADER, shell scripts.

Telephone provisioning system:
This system is completely developed and customized by RCN on oracle 9i database and 9ias application
Server and is the key application for RCN’s Telephone business.
 Installed and configured 9i db with java, xdk and Advanced Queuing features on sun fire v880 server solaris 2.8 OS
 Installed 9ias (9.0.2.1) infrastructure/mid-tire installations and configured https, forms and reports 6i servers.
 Troubleshooting and monitoring propagation in advanced queuing, forms, reports https and other 9ias processes and servers, applied database and application bug fixes and patches.
 Created backup and recovery procedures using RMAN and veritas netback 4.5 and logical export/import backups.
 Performance tuning / monitoring database space, batch jobs, sql ad hock query’s, reorganizing tables and indexes, recompile java classes and other invalid objects using quest database tools (Spotlight, sql expert, livereorg, toad, foglight) sql/plsql, shell, awk and perl scripts.

Clarify E-Front office Application (CRM), Sr.DBA:

IT helpdesk, Network Operational Costs and ETTS (Executive Trouble Ticketing System)
 Clarify ver 10.1 CRM Helpdesk Ticketing Application, is a 24/7-Oracle 8.1.7.4 Database, which handles IT and Network cost centers.
 Installation of Clarify ver 10.1, Setting up Clarify schema and configuring Rulemanager/Rmworker/Notifier and e-mail clerk clarify processes.
 The application and Databases are configured with Tuxedo 7.1 and Apache web servers on e5000 Sun Solaris 2.8 Unix server with raid 2 hardware setup and the Notification clarify processes are configured on e3000 Sun server.
 Developed NOCVIEW read only Oracle OWS 4.x application, with modplsql setup and
Psp scripts, this gives end users ability to view new / pending cases refreshed every 5 minutes
 Used clarify admin tools for creating schemas, purg/archave cases and for data extraction and loading process (makdb, dataex), PeopleSoft / clarify and lotus notes interface scripts

DB2 Web Selfcare:

Web selfcare is an online self service application for customers to view, upgrade and order new products and services that RCN provides as well as pay and view bills online
 Installation of DB2 UDB Servers and Clients on sun e5K Solaris 2.8 and Windows NT/2000 operating systems for Production, QA, and Test environments and Websphere 3.7 on NT server. Establish client connectivity using CCA/CLP. Applied most recent Fixpacks for the database server and clients.
 Upgraded database servers from version 7.2 to version 8. Configured instances and Database parameters for Performance. Implementation of Database Security, Creation of Users. Groups and granting/revoking of privileges.
 Perform Online and Off-line Backups scheduled in cronjob. Review requirements for new tables & indexes for enhancement projects. Run maintenance jobs like Reorgchk, Reorg, and Runstats using scheduled cronjobs. Reorgchk Analysis for Table and Index Statistics. Run consistency checks and fixing any database corruption problems
 Perform Export, Import/Load of data. Also Migrate data from one region to another i.e. Test, QA, Prod.
 Troubleshooting on Unix in relation to database performance as well as database and connectivity problems.
 Sizing and Capacity Planning (i.e. Sizing a Server Application as well as DB2 UDB Database in terms of Memory Consumption) to avoid Memory Shortage Failure.
 Used database utilities (i.e. db2look, db2move, db2dart, db2advis, db2exfmt, db2batch, db2adutl, export/import utilities, etc.) in migrations and for day-to-day maintenance tasks.

Primus knowledge Base Web Application, Sr.DBA:

Primus knowledge base application (eServer 4.0.b/ 5.0) is a Help Database for external and internal users. This application handles call centers with precise information to trouble shoot customer service problems and as a self service for the customers on net to trouble shoot and fix there service issues users with general and critical help information on all the applications and trouble service solutions for end users.
 Installed Primus application eServer 5.1/Perl 5.0.5 on Unix, Configured Primus application server processes and created primus schema in Oracle 8.1.7.4.0 database on Sun e450 Solaris 2.7 server with DMZ firewall configuration for external end user interface.
 Created perl shell scripts using primus admin tools Solnx to up load new solutions from development, testing database to production instance and scripts to track license usage
 Used statuspack for db tuning and analyze database for query performance
 Upgraded application from 4.0.b to 5.1 and Oracle databases from 8.0.6 to 8.1.7 versions

Convergent Billing and Operational Support System (CBOSS) Sr.DBA:

This is an Operational support system that provides Customer Care, service provisioning and Billing for its Internet Service Provider business.
 Installation, Configuration and Administration of CBOSS.
 The application is integrated with active worker adopters' middleware, which is the central database for communication between clarify and kenan databases.
 Kenan production database is configured on sun e10k server with sun High available fail over cluster, middleware and clarify databases are configured on different e10k server domain.

Newcort Services, Parsippany, NJ Feb 99 – Sep 99
Senior Oracle& PeopleSoft DBA
Implementation Of PeopleSoft HRMS
Environment: Oracle 7.3/8.0.5, PeopleSoft 7.5, Unix, and Windows NT/ Windows 95.

I have worked as the consulting DBA, Providing System administration, security administration and DBA expertise for implementations, upgrades and maintenance of Oracle and PeopleSoft HR Production System (v 7.5)
 Configuration and administration of PeopleSoft applications on Oracle 8.0.5 database.
 Designed the Database Change Control System, which supports, separates, integrates & protects 9 Oracle PeopleSoft Database instances.
 Implemented Backup procedures and recovery scenarios, replication setup, query, batch / application performance tuning, monitoring and troubleshooting of Oracle / PeopleSoft Systems using software like (Iwatch, Instance-monitor, Space-manager, Sqllab-expert, foglight, Toad).
 Performed Peopletools upgrade, custom project migrations and applied maintenance patches.
 Installation, configuration and support of three-tier / two-tier Application on NT and Unix servers and work stations
 Provide effective ‘close range’ DBA support to the Development Team, HR Users Group and Operations Group.

Celestial Technologies Ltd, India. Jun 95 – Jan 99
DBA/ Programmer – Analyst
Environment: Oracle 7.x, Developer/2000, Designer/2000 1.x/2.x, SunOS, Windows NT 4.0 and Windows 95.

While with this employer, worked on multiple different projects. Designed and developed multiple different database management systems, Met with users and performed requirements gathering, Wrote stored procedures, Database triggers, and functions in PL/SQL and SQL Queries and Sub queries to disseminate information, Used Explain Plan TKPROF Utility to tune SQL.

Integrated Human Resource Management System, Reserve Bank of India, India
 Creation of primary data storage structures, tables, indexes, users, profiles, triggers and Database links, Maintenance of Rollback segments and Redo logs, reorganization of Databases.
 Perform backups and recovery, monitoring and optimizing the performance of the Database, Performed internal tuning with memory allocation.
 Designed and developed the following modules
Book Grant & News Paper Module, Employee Attendance & Leave Module, Loan Management Module, Medical Module, Gratuity Module and Salaries Module. Involved in system integration, system testing and documentation.

Goldstone Engineering Ltd. An ISO 9002 Company. India, Integrated Operations System
 Designed and developed a Database management system.
 Identification and documentation of business requirements, processes, functions using
Data Modeling and Process Modeling techniques.
 Maintain flow of information by Design and implementation of a Relational Database Structure, various stored procedures, Database triggers, Functions such as Figure to Word conversion, Conversion of Unit of Measurement, Currency conversion Function etc were written in PL/SQL.
 Developed three main modules viz. Purchase & inventory, Sales & Marketing and Payroll.

Inventory Management System: The System Involved an important role in tracking down the various levels of bulk storage of different products and their stocks status by automatically updating their stock levels depending on predetermined levels of stocking and also reporting the re-order levels

Portfolio Management System: The Portfolio Management System is designed to manage all the activities related to the Shares of a company.

Financial Accounting System: This is a batch-processing system, which accepts invoice, purchase order, debit advice, credit advice, bank payment, bank receipts, cash payments, cash receipts and journal voucher in different batches.
Previous Topic: Oracle Apps Oregon
Next Topic: Oracle HRMS Functional Consultants
Goto Forum:
  


Current Time: Thu Mar 28 11:11:52 CDT 2024