Job Description
Senior project manager
Job Summary
-
Location: Texas
-
Project role: Senior project manager
-
Skills: Oracle PeopleSoft Functional_CRM
-
No. of positions: 1
Job description:
Install Supported MSSQL Software
Prepare the Environment : Ensure your system meets the hardware and software requirements for MSSQL Server installation.
Configure SQL Server : Set up SQL Server configuration options such as authentication mode (Windows or Mixed Mode), instance configuration, and SQL Server services.
Create DB with Scripts Provided by PeopleSoft
Review Scripts : Obtain and review the database creation scripts provided by PeopleSoft.
Execute Scripts : Connect to the MSSQL Server instance using SQL Server Management Studio (SSMS) or a similar tool. Execute the scripts to create the PeopleSoft database and its initial schema.
Install PeopleSoft Client
Download the PeopleSoft client installation files from the Oracle website or your PeopleSoft software vendor.
Ensure that the target machine meets the system requirements for the PeopleSoft client.
Execute the PeopleSoft client installer and follow the on-screen instructions to complete the installation process.
Configure App Designer and Data Mover
Open the PeopleSoft Configuration Manager and set up the App Designer by specifying the connection parameters for the PeopleSoft environment.
Configure Data Mover with the necessary connection details to interact with the PeopleSoft database.
Uninstall Oracle Client Software
Run Data Mover Scripts to Create Tools Database
Locate the Data Mover scripts provided by PeopleSoft for creating the Tools database.
Launch Data Mover and execute the scripts to create and configure the PeopleSoft Tools database.
Use Data Mover to Dump Application Data
Use Data Mover to export the application data from the current PeopleSoft environment. This process typically involves running Data Mover in export mode to generate .DAT files containing the data.
Use Data Mover Scripts to Upload Data into MSSQL Server
Ensure that the exported .DAT files are available and accessible.
Use Data Mover to run the provided scripts and import the application data into the newly created MSSQL Server database. This process involves running Data Mover in import mode.
Reconfigure App and Web Servers
Modify the configuration files of the PeopleSoft application server and web server to point to the new MSSQL Server database.
Ensure that the application server and web server can successfully connect to the new database.
Apply the configuration changes and restart the application and web servers.
Boot the Systems
Sequentially restart the database server, application server, and web server.
Ensure all PeopleSoft services are up and running without errors.
Conduct basic functionality tests to verify that the PeopleSoft environment is operating as expected
Disclaimer
HCL is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to secure@hcl.com for investigation.