SUMMARY:

• Multi - talented and resourceful Oracle DBA with 10+ years of Oracle DBA expertise in Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, migrations, patches, performance tuning, backupand recovery, cloning, space management, database security, auditing, troubleshooting, database design, TAR support, Unix shell scripting and documentation.
• Oracle DBA
• Performance Tuning
• Patching
• 24x7 Support
• RAC
• RMAN
• Advance Security Options
• Client Relations
• Goldengate
• Data Guard
• QA/Production Support
• Agile

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Oracle DBA

Responsibilities:

• Confidential (referred to in some countries and often in colloquial speech simply asHome Depot) is an American retailer ofhome improvementandconstructionproducts and services.
• Handled the Oracle databases, Applications and backup and recovery for general Database maintenance
• Provided 24x7x365 Duty Analyst Support roles in rotating schedules
• Provided system status updates to identified POCs
• Expertise in Management of Production environments (Stage, Production, DR)
• Handled Application monitoring, tuning, Log checking, troubleshooting etc.
• Handled Capacity analysis and resource monitoring
• Handled Documentation management, License management
• Handled Contingency Plan Execution, Security Assessment Process
• Handled Release package deployments in TST, UAT, PRD
• Handled Database patch management completely.
• Handled database with Advance Security.
• Expertise in Data change operations, Data calls, Requests for data extracts (CREs)
• Expertise with Database Management, providing technical expertise in the use of DBMS
• Expertise in Evaluate and recommending available DBMS products to support validated user requirements.
• Handled file organization, indexing methods and security procedures for specific user applications.
• Expertise in Design, implement and maintain low to moderately complex databases, access methods, access time, device allocation, validation checks, organization, Expertise in protection and security, documentation and statistical methods.
• Expertise in database dictionaries, monitors standards and procedures and integration of systems through database design.
• Expertise in evaluate and recommend database management systems products to support validated user requirements for implementation.
• Expertise in design and execute database backup and recovery procedures including disaster recovery.
• Expertise in executing ad - hoc queries and generate reports for users in a timely manner.
• Expertise in providing project status updates describing the state of assigned deliverables, s, and significant risk items.
• Handled database high availability solutions like Data Guard, RAC, Physical and logical standby databases, streams and Golden Gate replication
• Handled end to end administration of Oracle EBS 11i / R12.1 on RAC/ASM
• Worked on database handler, and database vault to make sure on high amount of data.
• Handled secured databases smoothly by applying database firewall techniques.
• Handled Web logic, SOA suite, Oracle EBS R12.2 installations and configurations
• Handled system roll-outs and change management during project implementation, supporting Dev, Test, UAT & prod environments
• Handled various issues with Apache and Web Logic components
• Performed Oracle DB admin tasks like Backup, Restore, DB refreshes, clones etc.
• Supported mission critical PRD environments 24/7 on call and offsite.
• Handled SQL, PL/SQL, Shell Scripting, Partitioning, Data modelling, Logical and Physical DB Design, Backup and Recovery Procedures.
• Write and execute PL/SQL statement against database and its objects.
• Experienced in maintaining high availability of databases for global operation using Oracle RAC and Data Guard/ Standby databases.
• Create and manage Standby databases at remote data center asDisaster Recovery.
• Migration of Database from 9i to 10g and 9i/10g to 11g.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack Diagnostics Pack, STATSPACK, etc.
• Providing Solutions to the Problems Faced by end Users or Programmers.
• Health Check of Databases, Cold Backups.
• Recovery of Database(Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption).
• Experience in linux & Unix, AIX and windows operating systems.

Confidential - SFO, CA

Sr. Oracle DBA

Responsibilities:

• Integrated Oracle Internet Directory & Oracle Access Manager and Configured with E - Business Suite.
• Supported SOA/Web logic, OBIEE, Workflow Builder, OID, Hyperion and Informatica environments
• Implemented ASCP, Demantra and ODI in R12 environment
• Implemented Oracle Ware house management in R12 in Linux environment
• Provided 24/7 Support on Oracle production instances
• Cloning and Refreshing Oracle Database Instances.
• Oracle Database Patching and Tax updates.
• Database Health check and Space Management.
• Worked on Advance Security.
• SupportedRACinstances usingSRVCTLutility.
• Maintained databases on 10g/11g including all daily activities and DBA jobs.
• Taking periodic backup of the databases on 10/11g and full environments using extensive shell scripts.
• Implemented Backup & Recovery procedures.
• Solid experience in Oracle Recovery Manager (RMAN), and standby database usingData Guard 9i/10g.
• ImplementedHot, Cold and Logical backup plans, UsedRMANfor backup and recovery. Performed backup validations using RMAN.
• Worked on all various features of Oracle likeImport/Export, Oracle OEM, Impdp/Expdp, Flashback, ADDM and AWR.
• Performance tuning for optimized results using tools likeExplain Plan, SQL*Trace and TKPROF, Statspack.
• Performed regular database cloning and refreshes to setup test and development database
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Load balancing, databases/schema/table re-organization for faster performance.
• Responsible for optimizing the queries and application tuning. Performed SQL tuning and assisted developers with coding PL/SQL
• Used various tools for monitoring and general database management likeSQL Developer, TOAD, OEM
• Shell scripting,cron scripting, RMAN backup scriptingand developed SQL control files to load data throughSQL Loa

Confidential - La Crosse, WI

Oracle DBA

Responsibilities:

• Expertise to Monitor and optimizes database performance. Expertise in Diagnose and resolve data management problems and issues.
• Performed monitoring and maintenance of databases, installation of database software upgrades, monitoring of database backups, standardization and implementation of databases to improve the management of production and test environments Handled physical database design, performance monitoring and tuning, documentation of standards and procedures, assistance to application developers, backup and recovery and consulting.
• Developed migration plans, data dictionaries, data models, metadata repositories, and other data management tools.
• Supported users by resolving problems with application databases and access.
• Implemented database security (users, roles and privileges) as well as mitigated security findings.
• Converted 10g database with exadata
• Configured PIM (Oracle Product Information Management)
• Configured Golden Gate
• Installed and Configured Oracle Web Center Imaging.
• Integrated Web Center Imaging with E - Business
• Good Trouble Shooting user and Functional issues
• Configured 11g RAC for 3 nodes on Red Hat Linux
• Good understanding of ITIL framework mainly Change, Problem, Release, Incident, Security Management.
• Installation, Configuration & Maintenances of Oracle Applications R12.1.1 and R12.1.3 with 10g/11g Databases.
• Performed Clones of Oracle Applications R12 instances from PROD to TEST, UAT.
• Experience in complete recovery, incomplete recovery, recovering data files, tablespaces, control files, block corruption.
• Upgraded Apps 11i to R12.1.1
• Installed Oracle Software 9i/10g on Windows and Sun Solaris platforms. Monitor database space requirements and adjust for future needs.
• Performed databasePerformance TuningandNetwork Trouble Shootingusing TNS configuration, Listener settings, SQLnet settings.
• Database Performance Tuning usingStatspack, AWR, and ADDM.
• Worked in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Worked on various tools likeSQL*LOADER, OEM, RMAN, RAC, Export/Import, SQL * Loader, TKPROF, Materialized Views, Replication.

Confidential - Overland Park, KS

Oracle DBA

Responsibilities:

• Configured PIM (Oracle Product Information Management) Configured 11g RAC for 3 nodes on Red Hat Linux
• Good understanding of ITIL framework mainly Change, Problem, Release, Incident, Security Management.
• Installation, Configuration & Maintenances of Oracle Applications R12.1.1 and R12.1.3 with 10g/11g Databases.
• Performed Clones of Oracle Applications R12 instances from PROD to TEST, UAT
• Worked on logical backups,Hot/Cold Backup and Recoveryand Database Refreshes.
• Experience in complete recovery, incomplete recovery, recovering data files, tablespaces, control files, block corruption.
• Upgraded Apps 11i to R12.1.1
• Installed Oracle Software 9i/10g on Windows and Sun Solaris platforms. Monitor database space requirements and adjust for future needs.
• Performed databasePerformance TuningandNetwork Trouble Shootingusing TNS configuration, Listener settings, SQLnet settings.
• Database Performance Tuning usingStatspack, AWR, and ADDM.
• Worked in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Worked on various tools likeSQL*LOADER, OEM, RMAN, RAC, Export/Import, SQL * Loader, TKPROF, Materialized Views, Replication.
• Worked with database vault and database firewall securely.
• Participatedin Disaster Recovery Drills, documented database and application validation steps

Confidential

Associate Database Engineer

Responsibilities:

• Worked closely with development team to create database, update databases for the web & Intranet applications.
• Handled complete database management for all Confidential servers and its applications.
• Executed several SQL commands, and wrote Stored Procedures.
• Prepared technical documentation for each project.
• Worked on Linux, Aix environments
• Handled Core DBA activities for Oracle 9i and 10g
• Handled Database Creation, Capacity planning.
• Planning and Implementing Backup and Recovery Strategy using RMAN.
• Handled Logical Backup using EXP and IMP, Transportable tablespaces, Data pump.
• Handled Transportable Table spaces to quickly refresh the Reporting database.
• Monitoring and Maintaining User Activities to ensure database security.
• Moving data between various databases using utilities like Exp/Imp.