SUMMARY:

• 10 years of experience in providing ERP solution in IT industry in various roles like Technical Analysis, Data Modelling, Designing, Development, Database Administration, Database Architect and Production maintenance, Database upgrades, ERP R12 RBAC and R12.1.3 Applications support.
• My experience with Oracle RDBMS with installing, patching, cloning, upgrades, monitoring, maintaining, performance tuning.
• Hands - on experience with Oracle 10g/11g RAC, ASM, RMAN, SOA Suite, Data Guard and Oracle replication and OEM 12C.
• Hands-on experience on Oracle Database upgrades from 10.2.0.4 to 10.2.0.5, 10.2.0.4 to 11.2.0.2 and 11.2.0.2 to 11.2.0.4 versions.
• Production support and maintenance of Oracle Applications R12.1.3 and 11.5.10.2.
• Extensive experience in Oracle E-Business Suite from application as well as database side.
• Involved in complete software development lifecycle (SDLC) for Oracle Implementations and Upgrade.
• Supporting and maintaining the Application responsibilities access control in system
• Result oriented, innovative Oracle Database Administrator/Oracle applications DBA experience as project management.
• My database and application knowledge, experience and expertise includes, RDBMS versions 11g, 10g, 9.x, e*Business Suite 11.5.9, 11.5.10, and R12.1.3 and Sun Solaris Administration and Linux Server management.
• Taking backup and cloning database on different level by using Expdp/Impdp dump utilities.
• Provide Level 3 application database administration production support to resolve problems including on-call support and closing of helpdesk tickets.
• Coordinate with data security to provide appropriate security, SOX compliance and secondary authorization.
• Hands on experience in Oracle ERP performance tuning, both infrastructure side turning, and code tuning.
• Hands on experience on MS SQL Server 2008, 2012 Installation, configuration and supporting the database.
• Had experience managing environments using Weblogic Admin Server console, Enterprise Manager, Node manager and other server administration utilities.
• Monitor hardware, OS and application performance through available utilities.
• Monitoring and controlling the standard JVM monitoring utilities.
• Have the experience on analyze and troubleshoot deployment issues in a timely manner.
• Act as primary customer contact for deployment related inquiries and issues.
• Strong issue fixing and debugging skills.
• System administrator maintenance and Support, Role Based Access Control.
• Supporting and maintaining the Application user’s access control in system.
• Assigning the required responsibilities to the internal/external users.
• I am a result driven, innovative Oracle Database Administrator/Oracle applications DBA experience as well project management.

TECHNICAL SKILLS

Operating systems: Linux 5.10, IBM AIX, HP-UX, Sun Solaris 10, Windows 2008, Windows NT

Databases: 11gR2/11gR1/10g/9i

Specialization: PLSQL Developer, Toad, SQL PLUS, SQL Developer, Oracle Workflow Builder, SQL Navigator, MS Sql Server Management studio, Hyperion Essbase and Planning Applications, Putty, WinSCP, PsFTP, GRC CCG and AACG applications,VSS, SVN, SDM12, Remedy and HP PPM tools, OEM 12C

Storages: Oracle ASM, Disk groups RMAN Backup, EMC DDBoost RMAN Backup

Programming Languages: Oracle SQL, MS SQL Server, PL/SQL, UNIX Shell Script.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Oracle Apps DBA

Responsibilities:

• My experience with Oracle RDBMS with installing, patching, cloning, monitoring, maintaining, performance tuning.
• Hands-on experience with Oracle 10g/11g RAC, ASM, RMAN, SOA Suite, Data Guard and OEM 12C.
• Configuring and monitoring the databases through OEM 12C.
• Database upgrade from 11.2.0.1 and 11.2.0.3 to 11.2.0.4 version for Non-production and Production databases.
• Hands-on experience on cloning and refresh of the databases from Production to Test and Development environments.
• Hands-on experience on Performance Tuning and Troubleshooting the database and concurrent jobs.
• Production support and maintenance of Oracle Applications R12.1.3 and 11.5.10
• Patching applying on R12.1.3 and 11i E-Business Suite applications.
• Hands-on experience on E-Business Suite R12 Applications Upgrade.
• Extensive hands on experience on Patch analysis and applying for database and applications.
• Involved in complete software development lifecycle (SDLC) for Oracle Implementations and upgrades.
• Supporting and maintaining the Application responsibilities access control in system
• Result oriented, innovative Oracle Database Administrator/Oracle applications DBA experience as well project management.
• Taking backup and cloning database on different level by using Expdp/Impdp dump utilities.
• Participates in the 24/7 on-call support on rotation.
• Implemented the Roles Based Access Control (RBAC) in DEV, UAT and Production ERP Applications.
• System Administrator responsibilities maintaining.
• Creating the roles for different category of modules and assigning the responsibilities.
• Creating the permission sets and assigning to respective roles.
• Provide Level 3 application database administration production support to resolve problems including on-call support and closing of helpdesk tickets.
• Coordinate with data security to provide appropriate security, SOX compliance and secondary authorization.
• Managing RMAN, Cold and Hot backups from database side.
• ERP Application user creation.
• Responsibilities creation.
• Supporting and maintaining the Application user’s access control in system.
• Supporting and maintaining the Application responsibilities access control in system.
• Assigning the required responsibilities to the internal/external users.
• Built up of new database and cloning the database and applications as per Business requirement.
• Hands on experience on MS SQL Server 2008, 2012 Installation, configuration and supporting the database.
• Provided the ERP and Non-ERP Healthy database and Applications to users
• Performed multiple SYS Admin activities.
• Creating and managing DDBoost RMAN backups and recovering the database from EMC DDBoost RMAN Backup.
• Maintaining and supporting the Oracle Demantra Applications and Value Chain Planning and databases.
• Applied the up-to-date and required patches for all the applications.
• Defined and documented the real time error handling strategy documentation.
• Closely worked with the programmers and the functional team to bridge the gap between them.
• Setup and configure 2 node RAC database and parallel concurrent processing to support failover and load balancing of concurrent processing.
• Performing various post clone activities on the newly refreshed instances.
• Applying one-off patches, CPU patches, RUP patches to various instances.
• Interacting with the users who raise Help desk tickets for any Database issues and work on resolving and closing the tickets.
• MS SQL Server Databases support and administration.
• Supporting and maintaining the MS SQL Server database.
• Hands on experience on MS SQL Server 2008, 2012 Installation, configuration and supporting the database.
• GRC Applications support and administration.
• UPK database and applications support and administration.

Environment: R12.1.3 ERP Applications, Oracle Database 11g/10g databases, Oracle Demantra Applications, OBI services, RAC, RMAN, ASM, Data guard, GRC Applications, UPK Applications, OEM 12C & RBAC.

Confidential, Columbus, OH

Oracle Apps DBA & SQL Server DBA

Responsibilities:

• My experience with Oracle RDBMS with installing, patching, cloning, upgrades, monitoring, maintaining, performance tuning.
• Hands-on experience with Oracle 10g/11g RAC, ASM, RMAN, SOA Suite, Data Guard, Oracle replication and OEM 12C.
• Hands-on experience on Oracle Database upgrades from 10.2.0.4 to 10.2.0.5 and 11.2.0.3 and higher versions.
• Hands-on experience on cloning and refresh of the databases from Production to Test and Development environments.
• Hands-on experience on Performance Tuning and Troubleshooting the database and concurrent jobs.
• Involved in complete software development lifecycle (SDLC) for Oracle Implementations and upgrades.
• Supporting and maintaining the Application responsibilities access control in system
• Result oriented, innovative Oracle Database Administrator/Oracle applications DBA experience as well project management.
• My database and application knowledge, experience and expertise includes, RDBMS versions 11g, 10g, 9.x, e*Business Suite 11.5.9, 11.5.10, and R12.1.3 and Sun Solaris Administration and Linux Server management.
• Taking backup and cloning database on different level by using Expdp/Impdp dump utilities.
• Participates in the 24/7 on-call support on rotation.
• Built up of new database and cloning the database and applications as per Business requirement.
• Provided the ERP and Non-ERP Healthy database and Applications to users
• 24*7 supported for all Production, UAT, SIT and Development database and applications both ERP and Non-ERP applications in Offshore and Onsite locations
• Performed multiple SYS Admin activities.
• Creating and Managing DDBoost RMAN backups and recovering the database from EMC DDBoost RMAN Backup.
• Build Oracle Demantra applications and databases.
• Build Oracle Demantra OBI services.
• Maintaining and supporting the Oracle Demantra Applications and databases.
• Applied the up-to-date and required patches for all the applications.
• Defined and documented the real time error handling strategy documentation.
• Closely worked with the programmers and the functional team to bridge the gap between them.
• Setup and configure 2 node RAC database and parallel concurrent processing to support failover and load balancing of concurrent processing.
• Coordinating various tasks with Offshore and work along with them as required cloning the production Oracle E-business suite environments to non-production environments.
• Performing various post clone activities on the newly refreshed instances.
• Applying one-off patches, CPU patches, RUP patches to various instances.
• Interacting with the users who raise Help desk tickets for any Database issues and work on resolving and closing the tickets.
• Installation, monitoring and troubleshooting of other Oracle Databases.
• MS SQL Server Databases support and administration.
• MS SQL Server Databases support and administration.
• Hands on experience on MS SQL Server 2008, 2012 Installation, configuration and supporting the database.

Environment: Oracle R11, R12.1.3 ERP Applications, Oracle Database 11g/10g/9i databases, Oracle Demantra Applications, OBI services, RAC, RMAN, ASM, Data guard.

Confidential, San Diego, CA

Oracle Apps DBA

Responsibilities:

• Database upgrades from 10.2.0.4.0 to 10.2.0.5.0 and from 10.2.0.4.0 to 11g versions.
• Managing space in table spaces and important files systems (like UDUMP,BDUMP etc)
• Working with databases with single instances and High Monitoring database for locks and issues like temp distribution in RAC instances.
• Applying RDBMS patches (OPatch) in single and RAC instances.
• I have experience with Installation, Configuration, Administration and Performance tuning of Oracle Weblogic Application Servers running for Oracle Service Bus/Business Activity Monitoring/Oracle SOA Suite.
• Have the exposure on Oracle Service Registry/Oracle Enterprise Repository in a clustered environment.
• Taking backup and cloning database on different level by using Expdp/Impdp dump utilities.
• Developed and maintain automated deployment systems.
• Hands-on experience on E-Business Suite R12.1.3 on Support.
• Had experience managing environments using Weblogic Admin Server console, Enterprise Manager, Node manager and other server administration utilities.
• Monitor hardware, OS and application performance through available utilities.
• Monitoring and controlling the standard JVM monitoring utilities.
• Have the experience on analyze and troubleshoot deployment issues in a timely manner.
• Act as primary customer contact for deployment related inquiries and issues.
• Strong issue fixing and debugging skills
• Automation of cloning processes using UNIX and sql scripting.
• Performance tuning of Oracle databases.
• RDBMS binary and database upgrade.
• Monitoring and troubleshooting the failed batch jobs and backups
• Refreshing Database on multiple levels using EXPort/IMPort utilities.
• Experience in working on Single Node and Multi Node installations involving both dedicated and shared application configurations for Production, User acceptance Test, SIT and Development Environments
• Troubleshooting patch issues.
• Patch analysis.
• Cloning applications in single and multi-node environments manually using auto config.
• Refreshing database and Applications using the existing binaries and Production backup
• Moving applications across nodes.
• Automation of certain cloning processes using UNIX and sql scripting.
• Pro-active maintenance like checking health of instance monitoring databases, concurrent programs, form sessions, general performance issues etc.
• Sys admin activities involving managing users and responsibilities.
• Workflow configuration in Oracle applications
• Discoverer configuration in Oracle applications
• Bouncing and troubleshooting the Non-ERP applications like JDA, Ariba, Vertex, DRM and CATS
• Patch applying in Non-ERP applications like JDA, Ariba, Vertex and CATS
• Released Tax Tables(Sales Use Tax and Consumer Use Tax) updating in Production, UAT, SIT and development Vertex applications
• Providing support for SRs with Oracle
• Monitoring and maintaining Hyperion Essbase and Planning Applications
• Providing required access for Hyperion Essbase and Planning Applications to users.
• Built up and supporting the GRC Production CCG and AACG Applications
• Patches applying in CCG and AACG applications
• Setup and configure 2 node RAC database and parallel concurrent processing to support failover and load balancing of concurrent processing.
• Developed method of Practice for various DBA activities like cloning, shutdown/startup of services.
• Coordinating various tasks with Offshore and work along with them as required cloning the production Oracle E-business suite environments to non -production environments.
• Performing various post clone activities on the newly refreshed instances
• Applying one-off patches, CPU patches, RUP patches to various instances.
• Check-in and checkout the code from VSS and deploying it to various instances.
• Interacting with the users who raise Helpdesk tickets for any Database issues and work on resolving and closing the tickets.
• Installation, monitoring and troubleshooting of other Oracle databases.

Environment: Redhat Linux 5, Oracle 11g RAC (11.1.0.7), Oracle 10g RAC (10.2.0.5 & 10.2.0.4), Oracle ERP Applications 11.5.10 and R12.1.3

Confidential

Oracle Apps DBA

Responsibilities:

• Database Schemas migration from 8i database to 11i database.
• Managing RMAN, Cold and Hot backups from database side.
• Built up of new database and cloning the database and applications as per Business requirement.
• Provided the ERP and Non-ERP Healthy database and Applications to users
• 24*7 supported for all Production, UAT, SIT and Development database and applications both ERP and Non-ERP applications in Offshore and Onsite locations
• Performed multiple SYS Admin activities.
• Taking backup and cloning database on different level by using Expdp/Impdp dump utilities.
• Creating and Managing DD Boost RMAN backups and recovering the database from EMC DDBoost RMAN Backup.
• Build Oracle Demantra applications and databases.
• Build Oracle Demantra OBI services.
• Maintaining and supporting the Oracle Demantra Applications and databases.
• Applied the up-to-date and required patches for all the applications.
• Defined and documented the real tine error handling strategy documentation.
• Closely worked with the programmers and the functional team to bridge the gap between them.
• Setup and configure 2 node RAC database and parallel concurrent processing to support failover and load balancing of concurrent processing.
• Coordinating various tasks with Offshore and work along with them as required cloning the production Oracle E-business suite environments to non-production environments.
• Performing various post clone activities on the newly refreshed instances.
• Applying one-off patches, CPU patches, RUP patches to various instances.
• Interacting with the users who raise Help desk tickets for any Database issues and work on resolving and closing the tickets.
• Installation, monitoring and troubleshooting of other Oracle Databases.
• MS SQL Server Databases support and administration.
• Contacting and approaching different business stake holders.

Environment: Oracle 10g Database Server, Web logic Application Server, Oracle ERP Applications 11.5.10.

Confidential

Oracle Apps DBA

Responsibilities:

• Cloning Oracle Applications 11.5.10 from two - node/single node environment to two/one node environment.
• Analyzing and Patching Oracle Applications, Maintenance Pack, Family Pack, Mini Pack etc.
• Monitoring Concurrent Processing and troubleshooting all managers related issues.
• Use AD tools, FND scripts to maintain Apps Instances.
• Maintain 5 Application Servers in different platforms.
• Table space management
• Troubleshooting the long running concurrent programs.
• Taking backup and cloning database on different level by using Expdp/Impdp dump utilities.
• Troubleshooting for all database space related problems.
• Help Desk Support to different Experian servers in Oracle Application Servers.
• Sys admin activities like creating apps Users, responsibility, Menu according to the requirement.
• Working with Oracle through SR.
• Responsible for gathering requirements from the business.
• Completing and delivering the components for Production, UAT, Development applications in the right time.
• Supporting the Production, UAT and Go-Live of the components
• Authoring all technical design documentation to the client.

Environment: Oracle 9i, Oracle 10g, Oracle Apps 11i and Release 12.1.3

Confidential

Oracle Apps DBA

Responsibilities:

• Patching and Managing Oracle Applications 11.5.9 (E-Business Suite 11i).
• Setting up new environments (Development, Production)
• Creating the database, tables, table spaces, data objects, setting privileges, indexes, user logins, passwords (security).
• Database Sizing, Table space Management, Security Administration.
• Defragmentation of database using export import.
• 24 X 7 Production server support.
• Interacting with development team, carrying out the jobs as and when required/ as per schedule.
• Monitoring and supporting Production server issues.
• Applying patches on production servers.
• Proactively applying the patches on Oracle Database as well as on E-Business suite server.
• Installation of Oracle Applications E-Business Suite 11.5.8 and 11.5.9 on Sun Solaris.
• Conversion of single node instance into multiple node instances with multiple application tiers
• Cloning, patching and maintenance of Oracle Application instances.
• Integration of Oracle Applications with Oracle 9i Application server Single Sign-on module, reports server and Discoverer server.
• Configuration of Printers on UNIX and registering the printer drivers with Oracle.
• Applications handling multi-lingual Oracle Applications with customized forms and reports that support both English and Japanese languages.
• Registration of Custom components with Oracle Applications and performing the code migration from one instance to another instance using FNDLOAD