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