Skill-Profil eines fest angestellten Mitarbeiters des Dienstleisters
English
Verhandlungssicher
German
Grundkenntnisse
Einsatzorte
Einsatzorte
D-60329 (+200km)
Deutschland
möglich
Projekte
Projekte
11 Monate
2023-10 - heute
Infrastructure Architect and Administrator.
Infrastructure Architect and Administrator. Oracle Databases 11g12.112.2...
Infrastructure Architect and Administrator.
Understanding and the current infrastructure and preparing a solution design of infrastructure to enhance security and compliance.
Capacity planning and provisioning of new hardware like servers, storage etc. based on current usage and keeping future growth in mind.
Preparing technology stack for the new infrastructure design that includes Network file servers, Hypervisor, Operating system, orchestration tools (Kubernetes), containerization tools (containerd) monitoring tool, file server etc.
Provisioning new infrastructure that includes setting up applications, databases, and file servers with high availability and fault tolerance with redundant standby systems in primary datacenter and disaster recovery site.
Creating a migration plan for applications, services, and databases from old infrastructure to new in an efficient and least intrusive manner so to have minimal to no impact on business users and meticulously executing said plan.
Integrating new services into the monitoring tools and provisioning new ones as per requirement.
Providing support for new infrastructure and troubleshooting any issues.
Oracle database migration from on-prem to Oracle cloud.
Oracle RAC and EXADATA administration.
Implemented various backup and recovery scenarios using RMAN.
Setup Physical standby database (DATA GUARD).
Testing production database disaster recovery scenario.
Table/Schema refresh from production to test/dev environment using data pump utility.
Database refresh using rman and clod backups.
Generating explain plans and SQL tuning advisor to understand the query execution and performance bottlenecks.
Performed database patching and applying Oracle quarterly CPU patches.
Oracle database and client software installation.
Written multiple shell scripts in Linux environment and scheduled in crontab and OEM to automate regular activities like backups, monitoring locks and long inactive sessions in database etc.
Develop RPA process to automate business processes using UiPath tool.
Maintaining and supporting RPA process in production system.
Enhancements to existing process to extend or improve performance and functionality.
RPAUiPath
PwC
India
2 Jahre 5 Monate
2014-12 - 2017-04
Oracle DBA
Oracle DBA Oracle Databases 11g12.112.2...
Oracle DBA
Upgraded Oracle database 11gR1/11gR2 to 12c.
Setup Physical standby database (DATA GUARD) for multiple production system.
Setup of LAB environment for testing production database disaster recovery scenario.
Mock testing disaster recovery scenarios with database switchover and failover to DR site
Maintainedprod and non-prod Oracledatabases on physical and cloud environment.
Migration of Oracle databases from on premise to Cloud.
Table/Schema refresh from production to test/dev environment using data pump utility.
Generating explain plans and SQL tuning advisor to understand the query execution and performance bottlenecks on both on premise and cloud environments.
Performed database patching and applying CPU patches.
Managed multiple production and test Oracle applications environments of different releases (11i and R12)
Performed database upgrade from Oracle 11gR1 to 11gR2.
Involved in various DBA activities like installation, monitoring, patching, and performance monitoring.
Responsible for backup, recovery and other activities of 11i/R12 application.
Oracle applicatios cloning from PROD to DEV/TEST environment.
Installaled and configured Oracle 10g Application server and weblogic server for third party applications like sabrix,synchro, vertex, markview etc.
Implemented OATM model.
Involved in Oracle database backups and recovery and workedwith RMAN.
Performed clonning using RMAN backups(using duplicate).
Troubleshootedthe long running concurrent requests.
Performed data encryption in tables using Ingrian tool.
Performed critical CPU patching.
Exported and imported the data in different servers.
Worked on various application tools like adadmin, adctrl , opatch.
Scheduled crontab for backup, shutdown the database, startup database.
Created simple shell scripting for Unix and Linux environment systems.
Performed troubleshooting for issues related to the Oracle application environments.
InternationalProjects
Automated Sourcing process using RPA (UiPath) to scrape job portals online for a JD and prepares a list of matching profiles along with score to indicate most relevant profile.
Automated high-volume configuration tasks in Oracle cloud using UiPath.
Infrastructure Architect and Administrator. Oracle Databases 11g12.112.2...
Infrastructure Architect and Administrator.
Understanding and the current infrastructure and preparing a solution design of infrastructure to enhance security and compliance.
Capacity planning and provisioning of new hardware like servers, storage etc. based on current usage and keeping future growth in mind.
Preparing technology stack for the new infrastructure design that includes Network file servers, Hypervisor, Operating system, orchestration tools (Kubernetes), containerization tools (containerd) monitoring tool, file server etc.
Provisioning new infrastructure that includes setting up applications, databases, and file servers with high availability and fault tolerance with redundant standby systems in primary datacenter and disaster recovery site.
Creating a migration plan for applications, services, and databases from old infrastructure to new in an efficient and least intrusive manner so to have minimal to no impact on business users and meticulously executing said plan.
Integrating new services into the monitoring tools and provisioning new ones as per requirement.
Providing support for new infrastructure and troubleshooting any issues.
Oracle database migration from on-prem to Oracle cloud.
Oracle RAC and EXADATA administration.
Implemented various backup and recovery scenarios using RMAN.
Setup Physical standby database (DATA GUARD).
Testing production database disaster recovery scenario.
Table/Schema refresh from production to test/dev environment using data pump utility.
Database refresh using rman and clod backups.
Generating explain plans and SQL tuning advisor to understand the query execution and performance bottlenecks.
Performed database patching and applying Oracle quarterly CPU patches.
Oracle database and client software installation.
Written multiple shell scripts in Linux environment and scheduled in crontab and OEM to automate regular activities like backups, monitoring locks and long inactive sessions in database etc.
Develop RPA process to automate business processes using UiPath tool.
Maintaining and supporting RPA process in production system.
Enhancements to existing process to extend or improve performance and functionality.
RPAUiPath
PwC
India
2 Jahre 5 Monate
2014-12 - 2017-04
Oracle DBA
Oracle DBA Oracle Databases 11g12.112.2...
Oracle DBA
Upgraded Oracle database 11gR1/11gR2 to 12c.
Setup Physical standby database (DATA GUARD) for multiple production system.
Setup of LAB environment for testing production database disaster recovery scenario.
Mock testing disaster recovery scenarios with database switchover and failover to DR site
Maintainedprod and non-prod Oracledatabases on physical and cloud environment.
Migration of Oracle databases from on premise to Cloud.
Table/Schema refresh from production to test/dev environment using data pump utility.
Generating explain plans and SQL tuning advisor to understand the query execution and performance bottlenecks on both on premise and cloud environments.
Performed database patching and applying CPU patches.
Managed multiple production and test Oracle applications environments of different releases (11i and R12)
Performed database upgrade from Oracle 11gR1 to 11gR2.
Involved in various DBA activities like installation, monitoring, patching, and performance monitoring.
Responsible for backup, recovery and other activities of 11i/R12 application.
Oracle applicatios cloning from PROD to DEV/TEST environment.
Installaled and configured Oracle 10g Application server and weblogic server for third party applications like sabrix,synchro, vertex, markview etc.
Implemented OATM model.
Involved in Oracle database backups and recovery and workedwith RMAN.
Performed clonning using RMAN backups(using duplicate).
Troubleshootedthe long running concurrent requests.
Performed data encryption in tables using Ingrian tool.
Performed critical CPU patching.
Exported and imported the data in different servers.
Worked on various application tools like adadmin, adctrl , opatch.
Scheduled crontab for backup, shutdown the database, startup database.
Created simple shell scripting for Unix and Linux environment systems.
Performed troubleshooting for issues related to the Oracle application environments.
InternationalProjects
Automated Sourcing process using RPA (UiPath) to scrape job portals online for a JD and prepares a list of matching profiles along with score to indicate most relevant profile.
Automated high-volume configuration tasks in Oracle cloud using UiPath.