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

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.