Professional Summary:

• Over FORTEEN years of extensive experience in the IT industry, with 9+ years of experience as an Oracle Database Administrator. Involved with the databases from designing, developing, implementing and administering, which includes installations, support, troubleshooting, backup & recovery, testing, networking, monitoring & managing of users, performance tuning of applications and the databases; Oracle 11g/10g/9i/8i/8.x/7.x; using SQL, PL/SQL, SQL*Plus, Sql Developer, OPS/RAC (Oracle Parallel Server), Standby Database (Data Guard), Oracle Utilities, Oracle Enterprise Manager & Oracle Management Server on Unix & Windows platforms. Supported and maintained large 24x7 production databases.
• Strong Understanding with UNIX OS; HP UNIX, AIX, Sun Solaris and Linux.
• Having very good understanding with the front-end tools, Developer 2000/6i, Visual Basic & Java.
• Proficient in use of ERWIN/Visio for Logical and Physical Design.
• Experienced in designing & implementing training & education programs for the end users, as well as clients.
• Good exposures to the complete project life cycle (SDLC) support, using advanced system management tools.

Databases: Oracle 11g/10g/9i/ 8i/ 8/ 7, MySql, PostgreSql, DB2, Sql Server, MS Access, FoxPro
Languages: SQL, PL/SQL, Java, XML, Perl, C++, Visual Basic, Cobol, and GW Basic
Oracle Products: Sql Developer, Oracle Applications 11.0/11i, 9iAS, Designer 6i, Developer 2000/6i, Forms 5/4.5/3, Reports 3/2.5, WebDB 2.2, Oracle Express Server 6, ASM, Import/Export, DBMS Packages, Oracle Diagnostics and Tuning Pack, Enterprise Manager/Grid Control, RMAN, OFA, SQL* Loader, OMF, OPS (Oracle Parallel Server/RAC)
O.S: Linux, AIX5L64bit, HP UNIX, Solaris, SCO, Windows 2000/NT, Novell Netware
Designing tools: Erwin, Visio 2001, Designer 6i
Other Applications: DBArtisan, TOAD, Business Objects, Data Stage, Exceed, Legato, SAM, CDE
Hardware: Dell PowerEdge, HP-9000 series, Sun Sparc/Fire V440, T2000, IBM Risc-6000, Digital Alpha, Compaq Proliant (1500, 2000, 1200), Compaq Prosignia 300.

Certifications: Oracle 9i, 8i, 8 & 7.3 Certified Professional Database Administrator
IBM Certified Specialist DB2 UDB Version 6/7

Projects:

Confidential,Brooklyn, NY Sep 2008 to date
Senior Database Architect/Administrator
As a senior member of the database team, responsible for all of their day to day database related activities, not only limited to Oracle, but also in charge of MySql and PostgreSql databases too.
Key player from the database perspective in their 2 flagship products mClass & Aris (Oracle) and some of their internal usage databases too for reporting purpose; e.g., sawmill, nagios, having almost more than 50 databases, all together (Oracle, MySql & Postgres), and doing all sorts of tasks; backups, refreshes, installation, configuration, upgradation & patching, creation of new databases/schemas, according to the needs of respective teams. Day to day performance tuning issues and concerns, gathering/exporting/importing statistics, have extensively used datapumps for database/schemas refreshes from one database to another via a db link, most of the tasks are configured/automated using crontab. Doing users/roles management, privileges tweaking, as requested by the application, managing all of their network concerns (tnsnames), the environment was not a core Data Guard shop, but having Standby Databases (Physical), and just very recent was part of a team, implemented Logical Standby too, for read only access, also implemented Database Partitions. Put into practice strong documentation standards, using open source; wiki technologies.
Also doing databases refreshes using Linux (OS) LVM snapshot functionality; virt-manager, got a very good exposure with Open Source Technologies.
Environment: Linux 5.3 (64bit), Oracle Enterprise & Standard Edition, 10g (10.2.0.3) & 9i (9.2.0.7), MySql: 5.4, PostgreSql: 8.4

Confidential,Edison NJ Jan 2008 Sep 2008
Oracle Architect/DBA/Trainer

• Played a vital role in their biggest project a one stop shop for all Oracle needs, taking care of all of their database on diversified operating systems; Windows, Sun Solaris & Linux.
• The company also involves in testing, where we design, develop & then implement their databases, and in some cases also administer their databases too, need to build a robust/efficient database according to the requirements of the client, also responsible for training & mentoring their Junior Database Administrators for the clients.
• Responsible for Installing different versions of Oracle software, applying latest individual patches or cluster of patches to the operating system and to the Oracle database as well, according to the requirement of the client.

Environment: 13 databases, running on Oracle 11g, 10g & 9i, on Windows, Sun Solaris 9 & Red Hat Linux Enterprise Server 4.

Confidential, Camden NJ July 2006 Dec 2007
Oracle Architect/DBA

• Managed all of the databases (Dev: 7, QA: 7 & PROD: 8) running on AIX 5.2, including a combination of 9i and 10g databases.
• Responsible for their day to day issues and processing’s of all databases, taking care of performance tuning of database as well as applications, upgrades and applying of latest CPU patches/patchsets.
• Major contribution: Automatic gathering of all statistics (tables/indexes, partitions & sub partitions)
• Upgraded the multiple databases from 9.2.0.7 to 10.2.0.3 manually & successfully, scheduling the backup using IBM standard scripts via RMAN using TWS (Tivoli Scheduling tool) to tape devices, working on monitoring tool using Web Interface and Oracle Application Express, also trying to consolidate all of their databases into each Dev, QA & Prod environment accordingly, configuring OEM standalone and Grid options.

Environment: 22 databases, running in Oracle 9i & 10g, AIX 5L (5.2), biggest database is of 3.5 TB.

Confidential,New York, NY May 2006 - June, 2006
Oracle Database Architect
Assisting the team of DBAs/Developers for multiple short assignments:

• Configure Database Resource Manager, to utilize the CPU resources appropriately, implemented till Production.
• Helped in day to day Performance/Tuning Issues, using BSTAT/ESTAT, Explain Plan, STATSPACK, TKPROF & OEM.
• Configure OEM (Oracle Enterprise Manager) & OMS (Oracle Management Server), to monitor and managed all the databases from single point, told them how to manage, events, jobs and agents in the whole environment.
• Upgraded 2 databases from 9.2.0.4. to 9.2.0.7. and then to 10.2.0.1, configure from the OS level as well.
• Oracle Enterprise Manager for 10g, and train them how to utilize its capabilities & to monitor the databases, no OEM Grid Control.

Environment: 6 databases, running in Oracle 8i, 9i and upgraded 2 of them to 10g, Sun Fire V440/T2000 (Solaris 8/10), max db size 65 gigs.

• HERMES: a company standard & approved practice of promoting applications (Oracle DDLs) to the final testing (UAT) & then to production environment. I have made our environment (IW) compatible to this standard of the company, using technologies like Perl, awk & unix scripting and now all the applications are being promoted using this standard.
• Partition Maintenance: At the end of every month, the DBAs have to create new partitions and drop the old partitions, before dropping those partitions they have to export this data to a designated place, from where the backup process pickups up those files & store at a backup location; for 7 years. Before my arrival the whole process was manual and having a lot of mistakes, I made the whole process automatic, got very good complements from the senior management.
• Active participant in day-to-day modeling related matters, performance issues & data security concerns.
• Chief Architect of their GIW (Global Information Warehouse), designing & developing the whole new strategy.
• The group has 4 different environments/databases (DEV, SIT, UAT & PROD), this is a warehouse environment, called Global Information Warehouse (GIW).
• Introduced new features of Oracle databases in the environment, e.g., Oracle Streams, Materialized Views with fast refresh, stored outlines and worked on Data Guard as well, also implemented ASM technologies.
• Accomplished 2 tasks that were pending for last 4 years: HERMES & automation of Partition Maintenance process.
• Closely involved in Citibank most promising and prominent project Citidirect; the online portal for accounts management.
• Taking care of all compliance issues related to Citibank standards.

Environment: 4 databases (DEV: 274GB, SIT: 380GB, UAT: 843GB (cluster) & PROD: 3.1TB cluster) on Oracle 8i/9.2.0.4 on Sun Solaris, working with SQL Plus, PL/SQL, RMAN, Oracle Enterprise Manager, TOAD, DB Artisan, Erwin, Visio, Exceed, Sql Loader, EMC SRDF and MS Project.

Was responsible for 21 UNIX servers in total and 8 Oracle databases (4 8i & 4 9i databases).

• Preparing servers from the operating system as well as from the Oracle perspective.
• Applying latest individual patches or cluster of patches to the operating system and to the Oracle database too.
• Creating user accounts/directories/permissions from operating system.
• Installing Oracle software according to the requirements of the client, with different options (e.g., InterMedia)
• Running scripts for creating their database environment
• Multiple instances of Oracle (8i & 9i both) are running on several (HP & Solaris) boxes according to the requirements of the applications, I am responsible for making them stable and checking their performance when applications are making huge amount of transactions.
• Automating the RMAN backup scripts, listener purge, alert log clearance, export backups, using shell scripts.
• Designed & tested successfully the Disaster recovery drill from RMAN tapes backups to a different physical location.
• Designed, develop & implemented the standby database/data guard strategy not only for failover but also for the backup purpose.
• Responsible for all the DBA related jobs for all the instances; performance tuning, backup & recovery (RMAN & Legato) (if required), managing users & privileges, resource limits & etc.
• Taking care of day-to-day related issues; importing/loading data, user related, performance tuning.
• Increase the size not only from the database level but also at the file system level (operating system).
• Helping application developers in data modeling and assist in the physical & logical design of the database.
• Also responsible for selecting the best UNIX box for client’s application, with respect to number of CPUs, the load balancing and also setting the environment variables and do the capacity planning for these boxes.

Environment:Oracle 8i and 9i, HP Unix 10 & 11i on 9000 series, Sun Solaris 8, Reflection X, Oracle Enterprise Manager, RMAN, Legato Networker, Oracle Management Server, CDE, SMC, Admintool & SAM.

Oracle Development DBA
March 2003 - November 2003
Working for AT& T/IBM project at their Cherry Hill office, responsible for day-to-day basis responsibilities of a DBA with 3 different database administrators, it was a testing effort for AT& T’s 5 years project plan. Working on 11 Unix servers (HP & AIX) on different Oracle 8i database.

• Having different versions of the same data in 2 different releases of the databases, working with the application developers on their regular issues regarding performance tuning, user & resource management, fragmentation & contention issues.
• Responsible for the backup & recovery (RMAN) of some of the databases.
• Oracle Database Administration using Oracle 9i in VLDB environment (1.4 to 2.0 terra byte), on different platforms (Unix Sun Solaris, AIX V5). Tasks included technical support, DB monitoring, application performance tuning, DB performance tuning, DB Reorg, space management, Backup & Recovery, DB Migrations, database troubleshooting, creation of DB schemas, objects, users, and roles.
• Provide 24X7 Oracle Database production, test and development support for Project Kaleidoscope. (Project Kaleidoscope is a co-sourcing arrangement between AT& T and Accenture to transform AT& T Consumer\'s long distance sales and customer care organization using Siebel Call Center 7.5, and Common Services).
• Perform database migrations and DB change management using PVCS Version Manager.

Environment: Oracle 8i and 9i, HP Unix 10 & 11i on 9000 series, IMB AIX, Exceed, Oracle Enterprise Manager, Oracle Management Server, TOAD, Sql Loader.

Confidential,Jersey City, NJ Oracle Production & Development DBA November 2001- July 2002

As part of the bid team for Lord Abbett, was responsible for gathering information relating to Oracle Database issues for the assessment part of the project of all related issues; database administration, performance tuning and backup & recovery (RMAN & Veritas). Major objective is to gather their current state information regarding database administration, and then on the basis of, give them suggestions & advices for the best practices, which can give them a strong ROI benefit.

• Design & develop the architecture of the CPU as well as the databases.
• Multiple databases on different platforms have to been taken care.
• Studied and designed the physical & logical structure of the databases according to business requirements.
• Rules of segregating the data read only & read/write.
• Providing functional & technical support for the data warehousing development teams.
• Implementation of Data Integrity, constraints, triggers (database/application).
• Utilization of the new features of Oracle8i.
• In the performance tuning, design a complete strategy (D, A, M, I/O, C), utilizing Oracle & 3rd party tools.
• Identifying the issues regarding resources, of CPU as well as the users, implement optimal usage.
• Change Management: design & implement a plan, so the data stewards/ownership cannot be conflicted.
• Designed & Implemented the RMAN backups for production databases.
• Utilizing the 3rd party tools and Oracle built-in powerful & strong capabilities & facilities.
• Backup strategy: utilizing RMAN & Legato full, incremental and cumulative.
• Recovery strategy, full, on the basis of datafiles, or on the basis of table spaces or block recovery.
• Create a complete report with suggestions, advices & best practices in the industry for a Large Data

Warehouse project, including all the process from ODS (Operational Data Stores) à ETL (Extraction,
Transformation, Loading) à EDW (Enterprise Data Warehouse) à Data Marts

• Utilizing the most practiced & renowned star schema and snowflake schema.

Environment:4 different databases on Oracle 9i/8i & 8, working with Sql Plus, PL/SQL, DB Artisan, Erwin, Visio, Data Stage, Business Objects, Java (JSPs/Servlets) on HP Unix 10, Sun Solaris 8 & Windows NT/2000 boxes.

Oracle Production DBA
Managing three 24x7 production databases on OPS/RAC (Oracle Parallel Server, 2 instances for each database), two development databases & one training database (Total 6) as Oracle DBA.Performing routine Oracle DBA tasks on three remote locations to keep the database consistent, up & running. 20 to 30 users per instance with a large database are using the whole system.

• Involved in the capacity of a Production DBA.
• Studied the existing data model, business rules and make the required changes in the existing logical and physical database design using ER-Win 3.5.
• Strongly Involved in user training and technical documentation.
• Involved in the Production database Size Estimation.
• Involved in the Application Reorganization and Re-engineering.
• Developed lots of Shell Scripts (POSIX) to validate and transfer data from Legacy Systems to Oracle Database.
• Tuned frequently used SQL Statements and PL/SQL Blocks using SQL-Lab and increased performance by passing appropriate HINTS, by utilizing the best optimization techniques.
• Application design also utilizes the Java language.
• Tuned Oracle Production database through SGA Tuning (Shared pool, Database buffer Cache, Redo log buffer) and minimized frequent swapping and paging of SGA.
• Extensively used the new features of Oracle 8i in the areas of
• Global Temporary Tables, Function base indexes, instead of trigger.
• Parallel Query and Parallel DML Options (Oracle Parallel Server/RAC)
• Object oriented approach in database design (object views, types)
• Using FGAC (Fine-Grained Access Control) to enforce security policies at a low level of granularity.
• Password management.
• Refreshing database, imp/exp., backup
• Space management.
• Native dynamic SQL
• Involved in the management moving new application releases through different stages of the application cycle (Development Database, Customer Test Database, and Production Database).
• Extensively Involved in writing PL/SQL procedures, functions, triggers & packages, Java Procedures and then Multi-threading them through Unix Shell Script.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make database faster and easier to maintain.
• Created Stored sub programs with Dynamic SQL at both client and Server side (DBMS_SQL, Native Dynamic SQL at Server Side and EXECUTE_SQL at Client side).
• Design Tables, Constraints, Views, and Indexes etc. in accordance with the application development team.

Environment: Oracle 9i/8i & 8, PL/SQL, Sql Lab 3.2/4.0, HP Unix 10/11, Windows NT/2000, Windows98,
OPS/RAC (Oracle Parallel Server), Developer 2000/6i, Java (JSPs/Servlets), HP-9000 series, 600 GB Production environment.

Confidential,Woodland Hills, CASeptember 1999 January 2000
Oracle Production & Development DBA
The assignment essentially involved the DBA support in Oracle 8i for the Sales & Marketing Monitoring System (SMMS), CS/NADB system, Endorsement System and Marketing System.

• ORACLE DBAsupporting several pharmaceutical research applications production & Development databases ensure smooth & efficient running of 5 instances on 24x7 basis in archive log mode.
• Monitor Archiving of redo logs, their growth and make backups (incremental & cumulative by Oracle tool RMAN) on daily basis for consistency.
• Performance tuning of applications using SQL Trace, TKPROF, AUTOTRACE & EXPLAIN PLAN Utilities.
• Creation of additional indexes & modification of SGA & memory allocation parameters wherever required.
• Imp/Exp of tablespaces for the use of DSS (Data Warehousing, Data Mining & Data Mart)
• Run occasional database performance checks routines & compare it with the previous runs to detect any performance overhead (checking the HITS & WAITS).
• Suggested Use of packages like DBMS_SQL, DBMS_PIPE, DBMS_JOB, DBMS_MESSAGE, TEXT_IO etc.
• Modified the profiles for effective resource management.
• Responsible for the analysis, design, Database Administration, development and implementation.
• Write PL/SQL procedures, functions, triggers, packages) scripts for performance tuning & troubleshooting.
• Using all the OPTIMIZATION techniques for the best possible Execution Plans.

Environment:Oracle 8i/8, PL/SQL, Sql Lab 3.2/4.0, Sun Solaris 7/8, Window NT, Windows95, ETL tools, Developer 2000, Java, Sun ultra SPARC server, 500 GB Application environments.

Confidential, April 1997 -- August 1999
Oracle Production DBA
The system has been successfully implemented in 30 countries and consists of a database size of close to 150GB.

• Involved in the capacity of a Production DBA as part of a 7-member development team.
• Involved in the Installation, Database design, Administration, implementation, customization & system support.
• Involved in Developing the Logical and Physical modeling of database objects using ER-Win.
• Involved in the normalization of the Data Models for the application.
• Involved in performance fine-tuning of the queries/reports using Java, PL/SQL & SQL Plus.
• Developed Loader Programs to migrate data from legacy system to database using SQL*Loader.
• Helped team members in writing efficient stored procedures/ packages/ triggers and give solutions to their Problems in software development activities.
• Administered & Implemented User-friendly Queries & Reports interfaces.
• Tuned frequently used SQL Statements and PL/SQL blocks using TKPROF and Explain Plan.
• Involved in user training and technical documentation.
• Involved in migration of the Database from Oracle 7.3 to Oracle 8.
• Installation & configuration of Oracle, Creating indexes, users and tablespaces.
• Setting Roles, Security Domains and permissions, using SQL Loader to load data into tables from text files.

Environment:Oracle 7.3/8, Developer 2000, Forms 3.0/4.5/5.0, Report Writer 1.1, Report 3.0/2.5, Pro*C, PL/SQL, Java, Erwin, Discoverer 2000, AIX, NT.

Teaching Experiences:

• NetCom Information Technology, NYC, NY- Conducting at their Empire State Building Campus Oracle 11g core Certification Curriculum.
• InFinal Technologies, Inc. Piscataway, NJ-Conducted Oracle 9i core Certification Courses (visiting faculty)
• Union County College, (Cranford campus)-Faculty Chairperson (February 2003 December 2004)
  Conducting Oracle9i Database Administration Certification track (OCP)
• Avtech Computer Training Institute, (Piscataway)-Instructor (January 2003 June 2004)
  Conducting Oracle8i and 9i Certification curriculum.
• Career Vision NJ/NY-Instructor (November 2002- February 2003)
  Conducting Oracle DBA & Sun Solaris classes in their New York & New Jersey campuses.
• XINCON Technology School Inc. (New Jersey)-Instructor (June 2002- December 2002)
  Conducting Oracle Certification Program (OCP DBA/Developer), Sun Certified Java Program (SCJP) and HP-
  Unix Administration courses to their students and corporate clients.
• OCP Instructor, NCR Education Center-Was conducting Diploma in Oracle (DIO) classes, covering the intense Oracle Certified Professional Exam
  Curriculum of both tracks DBA & Developer/2000 Rel. II.

Certification Courses & Education:

• Bachelors of Commerce
• Java Certification Program (covering SCJP & SCJD curriculum) from Tec
• Completed Six-month course: Oracle Developer/2000 from ICSS COMPUTER TRAINING INSTITUTE - 1998.
• Completed Six-month course: Oracle7.3 Database Administration from ICSS COMPUTER TRAINING INSTITUTE - 1997.
• Completed Two years (Four Modules) Diploma in Computer Science from COMPACC COMPUTER TRAINING INSTITUTE - 1991.