Sr. PL/SQL Developer Resume Houston, TX - Hire IT People

SUMMARY

12 years of work experience and advanced knowledge in System Analysis, Design and Development of Database Applications in Client/Server Environment as well as Web deployment using Oracle 12c/11g/10g/9i databases.
Advanced PL/SQL development experience and worked with large data sets.
Experience in working in Unix, shell scripting (KORN Shell, Bourne Shell), Vi editor, Exceed, Toad, PL/SQL Developer, SQL Optimization, Oracle Batch Processing, scheduling, SQL Loader, Oracle Forms/Reports, SQL*PLUS reports and Oracle Application Express ( APEX). Worked in Oracle EBS Workflows.
Quick in picking up domain knowledge and can handle end - to-end project independently, as well as in team.
Advanced skills in Oracle PL/SQL query writing, creating and maintaining Database Objects and performance tuning using plan table, trace, OEM reports
In-depth knowledge and experience with relational database concepts and query tools tools like Toad, SQL*Plus, PL/SQL Developer.
Experience in writing functional and technical documentation
Written and modified number of stored procedures, functions, packages, triggers to handle logical units using PL/SQL
Identified and built additional index ,archived data, rewritten queries to improve database performance
Ability to work in a rapidly changing and growth oriented environment
Agile /Scrum Software development approach
Using version control /change management tools like Beanstalk SVN and Serena.
A quick learner, committed person with integrity, problem solving, analytical skills and positive energy

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. PL/SQL Developer

Responsibilities:

Providing advanced Oracle PL/SQL programming support to ensure the continuous reliability, integrity and improvement of relational databases throughout our organization. This includes, but is not limited to determining database requirements, designing data structures, developing stored procedures and ETL processes. Query performance tuning including identifying additional index needs. Scheduling database procedures using DBMS SCHEDULER.
Managed data migration and integration between internal Oracle Servers and third party software. Using PL/SQL developer daily to write /execute /debug code.
Successfully collaborated with key stakeholders to complete projects on time.
Worked in AGILE environment with weekly sprints and monthly releases.
Writing technical documentation for the project and involved in training of end users.
Inclination to contribute ideas, enhancements, innovations and energy to the team.
Performed other related duties as required and assigned.

Confidential

Team Leader

Responsibilities:

Involved in Business requirement analysis, documentation (SRS) and creating functional specification design document.
Created detailed project outlines, application design specifications, and test plans
Worked in TOAD to write DDL and DMLs.
Changed database design managing the change of more than 100s of programs (including Database tables, functions, procedures, triggers, indexes, PL/SQLs, forms, reports, cron jobs)
Developed coding standards (rules) for making changes in existing code in accordance with the new standards,
Wrote Unix shell scripts to search code for regular expressions
Implemented very complex SQL queries for populating a table of 10,0000 rows with data from multiple schemas, reduced the query time drastically by using materialized view
Ensuring testing and timely release of correct version of programs.
Maintained applications using Version Control tool
Experience in code review and analyzed the PL/SQL programs to identified bugs and bottlenecks to improve performance.
Used PL/SQL SET functions to populate new tables from journal tables

We provide IT Staff Augmentation Services!

Sr. Pl/sql Developer Resume

Houston, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship