Naveen Kumar Rukkanna
Languages spoken: English  [Fair]

Summary

Edit Summary

  • Having about 10+ years of relevant experience as an Oracle consultant/corporate trainer

  • Oracle Prod/Dev/UAT DBA support.

  • Managing Tables, Views, Materialized views, Indexes, Synonyms, Sequences, Table Partitions.

  • Knowledge in Stored Procedures, Functions, Packages and Database Triggers using PL/SQL.

  • Having knowledge of Performance tuning

  • Knowledge of Oracle Architecture, Backup & Recoveries, RMAN, Performance tuning

  • Hands-on experience in Oracle DBA from installation, granting access, troubleshooting, etc

  • Created and modified SQL* Loader scripts for data conversions.

  • Creation and maintenance of other database objects like views, synonyms, sequences.

  • Handling corporate trainings on Oracle SQL, PL/SQL, forms and reports.

  • Extensively used utilities like PL/SQL DEVELOPER 12c, D2K, Oracle 11g/12c.

  • A team player with strong communication, analytical, and organizational skills with the ability to interact with individuals at all levels.

Associated with Koenig since May-2024.

Experience

Edit Experience

Working as a Corporate Trainer  on Oracle database, developement , forms and reports from Dec2021 to till date

Worked  in CTE as database engineer, Bangalore Client location TOYOTA  from Oct 19 to Oct 20,client Wonderla office Bangalore from Mar 2020  to Nov 2021 (Project was over)

  Role & Responsibilities:   

  • Built complex queries using SQL and wrote commands using PL/SQL
  • Supporting in modifying the procedures and functions and packages according the user inputs
  • Oracle reports designed according to the user modifications
  •  Supporting the oracle forms and reports with modifications
  •  Supporting in developing and modifying the oracle forms to oracle apex format

Project Details:

Migration project from oracle 11g to 12c Forms and Reports  for TKAP and TIES and SAL.

  • Worked as DBA Engineer in Techonoforte Pvt. Ltd for TOYOTA, Bangalore from Mar 2018 to May 2019. 

Project Details:

 

            Project

SAL

            Client

TKM

            Designation

DBA

            Role

DBA

Project # 1: AMInet

Description: AMI is a central repository for all domestic and export vehicles. SAL can be customized and enhanced to meet the changing regulatory and internal/external management requirements. The SAL system was developed by the JAPAN software vendor, implemented in 1968 to support JAPAN and foreign regulatory reporting requirements.

Technologies: Oracle11g ,RMAN , SQL, PL/SQL, FORMS and REPORTS,UNIX.

Role & Responsibilities:

  • Built complex queries using SQL and wrote commands using PL/SQL.
  • Running the required script which includes procedure and functions and packages to support the smooth flow the application.
  • backup planning 
  • rman backup
  • Monitoring the Database performance and take necessary action to optimize the database performance
  • To provide resolution to the tickets and reduce the recurring tickets through problem management and thus leading a higher customer satisfaction
  • Monitoring & Scheduling the jobs (Database & Unix) and fixing issues if any failures
  • Fixing the issues permanently by creating Problem tickets
  • Preparing the documents for future reference and providing assistance to juniors.
  • Involving Production releases and Deployments

         Apr  2013 – Apr 2017

          Mastermind Consulting   (As an SSE /Corporate Trainer)
          Banglaore , Karnataka (Company wind up)

Job Title: Oracle Developer / Oracle Corporate Trainer (Oracle 12c/11g/10g/6i Developer suite).
 

Role & Responsibilities:
 

  • Mainly in Software Design & Development, Coding, Testing, Enhancement, Customization, Bug Fixing, Maintenance and Application Support.
  • Handling corporate trainings on oracle sql,p/sql ,forms and reports
  •  Design ,Development, Coding, Testing, ENH, Maintenance of database object  like Packages, Procedures, Functions, Triggers, Views, Sequence, PL/SQL Collections, etc.
  • Creation of Database, various Database objects, writing PL/SQL codes.
  • Providing corporate presentations on Oracle SQL,PLSQL and D2K.
  • Documentation.
  • Designing & Developing web applications using Oracle forms.
  • Generating reports as per the design.
  • Users Created and passwords modified
  • Managed user management and profile management
  • Handled Internet ship/ projects on cybersecurity, system hacking, sql injection,DVWA and more
  • Handled  corporate batch for “Infosys ,Mysore” on Oracle 9i SQL, PL/SQL
  • Handled  Forms 6i for iflex, Bangalore

 

Trainings delivered for:

   
C I B (Oil & Gas, Bhutan) Central Bank of Somalia (banking, Somalia)
GCB Bank LimitedIntel
MFS (IT, United States) MIB (Government, Maldives)
MSNOracle
TIC TIMOR (Government, East Timor)

Preview Past Training of Naveen Kumar :

CourseRecording Link

Webinars Delivered

WebinarView Recording
Oracle Database Programming with PL/SQLhttps://youtu.be/Q0TnChapUME

Recent Feedback for Naveen Kumar :

Student NameFeedback
DechenThe trainer was knowledgeable and very approachable. He is enthusiastic, passionate, dedicated, energetic and committed to delivering the training.
FelisbertoI really like your trainer! The way he explains things is very clear and easy to understand, and he always provides motivation that encourages me to learn more. His training has been very beneficial and has helped me understand the material better. Thank you for having such a great trainer!
IsabelThank you for your dedication and the incredible effort you put into every session! Your passion for teaching and ability to make complex topics understandable truly inspire me. Keep shining and know that you're making a huge difference in our learning journey. You're awesome!
Joanico"I really appreciate everything for my teacher, The support and teaching style, makes learning much more fun and meaningful. Thank you for being a very inspiring Oracle teacher for me who has a very amazing teaching concept!.
LoveniaI like the way He teach, for me I like the session , because this is my first training about the Oracle administration. in the day begun this course I thought that this is really easy but when i learning day by day almost 5 days I recognised that, Oracle has a big concept that I need to understand and be smart to use it. And Thank You to Naveer for sharing the knowledge and suggestion .
MichaelYour dedication and energy are truly inspiring. The way you keep everyone involved and motivated makes a huge difference. We love it when you teach us with your heart.
RivaldoFor one (1) week, the teacher provided the material very clearly and in detail, I think my best oracle teacher for the first time, the teacher really pays attention and helps students learn all about oracle database.
SabirWe had a good learning session both theory and practical well balanced.
YesheyThe trainer is having a having good knowledge and the practical session is much worth since it can relate to our current environment.
YontenMr.Naveen has good knowledge on Oracle 19c database with good oracle skills to convince participants. Your knowledge has really helped us in understanding the 19c database architecture, performance tuning, and other housekeeping activities to enhance performance. Your way of teaching is very convincing and highly appreciated.