• Over 16 years of progressive experience in the areas of Oracle PL/SQL development, Environment Configuration Management & Technical Integration.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• As a Database Team Lead involved in building a cohesive team structure to drive the company’s vision to viable realizable goals.
• Functional experience includes Payments Applications, Telecommunications, HR/Payroll Applications and Insurance Applications.
• Strong skills include SQL, PL/SQL in Oracle 11g/12c; SQL, T-SQL in Sybase and MS SQL Server 2000, UNIX, LINUX.
• Developing complex Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Developing materialized views for data replication in distributed environments.
• Loading Data into Oracle Tables using SQL Loader.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Performing periodic maintenance tasks like Table Partitioning, Index rebuilds, Statistics Collection and data purge to ensure efficiency and reliability of the applications and databases.
• Shell scripts and SQL updates for reference data based on High Level Design/Low Level Design.
• Query Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Creating and scheduling jobs using DBMS_JOB and DBMS_SCHEDULER.
• Problem determination and Trouble shooting in Development, Test and Production Environments.
• Environment Configuration Management by Integration of the Patches, Installation and Configuration of HR Design Client/HRD Studio, DDL deployment, Execution of Jobs and Bug fixing.
• Analysis and development of Batch Programs using the Business Rules/Code of the existing system.