We provide IT Staff Augmentation Services!

Lead Solution Architect Resume

SUMMARY:

  • 10 years+ of experience as Oracle Application DBA (11 i, R12 and R12.2), on UNIX, Linux, AIX, Solaris and Windows2000 .
  • Applying patches to test instances and performs rigorous testing and subsequently applying to development and production instance.
  • Well versed in using AD utilities - adadmin, adpatch, adrelink, adctrl, adident, admrgpch.
  • Managing concurrent process,concurrent programs/managers registering new concurrent programs concurrent types, defining workshifts and specialization rules and combined specialization rules, defining new concurrent managers as per client requirements.
  • Involved in Migration of 11.5.10.2 to 12.0.4 ( R12)
  • Involved in PCP(Parallel Concurrent Processing) configuration.
  • Performa Database upgrade from 10g to 11g
  • Perform Database upgrade from 11g to 12c
  • Involved in creating RMAN backup scripts.
  • Configure and install RAC (10G RAC) on Linux
  • Involved in configuration on LOAD Balancing
  • Administer and maintain Cluster (RAC) environment since last 4 yrs.
  • Good knowledge of cloning RAC as well as Non-RAC database and configuring Confidential database.
  • Managing Database structures,constraints,database access,roles and privileges.
  • Good Knowledge of online, offline and RMAN backups and recoveries.
  • Managed Confidential configuration and migration of database from clustered file system to ASM.
  • Installation, Configuration and deployment of Oracle 11i, R12 and 10g/9i/8i database.
  • Install and maintain multi node installation of 11i and R12.
  • Expert in OEM, TKPROF, Explain Plan and SQL tuning of Oracle databases.
  • Highly experienced in Oracle 11g/10g/9i/8i Administration, Export and Import. Performance Tuning, Backup & Recovery.
  • Designed and implemented backup and recovery strategies. Extensively used RMAN for backup and Disaster recovery.
  • Responsible for patching oracle application and Oracle Databases as per requirements.
  • Successfully implemented Physical Data guard (standby database ) using Oracle Data Guard feature for High availability configuration.
  • Provided 24/7 support to production databases beyond regular hours.
  • Efficient in P erformance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
  • Experienced in Database design including creation, modification, and deletion of table spaces, data-files, rollback segments and schema's, creating schemas (Tables, Indexes, views, sequences, synonyms, roles, and users).
  • Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
  • Eposure on Weblogic administration.
  • Exposure on OBIEE administration.
  • Exposure on Informatica administration.
  • Exposure on SOA Administration.

TECHNICAL SKILLS:

Applications: Oracle Applications 11.0.x, 11i .R12 and R12.2, Application Object Library, System Administration, Workflow and Alerts, System Administration, Accounts Receivables, Purchasing, Order Entry, Account Payables, Fixed Asset, Cash Management and General Ledger

RDBMS: Oracle 8.0.x, Oracle8i, Oracle 9i, Oracle 10g and 11g

Languages: SQL, PL/SQL

Administration: Database Administration, Backup & Recovery, Performance & Tuning,SQL Server 6.5 and 7 Database administration

Database Utilities: Export / Import, SQL * Plus and SQL Loader, Tkprof, Bstat / Estat, StatsPack, AWR, Server Manager, Confidential Backup, RMAN

Database Tools: TOAD, Oracle Enterprise Manager (OEM), Grid Control, DBArtisan

Development Tools: VB 6.0 Forms 4.5 and Forms 6i

Operating Systems: Sun Solaris 2.6, Linux - RedHat Linux, AIX, Solaris,Windows 3.x/9x/NT/2000/2003/XP

Hardware: HP9000, Sun 6800, v880, 4400, Sequent & NT, Windows 2000

PROFESSIONAL EXPERIENCE:

Lead Solution architect

Confidential

Responsibilities:

  • Installation of Latest version of oracle application 12.2.5.
  • Installation of weblogic.
  • RMAN setup
  • Cloning of PROD instance to UAT.
  • Patch analysis and applying the patch both 11i and R12 instances using ADPATCH and ADOP.
  • Installed 12c cloud control.
  • OEM configuration and maintained the database administration.
  • Done Cross platform migration (SunOs to Linux ).

Confidential

Principal consultant

Technologies - E-Business Suite(R12), Oracle Database 11.2.0.3 On RAC Oracle solaries sparc 4

Applications: 11.5.9,12.04, R12 and R12.2

Database: 10g and 11g

Responsibilities:

  • Analysis and Applying the patches like CPU, application patches, Country code patches, one off Patches and maintenance patches.
  • Resolving the user problems like accessibility of applications.
  • Performed taking backups of OCR and VOTEDISK files.
  • Applied database patches Cluster Patches using Opatch Utility.
  • Applied application patches using ADPATCH AND ADOP
  • Cloning the application of run file system then copied to patched system(R12.2
  • Weblogic administration.
  • Informatica administration.
  • Performed the OEM and 10g Grid installation and configured the database and application Alert.
  • Performed alert mailing configuration so that if issue came it will notified through mail.
  • Manage Code migration, Data Conversion, disk space management, database performance and resource monitoring. Manage database network setup, Cluster setup, Fail Over set up,distributed database setup, and trouble-shooting (e.g. SQL statements, locking issues, network and Performance problems).

Confidential

Principal consultant

Responsibilities:

  • Code Migrations using KINTAN (third party tool) in DEV,TEST,UAT and PROD instances.
  • Analysis and Applying the patches like CPU, application patches, Country code patches, one off patches and Maintenance Patches
  • Refresh PROD instance to TEST and UAT.
  • Resolving the user problems like accessibility of applications
  • Creating the Users and assign the responsibilities.
  • Configured SSO
  • Implemented and configured the SSL setup.
  • Performed the OEM and 10g Grid installation and configured the database and application Alert.
  • Performed alert mailing configuration so that if issue came it will notified through mail.
  • Upgrade large financial organization from 11.5.7 to R12.1.
  • Design architecture put together all technical documentation, mentor dba's during the upgrade process.
  • Implemented Data Guard for standby migrated existing 9.2.
  • Databases to 11g Real Application Clusters. Implement a shared application top for both techstack and appl top. Customers run AIX, HP-UX, Linux and Solaris.
  • Manage Code migration, Data Conversion, disk space management, database performance and resource monitoring.
  • Manage database network setup, Cluster setup, Fail Over set up, distributed database setup, and trouble-shooting (e.g. SQL statements, locking issues, network and performance problems)
  • Backup the Database or logical/user objects for securing the data and database structure.
  • Build up plans for cumulative or incremental backups using RMAN, Exp/Imp and Shell scripts. Set-up Backup policy and plans for Daily, Weekly and Monthly backup.
  • Make cold or hot backups according to the production and Business requirements.
  • Test and verify that the backup is completed and reliable to restore and roll forward if required.
  • Tools- Net backup, RMAN, Exp/Imp, shell scripts, Data Guard for Standby DB

Principal Consultant

Confidential

Responsibilities:

  • Code migration on both UAT and PROD instances.
  • Performed 11i To R12 Upgrade, We upgraded the database from 9.2.0.6 to 11GR2.
  • Performed the Disaster Recovery setup for the Client. As a part of Maintenance activity
  • Performed the DR drill. Health checkup of Production instances
  • Applying the patches on UAT, PROD instances.
  • Taking care of production and UAT errors.
  • Refreshing the PROD instance to Development instance every week.
  • Taking care of RMAN backup schedules.
  • Creating the Mail alerts such as tablespace free space, blocking session.etc
  • Proficiency in Upgrading, Patching and implementation of Oracle Apps (Release 12 / 11i) and Proficiency with several AD admin tools like Rapid clone, ADpatch, Auto upgrade, ADadmin, ADcontroller, Etc.
  • Performed the Disaster Recovery setup for the Client. As a part of Maintenance activity

Confidential

Sr.OracleApps DBA

Responsibilities:

  • Installation of Oracle 8i,9i,10g, 11i,R12 single and multi-nodes.
  • Involved in up gradation of Oracle Application from 11i(11.5.10.2 to 12.0.4) to R12.
  • Cloning the oracle application using Rapid clone.
  • Database Refresh,Using the Oracle Applications tools for maintaining the database
  • Done upgrade/migration from 12.0.4 to 12.0.6
  • Involved in upgrade/migration from 11i to R12 .
  • Done installation and configuration of Discoverer.
  • Maintain the RAC instances Using the SRVCTL,OCRCONFIG,CRSCTL
  • Applied the patches when ever requires and also applies security patches.
  • Created number of instances for test, development and production.
  • Managing the concurrent Managers and its operations like starting, stopping concurrent
  • Managers, re-schedule the request, purging the concurrent request historical data, tuning of
  • Concurrent managers and monitoring the concurrent managers.
  • Creation of scripts to automate the procedures to generate statistics on database space
  • Management, performance and pro active monitoring.
  • Application user’s creation and responsibilities

Confidential

Oracle Apps DBA

Responsibilities:

  • Installing and configuring the applications on single node.
  • Involved in up gradation of Oracle Application from 11i(11.5.8. to 12.0.4) to R12.
  • Copy/Clone of Oracle application environment using Rapid clone.
  • Performance Tuning of Applications and database.
  • Troubleshooting the servers (webserver, formserver etc).
  • Monitoring Applications and Database Backups.
  • Monitoring and Following up TAR’s raised with Oracle.
  • 24/7 Sys Admin Activities and Support.
  • User creation setups, Creation of Responsibilities.
  • Menu and functions creations, Profile Option Settings.
  • Creation of Request Group, Data group, value sets and Flex Field setups.
  • Creation of Concurrent Mangers, Programs, and Request sets.
  • Troubleshooting of Concurrent Requests and Request sets.
  • Automation of manual day to day activates using Concurrent programs.
  • Knowledge of all business functional flow with in the Origination.
  • Installation of Oracle 8i, 9i.
  • Involved in Database upgrad from 9i to 10G.
  • Involved in configuration of Data guard
  • Copy/Clone of Oracle application environment using Rapid clone.
  • Database Refresh.
  • Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl etc.
  • Applied RDBMS patches Opatch.
  • Created a number of database instances for development, testing and production.
  • Created and managed the Database objects and schemas.
  • Managing the Concurrent Managers and its operations like starting, stopping the Concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager perations.
  • Creation of new scripts to automate the procedures to generate statistics on database Space management, performance and for proactive monitoring.
  • Application user creation / responsibilities assignment.
  • Installing (11.5.9) and configuring the applications on single node.
  • Copy/Clone of Oracle application environment using Rapid clone.
  • Performance Tuning of Applications and database.
  • Troubleshooting the servers (web server, form server etc).
  • Monitoring Applications and Database Backups.
  • Monitoring and Following up TAR’s raised with Oracle.
  • 24/7 Sys Admin Activities and Support.
  • User creation setups, Creation of Responsibilities.
  • Menu and functions creations, Profile Option Settings.
  • Creation of Request Group, Data group, value sets and Flex Field setups.
  • Creation of Concurrent Mangers, Programs, and Request sets.
  • Troubleshooting of Concurrent Requests and Request sets.
  • Automation of manual day to day activates using Concurrent programs.
  • Knowledge of all business functional flow with in the Origination.

Confidential

Database Administrator

Responsibilities:

  • Installing (11.5.9) and configuring the application on single node
  • Copy/Clone of Oracle application environment using Rapid clone.
  • Database Refresh, Using the Oracle Applications tools for maintaining the database and application like Adpatch,Adadmin, Adctrl etc.
  • Applied RDBMS patches using Adpatch.
  • Created number of instances for test, development and production.
  • Managing the concurrent Managers and its operations like starting, stopping concurrent Managers, re-schedule the request, purging the concurrent request historical data, tuning of Concurrent managers and monitoring the concurrent managers.
  • Creation of scripts to automate the procedures to generate statistics on database space management, performance and pro active monitoring.
  • Application user’s creation and responsibilities.

Confidential

Oracle Application DBA

Responsibilities:

  • Involved in Database upgrad from 9i to 10G.
  • Involved application upgrade from 11.5.8 to 12.0.4
  • Involved in configuration of Data guard
  • Copy/Clone of Oracle application environment using Rapid clone.
  • Database Refresh.
  • Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl etc.
  • Applied RDBMS patches Opatch.
  • Created a number of database instances for development, testing and production.
  • Created and managed the Database objects and schemas.
  • Managing the Concurrent Managers and its operations like starting, stopping the Concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
  • Creation of new scripts to automate the procedures to generate statistics on database Space management, performance and for proactive monitoring.
  • Application user creation / responsibilities assignment.

Confidential

Database Administrator/Programmer

Responsibilities:

  • Troubleshooting and 2nd-level support for database application issues, including Remote administration of Unix OS: HP-UX, Solaris, Linux. Backup and recovery via RMAN scripts and troubleshooting, Monitoring of Oracle database; automated error notification. SQL statement analysis and tuning.
  • Storage analysis and allocation.
  • Online index rebuilds and storage recovery. production database, archives database, and multiple test environments.
  • Application development support to programmers on all aspects of database programming.
  • Responsible for maintenance and improvement of production, archive Oracle database.
  • Responsible for data refreshes for production, development and databases.
  • Responsible for storage usage of all databases, including rearrangements of the database logical structure and tables when needed.

Hire Now