DevOps Job description  

 

1. Teamcity CI/CD tool for Sub projects configuration
2. Artifacts based Deployment -   Reports / DM Migration - Import Report to target SaaS environment using SOAP Web services. CURL Command is used to call SOAP Web service

                                                  

2. OIC components deployment – Integrations, Lookups, Packages (Automation) - Download integration file of specified version for upstream env from nexus using curl command in working directory of agent. Import integration file to mentions OIC environment using REST API called using curl command.

 

3. Database Components – Deployment of DB code from GITLAB to DB with the help of backend config with SSH Key and private key setup

 

4. FAH Components – Onprem data Migration - Copy mentioned directory to FAH Server using WinSCP command, Change owner and group owner of directory

      Convert shell script file to UNIX format using plink command

      Run shell script from subdirectory selected.

 

2. Deployment of LACLS patches based on Updation quarterly

                                                              i.      SAAS Components- (BIP Reports, Data Models, RTF Templates)

                                                            ii.      PAAS Components - Packages( corresponding Integrations- Activated), 

1. DB components – (Tables, Sequence, View, Grant, synonym, Constraints, sql, 
                                                                            type index, plcy,Package specification, package Body, triggers)

3. Scheduling of Reports on Incremental and full load basis

 

4. DBCS agent Connectivity - The agent should be installed on DB host

 

5. Creation of Directories/folder and granting permission’s into DB server through Putty

6. Deployment, Scheduling of Integration and configuring the Lookup’s /Connections in OIC( oracle integration Cloud), Enabling business event via postman for integrations.

7. Scheduling jobs and tasks as per requirements in ERP ( Oracle SaaS).

8. Sandbox creation and Validation 

9. PGP key generation - Extraction of certificates

10. . Certificate Updation on DB for Oracle Fusion(SAAS) / Oracle Integration Cloud (PAAS)
11. Migration of BIP Reports, Data Models and Artifacts with the help of NEXUS Repository – Code Commit with the help of Power shell from Local to Nexus Repository

 

Tools – TeamCity, Gitlab, Nexus, Putty, Puttygen, Key Explorer, Open SSL

 

Shell Scripting, UNIX, SQL