SUMMARY

• Oracle certified professional with 14 plus years of diversified experience in High Availability Grid Infrastructure RAC with ASM , stand alone database, Replication options known as Data Guard, Streams In all of these expertise in Installation, configuration, Administration tuning, design, installation, configuration, patches, upgrade, migration', database security, capacity planning, data modeling, backup, recovery, cloning, auditing, SQL, PL/SQL, troubleshooting and documentation.
• Solution Oriented IT Professional with core competencies in Oracle Applications EBS Administration, Customer Care and Billing, UC4, G4 ServiceHub , Hyperion, GIS Oracle Database Administration with RAC.
• Extensive Experience with Installations, upgrades, Patching, Cloning, conversion, process improvement, Application Tuning, Database Performance Tuning, Backups and Recovery, Space Management, Security Administration, Data Architecting, Capacity Planning, Disaster Recovery, Oracle Data Guard Setup, Performing Switch over/Switch back, Data Warehousing, Data Replication, Web Applications Design UNIX shell, Perl scripting, Documentation and project management.
• Experienced in installation, configuration and administration of fusion middleware technology.
• Strong interpersonal communication skills, ability to interact with people at all levels.

CORE TECHNICAL SKILLS

• Middleware
• Tools
• Operating System
• RDBMS
• Oracle Applications 12i, 11.5.10/9 and 10.7
• ERP
• Oracle 7,8i, 9i ,10gR2 and 11gR2
• SQL Server7, 2000 and 2005
• Teradata 7
• HP, Sun Solaris and LINUX
• Windows 2008, 2003, 2000, XP and NT
• Cloud Control Oracle Enterprise Manager
• DBA Studio, Toad , SQL Navigator, and PL/SQL Developer
• Humming Bird X-windows, VNC and Remote desktop Server, PC Any where and Net Meeting.
• Web Logic 5, 7, 10 and 11

Clients Served:

Confidential

Sr Oracle Database and Applications Administrator.

Contributions:

• Configured, maintained and patched Oracle e-business R12 12.1.3 in multi-node, multi apps nodes, RAC rollout to Production for modules like Financials, HRMS MSCP etc.
• Provide 24 7 support for Oracle Applications, Databases in the SOX controlled environments as per the SLA's and perform regular maintenance tasks.
• Instance/Capacity planning for the upcoming projects, consolidation of databases for effective server resources utilization.
• Perform Oracle Applications Cloning using Rapid Clone method.
• Perform patching activities such as patch analysis, merging patches, applying patches and post patch activities.
• Concurrent Processing management, Concurrent requests, concurrent manager's maintenance.
• Changing the Oracle Applications Passwords as per the SOX policies.
• Security User Management, Privileges, Roles, Auditing SOX , Authentication, Hardening password, responsibility creation etc.
• Planned and upgrade or migrate databases from 10gR2 to 11gR2 environments.
• Implementation of Backup Strategies using Export/Import and RMAN
• Upgrade 11i GC to 12c and configured targets databases, ASM and Middleware/Fusion weblogic to Cloud Control
• Implementation of monitoring scripts on the database and application services.
• Extensively worked with Oracle on Oracle SR's to address database and application issues.
• Migration of code, applying patches using.
• Plan and implementation of Archival Strategies' in the databases which has rapid growth.
• Monitoring the database and server performance. Database performance includes server performance, active sessions, locks, long running queries, auditing user sessions etc.
• Deciding the naming conventions of data file, redo log files, table spaces, and segments.
• Creating the database, tables, table spaces, data objects, partitioning, indexing, materialized views etc.
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management, and Security Administration
• Backups and Recovery using cold and hot backups.
• Extensive Unix Shell Scripting to automate maintenance and configuration of tech stack components, Cron jobs to automate the backups, monitoring Alerts
• Administrated Enterprise Database sized more than 2.5 Terabyte
• Servers Migration and Consolidation of Databases.
• Performance and Tuning has been performed in following areas
  • Database and ASM side
  • Application side
  • Server and
  • Storage side tuning

Part of the migration project New BLUE from legacy systems mainframes to Oracle suite such are

• CC B customer care and Billing
• Power Plant
• Hyperion
• EBS
• OBI
• GIS
• G4 service hub
• Maximo IBM
• UC4 and
• SOA/FUSION MIDDLEWARE

Following ad-hoc, planned tasks have been performed in production and non-production environments in the above applications

• Install, configure, Administrate and patch the Fusion environments, clustered and non clustered environments.
• Tuning
• Cloning and
• Patching
• Administrate ad-hoc and planned tasks.
• Installed and configured application and databases of respective application
• Support day-to-day activities such as
• Monitor the database performance, table spaces, locks, max extents etc.
• Configure the database and app tier backups and monitor.
• Address day to day user calls, system performance issues.

Technologies: 12i, 12c, 11gR2, 10gR2, OMS 11gR1 and 12c , MS SQL Server 2000/2005, Linux, Sun Solaris, Windows 2003 and 2008 , Visual Studio 2005, RMAN, Remedy incident change request tracking tool , Oracle EBS Suite, SOA and FUSION, Toad 9 and ETC

Confidential

Sr Oracle DB Engineer

Contributions:

• Oracle Grid Infrastructure installed in production, UAT and Development environments. This includes RAC and RAC 1 node Grid Infrastructures.
• Upgrade and Migrate multi Terabyte database' from 10gR2 to 11gR2 using TTS methods.
• Utilized RMAN and split mirror technologies for backup and Recovery strategy and even performed cloning of database.
• Upgrade OEM from 10g to 11gR1 Grid Control and setup alerting thresholds and rules.
• Performed performance tuning tools Explain Plan, SQL Trace, TKPROF, Statspack, and ASH.
• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning.
• Restore and Recover database' using RMAN and storage images.
• Administering Real Application Cluster RAC databases running on ASM and RAW file systems.
• Database Capacity Planning configuration redo and stream sizes
• Having good knowledge in transportable Tablespaces, traditional upgrade methods, export and import utilities and used to upgrade and migrating databases.
• Responsible for scheduling and holding design reviews as needed to support the development processes.
• Good at managing and monitoring grants, roles, privileges to users, analyze tables to generate and gather stats including verify daily backup's logs and alert logs
• Configured user log on load balancing and failover on RAC database
• Regular DBA activities like Undo segments, database auditing, space management, database issues, locking, managing user groups and tuning.
• Applied patches and database re-organization using oracle enterprise manager OEM .
• Plan, develop and Schedule of the production refreshing, dependency checking and setting up the initialization parameters for standby database as well as tuned SPFILE parameters.
• Maintained Very Large Multi Terabyte VLDB around 5TB in Data Warehouse Environment for DSS.
• Documentation of Oracle database operations standards.

Technologies: 9i, 10gR2, 11gR2, OMS 11gR1 , MS SQL Server 2000/2005, Linux, Sun Solaris, AIX , Windows 2003 and 2008 , Visual Studio 2005, RMAN, Remedy incident change request tracking tool , and Toad 9.

Confidential

Sr Oracle DB Engineer

Project: Forest is among the top pharmaceutical and biotech companies. Forest identifies, develops, and delivers pharmaceutical products that make a difference in people's lives. I have been involved in supporting various application databases, installation, upgrade and patch.

Contributions:

• Oracle Grid Infrastructure installed and configured in production, testing and development environments.
• Upgrade and Migrate multi Terabyte database' from 8i, 9i, 10gR2 to 11gR2.
• Used RMAN and split mirror technologies for backup and Recovery
• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning.
• Prepared instructions or steps on installation, configuration, and administration of Oracle binaries, database, Grid Infrastructure and Grid Control.
• Prepared steps on migration and upgrading databases from lower versions to 11gR2 and AIX to Linux environments.
• Database Capacity Planning configuration redo and stream sizes
• Having good knowledge in transportable Tablespaces, traditional upgrade methods, export and import utilities.
• Prepared backup strategies and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts.
• Responsible for scheduling and holding design reviews as needed to support environments.
• Good at managing and monitoring grants, roles, privileges to users, analyze tables to generate and gather stats including verify daily backup's logs and alert logs.
• Configured user log on load balancing and failover on RAC database.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Applied PSU and one-of patches to GI, Oracle Homes, OEM agents and OMS. Also document the steps for operations.
• Build data guard environments and documented steps for Operations purpose.
• Plan, develop and Schedule of the production refreshing, dependency checking and set up the initialization parameters for standby database as well as tuned SPFILE parameters.
• Worked on migration and upgrade steps preparation of a Very Large Multi Terabyte VLDB around 10TB databases.
• Test and prepared steps for advanced compression options for SAP environments.
• Upgrade OEM from 10g to 11gR1 Grid Control and setup alerting thresholds and rules.
• Documentation of Oracle database operations and training of backup personnel.
• Engineering tasks prepared for SAP and non SAP application databases.

Technologies: 9i, 10gR2, 11gR2, OMS 11gR1 , MS SQL Server 2000/2005, Linux, Sun Solaris, AIX , Windows 2003 and 2008 , Visual Studio 2005, RMAN, Remedy incident change request tracking tool , and Toad 9.

Confidential

Sr Oracle Database Administrator

Contributions:

• Install, Upgrade and patch Oracle 10gR2 databases and RAC.
• Participated in SEIBEL CRM production setup
• Part of QA Lab setup on VM ware.
• Improve database performance by setting the init parameters and also by tuning the application SQL'.
• Perform backup and recovery using RMAN
• Capacity planning.
• Monitor Oracle Databases and other Oracle targets using OEM.
• Database access creation and code push.
• On call rotation, support in 24x7 environments.
• Resolved Ad hoc Incidents Remedy , change requests and business requests.
• Participate Change control board meetings, Tech meetings and by weekly status meetings.
• Supported Siebel CRM application database and in house application database.

Technologies: 10gR2, OEM 10gR1 , Linux, Windows XP, RMAN, Altiris incident change request tracking tool , and Toad 8.6.1.

Confidential

OPERATIONAL- Oracle Database Administrator.

Contributions:

• Support 9i and 10gR2 databases
• Upgrade ODS database from 9i to 10gR2
• Set up and maintenance of data Guard physical standby databases.
• Tune database and application queries.
• Accomplished the Oracle database upgrades primary and standby and applied patches.
• Perform backup and recovery using RMAN and BCV splits.
• Implemented data security by Auditing UA and production environments and also by proper database access roles between applications and users. Enabled XML, EXTENDED and OS auditing in UA and PROD environments.
• OSCI Oracle Customized Scripts Implementation scripts to start and stop oracle binaries during the server boots, default environment setup and etc
• Capacity planning.
• Database monitoring using OEM 10gR1 and also Petrol monitoring.
• Grid Control Administration and also OEM repository maintenance.
• Database access creation and code push.
• On call rotation, support in 24x7 environments.
• Resolved Ad hoc Incidents Remedy , change requests and business requests.
• Participated in Change control board meetings, Tech meetings and weekly status meetings.
• Supported PeopleSoft, Remedy, ODS and more application databases.

Technologies: Oracle 9i, 10gR2, OEM 10gR1 , HP UNIX, Sun Solaris, Linux, Windows XP, RMAN, Remedy incident change request tracking tool , CITRIX, AutoSys and Toad 8.6.1.

Confidential

Sr Database Administrator

Contributions:

• Reduced the oracle installation time by 30 by documenting all the steps.
• Improved the backup time and the amount of backup by 30 using RMAN.
• Improved the database recovery time by creating the pro-active scripts.
• Setup and maintain the databases and Data Guard physical standby databases.
• Capacity planning
• Install and set up Database monitoring using OEM 10gR1 and also installed individual agents on all the servers.
• Data Modeling using Case2.
• Day to day Ad hoc request s resolving and also providing solutions for planned events.
• Attended Tech meetings, requirements gathering and designed as part of Data modeling.
• Note: Above all tasks are for Production, QA and Development databases.

Technologies: Oracle 9i, 10gR2, OEM 10gR1 , Sun Solaris 5.8 5.9 Linux, Windows 2000, XP, RMAN, Case2 and Toad.

Confidential

Sr. Database Administrator

Contributions:

Oracle 11.5.4 administration, Cloning, System administration Application user creation and profile setup Print pool creation Concurrent jobs monitoring Installed Oracle software and its upgrades Database Performance Tuning Installed Security patches Oracle Problem analysis and resolution Responsible for the Administration, maintenance, monitoring and performance tuning of all the databases and Job Automation, STATSPACK reports Migration of Databases from Oracle 8i to 9i, and some databases to 10g. Supported databases on Windows 2000, UNIX and Linux. Monitoring databases using Embarcadero performance monitor Experience on OEM. Backup and Recovery using RMAN. STDBY database creation for critical databases for machine critical applications holding databases. Teradata weekly and daily backups using NCR Net backup utility. Co ordination between teams. Architecture reviews, Change management meetings and Team meetings. Supported Siebel CRM, Oracle Apps 11.4 and other application databases.

Note: Above all tasks are for Production, QA and Development databases.

Technologies: Oracle 8i, 9i, 10g and 11i HP, Sun Solaris 5.8 Linux, Windows 2000,XP NCR Teradata, Net backup, RMAN, Toad, PL/ SQL developer, Embarcadero Performance Center tool and DBA Studio.

Confidential

Oracle DBA and Tool Supporter

• Oracle EBS 10.7 Administration
• Creating Production and Development Databases
• Concurrent jobs creation and scheduling
• Application users creation and profile setup
• Print spool creation, monitoring and trouble shooting
• Automated FAX process using STR Software product.
• Provided web feeling of Apps 10.7 using Citrix Servers
• Citrix server Apps related issues RTS.
• production databases runs on Veritas Cluster Servers
• Setting proper init SID.ora tuning parameters
• Monitoring Performance by querying Dynamic Performance Views
• Taking Database backup and adopting appropriate recovery procedures
• Taking HOT and COLD Backups using SQL BACKTRACK
• Performing Logical Backup Export Backup
• Recovering Database in Non Archive Log Mode By Importing Database
• Recovering database in Archive log Mode
• Taking database back up adopting specific recovery procedures as and when required
• Programming Shell scripts for space/processes/listener/oracle alerts monitoring
• Programming Shell scripts for Backup and Recovery
• Installing implementing Oracle 9i and 10g
• Upgrading production and development databases to Oracle 9i and 10g
• Management of schemas, objects
• Partitioning the tables indexes
• Creating Roles Profiles in all the database based on application specific requirement
• Granting the roles privileges to application users to access the oracle object
• Tuning SQL queries by using EXPLAIN PLAN and TKPROF Indexing of tables
• Checking Trace files and taking corrective action in case of abnormal termination of instance
• Uploading the Data by using SQL LOADER
• Partitioning the Tables and Indexes
• Statistics collecting using DB Tuner Troubleshooting based on the collected statistics
• Monthly quarterly periodic activities like recycling the listener stop start concurrent manager, shutdown startup the database etc.
• Implementing software patches
• Performing Capacity planning
• Gathering detailed requirements from Functional and Business owners
• Supporting application groups when application comes to live
• Peer review of code other support documents
• Documenting the process
• Preparing user/system manual
• Batch and RMAN backups have been schedule using APPWORX UC4
• Attending Meetings
• Co-Ordination with offshore
• Infrastructure support on UNIX, Linux and Windows NT and 2000.
• Designing Supporting new projects / Initiatives
• Monitoring inbuilt problem and performance tracker AMA application and monitoring tool.

Note: Above all tasks are for Production, QA and Development databases.

Technologies: Oracle 7.x, 8i, 9i, 10g and 10.7, PC Anywhere, Data Loader, TOAD, SQL Navigator, STR Fax software. Veritas clusters, HP, Sun spark servers, Blade, Linux, Windows 2000 and NT, Embarcadero Performance Center tool, SQL Backtrack 5.2, AMA Application monitoring and Alerting System

Confidential

Oracle Database Administrator

Project: GECFS has outsourced the Ready-To-Serve RTS Support areas. This engagement involves understanding of the RTS environment at GEFS, study of their existing operational processes and executing the RTS assignment. RTS environment includes several System/Database Administration work and routine operational tasks.

• Administration of Oracle databases.
• Installation, upgrading and patch application on various Oracle versions.
• Installation/Upgrading/Creation/monitoring of database
• Planning, implementing and automation of database backup.
• Assisted developers in writing efficient code and making efficient use of the resources for better performance and optimization.
• Database tuning, table space management, monitoring Rollback Segments.
• Replication of database
• Established best practices for database standards and documentation.

Note: Above all tasks are for Production, QA and Development databases.

Technologies: Oracle 7.3.4/8.0.x , Unix Shell Scripting, SQL Scripting, Unix CRON jobs, Space Manager, Schema Manager, RMAN, Oracle Data Warehouse, UNIX Sun Solaris 2.8, Windows NT/2000

Confidential

Team Member

• Analyze the each module such are Customer, Sales, Insurance, relief, fuel and billing.
• Design
• Test plans preparation
• Implementing enhancements
• Conducting code reviews / code walkthroughs as and when required.
• Testing changes and roll out into production
• Monthly jobs monitoring
• Document preparation

Technologies: Oracle 8.x, PL/SQL, SQL PLUS, Sun Solaris 5.6, Sun spark 1000 to E6000, Oracle Forms, Pro C Windows NT, 2000

Confidential

Team Member

• Participated in gathering requirements.
• Involved in high and low level designing.
• Prepared Test Cases
• Coding and internal reviews
• Testing the modules
• Rollout into Production and
• Support.

Technologies: Java 2.0, Servlets, HTML, Oracle 8.x, SQL PLUS, Windows NT, 2000.

COURCES/WORKSHOPS

• RAT by Oracle
• IPMS II
• Database Tuning
• Informatica 5
• Data warehouse concepts
• Six sigma rally
• CMM Level 5
• Initial training programming
• Object Oriented programming