SUMMARY:

• About Seven years of experience as an ORACLE DBA(8i/9i/10g/11g) on different Unix and Windows environments like - Linux,AIX, HP-UX , Sun Solaris, Windows NT/2000/2003.
• Installed and configured 2, 4, 6 node server side load balancing RAC (Real Application Clusters) databases on HP UNIX and Linux with ASM (Automatic Storage Management) and Data Guard.
• Experience in Upgrade from oracle 8i, 9i to oracle 10g, 11g and Migration of oracle database from red hat Linux, Window platform to Linux on development, integration and production environment using Oracle Data Migration Assistant.
• Experience in full life cycle of database administration. Worked both as a Development and Production Support DBA on a 24x7 Basis. Willing to work beyond regular hours.
• Successfully implemented physical standby database using Oracle Data Guard featurefor High availability configuration.
• Experience in Installation, upgrades, patches, TAR support. Duties included database creation, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.
• Designed and implemented backup and recovery strategies. Extensively used conventional and RMAN for backup and recovery. Logical backup usingand full/ partial export/import and Data Pump.
• Experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
• Efficient in SQL query optimization and instance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports, gathering statistics, pinning the objects, Running scripts.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Experience inmaintaining and monitoring databases By Oracle Enterprise Manager (OEM).
• Design and Implement Database security, schema management, Back-up, Restore, Scheduling and Maintenance task in SQL SERVER.
• Experience on Parallel Execution, Advanced Compression.
• Knowledge of Oracle Application Server (OAS).
• Knowledge of NetApp experience.
• Experience with FTP,SFTP,PSFTP,SCP files on cross platform
• Experience with OEM agent and GRID control Installation and configuration.
• Working knowledge of DATAWAREHOUSING tools like ETL (Extraction, Transformation and Loading).
• Experience in VM Ware Oracle Server administration, installation.
• Expertise in loading data from flat files using external tables, SQL*LOADER.
• Designed logical and physical Data Models using ERWIN into DDL and executed on large scale to create database.
• Strong analytical and problem solving skills with ability to work within team environment and independently when needed.
• Result oriented, self-motivated, Team player, ability to work independently and within a team.

OPERATING SYSTEM

HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2,
Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows NT/2000/2003.

DBMS

ORACLE 8i/9i/10g/11g, SQL SERVER, MS ACCESS

TOOLS

Oracle Migration Workbench, SQL-Navigator, OEM , Power Designer, ERWin, TOAD, SQL* Loader, Crystal Reports, RMAN

LANGUAGES

SQL, PL/SQL, UNIX Shell scripting, Perl scripting

ETL

SQL Server Integration Services(SSIS)

Oracle Database 11g Administrator Certified Associate (OCA)
Oracle Database 11g Administrator Certified Professional (OCP)
Oracle Application Database Administrator Professional (E-Business Suit R12)

Confidential,VA
POSITION: Sr.ORACLE DBA DEC 2011 – present

Description: CGI is a global information services company has multiple project Commonwealth of Virginia agencies (COVA), institutions and public bodies conduct procurement business through a web portal, thus capturing the efficiency and effectiveness of a virtual centralized organization. This procurement solution enables the Commonwealth of Virginia to obtain goods and services easier, faster, and at the best value.

Responsibilities:

• Installation and configuration of oracle 10g,11g database on Linux, AIX and Sun.
• Creation and configuration of Oracle database of various sizes 200GB to 500 GB, and 2TB in Dev, ITG, Model and Production environments.
• Cloned databases from oracle 10g on Solaris 10 to oracle 10g on Solaris 10 on development, integration and production environment.
• Support database platform are AIX, Hp-Unix, Solaris, REHL and Window.
• Create UNIX shell scripts that automatically monitored all databases on all servers for alert log messages, tablespace growth and process scheduler problems.
• Create table with Daily Range partition as per the requirement.
• Create Clone databases using user-managed as well as RMAN.
• Support the development staff for implementation of database objects.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Tune and optimize SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the AWR and ADDR report generated from snapshots taken at the peak business hours.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL, SQL performance tuning and korn shells, Unix shell Scripting.
• Managing Instances redo log files, Tablespaces, Data files, Indexes, Undo Segments, and Temporary segments.
• Extracted data from Oracle database into XML format for EDI requirement.
• Worked on logical backup using and full/ partial export/import and Data Pump.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.

Confidential,CT
POSITION: ORACLE DBA March 2011 – NOV2011

Description: UBS is a premier global financial services firm offering wealth management, investment banking, asset management and business banking services to clients. The project was to provide Oracle DBA support for multiple large databases in production, development and test environments for various types of databases.

Responsibilities:

• Installation and configuration of Oracle 10g, 11g databases on Linux 5.4.
• Implement Oracle 10g Release 1 RAC on Enterprise Linux 5.4 in a Test environment.
• Migrated databases from 9i to 10g, 11g and 10g to 10g on different platform.
• Creation and configuration of Oracle database of various sizes 200GB, 400 GB, and 2TB in Dev, ITG, Model and Production environments.
• Cloned databases from oracle 10g on Solaris 10 to oracle 10g on Solaris 10 on development, integration and production environment.
• Support database platform are AIX, Hp-Unix, Solaris, REHL and Window.
• Create UNIX shell scripts that automatically monitored all databases on all servers for alert log messages, tablespace growth and process scheduler problems.
• Create table with Daily Range partition as per the requirement.
• Create standby database and worked with data guard to provide high availability.
• Create and Manage user, table spaces, datafiles and archive log.
• Monitor, tune and maintain overall database.
• Create Functions, Procedure, triggers, synonyms and profiles.
• Work with Flash Recovery Area.
• Create and implement backup and recovery strategies using RMAN configuration.
• Provide troubleshooting and problemsolving support to application developers.
• Create Clone databases using user-managed as well as RMAN.
• Support the development staff for implementation of database objects.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Tune and optimize SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the AWR and ADDR report generated from snapshots taken at the peak business hours.
• Transported tablespaces and data exports from production and staging databases.
• Applied client patches and other patches as required.
• Support production databases on 24x7 on call basis.

Environment: Oracle 9i/10g/11g, RAC, TOAD, SQL Plus, Oracle Enterprise Manager (OEM) Grid Control, ERWIN, RMAN, Solaris 10, UNIX and Linux.

Confidential,Chatsworth, CA Sep 2010 - March 2011
ORACLE DBA

Description: MOA is an established software development company specializing in high end database applications targeted to the financial and foreign exchange markets.

Responsibilities:

• Installation and configuration of Oracle Database Software 10g.
• Creation and configuration of Oracle database.
• Migration of database (from 9.2.0.5 to 10.2.0.1) on SUN Solaris 2.7.
• Installed and Configured RAC on Red Hat Linux Advanced Server with 4 nodes server side load balancing using Automatic Storage Management.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.
• Production support of Databases on HP-UNIX.
• Worked on FTP, ZIP files on cross platform.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Successfully implemented physical standby database using Oracle Data Guard featurefor High availability configuration
• Designed and Implemented database security using Oracle roles and privileges.
• Troubleshoot Database performance issues using Automated Workload Repository(AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Communicate and coordinate with Oracle using TAR system for major database issues/ problems; apply the required patches, test (unit test/ system test) and roll out and implement the patches into production.
• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• UNIX Shell scripting for backup and monitoring of databases.

Environment:Oracle 10g/9i, SUN Solaris 2.7,Red Hat Linux, Hp-Unix, Windows 2000/2003, TOAD, OLTP, RMAN.
Confidential,FORT LAUDERDALE, FL
POSITION: ORACLE DBA JAN 2010 – AUG 2010

Description: UIH is a vertically integrated insurance holding company, which covers all aspects of insurance underwriting, distribution, claims processing and exposure management.
Responsibilities:

• Installation and configuration of Oracle Database Software 9i.
• Creation and configuration of database.
• Performance tuning of application by identifying the SQL, which are not written well; providing inputs to the application programmer; correcting and implementing the right components.
• Upgrading database from Oracle version 8i to 9i and migration of data.
• Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL and PL/SQL.
• Worked with UNIX scripts for monitoring and backup of the database.
• Communicating with Oracle to get the necessary patches required to fix up the database changes needed using TAR support and coordinating the patches and implementing the necessary changes.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs. Worked on DBMS SCEDULER.
• Identifying issues/ bottlenecks that could potentially cause issues, involving the right teams (such as server admins or application developers) and take a corrective action to rectify the issues.
• Written extensively UNIX Shell Scripts &PL/SQL Stored Procedures and Triggers.
• Performance tuning for Oracle Day-to-day maintenance and management of the different databases in development, testand production environments.

Environment: ORACLE 9i, AIX 4.3, OEM, RMAN, Tkprof, PL/SQL, UNIX.

Confidential,Clinton,MA
POSOTION: ORACLE DBA Aug 2008 – Nov 2009

Description: Nypro is the leading global solutions provider in the field of manufactured precision plastic products. The project was to migrate and upgrade the database and to perform day to day DBA activities.
Responsibilities:

• Installation and configuration of Oracle 9i on AIX 5.2.
• Creation and configuration of database.
• Participation in designing data model for administration system.
• Upgrading database from Oracle version 8i to 9i and migrate data on diverse platform.
• Troubleshoot Database performance issues using TKPROF, STATPACK, EXPLAIN PLAN. Tuned database for optimum performance.
• Develop difficult PL/SQL script to perform error managing and reporting.
• Change databases designs for many purposes such as data migration, data warehouse, and online transactions.
• Installation of software on a wide range of platforms, for large number of clients.
• Schedule jobs in Crontab including RMAN backup and other memory maintenance, security jobs.
• Maintain and monitor multiple databases using Oracle Enterprise Manager.
• Provides services in the identification and resolution of database issues.
• Setting up of RMAN configuration on the database to perform necessary back-up.
• Proactively monitoringproduction environment for any exceptions/ issues.
• Written extensively UNIX Shell Scripts, PL/SQL, Stored Procedures and Triggers.

Environment: ORACLE 9i/10g, OEM, SQL, PL/SQL, RMAN, TKPROF, AIX 5.2, WINDOWS 2000.