Dr. Oracle Apps DBA and SRE
Expedia
Total years of experience :14 years, 4 Months
Motorola Mobility, India, Pune, Maharashtra Oct 2010 - Present
Specialist Database Administration
• Converted the existing tablespaces structure to OATM
• Installed OEM grid agent 10g/11g on all servers and configured them.
• Installed AMP 3.0/4.0 on our OEM grid control and configured our EBS databases for monitoring concurrent mgrs, forms sessions, db locks, invalid objects and jdbc connections.
• Enabled Simplified Chinese on Oracle Apps R12 and applied the requisite patches.
• Configured standby databases for our existing Production databases and activated for testing.
• Monitoring and supporting day today activities of the production and development databases and work on urgent issues when fired by pager
• Creating Custom Concurrent Managers and Assigning Work shifts to it.
• Finding long running requests and sessions terminate them if needed.
• Applied database and application patches
• Performed SQL tuning, application and database tuning.
• Troubleshooting problems with web server, web listener, forms server, and concurrent managers, and database.
• Monitor database alert log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.) . Manage and maintain high volume transactional tables and indexes, database reorganization
• Create tablespaces, tables, and users for custom applications and maintained security.
• Written/Modified shell scripts to monitor as needed and maintain the Oracle Applications database.
• Upgrading the databases from 10.2.0.4 versions to 11.1.0.7 and 11.2.0.1.
• Upgraded to Oracle Apps Release 12.1.1 from 11.5.10.2 and also the db from 10.2.0.4 to 11.1.0.7 in Test/ Development instances.
• Administration and maintenance of Concurrent managers.
• Supporting the development and testing team during implementation of the Project and on all DBA related issues.
• Creation and maintenance of Customize Applications.
• Creation and maintenance of menus, Users, Responsibilities etc.
• Performing the jobs of System Administration for Oracle Application.
• Killing hung sessions on all databases which are causing locking.
• Maintenance of Oracle Applications on test databases.
• Supporting day to day user related issues, troubleshooting them and resolving them.
• Administration of OEM like monitoring the databases, server load, invalid objects, cpu, blocking
• Locks, long running sessions, scheduling jobs and alerting based on the metrics.
• Rman backup, Export/Import and various database issues.
• Performance tuning using tkprof and explain plan.
• Cloning of Databases from Production to development servers.
• Worked on SSO, OID and LDAP.
• Demantra Installation and configuration.
• APSC Installation.
Role Played as a DBA Lead:-
• Administered all issues in data and evaluated all factors.
• Monitored system performance with help of appropriate methods.
• Scheduled all activities and resolved any technical issue.
• Participated in departmental meetings and developed strategies.
• Evaluated performance of system and prepared reports.
• Coordinated with customers and supervisors for efficient working.
• Developed efficient operations for department.
• Maintained knowledge on management techniques and trends.
Motorola India Private Limited, India, Gurgaon, Haryana Aug 2007 - Sep 2010
Oracle Apps DBA
• Installing, configuring and upgrading of Oracle server (8.x, 9.x, 10.x) software and related products on test as well as Production servers on UNIX box boxes.
• Planning and creating databases manually as well as with DBCA on test and Production box.
• Design Physical and Logical structure of the Database
• Planning and creating directory structure for tablespaces at OS level.
• Creating tablespaces, adding resizing datafiles.
• Creating Rman catalog database for test as well as production servers.
• Managing Physical structure of database like datafiles, Redolog file and control files
• Configuring Rman backups for test and Production boxes.
• Rman backup scripting for full, cumulative and incremental levels for tape and disks.
• Scheduling export backups and Rman backups for tapes and disks using cron jobs.
• Managing Production, Development and Test Database in 24x7 environments.
• Checking ALERT logs to know types of bottlenecks recorded during the day if any, and rising to counter them.
• Monitoring Rollback Segments, Undo tablespace, temporary tablespaces and taking proper actions.
• Monitoring the growth of Tablespace and taking proper actions.
• Provide information and assist in accessing Database objects by other applications and tools.
• Checking health of database and statistics
• Rebuilding Indexes and segment shrinking.
• Addm reports generation and analysis.
• Ad hoc table creation, Users creation enabling, disabling constraints
• Ftp download from various servers.
• Monitoring DB using 10g EM.
• Monitoring Checking of OS level process using sar, ps and top commands.
• Troubleshooting errors in application and/Database.
• Monitoring archiving mount points and datafile mount points.
• Data files relocations.
• Generating execution plan for the SQL queries taking long time to execute based on statistics generated by Addm tool.
• Database software up gradation, cross platform database migration.
• Experience of working in highly critical RAC environment.
• In depth knowledge about installation of 10g Grid Control.
• Installing Agents for monitoring purpose & configuring it with Database Repository.
• Installation of Oracle Apps11i (single/multi node) on Linux.
• Cloning an RAC environment to NON-RAC environment
• Jinitiator & J2SE Upgrade.
• Managing Concurrent Managers & also Parallel Concurrent Processing.
• Taking export/import at table level, schema level and full database.
• On-Call Support.
• Worked on 24/7 high availability environments.
• Database up gradation.
• Used Oracle Application tools for maintaining application like adpatch, adadmin, adctrl etc.
• Database Cloning.
• Considering future growth, Reorganization of database and space management of database as per need.
• Weekly health checkup of database.
• Removing trace files and archive log files.
• Re-organization (Tablespace Level, Table Level)
• Monitoring various mount points in Production Application Server
• Purging the concurrent requests.
• Documentation.
HR Graphic Solutions, India, Pune, Maharashtra May 2004 - Aug 2007
Oracle Apps DBA Jr.
Worked as an Oracle DBA / Apps DBA Jr consultant.
DBA Roles and Responsibilities included: -
• Supporting Remote standby database as a DR site.
• Configured Listener.ora for multiple instances.
• Doing day to day duties and supporting users.
• Maintaining the database and schema objects.
• Wrote scripts to catch invalid objects in the database.
• Created parameter files and control files to setup the environment for the database.
• Created Month end database and reporting instance.
• Refreshed Reporting, Development, Test instances with Production Instance.
• Database Upgrade from 9.2.0.4 to 9.2.0.7
• Database backup (RMAN, Hot backup)
• Database Refreshes.
• Database health check.
Attended in-house training on Oracle Applications.
Oracle Apps DBA Roles and Responsibilities included: -
• Administration of Production, Test & Development Instances of Oracle 11i Applications.
• Installation, Patching of Oracle DB and Applications.
• Oracle Applications Cloning.
• University of Pune, Bachelor, Computer Science, Apr 2004
• Pune Board, H.S.C., Feb 2000
• Mumbai Board, S.S.C., Mar 1997