Oracle Apps DBA
Ministry of Communication and Information Technology
Total des années d'expérience :13 years, 11 Mois
Administrating the two node RAC database with oracle applications R12 on two node, maintaining the user security and user responsibilities, applying maintenance patches as per requirement, performing cloning frequently.Administering web logic database as well, and all other activities which a DBA has to perform.
Responsibilities:
Maintaining Database instances running in Sun Solaris and Linux environments. Database size varying from 40GB to 450 GB.
24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
Taking periodic Backup of the Database and the software using RMAN.
Created numerous scripts for routine database administrative duties
Performed performance monitoring using nmon and nagios.
Participate in rotational on-call support
Create users, tablespaces, roles, synonyms and databases as needed
Perfomed data refreshes of test and development environments
Troubleshoot performance issues
Monitoring Table spaces and extent Growth
Monitoring the Hit Ratios and tuning the System Global Area (SGA) accordingly
Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, ISOSTAT and TOP.
Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
Experience in Identifying performance bottlenecks on high volume transaction systems.
Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
Creation of database maintenance plans, rebuild indexes and integrity checks
Implemented RMAN Backups, Creation of catalog database.
Performed and scheduled Database Re-orgs.
Provided support on performance issues during project development resulting in improved response times and reduced contention
Intensively involved in the area of installations of Oracle Software, Configuration for database and day-to-day routine works for database administration.
Created Users, Roles and Managing Security.
Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files
Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
Import and Export of database objects to copy from one database to another database.
Administration and management of Oracle Applications R12 environment.
Monitoring performance of Oracle Applications and Databases.
Managing the Oracle E-Business Suite Apps and Database space allocation and database tables to ensure optimum performance.
Apply all vendor recommended patches, upgrades or fixes without disrupting the live operation.
Extensive Patching. Cloning Oracle Applications R environments.
Troubleshoot problems related to Oracle Database and Oracle Applications.
Performing root cause analysis of difficult problems and deriving a solution.
Supporting the TAR process and documenting problem resolution.
Generating and Compiling forms and reports.
Performing AD admin tasks.
Purging the tables.
Fresh installation of R12 single node & multi node.
Workflow monitoring.
Configuration and up gradation of Oracle R12 E-Business Suite software and evaluation of the hardware; database refresh from prod to pre-prod
Monitoring and Managing production Database having over 850 concurrent hits.
Managing 24/7 OLTP Production Databases with more than 2000 End users connecting through multiple application servers
Database Cloning on Test server from Cold and Hot backups of Production Database.
Space management for a database.
Managing Datafiles, Control files, Logfiles and Pfile.
All SQL related activities.
Performing Online & Offline backups, Oracle import / export as a method of recovering data or individual objects.
Oracle E-Business suite (R12/11i)
• Administration and management of Oracle Applications 11i environment.
• Monitoring performance of Oracle Applications and Databases.
• Managing the Oracle E-Business Suite Apps and Database space allocation and database tables to ensure optimum performance.
• Apply all vendor recommended patches, upgrades or fixes without disrupting the live operation.
• Extensive Patching. Cloning Oracle Applications 11i environments.
• Troubleshoot problems related to Oracle Database and Oracle Applications.
• Performing root cause analysis of difficult problems and deriving a solution.
• Supporting the TAR process and documenting problem resolution.
• Generating and Compiling forms and reports.
• Performing AD admin tasks.
• Printer configuration.
• Purging the tables.
• Fresh installation of 11i and R12
• Workflow monitoring.
• Configuration and up gradation of Oracle 11i E-Business Suite software and evaluation of the hardware; database refresh from prod to pre-prod
Databases
• Maintaining Database instances running in Sun Solaris and Linux environments. Database size varying from 40GB to 450 GB.
• Monitoring and Managing production Database having over 850 concurrent hits.
• Cloning Production Database to refresh test / development servers at regular intervals
• Maintaining Data guard environment i.e., Primary Server, Local standby and Remote standby server.
• Managing 24/7 OLTP Production Databases with more than 2000 End users connecting through multiple application servers
• Database Cloning on Test server from Cold and Hot backups of Production Database.
• Rebuilding of Indexes on weekly basis.
• Space management for a database.
• Managing Datafiles, Control files, Logfiles and Pfile.
• All SQL related activities.
• Performing Online & Offline backups, Oracle import / export as a method of recovering data or individual objects.
• Taking RMAN backups
• Continuously monitor system performance / resources ( I/O & CPU utilization) and take proactive steps to ensure peak performance
• Obtain the necessary database backups (logical or otherwise) to ensure the highest possible corporate data integrity
• Resolutions of database start up problems and database re-organization
UNIX:
Installing and administering of Solaris OS 9/10/11 & Linux 4/5/6
Installing and administering of Solaris OS 9 and 10 in Sparc and X86 machines.
Managing Sun server and entry level storages as field engineer.
Managing Sun Solaris Production and Development Servers.
Offering 24/7 support on call basis.
Monitoring server daily status.
Applying patches on a regular basis
Install & Update the required patched & maintenance level periodically
Providing technical support to the customer within a specified downtime.
Implementing enterprise project according to the customer IT analysis
Configuration of Image packaging system - IPS (NFS, LOCAL, DNS) on Solaris11
Configuration of IPMP
Installation, configuring and administrating of Solaris and Linux on production servers
Strong Knowledge and Experience in Oracle Solaris and RHEL environment.
Closely support the database team with any and all Unix needs.
Create Solaris 10 SMF packages for multiple administration tools
Scheduling jobs for backups and monitoring processes using crontab.
Configuration & administration of NFS, DNS
Maintaining and changing file systems and disk assignments
User Management - Creating, maintaining, and removing users and groups. Security settings on user accounts and groups
Setting up Disk quotas for Users
Performing Backups on Disks & Tapes
Setting up of File sharing using NFS
Installation and configuration of VERITAS Volume manager Server on Solaris OS
Backups, administration and installation of VERITAS Netbackup & EMC Networker
Daily monitoring of backups to ensure successful completion
Maintain system event logs