• UNIX experience and dealing with conversion projects, customer support for various organizations. Highly experienced in building, configuring, monitoring and maintaining Oracle databases on Sun Solaris and HP/UX servers in large complex environments
• Extensively worked on Production Infrastructure DBA Support RAC clusters.
• Performed user administration and tuning the system parameters for Oracle database installation.
• Migration of data from various databases to oracle.
• Production support for various databases and applications.
• Installation, configuration and upgradation of Oracle 8.0/8i/9i/10g/11g.
• Extensive experience in Oracle Migration Workbench.
• Installed Oracle Database services and Oracle products/tools S/W on Unix/NT.
• Optimized init.ora parameters to best utilize the new system resources.
• Planned Physical and logical layout of the database.
• Controlled and monitored user access to the database.
• Good knowledge in SQL, PL/SQL and shell scripting.
• Sound in concepts of Data warehousing, Data marts & Data mining.
• Tuning the application in terms of effective table design, which consists of not too many adherence to relational and normalization modes, user-centered table designing than theory centered table designing.
• Tuning memory, which involves sizing of buffer caches, shared pool, Database buffer caches in order to reduce parsing and disk accessing.
• Implemented ARCHIVE LOG Process and procedures for automatic copying files to development server as they generated.
• Configured Oracle Networking using SQL*NET for setting up Client/Server environment using Oracle Products.
• Used SQL * Loader for converting legacy databases to oracle formats.
• Finding bugs as well as provide recommendations to customers.

TECHNICAL SKILLS

RDBMS:

ORACLE 11g,10G/9.0.1/ 9.2.0.2/8.1.7/8.1.5, SQL Server 7 & 2000, MySQL & MS-Access

DATABASE TOOLS:

Erwin 4.0, TOAD 7.0, Oracle Migration Work Bench, Oracle Enterprise Manager, STATSPACK, Export/Import, expdp, impdp, RMAN, DBMS Packages, SQL Back Track, SQL * Loader, TKPROF, EXPLAIN PLAN, STATSPACK.

LANGUAGES:

C,JAVA, SQL, Pl/SQL, Shell Scripts

WEB TECHNOLOGIES:

HTML, JSP, JavaScript

WEB/APPLICATION SERVER:

Weblogic 5.1,WebSphere 4.5, Apache Tomcat 5.0, IIS

OPERATING SYSTEMS:

Sun Solaris 9/8/7/6/2.6/2.5, Linux, HP UNIX 11/10, AIX 5.1/4.3, Windows NT 4.0, Windows 2000,XP

NETWORKING TOOLS:

Sql*Net, TCP/IP, DHCP, DNS, NFS, NIS+, FTP

EDUCATION & CERTIFICATIONS

• Bachelors Degree in Electronics and Communication Engineering
• Oracle 10g Database Administrator Certified Associate (OCA)

PROFESSIONAL EXPERIENCE:
Confidential,NOV 2008 – Present
Confidential,Camp Hill, PA

Confidential,process ensures that the Early Intervention (EI) programs comply with Federal and State reporting policies and guidelines managed by the Early Intervention Reporting System (EIRS). EIRS is a data management system used to collect, update, retrieve and aggregate data for statistical reporting as a part of improving reporting effort. OCDEL has asked Deloitte to produce automated testing reports out of PELICAN EI that track issues critical to the Early Intervention Program
Responsibilities:

• Installing & upgrading the Oracle database server 11g/10g
• Installed databases on Sun Solaris.
• Involved in database designing.
• Allocating system storage and planning future storage requirements for the database system.
• Profile creation to control user resource and security.
• Created various segments of Tables, Indexes, and Clusters.
• Creating primary database storage structures (table spaces),primary objects (tables, views, indexes)
• Modifying the database structure according to the project requirements.
• Implemented Security administration by creating of roles, views and granting the necessary object/system privileges for users
• Fine-tuned the database for the maximum performance.
• Strongly utilized and executed SQL and PL/SQL languages.
• Generated and analyzed STATSPACK reports and monitoring statistics for
  performance tuning of the database.
• Plan backup strategies and setting up the RMAN backup, automate the backup maintenance and solved the configuration issues.
• Database Recovery (both complete and incomplete) from media failure
• Implemented Automatic Undo Management in order oracle to manage undo segments efficiently.
• Good Co-ordination with System Administrators and Network Administrators to achieve zero down time and better server performance.
• Used SQL*Loader to populate the Oracle Database Tables from Flat files.
• Monitoring the CPU usage, IO statistics, CPU time to identify any OS level performance killers.
• Writing Unix Shell scripts for monitoring and backup of databases
• Managing of Tablespaces for different user by granting quota on Default & Temporary Tablespaces.
• Taking Backup & Recovery of Database Using Logical (Export & Import) & Physical (Online & Offline) Backup.

Environment:
Tools : Erwin 4.0, TOAD 7.0, SQL BackTrack, VeritasNetbackUp
RDBMS : Oracle 11g/10g
Operating System : Solaris 8/7, WIN-NT.

Confidential,NY MAY 2007 to OCT 2008

Oracle Database Administrator

Responsibilities:

• Responsible for Designing the oracle Database & Schemas.
• Production Infrastructure DBA Support RAC clusters, Responsible for administration of almost a hundred instances comprising of several hundreds of databases with sizes up to 500Gb+ to 4Tb+.
• Responsible for Oracle database upgrades (all systems) from 8i to 9i/10g
• Designed and Installed the Oracle 9i,10g database.
• 24 X 7 Production Support.
• Migration of data from DB2 & SQL server database to oracle database.
• Responsible for exports and Imports on scheduling.
• Creation of Users and Roles and profiles and assigning particular roles to the users and for good performance assigned CPU time, idle time using profiles.
• Generated and analyzed STATSPACK reports and monitoring statistics for
  performance tuning of the database.
• Allocating system storage and planning future storage requirements for the database system
• Assisting in the logical design of the database using Erwin.
• Creation of table spaces, tables, views and indexes.
• Implemented ARCHIVE LOG Process and procedures for automatic copying files to development server as they generated
• Moving Database between O/S: Installed oracle 9i with necessary oracle
  patches, created a new database with the same SID on NT, did an export from NT and import on UNIX.
• Created cron jobs on UNIX for the batch process running on NT and writing PL/SQL scripts for generating reports for TestDirector.
• Providing on-site support of our Business application
• Interacted with the users and troubleshooting the problems involved with the development of stored procedures, triggers and problems related to the privileges & resources.
• Managing of Tablespace for different user by granting quota on Default & Temporary Table spaces.
• Taking Backup & Recovery of Database Using Logical (Export & Import) & Physical (Online & Offline) Backup

Environment:
Tools : Erwin 4.0, TOAD 7.0, SQL BackTrack, Veritas Net Backup
RDBMS : Oracle 10g/9i/8i, DB2, MYSQL
Operating System : Solaris 8/7, WIN-NT.

Confidential,Newark, NJ JUN 2006 to APR 2007

Responsibilities:

• Installed Oracle 9i and created databases to evaluate new features like Persistent INIT.ORA parameters (SPFILE), Oracle Flashback, Oracle Managed files Management, Automatic Undo space management, online operations like—Table redefinition, online index rebuild
• Installed Oracle 10g on Development and Test environments and upgraded the environments from Oracle 9i to 10g.
• Responsible for User Management and Role Management using SQL authentication.
• Experience configuring RMAN with Data Protector for Backup, Data Recovery & Data Protection
• Applied patches of Oracle 9i, 8i (8.1.5/8.1.7) Enterprise Edition on Sun Solaris UNIX server and windows NT/2000 server.
• Tested and Implemented procedures to detect the poor database performance, collecting required information, root cause analysis
• Tuned and improved the performance of the Oracle databases.
• Implemented Table Partitioning for large tables.
• Involved in load testing and capacity planning of Production/Development databases.
• Configured and implemented RMAN utility (8i/ 9i) for backups and recovery.
• Configured and implemented Oracle Standby databases (Data Guard) for higher Availability and Disaster recovery.
• Developed shell scripts, PL/SQL procedures to monitor the databases and scheduled UNIX cron jobs and Oracle DBMS_JOBS.

Environment:Oracle 8i/9i/10g, SUN SOLARIS 5.9, HP-UX 11.0, Import/Export, OEM, SQL* LOADER, FTP, RMAN, STATSPACK, EXPLAIN PLAN, TKPROF, JDBC, SQL, PL/SQL, and Windows NT/2000.

Confidential,India Jun 2004 to May 2006

Oracle Database Administrator

Responsibilities:

• Responsible for Installation, Configuration, Upgradation and Maintain Oracle software.
• Responsible for preparing stored procedures, Packages & Functions
• Responsible for the Oracle installation, configuration, scripting, testing, and implementation of hot/cold backups for production/test instances on various platforms (Sun, HP, NT).
• Creation of Users and Roles and profiles and assigning particular roles to the users and for good performance assigned CPU time, idle time using profiles.
• Worked with Diagnostics, Tuning and Management packs in Oracle.
• Monitored the extent growth and reorganized the tables if necessary to improve the performance in Oracle.
• Created index or rebuild index in order to improve query performance in Oracle.
• Detected locking problem and killed the oracle session causing that problem.
• Recovered the database after media failure or upon user’s request.
• Archived mission critical databases and made sure that the recovery plan was in effect for speedy recovery of the databases in the event of failure.
• Performed tablespace transport from one database over to another database.
• Checked the Oracle ‘trace files’ and ‘alert log’ files to investigate the cause of error.
• Created partition-tables if the data needed to be stored in some range values.
• Create database links to connect different databases.
• Created Locally Managed tablespaces for better space management and less fragmentation of data.
• Performed Auditing upon request on users, tables or transactions.

Environment ERwin3.5, TOAD6.5, OEM, Oracle 8.1.6 Enterprise Edition, Windows NT/Solaris.

Confidential,Hyderabad, India

Responsibilities:

• Installation and Configuration of Oracle 8i on Sun Solaris.
• Created database considering multiplexing and striping of Control files and Redo log files, the number of Rollback segments and enabling archiving to multiple destinations.
• Experience on application tuning requirement based on get-hit ratio and pin-hit ratio, Buffer pool sizing based on sort area size and number of cursors per user and number of users.
• Caching the frequently used look-up tables in database buffer.
• Planned and tested Cold / Hot / Export / Import backup strategies for the database.
• Tuning the SQL statements by SQLTRACE / TKPROF
• Monitored and Rebuild indexes and eliminating migrated rows for using Oracle blocks efficiently.
• Controlled and monitored user access to the database by Creation of Roles and granting required object and system privileges. Managing Tables, Indexes and Partitioned tables.
• Recovery Manager Implementation for Development database in testing environment.
• Create and execute detailed schedules and coordinate the efforts of many individuals.

Environment:
Oracle 8.1.7, MS SQL SERVER 2000, MS Windows 2000, Solaris 2.7