SUMMARY:

• Full responsibility and expertise in Oracle database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances and SQL - server databases.
• Good communication and cooperation skills with an aptitude to learn quickly, take responsibility, work under pressure.
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 11 TB.
• Experience in Installation of Oracle Databases 9i, 10g, 11g and 12c versions.
• Experience in the Upgrade of Oracle Databases in patch set Level and also in version Level (9i to 10g), (10g to 11g) and (11g to 12c).
• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, datapump export/import.
• Involved in each phase of life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase, development and production support activities.
• Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance and maintenance.
• Performing Fault Injection Test Cases for verifying the High Availability at each layer of RAC stack like port failover, instance failover, ASM failover and Node failover.
• Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms.
• Configuration and Management of Data Guard on RHEL, OEL.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) /Network Attached Storage (NAS).
• Proactively monitoring the database's health and taking preventive or corrective actions
• Proficient in Database Design(Physical and Logical Database Design) and Normalization.
• Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).
• Used EXPDP&IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Proficient in using various database Utilities like EXPORT/IMPORT, DataPump, TOAD.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.
• Automated many common tasks using Crontab including Backups, exports and imports,

TECHNICAL SKILLS:

Databases: MSAccess, MySQL, MS SQL Server, Oracle 10g, 11g, 12c

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Statspack/AWR, Shareplex Top, DBCA, DBUA, ADDM,RAC,ASM,DataGuard, Oracle Migration Workbench, ERwin, QDesigner, Remedy,SRVCTL,WinsSCP, Putty,Netca, Secret server, Keypass, Bomgar,Zoho,Dreamweaver,Team Viewer, Togo Assist, ServiceNow, Recovery Catalog, Autosys, Crontab,SAPetc

Operating Systems: MS Windows, LINUX, UNIX (Solaris 8/9/10, AIX, HP-UX)

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

• Database Administrator supporting three major projects from Development to Production through Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.3 & 6.1. Database sizes range from 2GB to 3TB (in ODS & EDW environments).
• Applies CPU/PSU Patches on ERP instance and Plain databases.
• Clones of Test/DEV instances from Production systems.
• Maintains Oracle11gR2 RAC high availability with ASM file system with Cluster Stat and Grid infrastructure on Linux environments. Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Provides System support for both development and 24*7 production environments.
• Analyzes SQL queries causing performance problems.
• Creates, Configured, Upgraded and Administered 10.2.0.4/11.2.03 & 12.1 versions Oracle databases on Linux Red Hat and Cent OS on Vmware and bare-metal environments
• Executes an upgrade of Oracle Database from 11g to 12c.
• Creates and configures new database server and database environments.
• Performs Monthly Re-org of complete databases using expdp and impdp
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Executes Disaster Recovery (DR) Plan Implemented using DATAGUARD (Physical Standby) for high availability/disaster recovery purpose on Oracle 11g.
• Performs DR switchover and failover operations.
• Participates in meetings for Project Updates/Project Enhancements/Trouble shooting periodically
• Maintains database and middleware/SOA layer performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases.
• Supports Oracle DB backups (online/offline), logical backups and Linux scripts, created clone databases, configured standby database, performed DBA day-to-day activities
• Troubleshoots installation errors both independently and with Oracle support (via My Oracle Support)
• Creates oracle databases on configured servers using both the DBCA & Database creation scripts.
• Manages, tune and troubleshoot database issues both on Linux command line, SQL*Plus, OEM client, Oracle 10g database control, oracle 10g Grid Control as well as other third party tools (TOAD, SQLDeveloper and DBArtisan for Oracle).
• Monitors and performs database sizing, tablespace management and rollback tablespace management, transaction management and security administration
• Carryout Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC)
• Provides valuable inputs for various performance tuning issues.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning)
• Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK, SQL*Trace, TKPROF.
• Expert in Performance Tuning and Monitoring of Oracle Databases on Linux/Unix platform using database tuning, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory. installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS file systems.
• Involves in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance
• Refreshes schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins
• Works on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1
• Monitorsdatabase systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed Linux shell scripts.

Tools: Used: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS,Oracle Grid control,Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential

Oracle Database Administrator

• Cloned/Migrated databases using RMAN and traditional Datapumpexport/import utilities in Oracle 10gR2.
• Worked on disaster recovery of e Dataguard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile testing.
• Automated monitoring the databases, performance parameters, backup and recovery activities by running cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.
• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Provided System support for both development and 24*7 production environments.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
• Performed troubleshooting of database using AWR and ADDM reports.
• Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.
• Executed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
• Responsible for network configuration and involved in a Client-Server environment using TNSnames, LISTENER, Net Configuration Assistant and other configuration files.
• Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using DatapumpExport/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Installed Oracle and grid software on standalone servers on ASM and file system.
• Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used run blocks to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
• Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, Oracle TOAD, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential

Junior Oracle DBA

• Performed migration from Linux to Solaris and 32 bit to 64 bit.
• Restored and Recovery of database in case of database crash, disk/media failure.
• Applied patches and works closely with Oracle to make Application environment up to date.
• Backups & Recovery Maintenance, Databases Performance Tuning.
• Typically involved in database Designing, creation and maintenance.
• Executed a good working knowledge of SQL, PL/SQL, and shell scripting.
• Created users and grant privileges according to the requirements.
• Working knowledge on UNIX administration on AIX server.
• Provided System support for both development and 24*7 production environments.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference. Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
• Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues, disasters from happening.
• Monitoredtablespace issues, creating tablespaces and adding datafiles.
• Involved in session management and monitored the critical wait events, blocking sessions in the database.
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Tuned test and production database by altering the parameters.
• Executed Export and Import of database objects to copy from one database to another database.
• Investigated suspicious database activity using Auditing.
• Wrote database documentation, including data standards, procedures and definitions.

Tools: Used: Oracle 10.2.0.1, Oracle 11g, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential

IT support Administrator

• Performed Hardware Maintenance, Repairs of printers and computers .
• Troubleshoots and resolved hardware, software, network incidents or issues with desktops, laptops as well as printers.
• Configured and Setup end users workstations, monitoring network and making sure connections are up.
• Created partitions on hard disk drive for backup purposes.
• Executed installation of Operating System Programs.
• Performed Computer Upgrading and Maintenance.
• Carried out Window and Windows Upgrade.
• Executed Software Installation and Updating.
• Performed Hardware, software, configuration and equipment setup/ installation.
• Assisted users both remotely and onsite in various locations.
• Supported end users with the entire Microsoft Office applications.
• Executed Clone on hard drives to have the exact copy of data from the source drive to the destination drive.
• Supported both Mac and Windows products as well as operating systems (OS).
• Protected the computer system from failures and also minizes the lost of data by performing a complete routine maintenance on the computers and network as well.
• Document activities, steps to resolution and process improvements.
• Created as well as changing or resetting user’s password and Account .