We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

SUMMARY

  • Technically sophisticated & result driven Oracle 10g Certified Associate with 8 years of professional experience in Database Administration.
  • Spearheading the effort with Confidential Wireless as an Oracle RAC Database Administrator.
  • Involved in Installation, Configuration, Patching, Space Management, Starting and stopping and Monitoring Database Server, Troubleshooting in Backup, Optimizing performance tuning on Databases in high availability Production Environments.
  • Demonstrated problem analysis/ resolution skills, ability to troubleshoot, solve problems quickly & completely.
  • Independently handled multiple databases for multiple clients (Leveraged) in multiple environments.

TECHNICAL SKILLS

Database: Oracle Database 10g/11g/12c, Oracle Apps

Database Tools: Oracle Enterprise Manage(OEM), OUI, Migrations, DB control/Grid Control, RMAN, SQL Developer, Oracle, Export/Import(IMPDP & EXPDP), Oracle Database Assistance, TKPRPF, SQL Plus, ISQL Plus,Golden Gate, Exadata

Operating Systems: SQL server 2008, SQL server 2014,Windows 2000/03 Server, Windows XP, IBM AIX, Confidential UX, Solaris

Programming Skills: PL /SQL programming,, Shell Scripting in UNIX,LINUX

PROFESSIONAL EXPERIENCE

Confidential

Oracle database administrator

Responsibilities:

  • Participate in Change Management meeting, Taking ownership in giving RCA of critical issues.
  • Oracle Enterprise Manager (OEM) installation and Administration 12C, 13C.
  • Experienced in troubleshooting and decision making knowledge on Mission critical issues during bridge call.
  • Oracle 11g config, administration, troubleshooting.
  • Capacity planning, database architecture/design for 11g databases.
  • Performance tuning for production databases .
  • RMAN Backup and Recovery - Standalone and RAC; Physical Standby Database and Active Data guard Standalone and RAC.
  • Oracle DBA responsibility for all L1, L2 & L3 tasks including monitoring, maintenance, user management, refresh, data pump.
  • Making structural changes to the databases
  • Routine dbase tuning & administrative activities
  • Planning and executing of db maintenance activities like dump & load, index rebuild, databases health checkup
  • Administrating in Golden gate .
  • Create shell scripts to automate/monitor dbase operations
  • Providing test databases to application, development and testing team based on request.
  • Optimizing the performance of production databases.

Confidential

Oracle RAC Database Administrator

Responsibilities:

  • Administrating and Maintenances of 24*7 production databases.
  • Oracle DBA responsibility for all L2 & L3 tasks including monitoring, maintenance, user management, refresh, data pump, New server build up projects .
  • Installation and configuration of oracle 11g/12c databases.
  • Planning and Implementation of various data guard and Physical standby setup with switchover and failover tests in Production environments
  • Golden Gate activates of the live databases for testing and development.
  • Database up gradation and migrations.
  • Creation of monitoring tools and automated DBA tasks using shell scripts.
  • Installation of Oracle 10g and Patch installation in AIX and LINUX
  • Implementation of Data Guard on LINUX.
  • Experience on RAC environment and hand on practice.
  • Conceptual knowledge of RAC environment.
  • Installation of Grid control and oracle client 11g.
  • Implementation of RMAN backup & recovery procedures.
  • Database creation, migration &up gradation.
  • Making structural changes to the databases.
  • Routine database administrative activities in golden gate.
  • Planning and executing of db maintenance activities like dump & load, index rebuild, databases health checkup.
  • Create shell scripts to automate/monitor dbase operations.
  • Providing test databases to application, development and testing team based on request.
  • Optimizing the performance of production databases.
  • Experienced in troubleshooting and decision making knowledge on Mission critical issues .

Confidential

Oracle RAC Database Administrator

Responsibilities:

  • Verifying backup report and checking backup jobs in crontab.
  • Configuration of RMAN
  • Performing Level0 and Level1 backups
  • Validating the Backup Sets and checking successful and failed backups.
  • Preparing Backup scripts and configuring in different database as per environment.
  • Starting and Stopping Instances and Oracle cluster ware.
  • Backup and Recovery of Voting Disk and OCR.
  • Adding and Deleting Nodes.
  • Running manual gather stat job weekly basis.
  • Migrations of data files from one mount point to another.
  • Oracle Client Installation in different database.
  • OUI used for grid control.
  • Installation of OUA in production environment.

Confidential

Oracle RAC Database Administrator

Responsibilities:

  • Monitoring the nodeapps status of multiple rac databases.
  • Checking the status of backups for node apps.
  • Experience on ASM and Exadata
  • Starting and Stopping Instances and Oracle cluster ware.
  • Administering OCR and Voting Disk.
  • Backup and Recovery of Voting Disk and OCR.
  • Adding and Deleting Nodes.
  • Running manual gather stat job weekly basis.
  • Migration of database from Non ASM to ASM end.
  • Experience in PL/SQL Programming

Hire Now