Sr. Oracle PL/SQL Developer Resume Cupertino, CA - Hire IT People

SUMMARY

Over 8 + years of experience in Database Analysis, Design, Data Modeling, Application Development, Implementation and Production Support activities in a Client/Server Environment using Oracle 11g/10g/9i, PL/SQL, Unix, Windows and Mac OS.
8+ years of IT experience in Oracle PL/SQL Application Development, Query Optimization, Performance Tuning & Troubleshooting.
Proficient in Data analysis, Data modeling, Database design, Data migration, and Business intelligence solutions.
Extensively worked on Backend Programming using PL/SQL stored Procedures, Functions, Packages, and triggers.
Have worked on Advanced PL/SQL techniques like Collections, Varrays, Nested Tables etc.
Expertise in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized Views, Indexes and Troubleshooting Oracle database issues.
Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms etc.
Experience in Bulk Data loading using Oracle utilities namely SQL Loader and External Tables.
Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader and UTL File Utilities.
In depth knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL using database tools like Toad, PL - SQL Developer.
Acquired good knowledge of Shell Scripting Concepts.
Work closely with users to understand and prioritize business goals and information needs, then translate these needs into system requirements and design specifications;
Refine conceptual systems design requirements into the technical design Involved in review and Gap Analysis of Functional Requirement documents. Creation of Technical Documents.
Expertise in all phases of Software Development Life Cycle (SDLC) viz: Analysis, Design, Coding, Module & Integration Testing, Technical Documentation, and Customer Support.
Excellent team player having very good communication, analytical, technical and interpersonal skills.

TECHNICAL SKILLS

Operating Systems: UNIX, WINDOWS, Mac OS X

Languages: SQL, PL/SQL, Shell Scripting

Databases: Oracle (10g & 9i), MS Access, MySQL

Tools: Toad, PL / SQL Developer, Oracle SQL Developer, Kronos Scheduling, Kronos Timekeeping, Microsoft Visio, SQL* Plus and Telnet

Version Control Tools: Borland StarTeam, Microsoft Visual Source Safe, SVN.

PROFESSIONAL EXPERIENCE

Confidential, Cupertino, CA

Sr. Oracle PL/SQL Developer

Responsibilities:

Involved in gathering the requirement specifications for the project.
Design, Development, Testing and UAT support activities.
Involved in generating the payroll extracts for the Kronos Timekeeper employees.
Involved in the Production Implementation/deployment, Primary and secondary warranty support.
Migrated the legacy data into Oracle using SQL*Loader.
Experience mapping and deriving table attributes for data migration.

Confidential

Oracle PL/SQL Developer

Responsibilities:

Involved in analyzing and estimating the radars.
Development, Testing and UAT support activities.
Tables’ data loading using SQL* loader.
Involved in the Production Implementation, Primary and secondary warranty support.

Confidential

Support Analyst (Oracle)

Responsibilities:

Involved in analyzing Software Requirements Document.
Generated the reports by using MS Access.
Created views and worked on Table Partitions.
Loaded the data into staging tables by using UNIX scripts.
Troubleshooting & maintenance of the database.

Confidential

Database Developer

Responsibilities:

Involved in analyzing Software Requirements Document & Business Requirements Document.
Design & Implementation of Database Design.
Created Tables, Indexes, Triggers, Synonyms, Views, Materialized views, Stored Procedures and Packages.
Done Query Performance Tuning.
Unit Testing and Bug Fixing.

We provide IT Staff Augmentation Services!

Sr. Oracle Pl/sql Developer Resume

Cupertino, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship