ORACLE DBA
ADVANCED SYSTEM LABORATORY
Total years of experience :1 years, 9 Months
• Creating database for Production/Quality/Development
• Database migration, Upgradation & Server consolidation.
• Conversion of character set of database.
• Patching Database using Opatch
• Creating the Clone of database.
• Database/Schema refresh (Export/Import)
• Change the Block size of existing database (export/import).
• Managing privileges and roles to ensure database security.
• Handling database change request from the application developers as on need basis.
• Tablespace creation and space management.
• Creating users, granting roles, allocating tablespace as required in the project.
• Loading data using SQL * Loader.
• Cron Job setting.
• Taking online and offline backup using scripts.
• Monitoring various database activities like number of users, memory usage, hit ratios, locks, alert log files, trace files, archive log files, space usage etc.
• Monitoring CPU/Host/Machine/Server usage
• Working on issues like DB listener down, DB down, Space alerts etc
• Installed/Worked on BEA Weblogic 10.3
• Configure WebLogic Servers in a Cluster solution for High Availability
• Deploy new business applications and application updates into WebLogic Application Servers
• Providing telephonic support to the users about the issues related to database.
• No Of Instances/databases : 20+
• Database Size : 10G - 100G