We provide IT Staff Augmentation Services!

Oracle Dba Resume

PROFESSIONAL SUMMARY:

  • Providing DBA support to multiple Cluster and non - Cluster databases in Production, Development Servers in “LINUX” and “WINDOWS” environment.
  • Monitoring and managing day-to-day operations, maintaining Table spaces and CRD files. Monitor Server Activity, Error Log, space usage, and solving problem as needed
  • Strong knowledge on Recovery of the database in case of failures (loss of Control file, loss of Data file(s), loss or crash of Tablespace(s) etc.)
  • Creating Table spaces and data files according to our requirement .Understanding of indexing, portioning, materialized views
  • Familiar with Tablespace level issues.
  • Experienced in Creation of users, grant privileges .
  • Experienced in enabling no archive log to archive log mode.
  • Design and implemented RMAN backup strategy.
  • Having experience in database cloning.
  • Experienced in Backup activities using Export/Import utilities.
  • Having experience in administration DB with OEM
  • Knowledge on Oracle Golden gate.
  • Experienced in Taking HOT Backups daily base and weekly cold backup.
  • Experience in data loading from flat files to oracle tables using SQL* loader.
  • Administration of ASM Instances and ASM Disk groups.
  • Patched and upgraded from lower version to higher version like 10.2.0.2 to 10.2.0.4, 11.2.0.6 to 12.1.0.2 environment.
  • Created high availability services and tested for failover.
  • Configured physical standby database for high availability and disaster recovery and tested for switchover and failover.
  • Administer RAC instances using srvctl, crsctl. Managing oracle RAC and non RAC environment
  • Knowledge on 12C environment.
  • Worked on Log miner, User management, security, privilege, role, and profile.
  • Installed and configured 2 node RAC using raw partitions and ASM.
  • Experienced in Analyzing and SQL Queries for excessive CPU usage, high disk reads / writes and execution plans by using TKPROF EXPLAIN PLAN.
  • Taking AWR, ADDM report for performance tuning.

TECHNICAL SKILLS:

Operating Systems: Red hat Linux, HP-UX, Windows

RDBMS: Oracle 9i/10g/11g/12c

Programming Languages: SQL, PL/SQL, UNIX Shell Script

ETL Tools: SQL Loader

Telnet Tools: Putty

Database Administration:: BACKUP & RECOVERIES, ASM, dataguardSQL LOADER, LOGMINER, CLONING, PACTHING, BASIC PERFORMANCE TUNING, RAC, TOAD TOOL .

Office Tools: : MS Office 03/07/10, Outlook.

PROFESSIONAL EXPERIENCE:

Confidential

Environment: HP-UX and Windows

Versions: Oracle 9i/11g/12C

Oracle DBA

Responsibilities:

  • Implemented and maintaining oracle11g and 12c databases on HP-UX and Windows.
  • Patched and upgraded 11.2.0.6 environment to 12.1.0.2 environment for all PROD and Non-Prod systems.
  • Managing backup and recovery of databases. User management, privilege, role, and profile.
  • Monitoring, Scheduling, planning backup & recovery strategy using hot, cold and RMAN.
  • Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions
  • Tablespace management, User management, Roles and privileges management.
  • Implemented ASM as storage option
  • Administered ASM instance by using SQL*PLUS and ASMCMD command line.
  • Analyzing SQL Queries for excessive CPU usage, high disk reads / writes and execution plans by using ANALYZE, TKPROF and EXPLAIN PLAN.
  • Migrated flat files from different sources into Oracle Database using SQL*Loader.
  • Migrating the data between production and the development database using Oracle utility traditional export/import.
  • Cloning databases through Data pump Exp/Imp, RMAN
  • Generating the database health check reports using Stats pack, AWR, and ADDM.
  • Provide 24*7 support for production environment.
  • Created, administered & maintained SQL Server Databases to Production, Development, Test and Staging Environment for various groups such as Developer, QA, BA, and User.
  • Expertise in database Performance tuning. Monitored the database server performance and if required go for tuning.
  • Experience writing build scripts, DDL and DML

Confidential

Environment: HP-UX and Windows

Versions: Oracle 9i, 11g, 12c

Oracle DBA

Responsibilities:

  • Created and built Oracle 11g Databases
  • Implemented and maintaining oracle11g and 12c databases on HP-UX.
  • Patched and upgraded 11.2.0.6 environment to 12.1.0.2 environment for all PROD and Non-Prod systems.
  • Created high availability services and tested for failover.
  • Managing backup and recovery of databases.
  • Monitoring, Scheduling, planning backup & recovery strategy using hot, cold and RMAN.
  • Tablespace management, User management, Roles and privileges management.
  • Installed and configured 2 node RAC
  • Administered the RAC databases using CRSCTL and SRVCTL utilities.
  • Implemented ASM as storage option for the RAC database.
  • Administered ASM instance by using SQL*PLUS and ASMCMD command line.
  • Analyzing SQL Queries for excessive CPU usage, high disk reads / writes and execution plans by using ANALYZE, TKPROF and EXPLAIN PLAN.
  • Migrated flat files from different sources into Oracle Database using SQL*Loader.
  • Migrating the data between production and the development database using Oracle utility traditional export/import.
  • Cloning databases through Data pump Exp/Imp, RMAN
  • Generating the database health check reports using Stats pack, AWR, and ADDM.
  • Provide 24*7 support for production environment.
  • User management, privilege, role, and profile. Managed security by defining roles and rights
  • Expertise in database Performance tuning

Confidential

Platforms: Linux

RDBMS: 9i and 11g

Oracle DBA

Responsibilities:

  • Creating users, granting privileges /roles, user account unlock and password reset for users
  • Created Physical standby DB in RAC environment
  • Working on issues on Data guard like resolving Archive log gap on Primary & Standby DBs
  • Switching over to Standby to Primary when required
  • Resolved block corruptions in standby DB
  • Performing Schema level/Full DB Refresh using Exp /Imp and Data pump
  • Solving Backup failure issues which use Export and RMAN methods
  • Cloning using RMAN
  • Migration of Oracle database from Non ASM to ASM
  • Monitoring the ASM Disk groups and Disks
  • Generating AWR & ADDM Reports and analyzing the same
  • Generating Explain Plan and analyzing the same
  • Identifying Locks at DB level/Object Level and killing the same
  • Identifying Table Fragmentation
  • Rebuilding the Indexes whenever necessary
  • Analyzing Tables, Schemas whenever necessary
  • Installation of Oracle software on Linux environment
  • Performed DB and Grid upgrades
  • Changing Parameter values as required at Database Level
  • Solving Performance related issues Expertise in database
  • Performance tuning, Monitor Server Activity, Error Log, space usage, and solving problem as needed

Hire Now