SUMMARY:

• Senior Oracle Database Administrator with around 9 years of IT experience in ETL, administration, planning, installation, configuration and upgrades of Oracle12c, 11gR2, 10G, 9i, databases including applying patches under Linux, HP - Unix, Sun Solaris, Confidential -AIX and Windows platforms.
• Experience includes managing Oracle 9i, 10g, 11gR1, 11gR2 RAC and 12c environments using the OEM Grid Control tools. Experience includes using Golden Gate to support data replication in the Oracle database environment. Experience includes Oracle Utilities Data Guard, Data Pump, Flashback and RMAN.
• Good experience of setup & configuration, implementation of (Oracle 11gR2 RAC two-node on Linux with ASM).
• Proficient in Oracle Database Administration activities such as Upgrades, Patches, TAR support.
• Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation.
• Migrating and Upgrading the Databases between different environments and versions.
• Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases. Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features.
• Design, document, implement, and maintain all backup, recovery including disaster recovery.
• Procedures using RMAN, VERITAS Net Backup. Worked with EXP/IMP, EXPDP/IMPDP to refresh the schemas and to restore the Dev, Test databases.
• Strong Exposure on High Availability Concepts (RAC, Standby), Database Cloning, and Oracle Streams.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases.
• Good experience in Oracle Clustering services (CRS), VERITAS Cluster Services (Quick I/O file systems) and High Availability features. Extensive Knowledge of 10g and 11g ASM.
• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems. Performed complete multi-master replication with updateable Materialized views.
• Strong programming experience in creating Packages, Stored Procedures and Functions, Database Triggers.
• Proactive monitoring, identifying areas that need to be improved in the application and database using STATSPACK, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring.
• Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
• Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWR, TKPROF and ADDM reports. Proven ability of providing production support for 24X7 on multiple databases.

TECHNICAL SKILLS:

Operating System: UNIX, LINUX, SOLARIS, AIX, HP-UX and WINDOWS NT/2000, XP, 2003

Data warehousing: Data Modeling, Star Schema Modeling, Snowflake Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling.

ETL Tool: Informatica Power Center 9.0/8.6, Informatica Designer, Workflow Manager, Workflow Monitor, OLAP, Mapplets, Transformations

RDBMS: ORACLE 11g/10.x/9.x/8.x and SQL Server 2008/2005

Oracle Tools/Utilities: RMAN, EXP/IMP, EXPDP/IMPDP, SQL * Loader, DBVERIFY, TKPROF and STATSPACK, AWR, ADDM, OEM, ODM, ERWIN

Languages: SQL, PL/SQL and UNIX Shell.

PROFESSIONAL EXPERIENCE:

Confidential, Bentonville, AR

Senior Oracle Database Administrator

Responsibilities:

• 24*7 on call rotation supporting over 300+ production database.
• Worked on Oracle 11g and upgraded to 12c.
• Successfully Maintained RAC environments of 3Nodes with ASM file system using cluster ware Responsible for applying quarterly PSU security patches.
• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Installed and configured extended 11g RAC on Linux.
• Created oracle database tables, materialized views, objects with storage parameters based on quarterly growth requirements of the system.
• Installing Oracle Golden Gate for EBS Reporting Databases
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Installed and controlled Grid Control to monitor RAC and Non RAC instances patched and upgraded the grid control.
• Upgrade/Patch/Clone/Migrate Oracle EBS Application Tier.
• Supported in improving DBRM to extensively work with I/O band width and intra database allocations through the resource manager of EXADATA.
• Responsible for RMAN backups and improvement to backup with incremental back by adding block change tracking feature of Oracle 11gR2.
• Configured VMware with Oracle 11gR2 and 12c RAC.
• Install and configure Oracle Golden Gate and Veridata
• Provided the support for Exadata databases.
• Created Users, Roles and Profiles, Privilege management with role-based security.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Configuring and using Oracle Log miner and Oracle Flash Back for recovery of the objects.
• Performed database tuning using Explain Plan, TKPROF, Statspack, AWR, ADDM, ASH, SQL Trace and other custom utilities.
• Designed, developed and maintained PostgreSQL database architecture.
• Created Streams environment in unidirectional and table level for replication of data
• Responsible for deployment of the Veridata and its Agents and perform data comparison while data sources are online.
• Managed and administered all NoSQL database systems.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow
• Integration of Exadata monitoring and escalation.
• Experience in Filtering of database changes at the database level, schema level, table level, and row/column level with xstream.
• Experienced in using 11g features like Database Replay, Partitioning, LogMiner, and Schema Management.
• Implemented transparent data Encryption (TDE). Used TDE with Encrypted columns and Data Pump.
• Configured and implemented Oracle 11g ACTIVE DATA GUARD for Database Disaster Recovery by using DATA GUARD broker (DGMDRL).
• Performed logical backups of schemas and database using DataPump (expdp/impdp) as per requirement.
• Installation of Oracle 11g Grid and respective agents on databases, application servers, predefine templates with group option to monitor Prod, UAT and Dev Databases.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Performed Cross platform migration using transportable, table spaces and RMAN.
• Done migration of non ASM database to ASM database.
• Monitored backups, space usage, and user activity on daily basis and Performed daily hot backups and weekly Cold backups using RMAN.
• Altered, modified, Partitioned, dropped, created Database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM.
• Also responsible for patch management of the applications.
• Trouble shooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.
• Used Export/Import, DataPump Utilities to move the data between different databases and for backups.
• Involved in deployment process from dev to production environments.
• Implemented and supported Golden Gate replication in production databases.
• Installed and configured Golden Gate on 11g RAC database running on ASM for replication.
• Managing the existing Golden Gate replication processes and setting up new Golden Gate replications for ETL process.
• Involved in installation and configuration of Golden Gate 11.1 and 12 c versions.
• Configured unidirectional Golden gate replications at table and schema level.
• Troubleshooting Golden Gate issues such as process abending and lag on replication environments.

Confidential, MN

Oracle DBA

Responsibilities:

• Planning, implementing and validating various versions of Oracle Databases to 10gR2(10.2.0.4,)& 11g R1(11.1.0.7) & 11gR2 upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Installation of 11.2.0.3 RAC (2 node) from the Scratch and the maintenance of the high available Databases.
• Migrated OCR and VOTING disks to newer disks by adding newer disks from SAN and dropping the old disks by using ASM’s native rebalancing feature.
• Installing and configuring Grid Infrastructure & Database software. (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, reinstallation & cleanup of Clusterware).
• Refresh/Cloning of Database and applications for development and testing purpose.
• Performing Backup/Restore of all the Oracle databases using RMAN.
• Performed migration of the oracle databases whose database sizes vary from 300 to 500GB from Oracle 10.2.0.4/11.1.0.7/11.2.0.1 to Oracle 11.2.0.3 using Exp/Imp and Expdp/Impdp.
• Implementing Physical and Logical Standby setups Data guard Configurations.
• Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC.
• Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through crontab.
• Implemented Oracle Patches CPU & PSU on the Compliance databases Device a plan to patch them.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Involved in Production Support for Critical Application Databases when needed.
• Installing agent 12c on the server. Adding High Available Database with CRS, Scheduling Backups through OEM12c.
• Scheduling jobs through oracle JOB SCHEDULAR, Crontab (UNIX).
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues helping to transform business requirements into environment specific databases.
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metalink.

Environment: Oracle 11.2.0.3/11.2.0.1/11.1.0.7/10.2.0.4, Quarter/Half/Full RACK, OEM 12c, LINUX, Confidential AIX, TOAD, SQL Developer.

Confidential, CA

Oracle DBA

Responsibilities:

• Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4)& 11g Release 1(11.1,11.2) & 11gR2 upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Implementing Physical Standby Active Data Guard in both 10g & 11g environments
• Involved in installation, configuration and support of Oracle 11g RAC.
• Worked on using the Materialized views for large Data Replication between 2 production databases.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Production Support for Critical Application Databases, work closely with Application Team in identifying issues and provide solutions for various issues.
• Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Implemented backup policy using oracle RMAN. Prepared test environments for backup/recovery using RMAN. And legato TAPE backup management.
• Recovering Databases when there is any Physical or Logical Corruption.
• Created routines for Daily, Weekly & Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
• Implemented Transparent Data Encryption (TDE) for compliance related databases.
• Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection. Also did Capacity Planning.
• Responsible for purging and archiving the production databases.
• Detected locks and resolving in-doubt transactions manually. Tuned oracle SQL statement by tracing.
• Tuned database servers by using new 10g features ADDM, AWR, Keep/pin objects, tune recovery time, ran SQL trace and generated TKPROF reports.
• Providing support to clients/developers regarding SQL queries, applications errors, database errors Prepared and managed system for Data replication. Loading flat file data into tables using SQL Loader.
• High level of tracing of Optimizer and SQL performance with events 10053, and 10046 etc, recommend any changes required.
• Scheduling jobs through oracle JOB SCHEDULAR, Control M, Crontab (UNIX), Scheduled Tasks (Windows) and Maestro 7.0 (Job Scheduling Tool).
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Used DBMS * packages to schedule jobs, re-engineering, gathering statistics, mview refresh...so on.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases.
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used new oracle Metalink.
• Contacting Application Team and clients to gather the information for migration. Reviewed architecture.
• Assisted developers with the Tuning during the development and tuned the applications.

Environment: Oracle 9i,10.2.0.4,11.1.0.6, Confidential Manage NOW, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, LINUX, Confidential AIX, WebSphere,Solaris5.9,TOAD,SQL Developer.

Confidential

Software Developer

Responsibilities:

• Extensively worked in data Extraction, Transformation and loading from source to target system using BTEQ and MULTILOAD.
• Involved developing scripts using Teradata SQL as per requirements.
• Developed simple mappings using Informatica to load dimensions & fact tables as per STAR schema techniques.
• Responsible for creating test cases, test plans, test data and reporting status ensuring accurate coverage of requirements and business processes.
• Experience in SDLC and agile methodologies such as SCRUM.
• Created Informatica mappings to build business rules to load data.
• Configured and ran the debugger from within mapping designer to troubleshoot the mapping before the normal run of the workflow.
• Created and tracked efficiently mapping parameters and variables.
• Involved in performance tuning of required mappings to improve the efficiency while loading the data.

Environment: Informatica 8.6.1, Oracle10g, Teradata TD12.