- #PL SQL DEVELOPER ORACLE CLIENT NOT PROPERLY INSTALLED ORACLE HOME KEY UPGRADE#
- #PL SQL DEVELOPER ORACLE CLIENT NOT PROPERLY INSTALLED ORACLE HOME KEY WINDOWS#
Data backup using export data pump and import data pump.
Created triggers, functions and procedures, Involved in RMAN backup, Managing and creating users and assigning roles and privileges to different users as per the requirements, created the indexes and analyzed the table for better performance. Datagaurd setup maintenance and log transfer. ASM disk partitioning, rebalancing and handling disk failure issues. Installation of RAC databases, Maintenance of RAC using SRVCTL and CRSCTL commands. Extensively worked on PL/SQL procedure, functions, packages, Performed heavy data loads using SQL*Loader, Prepared control, bat file for bulk data load using SQL Loader, Created Test database using cloning method, Involved in creating tables and indexes, views. Tuned and optimized SQL Query using hints, index, statistics of objects and explain plan, Used External table and Partition exchange as efficient methods of data loading, Backup and recovery procedures using RMAN Copying of data from development to test and production by using utilities like Export/Import, Scheduled jobs to run on daily/weekly/monthly basis.Įnvironment: Oracle 11g, RMAN, SQL Loader, Export Import, OEM, SQL Loader, CONTROL-M. Created and maintained Database objects like table spaces, tables, indexes, views, Partitioned appropriate tables to optimize performance and simplified maintenance work, Administered database using Oracle Enterprise Manager, Created and executed various database queries. Index usage Monitoring.Įnvironment: Oracle 11g, RMAN, SQL Loader, Export Import, OEM, SQL Loader, Control-M Worked with fragmentation and chaining issue. Worked with statistics explain plan hints. Done time based, cancelled based recovery using Hot backup and block level recovery using RMAN. 
TABLESPACE and Data block recovery using RMAN.Created the indexes and analyzed the table for better performance.Used data pump export import for data migration Installation of RAC databases, Maintenance of RAC using SRVCTL and CRSCTL commands. Copying of data from by using data pump Export/Import. Backup and recovery procedures using RMAN Cold backup and data pump Export/Import.Languages: SQL, PL/SQL, Java, C Programming
TOOLS: SQL Plus, Oracle Enterprise Manager (OEM), SQL * Loader, Data pump, TOAD, RMAN, Export/Import, DBCA, NETCA, DBUA, PL/SQL Developer
#PL SQL DEVELOPER ORACLE CLIENT NOT PROPERLY INSTALLED ORACLE HOME KEY WINDOWS#
Operating System: UNIX, WINDOWS NT 4.0, Red Hat Linux 7.3, Sun Solaris 8.0, 9.0, HP-UX.
Excellent communication and interpersonal skills. Responsible for setting and managing user accounts, granting required privileges to users. Experience in the management of schemas, de - fragmentation and partitioning the tables & indexes to improve the performance. Good Knowledge of UNIX shell scripting and experience in Perl. Expertise in Loading data from flat files using External Tables, SQL*LOADER. Efficient in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks. Specialist in functions, stored procedures, and triggers. Extensive Experience in PL/SQL procedures, Functions, packages and efficient query writing. Efficient in SQL query optimization using Explain Plan, AWR, TKPROF reports, gathering statistics, pinning the objects, and running scripts. Efficient in creating and managing users and objects. Performance and monitoring RDBMS (Relational Database Management System). Installed and configured Oracle 11g on Linux Server on Development, Test and Production Systems. Duties included database creation, tuning, backup/recovery, user and security management, general troubleshooting and cloning. Experience of installing, upgrading, patches. Data backup using export data pump and import data pump. Experience in implementing Hot, Cold and Logical backup plans and experience in clonning. Done time based, cancelled based recovery using Hot backup and block level recovery using RMAN. Experience in using RMAN for backup and recovery. Strong knowledge of RMAN.Designed and implemented backup and recovery strategies. Datagaurd setup maintenance and log transfer. #PL SQL DEVELOPER ORACLE CLIENT NOT PROPERLY INSTALLED ORACLE HOME KEY UPGRADE#
Experience in Upgrade of oracle database 11g R1 to 11g R2 using Oracle Database Upgrade Assistant (DBUA).Experience in Data Modeling, Design, and Development & Production Support on different UNIX environments like Sun Solaris, Linux and Windows 2000/2003 /NT. 9 years of experience as an Oracle DBA and PL/SQL developer.
0 kommentar(er)
