PROFESSIONAL SUMMARY : * Over 20+ years of work experience as Lead Developer. * Specialized in * Advanced Oracle Database Administration 10g, 11g & 12C * Oracle PL/SQL (12 Years) * Oracle Forms 10g, Reports 10g Development / customization * Advanced PL/SQL Scripting * Stored Packages, Procedures & Functions * SQL Performance Tuning * UNIX Shell Scripting * Interface development * ETL (Data Extraction, Transformation & Loading). * Data Migration.. * Complex Query Writing and Performance Tuning. * Excellent experience and maintaining database including database security, Capacity monitoring and performance tuning (I/O, Memory & SQL Tuning etc.) Using Statspack, Explain plan, Analyze, ADDM, AWR Report and so on. Gathering and analyzing AWR report for troubleshooting purposes. * 5-year experience in Real Application Cluster RAC including setting up 10g and 11g RAC. * Good experience in regular Security patching on oracle products and interim patching for various bug fixes on database products. * Great working experience in writing SQL for creating views, functions, stored procedures, creation of database etc. * Expertise in efficient database performance, implement performance optimized recommendations, fix issues and problems. Configuring and creating databases using DBCA. * Extensive experience implementing backup and recovery strategy for disaster recovery using Hot/Cold Backups and using the Oracle backup utility such as RMAN. * Experience in a variety of hardware platforms including MS-Windows 2000, 2003, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX. * Excellent knowledge of SQL*Plus, SQL*Net, SQL*Loader, Enterprise Manager & Performance Tuning Pack. * Great working knowledge installing, patching, maintaining and upgrading all Oracle software (10g to 11g) and (11g to 12c). * Extensive knowledge on database backup/recovery strategy (RMAN, Export/Import & Datapump), Capacity Planning, Replication (Streams) standby databases, Oracle configuration management, Database Cloning, Refresh, and patch management. * Documentation of the work assigned in the environment and stored for the future use. * Strong emphasis on organization and documentations. Excellent interpersonal and strong communication skills (including Presentations). Customer-service oriented attitude and self-motivated, dedicated in any work environment. * Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, coding, and configuring servers. * Worked on Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers. * Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN. * Extensive experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks. * Experience in Implementing FLASHBACK technology and its various features in Oracle 10g/11g. * Configured physical and logical Standby Database (Data Guard) and tested for business continuity/Disaster recovery plan. * Expertise on Installation/Configuring/Maintenance of Oracle Streams for replication, integration and transmission of data between different databases and applications. * Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations. * Wrote scripts to inform the DBA team on the status, performance and space management of the database. * Participated in planning and implementation of off-site Disaster-Recovery planning and testing. * Worked with development and operations staff in resolving problems quickly and efficiently. * Resolve the bottlenecks in all the database environments. * Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers. * Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database. * Experience in Logical backup using and full/ partial export/import and Data Pump. * Extensive work experience in a database migration project team, serving in both an advisory and technical capacity. * On call technical support for 24x7 mission critical production databases. Willing to work beyond regular hours. * Domain Exposure: Banking & Financial Systems, Supply Chain Management, Credit Card Dispute Management, Hire Purchase, Leasing, Bill Discounting, Fixed Deposits, Billing Systems. * Clients Worked with: Galileo, USA, Vadum Inc, USA, DataForce Systems Inc, USA, Soft Brands Hospitality, USA, Cronos Inc, UK, Baker Haus Veit, Canada, Custom Glass Products, USA, Pliva Inc, USA, Massachusetts Institute of Technology, USA, British Petroleum, UAE, Standard Chartered Bank, Standard Chartered Bank, Malaysia, Standard Chartered Bank, Thailand, Hindustan Lever Limited, ICARDA, Syria, Electricity Holding Company, Sultanate of Oman, Diwan of Royal Court, Oman, etc, Bank Sohar, Oman, Oman Telecommunications, Oman. * Worked with Manufacturing Business Intelligence & Financial Business Intelligence & Good exposure to BI publisher. (Oracle Technical applications) involved in Core development on Visual Basic 6 built. components to pull data from JD. * Played a Lead Technical Consultant role performing Code reviews, Design decisions. * Architected and migrated huge Oracle custom application to Oracle 10g Version. * Migrating Huge Migration project with MIT Boston to migrate a VAX based Oracle custom application to UNIX. * Wrote Unix Shell scripts. * Mentored teams on Implementation Strategy, Integration, Best Practices, etc. Environment: Oracle PL/SQL, Forms 10g and Reports 10g, Windows 2000 Server, Oracle 10G, Oracle 10g, IIS, XML, ASP, HTML, COM+, Visual Basic 6, MS SQL 7.0 / 2000Server, Unix, VAX, Shell Scripts, Pro*C. APPLICATIONS: Oracle Distribution System, Oracle Migration, Microsoft Web Portal and JDE Integration SKILLS: Advanced Coding in Oracle PL/SQL, Oracle forms 10g, Reports 10g, Team Manager/Lead, Migration Strategy, Best Practices, Implementation of oracle applications E-business Suite, Application Development. Jonas CLIENTS: SOFT BRANDS HOSPITALITY, USA, Data Force Systems Inc, USA Limited Tablet (India) Limited.

Highlights:

• Support
• Structured Query Language
• Integrate
• Linux
• Microsoft Windows 2000 Server
• Performance Tuning
• Management
• Oracle
• Oracle Applications
• Oracle PL/SQL Programming language