PeopleSoft Application Administration & Oracle DataBase Administration


PeopleSoft Application Administration &
Oracle DataBase administration services
for a US based Customer

About the Client

The client is a global network of Professional firms providing Audit, Tax and Advisory services

Business need

The client envisaged to provide Cost Effective PeopleSoft Application administration and Oracle database administration services

Solution delivered

  • Installed and configured PeopleSoft HRMS, Financials and Portal 8.3
  • Migrated 15 Oracle Databases from one data center to another data center
  • Installed and configured Unix/Windows 2000 Servers for People physical 3-tier architecture for Peoplesoft 8.3
  • Installed and configured Oracle 8.1.7(64 bit) on DB and Application Servers
  • Created the Portal databases on database server and loaded the psoft data using data mover
  • Restored databases from taps to the new HP Unix Boxes duly creating file systems and mounting
  • Created scripts for start and stop database, imports and exports etc
  • Created Oracle, psoft users on Database and Apps servers
  • Designed and implemented disk space allocation on Database, Application Servers and File servers
  • Done People Soft Database cloning and fixed the bugs raised in restoration
  • Installed SQR,Tuxedo, Cobol, Crystal Reports, ODBC Drivers
  • Installed and configured Web Server, Internet Architecture on File Server and assigned WSL and JSL Ports
  • Installed people books, verity and chart server
  • Created and Configured Process Schedulers, Apps servers
  • Tested 2-tier, 3-tier, n-tier connectivity for all databases and tested Cobol, crystal, sqr reports, sysaudit, ddaudit and fixed the bugs during the testing
  • Applied OS, Application and Oracle patches

Business benefits

ADU measures static and differential pressures using 2 pressure sensors and impact pressure using the temperature probe (PT-100). ADU transmits these
air data parameters via two identical ARINC 429 digital lines.

Provision is also made to calculate according to pin-program, correct & incorrect air data. ADU has built-in features for self tests to check the hardware and software integrity.

Architecture of ADU is centered on TMS320F2812 DSP chip, which is interfaced with temperature and pressure sensors. DSP performs complex arithmetic based on pressure readings to calculate various aerodynamic parameters.

  • Precisely accurate

Technology stack

  • Oracle 8i
  • HP-UX 11.00
  • Sun Solaris 2.7
  • Windows 2000/NT
  • People Soft HRMS
  • Financials & Portals 7.x/8.x
  • Configuration Manager/Data Mover
  • SQL* Net

Let’s fast-track your next big idea

Recent Posts
Contact Us

If you’d like us to contact you, please fill out the form.

Not readable? Change text. captcha txt