Kiran Kumar B.

Background

About Kiran Kumar B.

AS ORACLE DEVELOPER-10+ Years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle 8i/9i/10g,11g,12c SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation.Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.Expertise in Partitioning Framework. Created List, Range, Hash and composite partitions to store Transaction and Historical Data.Worked with query tools like Toad, PL/SQL Developer, SQL Developer.Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.Experience in Performance Tuning & Optimization of SQL statements using AWR, ASH, SQL Tuning Adviser, TKPROF, SQL Trace, HINTSExperience in tuning PL/SQL code using DBMS_PROFILER, Bulk Collect, FORALL, Parallel functions, Global/Parallel Temporary tables, Dynamic SQL, Records, PL/SQL TablesExperience in Oracle Supplied Packages UTL_FILE, DBMS_SCHEDULER, DBMS_SMTP, DBMS_XMLGENProficient in data loading/extraction using SQL*Loader, External Tables and Oracle utilities.Experience with NoSQL - MongoDBExperience with Java, JDBC, Servlets, JSPExperience in writing UNIX shell scriptsAS POSTGRES DEVELOPER-6+ years as PostgreSQL Developer - Develop PG Functions, Triggers, MViewsWorking experience with PG JSON objectsWorking experience with PG VectorsExperience with PostgreSQL Types and Arrays for effecting programmingExporting/Importing data from/into CSV files using PostgreSQL COPY featureEffectively made use of Temporary Tables/Functions (using PGTEMP feature) and Dynamic SQL while developing PL/pgSQL functionsExperience working with JSON support for PGEXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvementsMade use of PG Extensions feature for creating dblinks, cryptographic functions etc PostgreSQL audit and recommendations.Table partitioning and other PostgreSQL advanced features.Oracle, SQL Server, MySQL to PostgreSQL migration. AS MYSQL DEVELOPER-3+ Years as MySQL Developer