OBJECTIVE

• Contract position requiring extensive noledge of Oracle Databases. Willing to travel, work long hours.

Summary

• Around 8 Years of professional experience in Database Administration which includes design, development, maintenance and implementation of different Oracle database architectures.
• Expertise in installation, maintenance, patching and monitoring using Oracle Enterprise Edition 12C, 11gR1 and 11gR2 Grid Infrastructure
• Proficient experience and a track record of delivering quality solutions for enterprise level distributed systems.
• Expertise in all stages of Software Development Life Cycle (SDLC) including Requirement Analysis, Design, Implementation, Integration, Testing, Deployment and Post Development Maintenance in Agile Methodologies.
• Experience in creating data flow - diagrams including Class diagrams, Interaction diagrams, State diagrams and Deployment diagrams.
• Extensive noledge in Banking, Automotive, Production Control, Insurance and Marketing domains.
• Managing Exadata database for non-prod/prod environment.
• Experienced in using 11g features Strong experience in supporting development, unit test, system test, Integration test, certification test, production databases under almost all flavors of UNIX (Sun Solaris, IBM AIX, HP UX Red Hat).
• Expertise in cloning using RMAN Duplicate DB and hot backups to create Test, QA, DEV Instances.
• Experienced in features like Data Replay, Log Miner and Flashback data Archive.
• Expertise in applying Oracle Database patches using OPatch Utility.
• Experience in Upgrading databases on different platforms.
• Experience in configuring Oracle BI Discoverer 10.1.2.
• Created teh Scripts for teh migration from old system to new system.
• Load data from OLTP systems into data warehouse databases.
• Expertise in Database Space Management, Memory Tuning and Application Tuning.
• Expertise in troubleshooting and performance tuning.
• Experience in creating and managing Standby database using Data guard.
• Excellent work experience in developing applications using SQL Scripts & Shell Programming.
• Involved in supporting teh SOX teams by providing teh necessary data and execute task for SOX compliance.
• Proven experience wif mission critical databases high availability and disaster recovery environments configuration in 24*7 environments using 9i Data Guard and 10g Data Guard wif real time.
• Extensively worked wif utilities like Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Recycle Bin STATSPACK, ORADEBUG, HANGANALYZE, PSTACK, and TRUSS.
• Extensive experience wif TOAD, Quest Spot Light and BMC Patrol.
• Installation, Configuration and deployment of Oracle databases wif Real Application Clusters (RAC) on multi nodes.
• Worked extensively wif configuring database backups in RMAN environments using TSM, Networker, Netbackup, HP Data Protector and Commvault backup utilities.
• Experience in OLTP/DSS database systems, implementing and managing large Oracle databases.
• Experienced in installing, configuring and utilizing Glodengate replication technology for ORACLE migration wif zero-downtime and high availability.
• In-depth noledge wif SQL and PL/SQL.
• Expertise in Replication of Oracle Databases Streams and Shareplex.
• Experience in other major databases such as AS 400, Sybase, SQLServer 2008, DB2 and MySQL.
• Strong Object Oriented Analysis (OOA), Design (OOD) and Programming (OOP) skills.

TECHNICAL SKILLS

Hardwares: Pentium, IBM, Dell and Apple Mac.

Operating Systems: MS Windows 95/98/2003/2008/ NT/XP, HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux 4.x, 5.x.

Languages: C/C++, SQL, PL/SQL, Unix Shell Scripting, Java (J2EE).

RDBMS: Oracle 8i/ 9i/10g/ 11g RAC, MS SQL Server 2008, DB2, MySQL, AS 400.

Tools: & Utilities: RMAN, Data Pump, Dataguard, OEM, SQL*Loader, Grid Control, SSIS, GlodenGate, TOAD

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR/ADDM/ASH.

PROFESSIONAL EXPERIENCE

Sr. Oracle DBA

Confidential, Columbus, OH

Responsibilities:

• Installed, configured, upgraded & applied patches for Prod, Test & Dev databases.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution for multi-terabyte database issues during Pre & Post GO-LIVE period.
• Configured and Administered Oracle 11g RAC for high availability on ASM.
• Installed and configured GlodenGate11g on multiple databases to support data replication in Oracle Database environment.
• Upgraded Prod, Dev and Test instances from 10g (10.2.0.2) to 11g (11.2.0.1/11.2.0.2 ).
• Involved in Migration of teh oracle databases from Oracle 10g to Oracle 11g and Sun Solaris to OEL (Oracle Enterprise Linux) using GlodenGate wif minimal impact to online systems.
• Supported Oracle Exadata/Exalogic on Oracle RAC 11g in a multi-node environment.
• Configured DATA GUARD to provide high availability by implementing physical stand-by database and performed Roll Forward wif RMAN incremental backup when Standby is out of Sync.
• Configured database entries and monitored teh databases using Oracle Enterprise Manager (OEM) 10g/11ggridcontrol and TOAD.
• Implemented Oracle Transparent Data Encryption to encrypt tables and Tablespaces dat contains PII data.
• Designed and implemented Oracle Real Application Clusters (RAC) on Solaris for an OLTP application wif Transaction Application Failover and high transaction volume.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand-alone instances.
• Performed database cloning/exp/imp to setup identical databases in teh production, test and development environments.
• Created and managed table spaces wif different block-sizes to prevent row chaining and row migration.
• Performed regular DBA activities including space management and performance monitoring.
• Implemented Shell scripts to purge teh log, trace and audit files on Prod & Dev servers.
• Continuous Performance monitoring and tuning of teh databases and applications using OEM Tuning Pack, Diagnostics Pack, and STATSPACK etc.
• Rebuild Indexes, table partitioning,tuningmemory usage andSQLtuningusing Explain Plan,SQLTrace, TKPROF and Statspack for best performance.
• Data loading using Oracle SQL Loader, developing SQL Loader scripts to load global data and fine-tuned SQL Loader performance using Direct-load mechanism.
• Provide database support during monthly & quarterly releases.
• Developed scripts and reports using SQL, PL/SQL and Perl.
• Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for teh health check of teh databases.
• Maintain and periodically test backup and recovery process for Oracle databases for Disaster Recovery readiness.
• Designing and implementation of database backup/restore methodologies for troubleshooting, performance and networking issues and basic OS system administration.

Environment: RHEL RedHat Linux, Sun Solaris, Oracle 11gR2/10g, RAC, ASM, Dataguard, Streams, Gloden gate 11G, SQL, PL/SQL, UNIX Scripting, OEM 12c Grid Control, Ignite, Toad, Sql Developer, Datapump, Putty.

Sr. Oracle DBA

Confidential, Minneapolis, MN

Responsibilities:

• Provided 24x7 on call DBA support for over 250 Oracle 9i/10g/11g production, QA, DEV databases on RHEL, HP-UX, IBM-AIX.
• Involved in teh installation and configuration of multi-node (2, 3, 4) RAC databases on Oracle 10g/11g wif ASM.
• Migrated Oracle 9i/10g/11g RAC and non-RAC Single instance databases wif ASM using Transportable Tablespaces (TTS), Datapump and SAN Synchronization SRDF.
• Upgraded Prod/Dev databases from Oracle 10.2.0.4 to 11g/11g RAC.
• Oracle10g/11g Migration from Non-Exadata to Exadata databases using GlodenGate.
• Worked on Exadata maintenance activities like: FlashCache disk replacement, Battery replacements and System upgrades.
• Applied Bug fix patches, Quarterly Security Patches using Opatch uitility for RAC and non-RAC servers.
• Reconfigured teh OCR, public and private interconnects, modified teh VIPs and teh subnet masks for RAC Clusters and Upgraded single instance 9i/10g databases to 11gR2 RAC
• Setup, reconfigured and monitored 2/3 Node RAC Primary to 2/3 Node RAC Dataguard for DR.
• Tested teh Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of teh migration
• Created new databases/ instances on 11gR2/10g RAC and single instances using customized scripts from DBCA.
• Handled all daily DBA activities and worked on SQL scripting, PL/SQL coding, creating stored procedures, functions, packages, triggers and cursors.
• Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve teh performance
• Redesigned table and index partitioning strategies, using HINTS to improve teh query performance
• Developed, modified and optimized very complex queries to data retrieval usingExplain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques
• Monitored teh CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat, etc
• Designed daily, weekly Backup and Recovery procedures for production and non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups
• Migrated VLDB multi terabyte databases around 10TB and redesigned teh RMAN backup Strategy
• 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 teh health check of teh databases, and used teh notification tool to send teh alerts in OEM Grid Control
• Performed Initial load, extract, replica, trial files and exporting data onto Repository Database using Gloden Gate tool.
• Scheduled UNIX scripts in crontab jobs to automate and send notification e-mails for daily tasks like backups, monitoring teh alert logs, backup logs, cleaning teh old archive logs, old log files and tablespace monitoring.
• Migrated data to a new ASM Diskgroup to improve teh IO performance of teh database
• Export/Import, Datapump, Transportable tablepsaces and dbms datapump package to migrate databases from one database to another using NetworkLink.
• Recovered Databases: Recovering from Media Failure, Recovering teh tables dropped accidentally, Recovering data files and recovering from Block Corruption from previous RMAN backups
• Performed capacity planning, space monitoring like tablespace growth and ASM disk space
• OS level activities like space monitoring of Mount point and relocating data files for better disk I/O
• Interacted wif system and storage administrators, data modelers, developers, application owners for gathering teh required information and resolving various issues
• Resolved critical issues by raising SR wif Oracle Support and did Root Cause Analysis (RCA)

Environment: RHEL, HP-UX, IBM-AIX, Oracle 11g/10g/9i, RAC, ASM, Dataguard, RMAN, PL/SQL, UNIX Scripting, OEM Grid Control, EMC SAN, Toad, SQL*Loader, Oracle ExadataX2, Gloden Gate 10/11G.

Sr. Oracle DBA

Confidential, MA

Responsibilities:

• Part of 4 member DBA team to provide 24x7 support for Oracle 9i/10g production & development databases.
• Administered databases on 9i/ 10g/11g in all environments on RHEL, IBM-AIX, HP-UX
• Migrated databases from Sun Solaris 10, Windows 2008, IBM-AIX 5.2 to RHEL 4.1.
• Used Microsoft SSIS to import data from Oracle 11g to SQL Server 2008/2012.
• Upgraded and Migrated Production, Development and QA databases from 9.2.0.8 to 10.2.0.4
• Installed, Configured and maintained multiple production/ test 10G RAC databases wif ASM
• Worked wif SRVCTL, CRSCTL, DBCA, VIPCA, OIFCFG and ASMCMD for administration of Services, ASM instances and RAC databases
• Developed, configured and maintained Dataguard (Standby database) for faster Disaster Recovery
• Applied patches, patchsets and Critical Patch Update (CPU) using OPatch utility and OUI
• Cloned/ Data Refresh from production to setup test and development environments using RMAN duplicate
• Administered Very Large multi Terabyte Databases (VLDB) around 3TB+ on 3 Node 10g RAC in Data Warehouse and OLTP Environments including high-volume call center production databases
• Monitored databases using OEM Grid control and TOAD.
• Designed Backup and Recovery procedures for production and non production environments using RMAN
• Took periodic Complete, Incremental and Cumulative Backups of production and non-production servers using RMAN, SQL Backtrack using IBM Tivoli tape devices, Hot and Cold Backups
• Recovered teh databases, data files, blocks in case of disk failure, database crash and block corruption.
• Worked on SQL DML, DDL, PL/SQL coding, stored procedures, functions, packages, triggers and cursors.
• Provided support and tuned OBIEE applications usingExplain Plan, SQL Trace, Tkprof reports, SQL Tuning Advisor and Optimized long running queries by partitioning large tables, building indexes and parallel processing
• Performed Performance monitoring, Database tuning and Cluster Interconnect tuning using Dictionary views, OEM Tuning Pack, Diagnostic Pack and AWR (Statspack) reports.
• Creating and managing tablespaces wif different block-sizes to prevent row chaining.
• Used Export/Import, Datapump and XTTS to migrate objects between databases.
• Performed daily DBA activities: managing all teh database files, alert logs, tablespaces, segments, extents, data blocks & physical storage, database network connectivity, database links, users, granting/revokingsystem/object privileges, querying data dictionary tables for metadata, setting init.ora parameters and database locking issues.
• Developed UNIX Shell Scripts and crontab jobs to automate daily tasks including Backups, Exports/Imports, Startup and Shutdown of databases, monitoring tablespace growth, gathering CBO statistics, analyzing tables and indexes, trimming teh alert log files, monitoring teh backup logs and monitor teh alert logs for errors.
• Performed error handling and performance tuning in Teradata queries and utilities.
• Experience wif Oracle Streams and Materialized Views which enable teh propagation and management of data, transactions and events in a data stream either wifin a database, or from one database to another.
• Planned and executed Database Migrationfrom DB2 to ORACLE.
• Involved in data modeling, physical and logical database design using ERWIN data modeler.
• Experience in monitoring and tuning system resources associated wif teh database performance hit ratios, I/O, lock and latch contention
• Documented all Oracle database operations and training of backup personnel.

Environment: RHEL RedHat Linux, IBM-AIX, Sun Solaris, Windows 2003, Oracle 11g/10g/9i, RAC, ASM, Dataguard, Streams, RMAN, SQL Backtrack, IBM Tivoli, PL/SQL, UNIX Scripting, OEM Grid Control, EMC SAN, Toad, Datapump, SQL*Loader, Putty, Erwin, .Net, OBIEE reports, DB2.

Oracle DBA

Confidential

Responsibilities:

• Managed two node Real Application Cluster databases on Red hat Linux advanced server 2.1.
• Performed Database migration from Oracle 9i to 10g R2.
• Migrated single instance databases to multi-node 10g RAC environment for high availability and load balancing.
• Installed, configured and maintained ASM enabled RAC and single instance databases.
• Applied bug patches according to teh Oracle Critical Patch alerts.
• Configured teh automated alerts for teh production servers, which alerts DBA wif teh alert log errors and proactively space related errors.
• Cleaning teh ORACLE HOME file system by cleaning teh log files, alert log file and listener.log files.
• Identifying and troubleshooting everyday issues like locking, scripts execution, Data Audits etc.
• Working wif teh application support team to resolve database related issues and running scripts.
• Maintaining system security, defining roles, profiles etc.
• Checking CRON jobs. Monitoring Application specific background processes.
• Creating materialized views and materialized view logs to implement teh table level replication for teh MIS databases.
• Cloned database for development needs.

Environment: SQL*Plus, Shell Scripting, Red hat Linux (RHEL), Oracle 9i/10g, DB2 9.

Jr. Oracle DBA

Confidential

Responsibilities:

• Installation and Configuration of Oracle Database and Tablespace maintenance
• Created Users, Roles and granted Privileges to teh users
• Populated teh oracle Database Tables from flat files using SQL *Loader
• Implemented teh Physical and logical backups
• Teh Performance Using teh Oracle tools TKPROF, SQLTRACE and Explain Plan
• Carried out recovery activity for various types of failures encountered (Failures due to Corruption of Data Files/Redo Log files and failures at User level)
• Created Standby Databases for teh existing Databases

Environment: Sun Solaris, Linux, Windows, HP-UX, AIX