Oracle Database Administration with OCP Professional and Have the knowledge of CyberSecurity which adds security knowledge to the database team.
Aktualisiert am 13.12.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 16.12.2024
Verfügbar zu: 100%
davon vor Ort: 100%
Oracle Database Administration
IT-Security
RHEL-Administration
Oracle Software Installation
Database Creation
RAC Administration
RMAN Backup
Shell-Script
Cloning Oracle Database
Shell Automation
Database Migration
RMAN Cloning Database

Einsatzorte

Einsatzorte

Berlin (+50km)
Deutschland, Schweiz
möglich

Projekte

Projekte

3 years 9 months
2019-11 - 2023-07

Designing the architects

Senior Professional I.
Senior Professional I.
  • Designing the architects of the RDBMS databases (9i, 10g, 11g, 12c, 19c) Linux/Unix Environment.
  • Responsible for the Entire production databases (9i, 10g, 11g, 12c) Linux/Unix Environment.
  • Upgraded databases from 9i to 10g, 10g to 11g, and higher versions.
  • Critical CPU Patch Update. SAN Storage ASM Disk extension
  • Managing Multitenant, CDB, PDB 12c databases plugging and unplugging the databases for smooth operations.
  • Automation of RMAN Backup, expdp backups, Shell Scripting
  • Monitoring (Checkmk/mk_oracle), troubleshooting and performance tuning for maximum availability of data
  • Involved in the Migration of Oracle Database to AWS Cloud.
  • Managing Oracle Exadata X4 11gR2
  • Delivered application services as per ITIL standards.
Altran Germany SAS & Co. KG
3 years 1 month
2016-07 - 2019-07

Experience in installing, configuring, modifying, and maintaining

Lead Administrator
Lead Administrator
  • Experience in installing, configuring, modifying, and maintaining Oracle 10g/11g/12c Relational Database Management Systems in various Platforms
  • Standby database and Primary Database Switch over activities
  • Oracle Real Application Cluster (RAC), Automatic Storage Management (ASM), Grid Control, Performance Tuning, Backup Recovery, SQL Tuning. CPU Critical Patch Update
  • Upgraded databases from 9i to 10g, 10g to 11g, and higher versions. Flash recovery Storage area extension.
  • Oracle Exadata-X4 11gR2. Shell Scripting
  • Improved performance of Self-Services from 40 min to 2 mins by fine-tuning PL/SQL code used.
  • Hands on experience in knowledge of data modeling and database design.
  • Delivered application services as per ITIL standards.
Wipro Ltd.
India
1 year 6 months
2015-01 - 2016-06

Having deep knowledge and Hands on experience

Senior Oracle Consultant
Senior Oracle Consultant
  • Having deep knowledge and Hands on experience in Oracle Real Application Cluster (RAC), Automatic Storage Management (ASM), Grid Control, Performance Tuning, Backup Recovery, SQL Tuning.
  • Achieved a business continuity plan by implementing high availability solution Oracle Data Guard.
  • Advanced new and existing projects by creating test and development environments, cloning production databases and applying data mask.
  • Successfully complied with internal & external IT audit requirements with respect to security and procedures.
  • Migration of Oracle Databases to the local cloud environment using RMAN Backup tool
  • Secured databases and applications against single disk failure by configuring hardware RAID.
Petrofac Information Services Ltd.
India
3 years 8 months
2011-06 - 2015-01

Increased databases Security through CPU Patch

Assistance Consultant
Assistance Consultant
  • Increased databases Security through CPU Patch, user management and upgrading to the latest database version.
  • 100% business continuity efforts with backup and recovery of data using RMAN, logical backups and cold backups.
  • Setup Data Guard Broker to manage data guard environment in Various Banking and Insurance Domains.
  • Trouble-shooting different issues like Archive Transport issues andlog applying issues  at DR Site.
  • Improved database & application performance benefits by tuning OS kernel parameters, DB initialization parameters, memory, and I/O.
  • Managed Exadata
  • Effectively handled PRODUCTION tickets and fixed issues as per the SLA with accurate decisions by identifying root causes and fixing the same.
  • Prepared documentation for upgrade database activities.
TCS Limited.
India
1 year 2 months
2010-05 - 2011-06

Proactively improved performance of the application

Technical Associate (DBA)
Technical Associate (DBA)
  • Proactively improved performance of the application by initiating regular meetings with the development and application teams by revisiting time intensive PL/SQL code.
  • Automated periodic task using crontab, Unix shell scripting programming and debugging, configured database tools to monitor & manage database effectively.
  • Successfully complied with the database license matrix and made sure features being licensed are in use.
  • Ensured database has no security vulnerabilities and protect against intruders and deciding what database components to audit and how granular this auditing should be.
  • Facilitated testing cycles by loading and importing data from different databases using data pump and SQL*Loader.
Mphasis Limited
India

Aus- und Weiterbildung

Aus- und Weiterbildung

2004:

Computer Application

Master of Computer Application (MCA)

Currently pursuing Cyber Security in Arden University


CERTIFICATIONS

Oracle Certified Professional 9i

(OCP) ? Oracle University USA


Oracle Certified Professional 10g

(OCP) ? Oracle University USA


Oracle Cloud Infrastructure Foundations 2021 Certified

Associate ? Oracle University USA

Kompetenzen

Kompetenzen

Top-Skills

Oracle Database Administration IT-Security RHEL-Administration Oracle Software Installation Database Creation RAC Administration RMAN Backup Shell-Script Cloning Oracle Database Shell Automation Database Migration RMAN Cloning Database

Produkte / Standards / Erfahrungen / Methoden

Oracle Database 10g/11g/12c/19c Installing, configuring, modifying & maintaining
OracleData guardconfiguration. Critical CPU Patch Update
Building & Implementing Backup Policies using RMAN, Cold and Logical Backups
Performance Tuning, ADDM, AWR, Explain plan
SQL, PL/SQL, Unix/Linux Shell Scripting and debugging
Oracle Flashback Technology, Hands on knowledge in RAC, ASM, Cluster environment
Oracle Data pump, Oracle Exadata
Oracle Enterprise Manager & AWS Cloud Control
Patching, Cloning, Upgrading & Migrating Oracle Databases
Linux/Unix System Administration, RHEL/OEL 5/6/7, Solaris 10/11
Knowledge of MySQL & PostgreSQL
Excellent Communication and Written Skills, pursuing German

PROFILE

  • Currently pursuing cyber security in Arden University ? Berlin, Germany.
  • Oracle Cloud Infrastructure Foundations 2021 Certified Associate, Oracle Certified Professional (OCP) 9i/10g Database Administrator with experience of 12+ years as Oracle DBA in installing, configuring, modifying, and maintaining Oracle 9i, 10g, 11g, 12c, 19c Relational Database Management System, ASM, RAC, Cluster, Oracle Enterprise Manager (OEM) Grid Control, PLSQL, Unix Shell Script Programming and debugging Administration and Project Management experience. Enhanced Databases and application landscapes by adding forward-looking advance solutions & features that reflect business objectives.
  • Successfully administered 24/7 databases on multiple platforms and infrastructure in Banking, Insurance Domains. Excellent Linux administration skills with experience across a wide variety of systems, organizations and ITIL practices.


COMPETENCES

  • Installing, configuring, modifying, and maintaining Oracle 10g/11g/12c/19c Relational Database Management Systems and Oracle Enterprise Manager Grid Control 10g/11g on various platforms
  • Experience in Oracle Real Application Clusters (RAC), Oracle Automatic Storage Management (ASM), PLSQL and Unix shell script programming and debugging.
  • Enhancing Oracle Database landscape with High availability feature Data Guard.
  • Capacity planning & Performance tuning of Oracle Database to optimal standards.
  • Database Backup, RMAN data and recovery Procedures.
  • Security, authentication and audits.
  • Data Extraction, transformation, and loading.
  • Exadata


ACHIEVMENTS

  • Maintained performance and database security by monitoring and controlling access in 24/7 environment with 25-30 simultaneous users at a given time.
  • Developed, tested and maintained a Disaster Recovery plan proving beneficial using Data Guard Broker in a 11gR2 environment between multiple data centers.
  • Monitored resource utilization from both database and O/S level and upgraded hardware, database and maintaining 99.5% object reliability and 99.70% database uptime.
  • Designed and streamlined process with approvals on how code should be promoted in production with best backup and recovery solutions. 

Einsatzorte

Einsatzorte

Berlin (+50km)
Deutschland, Schweiz
möglich

Projekte

Projekte

3 years 9 months
2019-11 - 2023-07

Designing the architects

Senior Professional I.
Senior Professional I.
  • Designing the architects of the RDBMS databases (9i, 10g, 11g, 12c, 19c) Linux/Unix Environment.
  • Responsible for the Entire production databases (9i, 10g, 11g, 12c) Linux/Unix Environment.
  • Upgraded databases from 9i to 10g, 10g to 11g, and higher versions.
  • Critical CPU Patch Update. SAN Storage ASM Disk extension
  • Managing Multitenant, CDB, PDB 12c databases plugging and unplugging the databases for smooth operations.
  • Automation of RMAN Backup, expdp backups, Shell Scripting
  • Monitoring (Checkmk/mk_oracle), troubleshooting and performance tuning for maximum availability of data
  • Involved in the Migration of Oracle Database to AWS Cloud.
  • Managing Oracle Exadata X4 11gR2
  • Delivered application services as per ITIL standards.
Altran Germany SAS & Co. KG
3 years 1 month
2016-07 - 2019-07

Experience in installing, configuring, modifying, and maintaining

Lead Administrator
Lead Administrator
  • Experience in installing, configuring, modifying, and maintaining Oracle 10g/11g/12c Relational Database Management Systems in various Platforms
  • Standby database and Primary Database Switch over activities
  • Oracle Real Application Cluster (RAC), Automatic Storage Management (ASM), Grid Control, Performance Tuning, Backup Recovery, SQL Tuning. CPU Critical Patch Update
  • Upgraded databases from 9i to 10g, 10g to 11g, and higher versions. Flash recovery Storage area extension.
  • Oracle Exadata-X4 11gR2. Shell Scripting
  • Improved performance of Self-Services from 40 min to 2 mins by fine-tuning PL/SQL code used.
  • Hands on experience in knowledge of data modeling and database design.
  • Delivered application services as per ITIL standards.
Wipro Ltd.
India
1 year 6 months
2015-01 - 2016-06

Having deep knowledge and Hands on experience

Senior Oracle Consultant
Senior Oracle Consultant
  • Having deep knowledge and Hands on experience in Oracle Real Application Cluster (RAC), Automatic Storage Management (ASM), Grid Control, Performance Tuning, Backup Recovery, SQL Tuning.
  • Achieved a business continuity plan by implementing high availability solution Oracle Data Guard.
  • Advanced new and existing projects by creating test and development environments, cloning production databases and applying data mask.
  • Successfully complied with internal & external IT audit requirements with respect to security and procedures.
  • Migration of Oracle Databases to the local cloud environment using RMAN Backup tool
  • Secured databases and applications against single disk failure by configuring hardware RAID.
Petrofac Information Services Ltd.
India
3 years 8 months
2011-06 - 2015-01

Increased databases Security through CPU Patch

Assistance Consultant
Assistance Consultant
  • Increased databases Security through CPU Patch, user management and upgrading to the latest database version.
  • 100% business continuity efforts with backup and recovery of data using RMAN, logical backups and cold backups.
  • Setup Data Guard Broker to manage data guard environment in Various Banking and Insurance Domains.
  • Trouble-shooting different issues like Archive Transport issues andlog applying issues  at DR Site.
  • Improved database & application performance benefits by tuning OS kernel parameters, DB initialization parameters, memory, and I/O.
  • Managed Exadata
  • Effectively handled PRODUCTION tickets and fixed issues as per the SLA with accurate decisions by identifying root causes and fixing the same.
  • Prepared documentation for upgrade database activities.
TCS Limited.
India
1 year 2 months
2010-05 - 2011-06

Proactively improved performance of the application

Technical Associate (DBA)
Technical Associate (DBA)
  • Proactively improved performance of the application by initiating regular meetings with the development and application teams by revisiting time intensive PL/SQL code.
  • Automated periodic task using crontab, Unix shell scripting programming and debugging, configured database tools to monitor & manage database effectively.
  • Successfully complied with the database license matrix and made sure features being licensed are in use.
  • Ensured database has no security vulnerabilities and protect against intruders and deciding what database components to audit and how granular this auditing should be.
  • Facilitated testing cycles by loading and importing data from different databases using data pump and SQL*Loader.
Mphasis Limited
India

Aus- und Weiterbildung

Aus- und Weiterbildung

2004:

Computer Application

Master of Computer Application (MCA)

Currently pursuing Cyber Security in Arden University


CERTIFICATIONS

Oracle Certified Professional 9i

(OCP) ? Oracle University USA


Oracle Certified Professional 10g

(OCP) ? Oracle University USA


Oracle Cloud Infrastructure Foundations 2021 Certified

Associate ? Oracle University USA

Kompetenzen

Kompetenzen

Top-Skills

Oracle Database Administration IT-Security RHEL-Administration Oracle Software Installation Database Creation RAC Administration RMAN Backup Shell-Script Cloning Oracle Database Shell Automation Database Migration RMAN Cloning Database

Produkte / Standards / Erfahrungen / Methoden

Oracle Database 10g/11g/12c/19c Installing, configuring, modifying & maintaining
OracleData guardconfiguration. Critical CPU Patch Update
Building & Implementing Backup Policies using RMAN, Cold and Logical Backups
Performance Tuning, ADDM, AWR, Explain plan
SQL, PL/SQL, Unix/Linux Shell Scripting and debugging
Oracle Flashback Technology, Hands on knowledge in RAC, ASM, Cluster environment
Oracle Data pump, Oracle Exadata
Oracle Enterprise Manager & AWS Cloud Control
Patching, Cloning, Upgrading & Migrating Oracle Databases
Linux/Unix System Administration, RHEL/OEL 5/6/7, Solaris 10/11
Knowledge of MySQL & PostgreSQL
Excellent Communication and Written Skills, pursuing German

PROFILE

  • Currently pursuing cyber security in Arden University ? Berlin, Germany.
  • Oracle Cloud Infrastructure Foundations 2021 Certified Associate, Oracle Certified Professional (OCP) 9i/10g Database Administrator with experience of 12+ years as Oracle DBA in installing, configuring, modifying, and maintaining Oracle 9i, 10g, 11g, 12c, 19c Relational Database Management System, ASM, RAC, Cluster, Oracle Enterprise Manager (OEM) Grid Control, PLSQL, Unix Shell Script Programming and debugging Administration and Project Management experience. Enhanced Databases and application landscapes by adding forward-looking advance solutions & features that reflect business objectives.
  • Successfully administered 24/7 databases on multiple platforms and infrastructure in Banking, Insurance Domains. Excellent Linux administration skills with experience across a wide variety of systems, organizations and ITIL practices.


COMPETENCES

  • Installing, configuring, modifying, and maintaining Oracle 10g/11g/12c/19c Relational Database Management Systems and Oracle Enterprise Manager Grid Control 10g/11g on various platforms
  • Experience in Oracle Real Application Clusters (RAC), Oracle Automatic Storage Management (ASM), PLSQL and Unix shell script programming and debugging.
  • Enhancing Oracle Database landscape with High availability feature Data Guard.
  • Capacity planning & Performance tuning of Oracle Database to optimal standards.
  • Database Backup, RMAN data and recovery Procedures.
  • Security, authentication and audits.
  • Data Extraction, transformation, and loading.
  • Exadata


ACHIEVMENTS

  • Maintained performance and database security by monitoring and controlling access in 24/7 environment with 25-30 simultaneous users at a given time.
  • Developed, tested and maintained a Disaster Recovery plan proving beneficial using Data Guard Broker in a 11gR2 environment between multiple data centers.
  • Monitored resource utilization from both database and O/S level and upgraded hardware, database and maintaining 99.5% object reliability and 99.70% database uptime.
  • Designed and streamlined process with approvals on how code should be promoted in production with best backup and recovery solutions. 

Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.