PROFESSIONAL SUMMARY:

• Over 7years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows.
• Delivering Oracle Database performance - tuning services for customers with Explain Plan, Tkprof, StatsPack, and SQL Trace.
• Excellent experience in Installation and configuration of Oracle 12c,11g, 10g, in UNIX/LINUX and Windows environment.
• Upgraded Databases from to 10g, 10gto 11gand 11g to 12c on various platforms.
• Proficient in Database administration activities such as user management, space management, Monitoring,Creating Database, Managing Oracle Instance and Database security and Materialized Views.
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) using oracle 11g tools like AWR, ADDM, Advisories, TKPROF, SQL TRACE,EXPLAIN PLAN for the better performance.
• Performance Monitoring and Tuning of Database using Grid Control & Diagnostic pack (AWR, ASH ADDM)
• Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).
• Experience in performing point in time recovery at times of necessity.
• Design and implement backup and recovery including disaster recovery structures.
• Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.
• Extensive experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
• Wrote scripts to inform the DBA team on the status, performance and space management of the database
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes installed and configured Oracle, 10g, 11g, 12c on Sun Solaris AIX, UNIX/LINUX, HP-UX and Windows environment.
• Synch -up database environments (DEV, QA) after each major release or production change.
• Implemented One node RAC and four node 11g RAC clusters on Linux platform and AIX LPARs having GPFS cooked SAN Storage.
• Provided support to the Database system Infrastructure area that had few critical Business Systems including TR, Bills Order and Tracking, Online Charges.
• Co-ordinate with UNIX administrators and management team for space management, problem resolution, capacity planning, software version control, evaluation and support on various servers.
• Established standby/cloned database via DataGuard for Database Disaster Recovery
• Employed predefined UNIX scripts to cleanup database files such as outdated archived redo logs and trace files out of bdump, udump and audit directories.
• Trouble shoot and Configured Sql*Net files according to client and server settings to transfer data.
• Worked on export/import, data pump and SQL Loader.
• Experienced in installation and configuration of Oracle cluster ware and Automatic Storage Management (ASM) in RAC environment.
• Experience in conversion of SingleNodeInstance to multimode RAC with ASM, and adding instance to existing RAC.
• Experience in Migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances.
• Experience in Real Application Clusters (RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management (ASM).
• Configured and maintained physical standby databases using Oracle Data Guard to perform quick disaster recovery.
• Experience in maintaining DataGuard to provide high availability by implementing physical standby database and snapshot standby and worked with Oracle 11g features, 11g Grid Control.
• Data warehouse analysis and design for diverse legacy system integration.
• Process/workflow analysis, project management from analysis and design for implementation.
• Conceptual data modeling, logical and physical data modeling.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Worked with development and operations staff in resolving problems quickly and efficiently
• Oracle GOLDEN GATE for data sharing using EXTRACT, REPLICAT, DATAPUMP, MANAGER PREOCESS for Bidirectional, unidirectional, Broadcasting and consolidation topologies.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XPRDBMS Oracle 8i/9i/10g/11g/12c.

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*Plus

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, MO

Oracle DBA/Team Lead

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g, 12c

Responsibilities:

• Primary DBA for 100+ databases of Oracle and some Sql Server 10g/11gR2 and GOLDEN GATE, RAC administration on Linux REHL, HP-UX. Worked as per ITSM/Remedy Incident ticket/Critical Response Time (CRT) call.
• Perform schema refreshes on SQL SERVER, creating users and granting privileges
• RAC- Administration/Trouble-shooting of 3 Node cluster on Oracle 10g/11G R2. Configuring Grid Infrastructure SCAN Listeners on 11gR2. Migrate OCR files to ASM. Trouble-shoot Resource related issues. Cluster-wide Resource management such as create resource plan, Service configuration, parallel instance group, Application Isolation. Stress testing, benchmarking of clustered database.
• Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
• Data guard - configure primary -standby using duplicate from active database command of 11g. Apply SCN-based Incremental backup to sync standby after loss of Archive logs on primary. Measure data loss based on latency/lag. Cross-platform migration using Data guard.
• Managed Container and pluggable databases
• Cloned 12c database
• Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.
• Installation of 3 nodes 10g RAC on Linux & Solaris with veritas cluster. Configured ASM, OCFS and RAW devices. Troubleshooting & tracing of RAC processes & CRS components. Relocate service. Tuning of RAC environment. Managing fail-over of instances. Resource utilization on each node. Monitor top objects in cache fusion and traffic.
• Backup by RMAN and data pump. Consistent backup using data pump. Diagnose and repair block level corruption using RMAN. Script and test RMAN backup/restore. Optimizing backup by compressing. Troubleshooting RMAN restore. Used RMAN convert command to transfer datafile from ASM. Duplicate database on remote host using 11g active database command. Hands on Varitas NetBackup. Flashback database.
• Audit database performance using ADDM reports, AWR snapshot and diagnostic SQL scripts. Identify and tuning of ad-hoc queries, PL/SQL code which are high intensive resources. Tuning instance by init parameter. Used explain plan and stats pack/TKPROF utility to Improve response time of query. Create/manage local partitioned and bit-map indexes.
• Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat etc.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
• Migrated VLDB multi terabyte databases around 10TB and redesigned the RMAN backup Strategy.
• Oracle GOLDEN GATE for data sharing using EXTRACT, REPLICAT, DATAPUMP, MANAGER PREOCESS for Bidirectional, unidirectional, Broadcasting and consolidation topologies
• Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
• Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
• Performed Online and Offline backups with RMAN, export/import and expdp/impdp.
• Implemented Point in time recovery using RMAN.
• Experience using like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging
• Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tunig Automation, Flashback Database, compression techniques and several others
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
• Configuration and implementation of Oracle) for high availability.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Datapump, conventionalExport/Import (Oracle 11g, 10g) for migration and logical backup of database.
• 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”.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK,TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.
• Experienced in configuration of ASM for RAC and NON- RAC environments.
• Configured Repository and clients for GRID Control and also implemented DB Control for some databases.
• Supported& maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, StorageAllocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12cGrid Control.

Confidential, IRVING,TX

Oracle DBA

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g, 12c

Responsibilities:

• Primary DBA for 200+ databases of Oracle 10g/11gR2 on Linux REHL, HP-UX. Worked as per ITSM/Remedy Incident ticket/Critical Response Time (CRT) call.
• RAC- Administration/Trouble-shooting of 3 Node cluster on Oracle 10g/11G R2. Configuring Grid Infrastructure SCAN Listeners on 11gR2. Migrate OCR files to ASM. Trouble-shoot Resource related issues. Cluster-wide Resource management such as create resource plan, Service configuration, parallel instance group, Application Isolation. Stress testing, benchmarking of clustered database.
• Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
• Data guard - configure primary -standby using duplicate from active database command of 11g. Apply SCN-based Incremental backup to sync standby after loss of Archive logs on primary. Measure data loss based on latency/lag. Cross-platform migration using Data guard.
• Managed Container and pluggable databases
• Cloned 12c database
• Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.
• Installation of 3 nodes 10g RAC on Linux & Solaris with veritas cluster. Configured ASM, OCFS and RAW devices. Troubleshooting & tracing of RAC processes & CRS components. Relocate service. Tuning of RAC environment. Managing fail-over of instances. Resource utilization on each node. Monitor top objects in cache fusion and traffic.
• Backup by RMAN and data pump. Consistent backup using data pump. Diagnose and repair block level corruption using RMAN. Script and test RMAN backup/restore. Optimizing backup by compressing. Troubleshooting RMAN restore. Used RMAN convert command to transfer datafile from ASM. Duplicate database on remote host using 11g active database command. Hands on Varitas NetBackup. Flashback database.
• Audit database performance using ADDM reports, AWR snapshot and diagnostic SQL scripts. Identify and tuning of ad-hoc queries, PL/SQL code which are high intensive resources. Tuning instance by init parameter. Used explain plan and stats pack/TKPROF utility to Improve response time of query. Create/manage local partitioned and bit-map indexes.
• Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat etc.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
• Migrated VLDB multi terabyte databases around 10TB and redesigned the RMAN backup Strategy.
• Oracle GOLDEN GATE for data sharing using EXTRACT, REPLICAT, DATAPUMP, MANAGER PREOCESS for Bidirectional, unidirectional, Broadcasting and consolidation topologies
• Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
• Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
• Performed Online and Offline backups with RMAN, export/import and expdp/impdp.
• Implemented Point in time recovery using RMAN.
• Experience using like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging
• Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tunig Automation, Flashback Database, compression techniques and several others
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
• Configuration and implementation of Oracle) for high availability.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Datapump, conventionalExport/Import (Oracle 11g, 10g) for migration and logical backup of database.
• 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”.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK,TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.
• Experienced in configuration of ASM for RAC and NON- RAC environments.
• Configured Repository and clients for GRID Control and also implemented DB Control for some databases.
• Supported& maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, StorageAllocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12cGrid Control.

Confidential

Oracle DBA

Environment: RHEL 5.X; Windows NT 2000/2003; Oracle 10g, 11g

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.
• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.
• Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Collecting performance statistics using Stats pack/AWR (Automatic Workload Repository) and analyzing by ADDM (Automatic Database Diagnostic Monitor)
• Rebuilding indexes or analyzing the index as per the fragmentation level and minimize the performance issues.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• Setup data guard, create physical-standby database using hot backup. Troubleshoot errors on standby. Manually register archive logs.
• Setup & test backup on databases. Writing RMAN scripts embedded in shell scripts. Recover full database by applying archive and redo logs. Duplicate database by RMAN on remote host. Optimize backup on RAC.
• Imp/exp used for load data into users on daily bases. Import schemas as part of recovery process in times of logical corruption. Export statistics from production to test.
• Tuning of instance, database with help of system views and init parameters. Partition of tables, indexes to improving performance. Used partition pruning, wise-join.
• Monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs in cron. Used ADRCI and OEM on 11g databases. Maintenance of bitmap indexes.
• User management includes, crate/alter users, Grant roles, and assign resource profile. Auditing database objects for DML operation.
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers
• Experienced of managing and administering 24 X 7 running databases and support
• Applied bug patches according to the Oracle Critical Patch alerts.
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4 and 11.2.0.3.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Involved in De fragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.
• Responsible for all database activities such as User management, space management, database security management.
• Implemented the resizing the online redo logs in production and in standby database.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in crontab using RMAN utility and monitoring the scheduled jobs.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run the 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.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.