SUMMARY:

• Over 15 years of IT experience out of which more than ten years as an Oracle DBA & System Administration. I am responsible for Software Development, Project Management and System administration. Have Experience in Design, Development, Customization and Implementation of various applications.
• ORACLE DBA on Window-NT/SUN Solaris/IBM AIX/Redhat Linux with OS Administration.
• Solely responsible for planning, installation & maintenance of Oracle Fail Safe 3.X on Microsoft clusters server configuration.
• Working on Oracle 9i Real Application Cluster environment and also acquired training from Oracle Corp.
• Worked in 24x7 production environment.
• Working with more than 900 databases on Sun Solaris / AIX / Linux / HP UNIX base servers.
• Responsible for Oracle installation, patch applied & co-ordinate with Oracle support.
• Responsible for operating system installation & patch applied.
• Responsible for Oracle middle tier application and patch applied.
• Responsible for creating Development & Test database from production environment. Also doing data refreshing as when required.
• Strong experience in Oracle 7.x, 8i, 9i, 10g & 11g Database Architecture and Administration.
• Planning for logical & Physical database in production server. Creation, maintenance and reorganization of Table spaces & maintained multiple databases
• Strong experience in ORACLE Database Administration including design of database, planning/implementing backup/recovery strategies & Performance tuning (block level & kernel parameter also).
• Capacity Planning, space utilization and Data Modeling & designing using Erwin.
• ETL package for Data loading and Extraction. Proficient in monitoring and optimizing the performance of the Database.
• Experience in enabling TCP/IP network and managing SQL* NET connectivity.
• A big exposure towards handling very large databases (more than 1000 GB), backup & recovering strategy.
• Programming skills in PL/SQL, Stored procedures, packages and triggers, Visual Basic, Clipper, FoxPro, Ms-Access and COBOL.
• UNIX Shell programming, Perl scripting, UNIX system administration, RAID configuration, TCP/IP, NFS, DNS, NIS setup and administration.
• Migrated the Oracle Production database from 7.3.4 to 8i, 8i to 9i, 8i to 10G, 9i to 10G, 10g to 11g.
• Worked on Setting up of Standby Database, Oracle Replication & Parallel servers in Production environment.
• I have done many analysis reporting using various Business Intelligent tools like Cognos, Microstrategy & Adaytum for Datawarehouse.
• Experience in installing Oracle Applications 11i & working knowledge of it.
• I have also work on Veritas file system management, Veritas Cluster server (VCS), Veritas netbackup & Veritas Backup Execute.
• Regularly doing housekeeping activity like space management, OS auditing, maintenance of user accounts and groups. Scheduling jobs using Crontab, Administering (creating, mount/unmount, file system integrity, backup/restore) the file systems.
• Knowledge of Solaris Cluster management, AIX HACMP.
• Assisting in router configuration & networking troubleshooting.

EDUCATION/CERTIFICATION/AWARDS:

• Master in Computer Science.
• Oracle Certified Professional 9i, 10G, 10gR2 RAC certified expert, 10G middle tier dba, 11G, EBS R12 Apps dba.
• Certified Sun Solaris 10 system admin.
• Oracle 9i Real Application Cluster training
• Brainbench certification of Sun Solaris.
• I was awarded with GAR (Greater Asia Pacific Region) Chairman’s Quality Award Competition 2000 & cash prize for best employee of IS department.

Applications : Sun ERP – SO / IC / PO / LA / AR / FAR / AP /CO.
Intranet Server Apache & IIS.
Complete Banking Application System – SB / CD / OD / CLG / FD / ADVANCES / GL/ STATUTORY COMPLIANCES etc.
Share Registrar Application: - Complete Integrated application development for share registry – Covering all Capital market Instruments - Equity, Debentures, FCD, PCD.
Industry Specific Applications for Industries as – Food & Beverages, Fashion, Financial Services, Bank - in the field of Sales, Manufacturing, Purchase, Accounts, Finance Payroll, etc.
Oracle Tools : PL/SQL, SQL*LOADER, SQL*PLUS, TOAD, QUEST, OEM, Oracle Management Server, DB Artisan SQL Navigator 4.X.
ETL & Data Model : Informatica, Erwin.
Business Intelligence : Cognos, Adaytum, Micro Strategy, Crystal Report.
Operating Systems : Unix (AIX, Solaris 5.x, Redhat Linux), Windows NT, Window 9X,
Window2000 server, Window XP, MS-DOS, Novell NetWare 4.0.
RDBMS : Oracle 11g,10g, 9.x, 8.x / 7.x, Sql Server ver 7.00
Languages : SQL, PL/SQL, Java, Visual Basic, Cobol, FoxPro, MS Access,
Clipper, Power Builder.
Hardware : RS 6000, Sun Solaris 5.x, Netfinity 5500, Pentium Workstations,
WAN, DEL Power Edge 6650/2300.
Admin Tools : Smitty, admintool, Solaris sysinfo, Solstice DiskSuite, Veritas
Backup Exec 9.x, Manager, Arc serve, Sun cluster, Net backup,
Tivoli, etc.
Other Tools : Mercury (CRM), PVCS (Software version control), Documentum
(Document Management) ,Manage Now (IBM problem
Management tool).

EXPERIENCE:

Confidential, Nov’04 to Present
Sr. Oracle DBA

IBM Client’s List

• Confidential
• Confidential
• Confidential
• Confidential
• Confidential
• Confidential
• Confidential
• Confidential
• Confidential
• Confidential
• Confidential
• Confidential
• Confidential
• Confidential
• Confidential
• Confidential

RESPONSIBILITIES:

• Working with more than 900 databases environment where taking care of production and development.
• Primarily responsible for more than 30 databases.
• Works on client’s Data Center to IBM Data Center move. Get opportunity to work with many teams to make it successful.
• Successfully handle cross platform database transfer move for Oracle 10g, 11g database where I have done database or tablespace level export between Window base to Linux base for OLAP, OLTP type database.
• Installing & applying patches for Oracle 7, 8i, Oracle 9i , Oracle 10G , 11G, 10G RAC & 11G RAC software.
• Installing & applying patches for Oracle middle tier application.
• Supporting to 24 X 7 working environment.
• Working with Unix , Storage , application team to create a new RAC database for Production, Development & Test area on Linux, AIX , Sun Solaris.
• Converting single instance to RAC instance and RAC instance to single instance.
• Familiars with how to add / remove node in existing RAC environment.
• Work on disaster recovery for IBM’s clients.
• Planning, Designing and Implementing backup strategy, Creating backup scripts as needed using RMAN or other.
• As needed done Object level recovery using RMAN backup.
• Many times I’ve been called to resolve Oracle Performance Issue for other departments of IBM’s clients.
• Applying Oracle Security patches to applicable Oracle databases.
• Working with client’s auditor to setup database security access level and audit the database.
• Helping Application team with improving their application performance.
• Creating, Supporting and Troubleshooting Data Guard databases for Primary site and standby site. Successfully done switch over & failover as needed.
• Responsible to setup cronjob for application related task, database monitoring, backup jobs and write shell scripts as required.
• Monitoring the databases for 24X7 environment..
• Database refreshing from Production to Development/Test environment based on Production hotbackup.
• Solely, primary responsible to create a Veritas netbackup script for database backup purpose and coordinating with Backup and Unix team.
• Production database migration from 8i to 9i, 8i to 10G and 9i to 10G, 10G to 11G.
• Working with client’s external vendor to setup their database environment.
• Supporting and Troubleshooting for Advance Queue and Replication database related issue.
• Coordinating with Application team, Backup team and Unix team to rollout Database Implementation.
• Database Refreshing from Production to Development/Test environment with export/import utility at database level / schema level / tablespace level.
• Coordinating with ODCS dba team to transfer Sun Solaris base database to AIX base database.
• Managing database security.
• Successfully done Production environment recovery at database or datafile level as needed
• Testing for Fail over database meaning database move from one server to another sever.
• Checking bottle neck for database performance.
• Converting 32 bits base database to 64 bits base database.
• Well verse with Data pump , export / import utilities.
• Support Oracle middle tier application performance & backup management.
• ENVIRONMENT: Oracle 7.3,8,8i,9i,10G,11g,9i RAC,10g RAC,11g RAC,EBS 11i,EBS R12, SQL, PL/SQL, Oracle Enterprise (OEM),Oracle Management Server, Toad and many other database tools. Sun Solaris 5.X, AIX 5L, Windows Xp/NT.

Confidential, (Oldwick, New Jersey) From Aug’04 to Oct’04
Sr. Oracle DBA

RESPONSIBILITIES:

• Designing database for Production Server for RAC (Real application cluster).
• Installing & apply patches for Oracle 9i software.
• Maintaining database security.
• Database client / web / application / iSQLPLUS configuration.
• Configuring automated open database backup & export dump.
• Monitoring the database usage.
• Creating a logical & physical diagram of application / database using data modeling tool like ERwin.
• Created a new Development & Test environment on Oracle 9i base.
• Writing triggers & procedures as per requirements.
• Monitoring the problem thru Mercury & give solution base on that.
• Recovered the database or tablespace or table as per types of failure.
• Database tuning through Oracle Management Server & self-written scripts.
• Well verse with database tool like SQL Navigator, Oracle Enterprise & Oracle Management.
• Recovered the table base on flash back query (Base on timestamp).
• Give a proper training to database user who does mistake.
• Involved in PL/SQL development, based on the requirement.
• SQL tuning using SQL Navigator.
• Written an ETL code in PL/SQL where source data in JD Edwards & target in there in house application
• ENVIRONMENT: Oracle 9i, Windows 2000 server, SQL, PL/SQL, SQL Navigator, Oracle Enterprise (OEM), Oracle Real Application Cluster (RAC), Oracle Management Server, Cognos, All Fusion ERwin 4.01, PVCS, Documentum, Mercury & many other database tools.

Confidential, (Columbia, South Carolina) From Feb’04 to Aug’04
Sr. Oracle DBA

RESPONSIBILITIES:

• Designing database for Production Server.
• Migration of Old 8i Production Parallel server to Oracle 9i base.
• Co-ordinate with system & Dell guy for Microsoft cluster server configuration.
• Installing & apply patches for Oracle 9i software.
• Installation of Oracle Fail Safe on Microsoft Cluster server.
• Maintaining database security.
• Database client / web / application / iSQLPLUS configuration.
• Configuring automated open database backup & export dump.
• Monitoring the database usage.
• Configuring database shutdown script for APC power management.
• Created a new Development & Test environment on Oracle 9i base.
• Helping application developer for application error.
• Writing triggers & procedures as per requirements.
• Decide DR (disaster recovery) strategy for production database.
• Planning for HA (highly available) database to the users with minimum of downtime.
• Recovered the database or tablespace or table as per types of failure using RMAN.
• Database tuning through Oracle Management Server & self-written scripts.
• Well verse with database tool like Toad, DB Artisan, and Oracle Enterprise Manager, Oracle Management & BMC’s SQL Backtrack.
• Recovered the table base on flash back query (Base on timestamp).
• Give a proper training to database user who does mistake.
• Shifting Production database to other server when detect hardware problem in servers without loosing data & minimum down time.
• Involved in PL/SQL development, based on the requirement.
• ENVIRONMENT: Oracle 8i, Oracle 9i, Windows 2000 server, Oracle Fail Safe 3.x, SQL, PL/SQL, Toad, SQL Back-track, Oracle Enterprise, Oracle Management Server, ERwin, Power Builder, DB Artisan, Veritas Backup Exec 9.X, Dell Power Edge 2300/4300/6350/6650 & many other database tools.

Confidential,(Wall Street, New York)
From Mar’02 to Feb’04

• Oracle DBA & AIX/Solaris Unix Administrator.
• RESPONSIBILITIES:
• Designing Database for Data warehouse.
• Planning for logical & physical layout for Database.
• To setup Business Intelligent tool.
• Developing ETL package for Data load and Extraction
• Monitoring Documentation process done by Programmers.
• Creating Stand-by Oracle Database & to setup Oracle 11i clone database.
• Designing and Implementing Backup and Recovery Strategy (Hot & Cold backups), Writing Cron jobs for daily Report on Database activities.
• Well verse with Unix shell scripting.
• As a regular task – Observing system storage, Rebuilding Indexes, Fragmentation of Database Objects, Tuning Issues, Resolving IO Contention,
• Used Oracle tools like TKPROOF, UTLBSTAT and UTLESTAT for Performance Tuning of Database
• Working with Oracle Applications tools like rapidwiz, adadmin & etc.
• Assisting Programmers in Development process.
• Operating system installation & applying necessary patches.
• RAID Configuration.
• Operating system level auditing & file securities.
• User & group management.
• Writing korn shell & Perl script as per the requirement.
• Operating system level backup & disaster recovery planning.
• Applying patches for OS, Oracle 8i & Oracle 11i.
• Knowledge of Internet Computing architecture.
• Work with OEM, DBArtisan, Toad or ERwin.
• ENVIRONMENT: Oracle 8i Enterprise Edition on AIX, Oracle 11i, Window NT, Solaris 5.x, RS6000, Veritas Volume Manager, Unix Korn shell & Perl scripting, Netbackup, ERwin, Microstrtegy, Cognos.

Confidential, – MUMBAI – INDIA FROM MAY 1999 TO FEB 2002 ORACLE DBA/ INFORMATION SYSTEMS EXECUTIVE

• Responsible for conversion of previous years data which is in different formats into a separate standard format.
• Responsible for to setup BI tools like Cognos / Adaytum to give various matrix reports required by users & management.
• Responsible for furthers programming on Sun system as per requirements of users.
• Responsible for user training & troubleshooting.

MIS BUDGETORY

• Responsible for to setup Adaytum Server & clients setup.
• Responsible for data in & out for Adaytum.
• Building D-list, D-cube & D-link as per requirement.
• Maintaining user wise security.
• Give user training & trouble shooting the problem.
• Publish output in web compatible.
• To setup working Adaytum via Excel for user requirement.
• Building a data model for Trial balance sheet, Profit & Loss a/c. to Product wise sales. (With drill down facility).
• Allocating SADA cost using contributor admin.
• Using the Financial BIF to speed up the things.

Oracle DBA

• Responsible for creation of multiple databases. Planning for Logical & Physical layout for the databases.
• Responsible for disaster backup recovery & monitoring tablespace for space management.
• Responsible for data migration using SQL Loader.
• Responsible for OS level kernel parameter setting for database tuning.
• Responsible for user management & give relative access for security.

Unix Administrator (AIX (RS6000) & Sun Solaris)

• Responsible for maintaining the above server covering following activities.
• Network Management, Software installation / un installation, User management, Operation management, Space management, Add / Remove devices.
• Disaster backup recovery planning for OS level.
• Cross platform activities like printing on NT printing server etc.
• Team member for configuration of DNS, NIS, SDK (Software distribution kit) for this server.
• Responsible for OS level auditing & securities as per company standard.

• Worked as team member in setting up of intranet server (Apache Linux based and IIS Windows NT based), which is used for various kinds of MIS reports & other policy related matters.

• Coordinator for International reporting of HR activities like ESOPS & Manpower reporting

• Awarded with GAR (Greater Asia Pacific Region) Chairman’s Quality Award Competition 2000.
• Cash prize for best employee of IS department at BANGKOK meet AUG-2000
• Various letters of appreciation from senior members of the management.

ENVIRONMENT: Sun spark U10, E250, E450, IBM RS6000, Netfinity 5500,Redhat Linux 6.2, Aix 4.3, Sun Solaris 2.6, 2.7,2.8, Oracle 8i, PL/SQL, Cognos, Adaytum, Windows NT, Microstrategy, Visual Basic, Erwin, Vantive (CRM), Tivoli, SAS.

JUNE 1998 to APRIL 1999 Oracle & UNIX Consultant
This is a leading bank in Mumbai.

• Developing, Maintaining & Implementation of Banking software system for there Mumbai branches.
• Responsible for user training on the system.

ENVIRONMENT: IBM RS6000, Netfinity 5500, AIX 4.3, Oracle 7.X, PL/SQL, and Windows NT.

Confidential, – AHEMEDABAD – INDIA
JAN 1997 to JUNE 1998 Oracle DBA & Solaris Admin.

• Project Consultant for Implementing computerization of entire banking Operations of Ahmedabad leading Bank.
• Implementing Oracle application as per client requirements.

Environment: Sun Solaris 2.X, Windows NT, Oracle 7.3, PL/SQL, Oracle 10.X, Cobol, FoxPro 2.5 LAN ver., Clipper, Novell NetWare, MS-Dos, Sun Sparc servers.

Confidential, – AHEMEDABAD – INDIA
JAN 1992 to DEC 1996 GROUP EDP MANAGER

This is a group with diverse interests in industries such as Food & Beverages, Fashion, Financial Services with 28 sister concerns.

• Responsible for design, developing & implementing for 28 sister companies common financial accounting, payroll & inventory system.
• Responsible for complete integrated application development for Share Registrar Application - Covering all Capital market Instruments – Equity, Debentures, FCD, PCD.
• Responsible for data migration.
• Responsible for backup/restore planning.

ENVIRONMENT: Window 95, Oracle 7.X, PL/SQL, FoxPro 2.5 LAN ver., Novell NetWare, MSDOS.

Confidential, – AHEMEDABAD - INDIA
JAN 1990 to DEC 1991 PROJECT EXECUTIVE

Designing, Development, Installation and user training for the complete Banking and other Solutions for projects of many RBI (Govt.) approved commercial Banks.

• Responsible for Coding & implementation of the complete Banking system which include department like Saving, Checking, Deposit, Clearing, Foreign exchange & others.
• Responsible for user training for the system.
• Responsible for solution for RBI requirement.
• Responsible for Daily/Monthly/Qtr. Report designing & coding.
• Responsible for direct interaction with client for troubleshooting.

ENVIRONMENT: Window 95, Oracle 7.X, PL/SQL, Foxpro 2.5 LAN, Novell NetWare, MSDOS & Cobol.