Senior Database Developer- 9 years Experience

A senior PL/SQL with around 9 years of diverse experience in Database Design, Development, Administration, Enhancement and Implementation. • Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys. Highly skilled in Design, Development, Implementation, and Testing of business applications, Unit and System testing on database. • Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types. • Experienced in Dynamic SQL, PL/SQL Collections and Exception handling. • Experience in advanced PL/SQL concepts like Bulk collections, Multi Table insert, PL/SQL tables , Cursors, Nested tables, Varrays, Records, Types and Dynamic SQL for DML operations for better performance. • Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer. • Worked as a member in the design team for creating data flow diagrams and Entity relation modeling using Erwin tool. • Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table Partitioning. • Experience in creating SQL loader scripts to load data from flat files into the database and also creating External Tables to manage data which is store at the OS level. • Experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing. • Experienced in working with Star Schema and Snow Flake Schema. • Experience in Data Migration across various databases as well as within the same database across different systems. • Well-versed with different stages of Software Development Life Cycle (SDLC). • Well experienced working with Waterfall & Agile Methodologies. • Experienced in Tuning Queries for better performance with large volume of data. • Quick learner with ability to master new concepts and applications. • Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.

Application Support