SUMMARY

• 8 years of IT experience as Oracle Application DBA, Oracle DBA this includes Oracle database production support and Application Production Support, WebLogic administration, data ware housing technology etc.
• Working with Accenture supporting various Clients and Leading Onsite and Offshore DBA Team.
• Provided 24/7 support and on call as required for different projects.
• Experience in administering oracle databases 10g, 11g and 12c.
• Strong experience on the administration of E - Business application versions 11i, R12, R12.2
• Have good understanding of the internals of the Oracle concurrent manager and understand how to monitor and tune Oracle E-business suite Applications.
• Experience in Cloning, export/import, expr/imp, sql loader and Patching.
• Experience on R12.2 upgrade of e-business suite application.
• Took Backups on scheduled time and monitoring scheduled Backups
• Performed backups and recoveries using RMAN conventional hot backups.
• Established and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Creating and implementing Disaster Recovery Plan.
• Experience in performing regular Backups and scheduling tasks.
• Cloning of GeBIZ Application and Databases.
• Administering Large Databases from capacity planning to database design and maintenance.
• Maintenance of Oracle RAC databases.
• Performing code deployments in PROD to make the latest changes once deployed and tested in lower instances.
• Cloning (Refresh) from PROD to lower instances on regular intervals.
• Managing Security (Creating and dropping of users, granting and revoking rights as and when required).
• Perform day-to-day break-fix, troubleshooting, performance tuning etc.
• Monitoring Database performance and optimizing performance.
• Experience AWR reports, Wait events and Performance issues of long running jobs.
• Used TKPROF, EXPLAIN PLAN and AWR, stats pack for the Better Database performance.
• Experience in analyzing long running slow queries and tune the same to optimize application and system performance.
• Experience in configured High Availability like Datagram and RAC.
• Experience in installing and implementing Oracle Enterprise Manager cloud control at level 3.
• Experience in ASM administration.
• Migrated existing databases into RAC configuration.
• Providing connectivity and troubleshooting of connectivity problems.
• Creating Weekly and Monthly analysis reports for the Database Growth and Performance Statistics.
• Participation of team meeting on a by-weekly basic for a discussion on the ongoing activities.
• Perform Oracle Application DBA responsibilities as needed.
• Having Good knowledge in Oracle WebLogic Administration.
• Good experience in OBIEE and ODI administration.
• Applying patches on Apps and databases.
• Experience in Database and OEM upgrades.
• Provide operational support to all Oracle database servers in development, testing, and production environments.
• Worked as Informatica tool admin (ETL Administration) for archiving and purging for production data.
• OEM 12c administration and monitoring databases through OEM.
• Strong experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Expertise in writing UNIX shell scripts to automate daily manual tasks of DBA.
• Implemented automated backup strategy using the UNIX shell script.
• Experience in patching of oracle database and applications.
• Experience in online patching of R12.2 E-business suite application.
• Experience in writing SQL and PL/SQL codes.
• Experience in Jenkins tool for automating the deployment and testing.
• Experience in SOAPUI for web service testing.
• Experience in SQL server administration
• Experience in Oracle databases performance Diagnostics at both the Sql and System level.
• Analytical and Communication skills, planning and Co-ordination skills, Experience with project management.

TECHNICAL SKILLS

Applications: Oracle Application 11i / R12

Database: Oracle 8i, 10g, 11gR2,12c

Tools: Oracle OEM, TOAD, SQL Developer

Oracle Utilities: RMAN, EXP/IMP, Tkprof, Explain Plan

Oracle Technologies: Data-guard (Physical Standby) RAC.

Operating System: RHEL 4.5 / 5.4, OEL 5.9, AIX 6.1, HP-UX Windows

Ticketing Tool: BMC Remedy ITSM.

Hardware: PC Assembly, Troubleshooting, Computer Repair

PROFESSIONAL EXPERIENCE

Confidential, Addison, Texas

Snr.Oracle DBA

Responsibilities:

• Managing and administering 24/7 production databases, development and test instances.
• Working on client location, interacting with clients and coordinating with offshore team.
• Administering very large (near to 10TB) databases.
• User Management which includes create and maintain users and roles, Granting of privileges etc.
• Maintained and administered oracle database security by granting and revoking system/object Privileges, roles, auditing user actions in the database.
• Developed and implemented new UNIX shell scripts for various tasks such as automated the System health check and send summary email to clients daily.
• Write shell scripts to automate daily tasks and schedule in corn
• Developed PL/SQL codes such as triggers to prevent some datatypes beings used while creating Tables in database.
• Assisted functional team to automate their daily manual works to automate and send mail alerts Using UNIX shell scripts.
• Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metal ink).
• Checking Alert Logs, Archive Logs, Trace files, backup verifications & Health checkups of database.
• Cluster maintenance of RAC and ASM.
• Good understanding of server cluster technique.
• Maintenance of concurrent processing requests and concurrent managers.
• Interact with functional team; define responsibilities, menus, request groups, users.
• Experience of execution plans and how to use them to optimize/improve query costs and create new indexes.
• Configure and tune hardware and software to insure optimum performance and resource Utilization.
• Code deployment for custom development from Development, TEST, PROD instances.
• Weekend maintenance of the production, which includes application, and cluster bounce.
• Checking the data guard sync report, analyzing, and fixing the gaps.
• Monitor the critical programs and identify the issues of failures.
• Worked on SSH configurations as part of automated file transfer from one server to another.
• Using OEM 12c for system monitoring which includes activities such as managing groups, incident rules, managing targets etc.
• Purging and re-org of tables on regular intervals. Identify the tables eligible for purging andRe-org to improve the performance.
• Cloning (Refresh)of test instances from PRODUCTION on a regular basis using RMAN restore, Duplicate etc. for database.
• Scheduled and monitoring of RMAN backups daily on production and weekly basis on Test instances.
• Administration of Informatic tool such as user access accounts, roles, setting standards etc.
• Perform Informatic software upgrades as needed.
• Proactively monitor development, test and production Informatic implementation servers.
• Provides technical consulting on complex projects considering ETL best practices & desired results.
• Provide user support by investigating issues/problems, enforcing standards, and answering Inquiries.
• Works with different teams to ensure best practices for code development are followed and optimal configuration of ETL infrastructure

Environment: Oracle Database 11g with RAC, Data guard and ASM, Apps 11i with shared Appleton and PCP, BPEL10g, JBOSS, OEM12c.

Confidential, New Jersey

Snr. Oracle DBA

Responsibilities:

• User manager management on Oracle Database and applications.
• Worked on the management of 11g databases.
• Worked on the administration of Oracle E-business suite application R12.1 which includes patching, cloning.
• Documented new system and created the entire Database Runbook(Standared Operating Procedure)documents.
• Experienced in Export & Import user level, tablespace level, and database level.
• Monitoring & Managing the Tablespaces and Datafiles growth.
• Monitoring locks and various sessions using OEM.
• OEM agent installation.
• Control database privileges and Managing user Accounts.
• Creating and administrating database objects like table, views, indexes etc.
• Coded UNIX shell scripts to execute Oracle Custom Packages.
• Deployment of new code and Oracle Apps and WebLogic products.
• Coordinate and perform migration of data and database objects between environments.
• Worked actively with Oracle metal ink to identify and fix new issues.
• Ad patch and patch on different test instances of applications and databases.
• RMAN backup, restore, duplication of databases.
• Checking Alert Logs, Archive Logs, Trace files, backup verifications & Health checkups of database.
• Monitor system for invalid objects
• OBIEE and ODI administration.
• Interact with application teams to fix the application related issues.
• Performs ongoing tuning of the database instances.
• Complete DBA support in DEV, TEST instances.
• Ensure database consistency and integrity
• SQL and PL/SQL coding with DEV team.
• Code deployment in DEV, TEST and once finalized deploy to PROD on weekend.
• Troubleshoots with problems regarding the databases, applications andDevelopment tools.
• Provides technical support to application development teams.
• Plans and implements backup and recovery of the Oracle database.
• Worked on different ad utilities to handle application related activities.
• Evaluating Oracle features and Oracle-related products.
• Performing monthly and annual performance reports for trend analysis and capacity planning (Plan for andmonitor database space usage).
• Interface with Oracle Corporation for technical support.
• Managing and administering SQL servers.

Environment: Oracle 11g database with ASM, Apps R12, WebLogic 11g, OBIEE11g, ODI11g, OEM12c.

Confidential, Illinois

Snr.Oracle DBA

Responsibilities:

• User manager management on Oracle Database and applications.
• Installation, creation and configuration of Oracle Database.
• Monitoring & Managing the Tablespaces and Data files growth.
• Checking Alert Logs, Archive Logs, Trace files, backup verifications & Health checkups of database.
• Code Migrations.
• Writing shell scripts to automate the day-to-day works.
• Provides technical support to application development teams.
• Plans and implements backup and recovery of the Oracle database.
• Assist developers with database activities.
• Interface with Oracle Corporation for technical support.
• Performs ongoing tuning of the database instances.
• Coded UNIX shell scripts to execute Oracle Custom Packages.
• Create database objects (tables, indexes, etc.)
• Collaborate with the technical and functional team to understand the business and performance requirements to help define a detailed sizing of the infrastructure components required to support the implementation.
• Create, update and Document Standard Operating Procedure (SOP) docs for Production DBAs for new features released to production.

Environment: Linux and Solaris, UNIX, Oracle 11g and 10g, TOAD 9.7.2, RMAN, SQL*Plus, PL/SQL, SQL*Loader, Bartizan 8.7, MS Visio 2010, Oracle BI Publisher, SAP BI/BO, RAC and Data Guard, Golden Gate, WINDOWS 2003/2005 and Siebel 8.

Confidential

Snr.Oracle DBA

Responsibilities:

• Managing and administering 24/7 production databases, development and test instances.
• Administered large 11g and 12c databases.
• Administering of Oracle E-business suite application R12.1 which includes, administering concurrent request, concurrent manager, patching, cloning etc.
• Worked on the administering of different WebLogic products and OBIEE&ODI.
• OEM agent installation, adding targets to OEM and monitoring.
• OEM 12cR3 upgrade to OEM12cR4.
• Database upgrades from 11.2.0.2 to 11.2.0.4(11g).
• Ensuring security of the database by creating profiles and monitoring user sessions. Handle day-to- day DB activities using Oracle utilities and tools, monitoring space and memory requirements.
• Checking Alert Logs, Archive Logs, Trace files, backup verifications & Health checkups of database.
• Monitor system for invalid objects
• Cluster maintenance of RAC and ASM.
• Ad patch and patch on different test instances of applications and databases.
• RMAN backup, restore, duplication of databases.
• Cloning of applications and databases.
• Installation, configuration, administering of different WebLogic products.
• Document the process and steps and pass it to the team. Prepared Standard Operating Procedure documents for new and Modified systems, environments, or databases.
• Regular cloning(Refresh) of TEST instances using RMAN for databases.
• Automated the day to day activities using Unix shell scripts.
• Perform application tuning and performance monitoring
• Interface with Oracle Corporation for technical support.
• Patch Management and Version Control.
• Assist developers with database activities.
• Weekend maintenance of production and test instances.
• Collaborate with application teams to design database solutions.
• Monitor application related jobs and data replication activities
• SQL coding to help developers and migration of objects across instances.
• Patching on all the quarter releases for database.
• Create database objects (tables, indexes, etc.)
• Worked on SSH configurations as part of automated file transfer from one server to another.
• Troubleshoots with problems regarding the databases, applications and Development tools.
• Interact with different application teams to fix the P1 issues in PRODUCTION.
• Work with design teams and create/clone new test instances for new releases.
• Worked on the administration of OBIEE and ODI which includes installation, deployment etc.
• Experience with Jenkins tool, worked to automate the deployment and web service testing of various WebLogic products.
• Experience in SOAPUI testing, which is used as a basic web service testing after the deployment and before releasing to the testing team.

Environment: Oracle Database 11g with RAC, Data guard and ASM, Apps 11i with shared Appleton and PCP, BPEL10g, JBOSS, OEM12c.