Database Administrator Oracle
Resume:
Narasimha Kamath
Bloomingdale, IL 60137
********@*****.***
VISA Status: Citizen
Summary
●Oracle FORMS & REPORTS From 2.3 to 12.1 using & PL/SQL.
●Installed and managed Oracle Web Logic version from 9 to 12.2
●Experienced Oracle Database Administrator and Developer Beginning from Version 6, to 12.1, 19C
●Worked with JIT[Just in Time] ERP system from Fourth Shift Corporation Minneapolis. Modules OE, PO, GL, BM, AP, AR, CM, RT, Service, Quotation.
●Experienced in ETL/Data loading using SQL*Loader and UNIX shell script awk, nawk, ODBC Connection and PRO*C program.
●Oracle Data migration, UTF-8 conversion.
●Proven ability to design, implement, and manage Oracle databases.
●Operating systems like Linux, Sun Solaris, AIX, VMware, Oracle Solaris VM.
●Windchill PLM experience with Windchill 3.4 to 12.2 with Creo Technical problems.
●Net Backup R-Sync, Backup Scripts
●Strong skills in database administration, performance tuning, disaster recovery and Backup.
●Trained For Oracle Fusion Implementation GL, AP, AR Cash Management, Fixed Assets.
●Trained on Fusion Report like Smart View, OTBI, Oracle BI.
Work Experience:-
Packaging Corporation of America. 2024 Jan 12 ……
Working as Oracle DBA and PL/SQL Developer
InventusPower Woordridge Illinois
Database Administrator 2023 September to 2023 December
Worked on Windchill PLM Solutions to replicate the data to Development Server. Created report using C#
M&R Printing Equipment Inc Roselle, Illinois
Oracle Database Administrator / Programmer Analyst / Application Developers
1997– 2023 May
Worked as Database Administration and Programmer Analyst.
●Rewrote All the 125 version 2.3 Oracle Forms to Version 3.0. Converted RTF Report to RDF Report
●Converted all versions of Oracle Forms from Subsequent Version up to latest version (2.3 to 3, 6 to 9, 9 to 11, 11 to 12)
●Converted verion 6 trigger to Web version 10g
●Converted All PRO*C program to PL/SQL Package, procedure, functions.
●Develop, upgrade Existing ERP application using oracle Forms and Reports, PL/SQL and SQL. Created many Oracle Package Procedures and Triggers
●Created Service Screen Module, Sales Quotation Module.
●Managed Oracle Application Server and later Web logic server upto 12.2
●Oracle databases” Installed, configured, Upgraded, and maintained Oracle databases. 6.0, 10c,11G,12c,19c,21C
●Performed backup and recovery operations using NetBackup and Rman, Bash Shell Script
●Managed database users and permissions.
●Resolved database performance issues.
●Data loading using SQL*Loader and Unix Shell Script
●Oracle Data migration, UTF-8 conversion
●Worked with Sun Solaris, IBM AIX, DEC Systems
Windchill Engineering PLM system:
Working with PTC windchill system version 3.3 to 12.2
Proven Experience Installing, Implementing, Upgrade, patching on day-by-day basis. Trouble-shoot Creo and Windchill Software problems.
Integration between PLM system and ERP system.
R systems Inc San Francisco, CA
1995 - 1997
Oracle ERP developer
●Did Contracting work in The Nature Conservancy Virginia, Parsons Construction Management Washington DC.
●Developed Oracle ERP systems using Oracle Forms and Reports and PL/SQL.
●Worked with ERP system called JIT.
●On contract with Parsons Management Systems ETL loading Campaign data using Unix shell script [awk, nawk] and Sql Loader to generate Reports.
●Created Batch Job using PRO*C and Unix-shell Script.
Education
Oracle Fusion Implementation course from techleadsit.com
Post Graduate Diploma in Computer Science from Ratan Tata Institute India.
Bachelor of Science in Physics, Chemistry and Mathematics Govinda Dasa College, India
Skills
●Oracle Database 19C,12C,11g,10g, 9i, 6
●PL/SQL and SQL, Explain Plan, SQL Hints
●RMAN Recovery and Backup using NET-BACKUP
●Oracle Enterprise Manager
●Oracle Web Logic Server,Tomcat and Apache, with SSL option.
●Windchill PLM, CREO Install and Problem Resolution.
●Linux, Sun Solaris, IBM AIX.
●Trained to implement Oracle Fusion Implementation GL, AP, AR Cash Management, Fixed Assets
●Unix Shell Script, Unix ETL Data loading using Awk, SQL*Loader and Unix-shell script.
●Knowledgeable to Implement Data-Guard
References: Available upon request.
Contact this candidate