SUMMARY

Ø Over eight years of IT experience with proven expertise in Software Development Life Cycle including Requirements gathering, Design, Development, Unit Testing, and Implementation.

Ø Extensive experience in Applications Design Development, Integration and System Testing Support of Oracle 8.1.x, Oracle 9.x and Oracle 10g(RAC) in Production, Staging, Development environments.

Ø Experienced application (development) DBAandDeveloper for production, testing and staging Oracle databases.

Ø Extensive oracle database SQL, PL/SQL development experience in oracle 8i, 9i and 10g.

Ø Experienced in Data Warehouse development working with Data Migration, Data Conversion, and Extraction, Transformation, Loading using Informatica Power Center/Power Martwith Databases like Oracle, Sql Server, and DB2.

Ø Strong in Database design & development, System Analysis, Designer, UNIX skills, Windows NT/2000 skills.

Ø Proficient in SQL, PL/SQL Programming, Query Optimization using optimizer hints, Explain plan, SQL trace, TKPROF.

Ø Expert in overall database design, such as creating normalized databases, authentication, query tuning, creating proper indexes, creating stored procedures, functions, packages, triggers and data types.

Ø Significant experience in Health care, Financial, Real Estate, Insurance, Purchasing, Inventory Control, and Manufacturing applications.

Ø Experience in working high transacted OLTPsystems.

Ø Well versed in using Cursors and Ref Cursors in various data processing.

Ø Experienced in oracle PL/SQL, SQL *Plus and T-SQLProgramming.

Ø Experience in using Oracle supplied packages such as DBMS_STATS, DBMS_JOBS, DBMS_SYSTEM and DBMS_DDL.

Ø Experience in creating partitions on large tables and creating indexes in order to improve performance.

Ø Experience in predicting growth trends and capacity planning.

Ø Experience in performing Database related activities using Oracle Enterprise Manager(OEM).

Ø Experience in managing security through grants, roles, privileges and profiles.

Ø Experience in capacity planning, space management and database migration.

Ø An excellent team player that understands the critical nature of DBA activities with 24/7 support.

Ø Experienced in data modeling using SQL Developer Data Modeler, ER studio 6.1, Oracle Designer 2000 and Erwin,prepare cutover and rollout plans.

Ø Experienced in understanding of Oracle Data Dictionary and oracle Tunable init.ora Parameters.

Ø Worked as a Team member in performing tasks such as Strategic Planning, Logical and Physical Data Modeling & Application Performance Tuning.

Ø Knowledge of using SQL Server 2005/2000.

Ø Experienced in SQL*Loader, Export, Import, Tuning using explain plan, SQL Trace, and tuning of init.ora parameters.

Ø Experience in working with RMAN backups and recovery.

Ø Experience in working HIPAA-compliant and Sarbanes-Oxley (SOX) compliant environments.

Ø Installations and configurations of Oracle Servers (10g, 9i, 8i & 8.0) on Sun Solaris, Red Hat Linux and Windows 2000/NT servers in production and development.

Ø Possess excellent interpersonal, communication and technical skills.