PROFESSIONAL PROFILE

• More than Ten Years of work experience in IT as Oracle Database Administration (DBA).

• Working experience on Installation/Configuration & Upgrade/Migration of Oracle databases ORACLE 8i/9i (R 1&2) RAC/10g (R 1&2) RAC/11g RAC on different operating systems like Sun Solaris, HP-UX, AIX, Linux and various Windows operating systems.

• Working experience on Real Application Cluster (RAC), Raw Devices and Data Guard.

• Experience in handing Terabyte database (TB).

• Hands on experience of 10g advanced features like ASM, FLASHBACK, AWR, and ADDM.

• Experience in performance tuning of database, instance, SGA, I/O, using Enterprise Manager (OEM), TOAD, STATSPACK, SQL Trace, TKPROF and Explain Plan.

• Extensively used RMAN, Sql Loader, export/import and Data pump utility.

• Design and Implementing Backup and Recovery by taking Hot backup, Cold backup using RMAN, and user-managed backup using backup script.

• Tested and implemented different physical and logical backup and recovery methods like point in time (PITR), media recovery, full / partial backup.

• Expertise in Performance Tuning (Oracle 8i/9i/10g) and Stress Testing.

• Working experience on reorg/reindex of database objects.

• Extensive experience in UNIX shell scripting, Crontab to monitor database status, retrieve database statistics for analysis, startup and shutdown database, automatic moving and purging of archive files based on time.

• Implemented Oracle Advanced Security.

• Expertise in Oracle (8i/9i/10g/11g), Developer/2000 (Forms 6i, Report 6i), SQL and PL/SQL.

• Administered multiple databases of Very large sizes (VLDB).

• Experience in full software development life cycle.

• Consulting in Functional as well as Technical aspects of ERP Implementation for Client and Custom Software Development and Onsite Project Implementation.

• Fluent in Problem/tar resolution with Oracle Corporation and Metalink.

• System Architecture Design and Application Design based on Business Logics.

• Possess strong fundamentals and understanding of RDBMS, Client-Server Systems, SQL and PL/SQL.

 Supported Infrastructural Team.

• Extensive experience in writing and debugging complicated Sql and PL/SQL.

• Extensive experience in developing PL/SQL stored procedures, functions, Packages and Triggers for administering and maintaining the database and for application development

• Database administration experience on Development, Test, QA & Production Environments

• Database design & change promotion from Development, Test, QA & Production

• Ability to analyze Oracle diagnostic reports, trace files and alert logs.

• Extensive on partitioning and sub-partitioning (Range, Hash, List, Composite) of tables in Data warehouse, OLTP environment.

• Good Knowledge about 9iAS Performance Tuning.

• Have very good experience with Metadata management and Database management.

• Maintenance of SEI – CMM Level 5.0 based documentation.

• Used Toad/Spotlight extensively.

• Worked on database design, logical and physical modeling of the database using CASE tools like ERWIN/ Power designer, and normalization/de-normalization of database tables and object sizing. Good knowledge of database design patterns.

• On call 24X7 production supports. Willingness to work beyond regular hours.

• Highly motivated professional, a skilled communicator, a team player and ability to work in fast paced and dynamic environment.

• Excellent Project Management and Team Management Skills.

ACADEMIC PROFILE

• Master In Computer Application (MCA), IGNOU, New Delhi.

Professional Certification

• ORACLE CERTIFIED PROFESSIONAL in ORACLE 10g.

• ORACLE CERTIFIED PROFESSIONAL in ORACLE 9i.

• ORACLE Certified in Oracle9i: SQL.

• ORACLE Certified in Fundamental-1.

• ORACLE Certified in Fundamental-11.

• ORACLE Certified in Performance Tuning.

Training

• Oracle 9i new features.

• Oracle Performance Tuning.

• Oracle Backup and Recovery.

• SAP Netweaver XI.

TECHNICAL PROFILE

OS/Servers/Storage UNIX, SunOS (Solaris 9/10), HP-UX(11i), Redhat Linux AS 3, Windows NT/2000

Languages PL/SQL, SQL, C, Shell Scripting, C++, JAVA, FORTRAN, PASCAL, BASIC.

Databases & Tools Oracle 7.x/8.0.x/8i/9i, Oracle 9iAS, Oracle Enterprise Manager, RMAN, Oracle*Forms 6i, Oracle*Reports 6i, Designer2000/6/6i/9i, Toad SQL*LOADER, EXP, IMP, EXPDP, IMPDP, RMAN, TKPROF, EXPLAIN PLAN, STATSPACK, SPOTLight

Database Design Tools Power designer, Erwin.

Scripting UNIX Shell Scripting (Korn, Bourne, bash)

OS Tools: Shell, sed, awk, UNIX Programming

PROJECT PROFILE

Client: Montclair State University, Montclair, NJ

Role: Peoplesoft administrator/ Oracle DBA June’2009 – Till date

Montclair State University for 100 years with about 18,000 students is New Jersey's second largest and fastest growing university. And they have reputation for exceptional faculty, commitment to excellent teaching and the quality of scholarship. At the undergraduate and graduate levels, MSU provides close to 300 majors, minors, concentrations and certificate programs, while remaining accessible and affordable. Six schools and colleges prepare students to lead productive, rewarding and responsible lives in society and the world.

Forbes ranks Montclair State Best Public University in NJ for year 2009.

My role here is to install configure and maintain Peoplesoft CRM (9.0), CS (8.9), EPM (8.9), FS (8.9), PORTAL (9.0) with peopletools (8.5). Beside I have to install, configure and maintain databases on 10g and 11g. We have implemented two node 11g RAC.

Responsibilities:

• Install, configure and maintain Oracle 10g and 11g database and People tools (8.5), CRM (9.0), CS (8.9), EPM (8.9), FS (8.9) and PORTAL (9.0).

• Install, configure and maintain Oracle 11g database on Solaris 10.

• Apply patches to database 10g/11g and to PeopleSoft.

• Performance monitoring of database using OEM GRID CONTROL and problem identification, troubleshooting, and resolutions.

• Performance tuning of code. The process involves tracing, analyzing and replacing SQL code with more optimized code.

• Refreshing/Data movement development/test database from production using Export/Import, DATA PUMP. This is done so that the latest data is available in the development/test database.

• Configured RMAN for backup recovery in all environments.

• Migration of database from older release to new release.

• Data loading using oracle SQL Loader, developed SQL*Loader and external table scripts to load data and also loaded data from a single flat file to multiple tables.

• Analyzing database objects in order to improve the performance of the database.

• Optimized performance by large table partitioning, table and Index rebuilding etc.

• Query performance using better joins and used Hints appropriately.

• Written SQL query, PL/SQL stored procedures, functions, packages, triggers for database maintenance and management.

• Created shell scripts to automate the tasks

Environment: O/S: Solaris 10 on SPARC 64 bit S/W: Oracle 10g/11g

Client: ADP, Parsippany, NJ

Role: Oracle DBA Nov’2008 – May’2009

Automatic Data Processing, Inc. (NASDAQ: ADP), with nearly $9 billion in revenues and over 585,000 clients, is one of the world's largest providers of business outsourcing solutions. Leveraging nearly 60 years of experience, ADP offers the widest range of HR, payroll, tax and benefits administration solutions from a single source. ADP's easy-to-use solutions for employers provide superior value to organizations of all types and sizes. ADP is also a leading provider of integrated computing solutions to auto, truck, motorcycle, marine and recreational vehicle dealers throughout the world.

My role here is to do performance tuning of Payx application. PayX applications carry out payroll process of the entire client. ADP has designed there database as VPD. So a specific client can see their own data only. And client assumes it as their own virtual private database.

Responsibilities:

• Troubleshoot Database performance issues using ADDM, AWR, Explain Plan, TKPROF.

• VPD database.

• Performance monitoring of database using OEM GRID CONTROL and problem identification, troubleshooting, and resolutions.

• Performance tuning of code. The process involves tracing, analyzing and replacing SQL code with more optimized code.

• Refreshing/Data movement development/test database from production using Export/Import, DATA PUMP. This is done so that the latest data is available in the development/test database.

• Used Logminer for logical recovery of the database and analysis of redo log files.

• Migration of database from older release to new release.

• Data loading using oracle SQL Loader, developed SQL*Loader and external table scripts to load data and also loaded data from a single flat file to multiple tables.

• Analyzing database objects in order to improve the performance of the database.

• Optimized performance by large table partitioning, table and Index rebuilding etc.

• Query performance using better joins and used Hints appropriately.

• Involved in logical and physical schema design and data modeling using ERWIN.

• Created Bit-Map Indexes to improve the performance of query in data warehouse environment B-tree indexes in OLTP environment.

• Written SQL query, PL/SQL stored procedures, functions, packages, triggers for database maintenance and management.

• Created shell scripts to automate the tasks

Environment: O/S: Solaris 10 on SPARC 64 bit S/W: Oracle 9i/10g

Client: UBS Investment Bank, Stamford, CT

Role: Senior Oracle DBA Apr’2007 – Oct’2008

UBS is one of the world’s biggest Investment bank. They are diversified global financial services company. It is the world's largest manager of private wealth assets, the world's biggest manager of other people's money, by both market capitalization and profitability.

I worked for data warehouse project named Fusion. Fusion is a strategic Historical Data System containing end-of-day time series data on financial instruments including, but not limited to, daily closing, low, high, open and volume data for equity instruments, corporate action data, industry classification, FX spot and implied volatility data. An API/server infrastructure provides request/reply data access. The system contains multiple sources of data from external vendors including Bloomberg, Option Metrics, FTID, Mark-It as well as internal UBS systems. Fusion is able to: Store and manage market data from multiple (external and internal) vendors

Calculate, store and manage proprietary data for our front office systems, such as volatility forecasts and implied volatilities Provide analytics such as return, realized volatility, and beta calculations Provide data adjusted for corporate actions

The data is stored in an Oracle relational database designed for quick access. Currently size of database is 2.5 Terabytes with total capacity of 5 Tb. Cross-referencing across sources is available. Data is compartmentalized by source and type and is not mixed between different sources.

Responsibilities:

• Designing, Installation, configuration and deployment of Oracle 10g database and Real Application Clusters (RAC) on two nodes SUN Solaris 64 bit.

• Configuration of database on ASM.

• Troubleshoot Database performance issues using ADDM, AWR, Explain Plan, TKPROF, and STATSPACK and monitoring using OEM GRID CONTROL.

• Performance monitoring of database using OEM and problem identification, troubleshooting, and resolutions.

• Performance tuning of code. The process involves tracing, analyzing and replacing SQL code with more optimized code.

• Refreshing/Data movement development/test database from production using Export/Import, DATA PUMP. This is done so that the latest data is available in the development/test database.

• Apply security (CPU) and daylight saving time patches on 10.2.0.3.

• Worked as liaison between development team and operations.

• Data loading through ETL tool Informatica from ODS (Operational Data Store).

• Data integration, data cleansing and data transformation.

• Data loading using oracle SQL Loader, developed SQL*Loader and external table scripts to load data and also loaded data from a single flat file to multiple tables.

• Analyzing database objects in order to improve the performance of the database.

• Optimized performance by large table partitioning, table and Index rebuilding etc.

• Query performance using better joins and used Hints appropriately.

• Involved in logical and physical schema design and data modeling using ERWIN.

• Setup Backup and recovery plans using RMAN and Netbackup.

• Created Bit-Map Indexes to improve the performance of query in data warehouse environment B-tree indexes in OLTP environment.

• Enabled and used security features like FGAC, Roles and privileges.

• Used Logminer for logical recovery of the database and analysis of redo log files.

• Wrote DML, DDL, PKGs , FUNSs, TRIGs for database maintenance and management.

• Created shell scripts to automate the tasks

Environment: O/S: Solaris and AIX S/W: Oracle 9i/10g RAC H/W: PRIMEPOWER650 1-slot 8x SPARC64 V

Client: AOC (Supreme Court of California), San Francisco, CA

Role: Oracle DBA Jan’2007 – Mar’2007

AOC (administrative office of California) looks after all the administrative work of court including IT requirement of Supreme Court of California. Earlier all the county courts were independent of Supreme Court. Later on they were brought under administration of Supreme Court of California. I was responsible for designing and configuring database for these different county courts and integration with main database

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g (10.1.0.1) database.

• Applied various patches as required.

• Created Database design and data modeling using ERWIN tool.

• Used data warehousing technology – materialized views/partitioning to improve reporting performance.

• Monitored performance of Database and Applications using various tools like OEM, Explain Plan, AUTO TRACE, STATSPACK, and TKPROF.

• Perform backup and recovery using RMAN and logical backup using Export/Import.

• Implemented Oracle Advanced security.

• Database objects creation and schema maintenance.

• Developed PL/SQL stored procedures, functions, packages, and triggers for implementing business rules

• Scheduling job using Crontab according to the requirement as daily, weekly, or monthly basis.

• Created shell scripts to automate the tasks.

Environment: O/S: Solaris 10 on SPARC 64 bit S/W: Oracle 10g.

Client: Prolink, New York.

Role: Oracle DBA July’2006 –Jan’2007.

Prolink is largest private International Telecom service provider in Thailand. Prolink is biggest VOIP Company in Thailand. 80% calls from USA to Thailand is terminated by Prolink. For Thailand billing and call termination they maintain databases in Bangkok. Other set of database is at New York. They wanted to have one new system for call centre troubleshooting, MIS reports for higher management and Billing system.

Responsibility:

• Designed database for this new system.

• Worked on Normalization as part of Logical and physical Models and data modeling.

• Physical DBA activities like Database Installations, creations and migrations/upgrades on Solaris having Oracle 10g.

• Interacting with User Groups/Corporate Testing Groups/Business people

• Problem diagnosis and performance tuning of both standard and custom code. The process involves tracing, analyzing and replacing SQL code with more optimized code.

• Created backup and recovery plans using RMAN.

• Day to day management and monitoring of database.

• Space management of the Database

• Stress testing of application and database.

• Created batch work for Billing.

• Performance tuning, monitoring system health, applying patches. Enterprise

manager.

• Monitoring the database and system performance through UTLBSTAT/UTLESTST,

sar, ps, vmstat, iostat, mpstat.

• Database design, trigger and function.

• Problem identification, troubleshooting, and resolution.

• PL/Sql procedure, trigger and function, Sql, Shell scripting.

Environnent: O/S: Solaris 10 on SPARC 64 bit S/W: Oracle 10g.Its a 24x7 environnent. Oracle Enterprise Manager 2.x.

Client: Hewlett-Packard (HP), Bangkok.

Role: Team Lead/DBA Jan’2005 –June’2006

HP Singapore has done Portal and online transaction for KTB (Krug Thai Bank).KTB has changed there legacy system which was on COSES to the new system Build on J2EE, EJB and Weblogic as middle tier. This system supports all the online transaction a bank provides to customer. Like money transfer, direct debit, account summary, funds transfer etc.

They have two node RAC database at the data centre. KTB have Data guard at DRC site located 30 KM away from the primary site.

Responsibility:

• Installation, configuration, upgrading and maintenance of Databases in different environment.

• Total 11 Instances on HP-UX (11i) and 4 on AIX.

• Data modeling and database designing using powerdesigner.

• Maintenance of Transactional database monitoring through SPOTLIGHT.

• Data integration, data cleansing and data transformation.

• Implemented Oracle 9i RAC and Physical standby database.

 Carry out all Oracle production DBA functions.

 Owner of the database physical model on Development, Test, QA & Production for the projects

• Creating Users and maintaining System Security Defining Roles, Defining Profiles, Privileges in Oracle.

• Applying database & Oracle quarterly security patches

 Supporting and helping developers.

 Worked on daily DBA activities

 Preparation of Database design.

 Re-engineering and re-designing inefficient processes for better performance and throughput.

 Used Logminer for logical recovery of the database and analysis of redo log files.

 Creation of triggers to keep old records of master data after it’s modified. Created various functions for reports.

 Supported Infrastructural Team.

 High database availability.

• Data loading using SQL*Loader and External Table.

• Backup and recovery plans using RMAN and logical database backup using EXPORT/IMPORT utilities.

 Day to day management of schema and monitoring of database.

• Wrote shell scripts for housekeeping to automatically purge transactional tables based on time.

 Database Performance Tuning and monitoring.

 Stress Testing of Database.

Environment: O/S: HP-UX (11i) and AIX S/W: Oracle 9i (9.2.0.5).H/W: HP Superdome 9000. It’s a 365*24*7 environment. It has RAC with Data Guard. Backup has been implemented using RMAN. It’s a Clustered environment having two node databases. It has symmetric multiprocessor system. For storage they are using SAN network.

Client: Prolink, Bangkok/New York.

Role: DBA Sep’2004 –Dec’2004

Prolink is largest private International Telecom service provider in Thailand. Prolink is biggest VOIP company in Thailand. 80% calls from USA to Thailand is terminated by Prolink. For Thailand billing and call termination they maintain four databases here. Other set of database is at New York. Maintenance of all the Bangkok database was my responsibility.

Responsibility:

• Installation, configuration, upgrading and maintenances of all different Instances.

• Oracle production DBA functions.

• Database administration using Dictionary views.

• Data modeling of the existing application using ERWIN.

• High database availability.

• Developing complicated sql and tuning the same using EXPLAIN PLAN, SQLTRACE &TKPROF

• Backup and recovery plans.

• Batch work for Billing.

• Database design, trigger and function

• Tuning (increased performance by 190%).

• Shell scripting.

Environment: O/S: Linux Red Hat(7.3) and Linux Advanced Server (3.1) S/W: Oracle 8i(8.1.7) and Oracle 9i(9.2.0.4).Its a 24x7 environment. Oracle Enterprise Manager 2.x.

Client: Tsutaya, Bangkok.

Role: DBA Developer. Jun’2004 – Aug’2004

Tsutaya mainly deals in sale and rental of video cassettes, VCD’s, DVD’s, comics etc. They have 177 shops spread all over Thailand having 900,000 members. They are one of the largest distributors of VCD’s and DVD’s in Thailand.

Responsibility:

• Carried out Physical and Logical database design and database reorganization.

• Uploading of the transactional data coming from shops through dialup connection stored at RAS server.

• Master Data loading using SQL*Loader.

• Normalization, Schema designing and Data modeling of the application.

• Installation and tuning of Oracle 9i database and 9iAS.

• Optimization of sql and pl/sql .

• PL/sql procedure, trigger and function are written for the database uploading.

Oracle scheduler is used to upload data.

• Backup and Recovery using RMAN and user managed techniques.

Environment: O/S: Windows 2000 S/W: Oracle 9i (9.2.0.1), Oracle 9iAS 10222.

Client: SK Foods Ltd., Bangkok

Role: DBA Developer and Team Leader. Feb’2004-May’2004

SK Foods Ltd. is a leading exporter of Fish in Thailand having transaction of around $1 Billion per year. The exports fish to countries like US, Japan, Singapore etc.

Responsibility

• Installed and configured and maintained Oracle 9i database and Oracle 9iAS application server.

• Created database object like tables, views, indexes, partitions.

• Using SQL*Loader, Export, Import in order to Extract and Load Data.

• Data modeling including logical and physical model with E-R Diagram.

• SRS for purchase and Inventory control system

• Developing business requirement PL/SQL packages, functions, procedures, triggers.

• Translation of some of the Forms and Reports into Thai language using

• Translation Builder Package of Developer.

• Configured Backup procedure for database using RMAN.

Environment: O/S: Windows 2003 S/W: Oracle 9i, Oracle 9iAS 10222, Developer

2000(6i)

Client: Neco Schubert & Selzer, Nagpur

Role: Team lead and DBA Jun’2003-Feb’2004

Neco Schubert & Selzer, Nagpur. is a unit of NECO group of Company( INR 200 Billion.), having transaction of around INR 12.5 million. They are manufacturer of Pressure valve for oil sector and for different companies. They also carry out job work for Mahendra & Mahendra. NECO is the manufacturer of head Cylinders for Premium saloons like SCORPIO, Mercedes Benz etc.

Responsibility:

• Installed and configured database Oracle 9i with 9iAS and ERP software.

• Developing new application and modifying the existing one according to the

requirement of the client.

• Data modeling and designing of the new module using Erwin.

• Monitored the database growth on daily basis. Established backup and recovery strategies.

• Installed and configured database Oracle 9i.

• Created database object like tables, views, indexes, partitions.

• Item master data uploaded using SQL loaded.

• System study for Sales module

• PL/sql procedure, trigger and function

• Backup procedure and Tuning

Environment: O/S: Windows 2003 S/W: Oracle 9i, Oracle 9iAS 10222, Developer 2000(6i)

Client: Special Engineering Services Ltd, Kolkata

Role: Senior Developer and DBA Oct’2002-May’2003

Special Engineering Services Ltd, Kolkata. is a part of Birla group of Companies, having transaction over INR100 crore annually. They are main supplier of Ambassador and Lancer car spare parts to the manufacturing unit of HM (Hindustan Motors).

Responsibility:

• Installed and configured Oracle 9i database with installation of 9iAS

• Creation of users for sales, purchase, inventory and Hrpay module.

• New cycle addition like trade conversion

• Database and application developers troubleshooting.

• Proactive /active database check up. Tuning of database and application

• Conducted requirement analysis, designed the Database. Extensively involved in Logical and Physical design of the database.

• Created PL/sql procedure, trigger and function for database maintenance and application.

• Implemented Backup procedure

Environment: O/S: Windows 2000 advance server S/W: Oracle 9i, Oracle 9iAS 10222, Developer 2000(Form-6i, Report-6i)

Client: Marsons Ltd., Kolkata

Role: Senior Developer and DBA Mar’2002-Sep’2002

Marsons Ltd., Kolkata. They are big transformer manufacturer. They mainly export it to other Asian countries. Marson’s also supplies it to the different state government and to the private sector companies.

Responsibility:

• Installed and configured Oracle 8.1.7, IIS-4.0, Developer 2000.

• Created tables, views and other objects for Inventory, Purchase, hrpay Module.

• Perform database cloning to create Test and Development environments from production.

• Developed PL/SQL stored procedures, functions, packages, and triggers for implementing business rules

• Performance tuning, monitoring system health, applying patches.

• Wrote complicated SQLs for reports.

Environment: O/S: Windows NT S/W: Oracle 8.1.7, IIS-4.0, Developer 2000 (Form-6i, Report-6i)

Client: ISS Global Software Services, New Delhi.

Role: Developer and junior DBA Feb’1999-Feb’2002

ISS is big software company in software development and database maintenance.

ISS developed software for Ramkrishna forging Ltd. Ramkrishna is basically a big forging company. A big supplier of forged iron to Indian Railway, Telco etc. Their turnover is around 65 crores.

Responsibility:

• Carried out Physical and Logical database design and database reorganization.

• Created users and roles, and maintained system security.

• Created tables, views and other objects with appropriate table space sizes.

• Backup and Recovery using RMAN and user managed techniques.

• Worked on Inventory, purchase, Finance, and hrpay modules.

• New quality control cycle added.

• Performance tuning of SQL’s and PL/Sql.

• This involved scripts for monitoring database activities, space used, tracking

of offensive SQLs, data dictionary script creation, Database creation, Tablespace

creation etc

Environment: O/S: Windows NT S/W: Oracle 8.1.6, Oracle 9iAS

10222, Developer 2000 (Form-6i, Report-6i)

Contact this candidate