Objective – Seeking a challenging position of to utilise my experience and my knowledge.

Professional Summary:

Over 12 years of progressive IT experience in architecting, modeling and implementation of business process models, application models, data models for Database administration, OLTP, Data warehouse, and business intelligence applications, assessing architectures and proactively interpreting the future trends in technology.

The Oracle DBA activities that I have been involving so far includes day-to-day production database monitoring, Backup & Recovery using RMAN, Trouble shooting production issues, Performance Tuning, Physical Database design, expertise skills in coding with PL/SQL & Developer 2000 (Forms 6i & Reports 6i).

I am a skilled Enterprise Resource Planning Consultant with extensivefunctional & technical knowledge of various ERP software developed on Oracle technologies. I am having both the technical & functional skills of various popular ERP software (Oracle App 11i) as well as in-house developed applications including modules Production & Production planning, Sales, Purchase, Account Payable, Account Receivable, General Ledger, Costing, Fixed Assets, Material Planning, Supplier chain management, CRM & HRMS.

I have worked more than 7 years onsite in various countries like US, Europe (Netherland, Italy & Lithuania), Indonesia, Bangkok, Oman, Qatar, Kenya & Uganda, played various roles from DBA/developer to Project Manager.

I have experience working with senior management sometime reporting them directly.

Currently I am leading a team of 3 DBA & 12 Application developers which is providing support round the clock & across the globe.

I have attended training on Oracle Database 10g: Administration Workshop II.

Expert IT Skills

• Oracle7, Oracle8, Oracle8i, Oracle9i & Oracle10g database administration and management
• SQL*Plus, SQL and PL/SQL programming and development
• Oracle Developer 2000 ( Forms 6i & Reports 6i)
• Materialized views, Explain Plan, TKPROF , STATSPACK , AWR and ADDM utilities
• Unix Shell Programming
• Knowledge of Oracle e-business Suite 11i
• Operating systems: UNIX, LINUX, Sun Solaris, Windows- XP/Vista

Employment History

May 2008 – Till Date
Company - Confidential, Bangkok, Thailand
Role- Oracle DBA/Database Architect
Confidential

Indorama Ventures Public Company Limited is one of the largest vertically integrated polyester chain producers in the world and a leading global manufacturer of wool yarns with an annual turnover of US$4.3 billion.

The company is implementing an in-house developed ERP software, called SBMS developed using front end tool Oracle developer 2000(forms 6i & Reports 6i) and backend Oracle database. The SBMS software is currently installed 14 sites around the world.

My contribution to the ERP software as follows -

• Performing daily monitoring of databases running in 14 different locations, including trouble shooting production issues, system jobs, system performance, database availability and backup
• Formulating and executing SQL scripts to perform query jobs, data patches, statisticsand reports
• Creating new databases and users, setup RMAN backups, Export and Import
• Performance Tuning using Materialized views, Explain Plan, TKPROF, STATSPACK, AWR and ADDM utilities to fine tune SQL execution plans. Modify init parameters to improve instance/database performance, Physical Database design
• Solely responsible for administrating and maintaining all production and development DB environments and main point of contact for all operational/domain knowledge
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity
• Install & configure database for development & production environment.
• Develop, maintain installation and configuration procedures and security standard
• Enforce database standards in accordance with company policies
• Mentoring junior programmers in writing PL/SQL programming & DBA activities
• Writing complex PL/SQL programming for the SBMS ERP software

Oct 2006 –May 2008
Company - Confidential, Noida, India
Role- Senior Technical Associate & Team Lead
Website – Confidential

• Be an interface between offshore delivery team and customer (AT&T)
• Database analysis & design for business needs in cooperation with various levels of business and systems personnel.
• Provide technical expertise to junior developers in writing SQL, PL/SQL programs & stored procedures.
• Involve in writing PL/SQL packages for the PIE application, written stored procedures for various data loading applications using SQL*Loader & UTL_FILE, written stored procedures to authenticate users using Oracle 10g encrypting & decrypting built packages, written packages using collections & forall to manipulate very large data loading tables. Used PL/SQL wrappers to wrap procedures, functions & packages.
• Involve writing complex stored procedures to extract & load data into the staging tables. Used pipe line functions by passing collections to these complex procedures. Also using materialized view to populate some of the staging tables with materialized view logs. Using DBMS_MVIEW.EXPLAIN_REWRITE, DBMS_MVIEW.EXPLAIN_MVIEW, DBMS_MVIEW.TUNE_MVIEW & DBMS_ADVISOR.TUNE_MVIEW to verify query rewrite integrity and performance of the materialized views.
• Involve in writing database triggers to maintain complex data integrity & auditing database objects & schemas, written autonomous triggers for auditing database objects
• Optimized complex queries using materialized views, used query_rewrite & materialized view logs for materialized views, assisted DBA by providing suggestions to set the database in cursor_sharing mode. Also used cursor_sharing with stored procedures.
• Optimised SQL & PL/SQL packages using oracle various Oracle optimization techniques, used PLAN_TABLE & DBMS_XPLAN.DISPLAY, Indexes, IOT, Table partitioning & PL/SQL optimizer & profiler. Assisted DBA using composite table partitions.
• Used UNIX shell scripts to ftp data from various locations before being loaded by SQL*Loader.
• Wrote programs to schedule jobs using dbms_scheduler(Oracle 10g.
• Provide assistance to production support team for SQL & PL/SQL & performance tuning activities.
• Involve monitoring Oracle enterprise manager console for monitoring database performance & growth.
• Setting clone database for development teams & setting database in backup & recovery mode.

Aug 2004 – Sep 2006
Confidential, Nairobi, Kenya.
Oracle Programmer & Team Leader

• Installed and configured 9iAS & the Oracle Portal.
• Installed Oracle database - 9i & created the primary database storage structure and primary objects.
• Writing code for ERP software developed in Oracle & Developer 2000.
• Involved in activities like allocating system storage and planning future storage requirements.
• Modifying the database structure.
• Managing database users with all access and security implications & developed and implemented strategies for database security.
• Prepared proper backup and recovery plans & performed backup and recovery of the database using RMAN.
• Monitored and tuned the database performance including SQL tuning using Statspack Reports, Explain Plans, SQL Trace and TKPROF.
• Set up and maintained warm standby databases.
• Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.

May 1999 – June 2004
Company - Confidential, Okhla Industrial Area, India
Role- Sr. software Specialist & Team Leader

• Worked in the design, development and customization of HR and Payroll Modules.
• Involved in writing code to transfer data between oil digging rings to the Head office using external media.
• Developed & customized financial reports like trial balance, Profit & Loss and Balance sheet with schedule 6.
• Involved in coding in front-end using Forms 5 for inventory module. Also customized the Purchase bill data entry form to provide & maintain data related to import purchases.
• Installed Oracle database - 9i & created the primary database storage structure and primary objects for databases installed at the Oil digging rigs.