APPS DBA
Resume:
MRUTYUNJAY S Y
CAREER SUMMARY
Mr. Mrutyunjay S Y has around 7+ years of IT Experience as an Oracle Apps DBA on various versions (12.1.3, 12.1.1, 11.510, 11.5.9) and as an Oracle DBA on various versions(8i, 9i, 10g &11g), 10g/11g RAC, ASM Data guard etc
His past roles have included working as a Senior Consultant (Oracle Apps Database Administration) with Oracle Corporation & Sierra Atlantic. His role included providing support for Oracle database administration for production as well as development environment running on LINUX, UNIX, SOLARIS and HP and Windows platforms and has worked on database with more than 2 TB of data.
He has lead Sterilite, Stryker, Amli and Clearstone Projects from onsite, which includes experience in Practices & Procedures in end-to-end Oracle Application implementations and product support including later rollouts. He has supported more than 40 Production instances of various clients across APAC region and Middle East from onshore and offshore.
Expertise in Oracle E-Business Suite which include installation, configuration, maintenance, migration and up gradation of Oracle Apps across various platforms, remote administration, cloning and patch application on AIX, Linux Sun Solaris and other UNIX platforms. He is Expert in RAC environments with ASM, standby database and shared appltop configurations. He has Expertise skills on Oracle SQL and Application tuning.
He is Proficient in maintaining cordial relationship with customers, ensuring quality and service norms thereby achieving customer satisfaction and business retention. Excellent interpersonal, communication and organizational skills with proven abilities as off shore and onsite co-coordinator for various projects
TECHNICAL PROFILE
Applications/Application Servers Oracle Applications Release’s: (12.1.3, 11.5.10, 11.5.9, 11.0.3);10g AS, 9iAS, Grid Control, Demantra
RDBMS 11g RAC, 10g RAC , ASM, 9i, 8i, Dataguard
Operating Systems LINUX (Suse, Red Hat), OLE, Solaris, HP, Windows 2000, Windows NT, DOS
Fusion Middleware Application Server 10g and SSO Maintenance
PROFESSIONAL EXPERIENCE
1. Projects Profile:
Team Sun Power onsite DBA
Role Senior Oracle Apps DBA and Onsite Lead
Client Sunpower Corp
Duration 31//01/2011 – Till Date
Environment
Database : Oracle 10.2.0.4
Oracle Applications 12.0.6
O/s :Oracle Enterprise Linux
Applications : SSO/OID, Demantra and OBIEE
• Setup DBA Practices
• Resolve DBA Outstanding issues
• Install OEM Grid and Configure Alerts
• Configure crontab monitoring
• Upgrading and Patching Oracle Applications and Databases.
• Interacting with functional Implementation teams and guiding/suggesting Instance requirements, patch management methodologies
• SSO/OID Configurations
• Demantra Installation
• OBIEE Database Support
• Installation and configure SMO
• Automation of SMO clone
• Worked Closely with Service-now to fix Issues
• Establish Change management Process
• Tuned and Fixed Issues Related to JVM and Concurrent Manager
2. Projects Profile:
Team Remote DBA Practice
Role Senior Oracle Apps DBA
Client Specialized technology Resources , Globtek , Conformis, Viisage and Actuant
Duration 01/2010 – 03/2011
Environment
Database : Oracle 9.2.0.6, 10.2.0.4
Oracle Applications 11.5.10.2
O/s :Linux
• Upgrade Oracle Applications Database from 9.2.0.6 to 10.2.0.4
• Install, Manage, Troubleshoot Oracle applications 11.5.10.2
• Code Migration of reports, forms, AOL objects etc
• Code Migration through FNDLOAD, WFLOAD
• Database Administration on 10g ,9i Databases
• Setup monitoring tools like sitescope.
• Proactive Monitoring of Application Instances through OEM, SiteScope. & Solarwinds
• Upgrading and Patching Oracle Applications and Databases.
• Interacting with functional Implementation teams and guiding/suggesting Instance requirements, patch management methodologies
• Interacting with Oracle Support for Issue Resolution.
• Performance tuning of Oracle Applications and Databases. ( Slowness in Navigations and Concurrent Requests , Load Balancing Application connections and Concurrent Managers and SQL Query)
• V$ Views, Statistics and Metrics and Wait Events
• Capacity Planning & estimating future disk space requirements
• Weekly status Reports for Clients.
3. Projects Profile:
Team Remote DBA Practice
Role Senior Oracle DBA
Client Amli
Duration 01/2010 – 10/2010
Environment
Database : Oracle 10.2.0.3,9.2.0.6
O/s :Windows, Linux
• Migration of Application from Windows to Linux
• Database Upgrades (11g) and Platform Migration.
• Application Upgrade from 1159 to R12.
• DMZ Configuration with no External Web Tier with Reverse proxy
• Backup and Recovery of Databases (RMAN) and conventional backups.
• Help development and project teams in code review/migration
• Cloning using RMAN and other conventional methods
• On Call Support
4. Projects Profile:
Team Remote DBA Practice
Role On-site DBA Coordinator
Client Clearstone
Duration 03/2010 – 03-2011
Environment
Oracle E-Business Suite:1159, 9i , OFA ( 6.3.4)
Database : Oracle 9.2.0.7
O/s :Linux
• Migration from MDS Datacenter to Clearstone MDS datacenter
• OFA installation and configuration
• On-Site Offshore Co-ordination/On-Call DBA Support.
• Support for Month-end & year-end closing
• Code Migration to production and other environments
• Monitoring database and Application Load/Health Checks.
• Concurrent Manager and Requests Monitoring.
• Troubleshooting concurrent request errors, performance.
• Participating in Root Cause and Corrective Actions activities as per client requests.
• Building Test cases in internal environment for stimulating real time issues.
• RMAN backups and recovery
5. Projects Profile:
Team Remote DBA
Role Oracle Apps DBA
(Worked on more than 20 Clients from Offshore) Ex: Radisys , BCF , Checkpoint, Actuant, Aspen , Sleepy, Panduit , AS & E , Avecia , Infinity , Irobotic , Opnext etc.
Duration 01/2010 – 07/2010
Environment
Oracle E-Business Suite:11.5.1 to 11.5.10.2,R12
Database : Oracle 8i,9i & 10g
O/s :Sun Solaris,Linux ,HP-Unix,IBM AIX , Windows
Roles and Responsibilities:
• Installation APPS and database ( 11i, R12 and 9i , 10G and 11G), Configuration & Upgrade ,Cloning and Patching
• Patching and Cloning
• RMAN configuration and automate of RMAN backup.
• Alert Handling crontab scripts.
• Upgrades Both DB and ERP application ( 1159 to R12 and 9i to 10G)
• Migration
• DMZ Configuration
• Setting Custom Tops and well exposed to SYSADMIN works on Applications
• Discoverer Installation & Configuration.
• Discoverer Upgrade from 4i to 10103.
• Troubleshooting on production Issues, cloning, patching, and upgrade and various Issues
• Tuning Application and database performance Issues ( using Stats pack, Awr report, ADDM and ASH Reports)
• DBMS_XPLAN and EXPLAIN PLAN and compare with bad and good one
• SQL*Plus AUTOTRACE & SQL Trace Facility
• SSO Troubleshooting
6. Projects Profile:
Project Name Oracle Corporation
Client Sterilite Corporation
Role Oracle DBA/ Oracle Apps DBA
Duration 12/2004 – 04/2009
Environment
Oracle E-Business Suite:11.5.9 and 11.5.10.2
Database : Oracle 8i/9i/10g
O/s : Linux
Project Description
Carried Out Application Upgrade from 11.5.9 E-Business Applications with 9i RAC system to 11.5.10.2 with 10g CRS, ASM and RAC on Linux.
• Production Support offshore (Bangalore, India) and onsite (Atlantic USA)
• Patching and Cloning
• Upgrade of 11.5.9 to 11.5.10.2
• Upgrade of 9i RAC to 10g RAC.
• Shared Appltop Configuration
• Failover Testing. Both RAC and PCP
• Setup Backup Strategy using RMAN
• Data Guard Configuration for High Availability.
• Data Guard Switchover and Switchback.
• Software Requirement Specification testing
• Tuning Application and database performance Issues during upgrade
• Tuning JVM and Database
7. Projects Profile:
Project Name Oracle Corporation
Client Stryker Corporation
Role Oracle DBA/ Oracle Apps DBA
Duration 12/2004 – 04/2009
Environment
Oracle E-Business Suite:11.5.9 and 11.5.10.2
Database : Oracle 8i/9i/10g
O/s : Linux
Project Description
Primary emphasis on Production Support from offshore and onshore with various projects completed database upgrade from 9i to 10G and 115102 Upgrade from 1159.
• Configuration of 10g CRS
• Upgrade to 10g RAC
• Implemented new methodology for Standby DB patching with apps servers
• ATG Family & I expense Go Live in Production
• Cloning/refresh of instances.
• Patching and Upgrade of various instances includes Application & Database patches.
• Discoverer Upgrade from 4i to 10103.
• Switch Over and Switch back of DB and application over DR and Primary.
• Kintana tool for code moves like concurrent and objects.
• IBM AS400 Ticketing system
• Service-now ticketing tool, for end user service requests for performance, database and application Issues and requests.
• Enabling Traces, Gathering Statistics for tables & schemas using DBMS_STATS & FND_STATS.
• Supported Application Server Single Sign On Instance
• Tuning Application and database performance Issues
8. Projects Profile:
Project Name Oracle Corporation
Client Cox Communication , Welch’s, Libgo, Invacare and 20 clients
Role Oracle DBA/ Oracle Apps DBA
Duration 12/2004 – 04/2009
Environment
Oracle E-Business Suite:11.5.9 and 11.5.10.2and R12
Database : Oracle 8i/9i/10g/11g
O/s : Linux , AIX, HP Windows and Solaris
Project Description
Primary emphasis on Production Support from offshore and onshore with various projects completed database upgrade from 9i to 10G and 115102 Upgrade from 1159. RAC and ASM implementation and Migrations.
• Cloning/refresh of instances.
• Patching database and application.
• Involved in Month and year end close for various customer where we need to enable and disable users, configure new MEC URL by giving access to particular set of users and monitoring system Configuration of 10g CRS
• Upgrade to 10g RAC
• Implemented new methodology for Standby DB patching with apps servers
• ATG Family & I expense Go Live in Production
• Patching and Upgrade of various instances includes Application & Database patches.
• Discoverer Upgrade from 4i to 10103.
• Switch Over and Switch back of DB and application over DR and Primary.
• Kintana tool for code moves like concurrent and objects.
• IBM AS400 Ticketing system
• Service-now ticketing tool, for end user service requests for performance, database and application Issues and requests.
• Supported Application Server Single Sign On Instance
• Enabling Traces, Gathering Statistics for tables & schemas using DBMS_STATS & FND_STATS.
9. Project Name Arowana Consultancy, Dubai
Client Injazat database Software Systems and Du Telecomn
Role Oracle DBA/ Oracle Apps DBA
Duration 04/2009 – 12/2010
Environment
Oracle E-Business Suite:11.5.9 and 11.5.10.2and R12
Database : Oracle 8i/9i/10g/11g
O/s : Linux , AIX, HP Windows and Solaris
• Patching and Cloning.
• RMAN configuration and automate of RMAN backup.
• Alert Handling crontab scripts.
• Production support for handling alerts.
• Migration from Solaris to Linux. ( Single node to RAC ERP Migration) ( 11510 to R12, 9i single node to 10G RAC database ) which included installation of 11i , 10G CRS and RDBMS , Migration and Upgrade
• Database tuning
• Troubleshooting
ORACLE AWARDS/RECOGNITIONS
Appreciation from Sterilite for the high quality and timely delivery of 10g RAC Upgrade
Have received Memento from VP of Oracle GSD, India for Sterilite.
Recognized as the Best Performer for Stryker support from offshore and as well as onsite.( Memento from Client)
CERTIFICATIONS/ TRAINING
Completed 10g OCA and10g OCP Certification
Completed 9i OCA
Oracle Database 10g DBA by Oracle University
Oracle Database 9i DBA Oracle University
EDUCATION/TRAINING
Education: B.E. in Information Science from Dayananda Sagar College of Engineering, Bangalore
Email ID: *****.****@*****.***
Contact # : 510-***-****
Contact this candidate