Oracle sql developer for mac os7/25/2023 ![]() ![]() Involved in requirement analysis, preparing functional specifications, system design, development and database administration. ![]() Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.Transferred SQL and Korn shell programs into ODI and created data extracts.Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.Extensively used bulk collection in PL/SQL objects, partitioned the fact tables and materialized views for improving the performance.Created various database objects like tables, views, materialized views, procedures, functions and packages using oracle tools like Toad, SQL Developer and SQL* plus.Tools: TOAD, SQL*PLUS, SQL Developer, SQL*Loader, Crystal Reports, Forms 6i/9i/10g, Reports 6i/9i/10g, Work Flow Builder and XML Publisher. Tools: Windows/Linux/Mac OS Environment, Eclipse, Git, Xcode, Subversion (SVN), CVS, ClearCase. Programming Languages: SQL, PL/SQL, Unix shell scripts, SAS, C/C++/C#, Perl, XML, HTML, VB.NETĮTL Tools: IBM Infosphere DataStage, Informaticaĭata Warehousing: Star & Snow-Flake schema Modeling, Erwin, Sybase Power Developer, SSIS, SSRS, OWB, ODIĭev. Other Technologies: HP Project and Portfolio Management (PPM), HP ALM/QC, Oracle E - Business Suite 12, Oracle Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Oracle Applications Manager (OAM) Extensive experience in identifying performance issues, debugging and performance tuning using SQL Trace, Explain plan, Indexing, Hints, Partitioning, TKPROF, Profiling and Oracle Code Coverage Utilities.ĭatabases: Oracle 8i/9i/10g/11g/12c, MySQL 5, MS SQL SERVER 2005/2008, DB2/UDB, SAP Tables and MS Access.Expertise in database performance, data warehouse, ETL, SQL queries, PL/SQL procedures, packages, functions, cursors, triggers, interfaces and data conversion using PL/SQL, SQL*plus, TOAD, and SQL developer & full suite of Oracle Tools including development and customization of Oracle Developer (Reports & Forms) and Oracle discoverer.Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming.Used oracle features like Collections, Ref cursors, Analytical functions, Global temp tables, External tables and Materialized views.Developed and Automated batch load process using SQL*Loader, Shell scripts and Crontab.Proficient in PLSQL programming, designed and developed Stored procedures, Functions, Triggers, and Packages to provide database access and manipulation functionality.Strong knowledge in Oracle Architecture, Data Dictionary and DBMS Packages. ![]() ![]()
0 Comments
Leave a Reply. |