SQL Developer Resume Profile

Summary:

Over 8 years of IT experience handling all phases of SDLC like analysis, design, development, implementation and deployment of large software products in both Client/Server and Web Server Environment using Oracle 11g/10g/9i/8i database, J2EE and .net on different platforms like Unix and Windows environments, that involves system study, designing process flow diagrams, preparation of user manual, testing and debugging of software, implementation and training for users.
Expert in Oracle Database Development. Designed and implemented OLTP and Data Warehouse Systems, application schemas, reports, and application interfaces using PL/SQL, Stored Procedures, Packages, Triggers, Functions, SQL Loader, External Tables, Utl File, Objects Types, Collections, Bulk Collect, Cursors, Ref cursors, Table functions, Global temporary tables, Analytical functions and Dynamic Sql on Oracle 8i 11g , Oracle Flashback table query.
Experienced in Development of SDLC right from Requirement Analysis, High Level Design, Detail Level Design, Coding, Implementation and Testing.
Skilled in Unix Shell and Perl script writing. Created load scripts in Korn shell and Perl on Unix, called by scheduler Crontab and Autosys , to format and transfer data from various platforms and databases.
Solid experience of Performance Analysis and SQL query tuning, response time reducing, while designing scalable applications from scratch and maintaining existing ones, using AWR, Profiler, EXPLAIN PLAN, TKPROF and SQL Trace. Good knowledge of key Oracle performance-related features, such as Cost-based optimizer, Execution plans, Optimizer Hints, Indexes, Partitioning, Temporary tables, v -views.
Extensively worked on SQL Loader, creation of control files to load the data from flat files.
Good knowledge on oracle administration fundamentals including import/export, expdp/impdp.
Involved in Design of Data modeling including logical, physical data modeling and dimensional data modeling using ERWIN.
Used several Oracle provided packages such as DBMS JOB, DBMS PROFILER, DBMS STATS and DBMS SCHEDULER packages.
Experience in creating Indexes, Range partitions, Materialized views and DBLinks
Proficient using TOAD, SQL Navigator, SQL/PLSQL developer, Clear Quest, Clear Case, DOORS and FTP tools Humming bird, Putty, Fsecure etc.
Strong experience with DATAPUMP utilities like EXPDP/IMPDP.
Developed shell scripts to run the HYPERION SQR PROGRAM Reports.
Worked on Database links and materialized views.
Worked with forms and reports.
Analyzed tables and indexes for Cost Based Optimization CBO to work efficiently.
Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
Extensive experience in writing Static Dynamic REF Cursors, Dynamic SQL, Records, PL/SQL tables Exception handlers.
Expertise in handling errors using Exceptions.
Wrote Proc C programs to handshake data with other projects.
Designed and implemented pre and post processing Pro C programs for ETL process.
Hand on experience in creating different kinds of partitions for managing large tables.
Experience in working with high transacted OLTP systems.
Worked on operators in PL/SQL like Union, Union all, Intersect and Minus.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship