SUMMARY

• 8 years of IT work experience in Database administration under windows, UNIX, Linux, RHEL, Sun Solaris and IBM - AIX platforms in Oracle 11g/10g/9i/8i with RAC.
• Experience in installation, up gradation and applying patches in Oracle 11g, 10g, 9i and 8i and also enterprise manager grid control (OEM) 11.1.0, 10.2.0.4, 10.2.0.5.
• Experience in implementing the Oracle RAC with Multi node Cluster in ASM Environment and using storage area network SAN, monitoring, tuning and load balancing RAC Environment.
• Experience in working with Veritas cluster file system (VCFS) in RAC. Experience in working with SCAN LISTERNER(new feature in 11g RAC)
• Hands on Experience in creating Physical and logical standby database using DATAGUARD(11g, 10g and 9i) for disaster recovery using RMAN and Oracle Enterprise manager (grid control).
• Hands on experience with different tools like TOAD, DBARTISAN (8.7.2), DBCONTROL and GRID CONTROL (11g).
• Experience in hot and cold Backup & Recovery and cloning of databases using RMAN and developed scripts for backup and recovery.
• Troubleshooting production issues, Performance Tuning, Physical Database design, Table Space Administration and managing Data Dictionary objects. Extensive SQL and PL/SQL skills.
• Created and modified Database objects such as Tables, Indexes, partitioned the tables, Views, Functions, Procedures, Triggers, Stored Procedures, and Packages.
• Setting up the complete Database Security Implementation and troubleshooting Oracle Technologies as an Oracle DBA on OLTP and OLAP environment.
• Export and import of Database objects, schema and database itself using Export/Import Utilities and Data Pump Import/Export Utilities.
• Hands on experience in upgrading the databases from 9i and 10g to 11gr2 and solved the issued during upgrade.
• Hands on experience in migrating the databases from normal file system to ASM file system 10.2.0.4 and migrated the databases from windows 2003, solaris 10 to Linux (RHEL 5.5) platform.
• Efficiently handled Space Management, Size and Capacity Planning in different versions of Oracle Databases.
• Skilled in Oracle Performance Tuning like sql tuning and instance tuning using OEM, TOAD, AWR, ADDM, TKPROF, EXPLAIN PLAN, STATSPACK and SQLTRACE.
• Performed fine tuning by creating indexes, partitioning tables, partitioning the indexes.
• Skilled in optimizing the queries using cost based optimizer and rule based optimizer.
• Handled the large database with size up to 5 TB on different platforms like AIX, RHEL AND HP-UNIX.
• Experience in developing UNIX shell scripts using korn shell and perl scripts.
• Collaborate well with project management, business analysts and department management teams.
• Superior communication, organizational and interpersonal skills.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i/7.

Languages: C, C++, SQL, PL/SQL, HTML, DHTML, XML, Java ScriptAssembly Language, UNIX shell scripting, Perl Scripting.

Tools: Oracle forms and reports, Toad, RMAN, Data Guard, OEM, SQL*NETImport/Export, Data pump Import/Export, STATSPACK, SQL*LoaderSQL*PLUS, Erwin, Designer 2000, Clusterware, VERITAS NetbackupOLTP, OLAP, RAC.

Platforms: Windows Vista/XP/ 2008/2003/2000/98/ NT, Red Hat Linux (3.0/4.0SLES/SUSE), HP-UX, AIX, Sun Solaris, IBM-AIX.

PROFESSIONAL EXPERIENCE

Confidential, WOONSOCKET, RI

Sr.Oracle DBA

Environment: Oracle 11g/10g/9i, TOAD, GRID CONTROL(11g), STATSPACK, DATAGURD, AWR, IBM-AIX(6.1), RHEL(5.5), WEBLOGIC, STREAMS, EXADATA, ASM, PeopleSoft, RAC.

Responsibilities:

• Responsible for installing RAC (11g), RAC-ONE (11g), standalone databases (11g), databases using grid infrastructure on ASM file system on AIX(6.1) and RHEL(5.5).
• Migrated the databases from NON-ASM to ASM filesystem from 11.1.0.7 to 11.2.03.
• Used utilities like ASMCMD, ASMCA for monitoring and maintain the ASM file system. Used asmca to add and delete the disks from and to disk groups.
• Worked on scan listener, SRVCTL to create and maintain the services on RAC-ONE and RAC databases.
• Upgraded the databases from 11.2.0.2 to 11.2.0.3 and from 10.2.0.4 to 11.2.0.3 and resolved the issues during and after upgrade.
• Installed the data guard (11g) and enabled the dataguard broker. Tested the read only feature on standby databases, switch over & switch back and failover. Used DGMGRL for DR testing.
• Used the flashback feature to flashback the database in case of deployment or release failures.
• Database server tuning. Proactively monitored hit ratios on different components of the SGA. This included tuning of the shared pool, databases buffers and redo buffers.
• Used utilities like DGMGRL, SRVCTL, CRSCTL, CLUVFY, TOAD, and GRID CONTROL for monitoring and maintain the databases.
• Coordinated with application team for database down time and applied the CPU, PSU and rollover patches as required.
• Responsible for taking the RMAN backups in non-prod environments as per application team requirement and restored and recovered the databases using RMAN.
• Refreshed the objects, schemas, databases using exp&imp and expdp&impdp utilities. Also used RMAN to refresh the databases from prod to non-prod environments.
• Used the tools like TOAD, AWR, ADDM, STATSPACK, SQL TRACE, and GRID CONTROL to resolve the sql performance issues.
• Created the triggers for generate the trace (for oracle SR'S) for sessions causing the performance issues.
• Worked on movement of objects from one tablespace to another and worked partitioning the tables based on range to improve the performance.
• Worked with oracle to resolve the issues caused during the refresh of the materialized views and performance problems after migrating the databases from NON-ASM to ASM.
• Responsible for creating the databases users and grant the necessary privileges. Created the wallets for batch jobs and tested wallets. Resolved the issues causing the login issues using wallets.
• Helped the application team in installing the clients on their pc's and resolved the issues in logging to the database.

Confidential, BOSTON, MA

Sr.Oracle DBA

Environment: Oracle 11g/10g/9i, TOAD, DBARTISAN(8.7.2), DBCONTROL, GRID CONTROL(11g), STATSPACK, DATAGUARD, AWR, SUN SOLARIS(10), RHEL(5.5), WINDOWS(2008), AIX(5.3), PeopleSoft, E-business, Trading, Websphere, Java, EXADATA.

Responsibilities:

• Responsible for installing, supporting the oracle stand alone, RAC(2node) and RAC(2node) with dataguard databases of the version 11g, 10g and 9i on Sun Solaris 10, RHEL 5.5, AIX 5.3 and Windows 2008.
• Used Vertias Cluster File System (VCFS), ASM file system and SCAN LISTENER in installing Oracle 11g RAC and also installed oracle grid agents on standalone and RAC databases.
• Worked with maintaining the OCR and VOTING DISK in normal and external redundancies and also worked with cluster ready services (CRS) and used CRSCTL for maintaining CRS.
• Worked on installing the data guard on RAC databases for disaster recovery and setup the dataguard broker. Tested the dataguard switchover on the RAC databases manually and also using dataguard broker.
• Worked on resolving the gap between primary and standby databases in dataguard by registering the missing archive logs in the standby database.
• Worked on setting up the flashback and restore point on the databases and also flashbacked the databases to restore point when required.
• Worked with different utilities like dataguard broker (DGMGRL), SRVCTL, CRSCTL and CLUVFY.
• Worked on installing CPU patches manually and also using enterprise manager grid control. Worked on installing the Rollover patches for RAC databases.
• Kept tracking the database performance using oracle enterprise manager and checking the users sessions which consuming more CPU and taken the necessary steps to reduce the CPU usage.
• Worked on refreshing the tables, schemas using exp & imp and also using expdp & impdp. Refreshed the databases from PROD to UAT, QA, and DEV using RMAN.
• Worked on DR tests using dataguard and VVR, resolved the issues during switch over and switch back.
• Migrated the databases from 9i and 10g to 11gr2 from Solaris 1o to RHEL 5.5.
• Upgraded the databases from 9i and 10g to 11gr2 and resolving the issues during upgrade.
• Worked on RMAN backup and recovery. Recovered the databases (full recovery) during database upgrade and point in time recovery as per the user request using RMAN.
• Created the dblinks (private and public), synonyms (private and public) and views. Validated the views and compiled the views which are invalid.
• Have used different tools like TOAD (10.6), DBArtisan (8.7.2), EXPLAIN PLAN, AWR, ADDM, TKprof, STATSPACK, Oracle enterprise manager (GRID CONTROL) 11g to solve the performance issues.
• Helped developer in installing Oracle Client, troubleshoot and establish the connection to Oracle database through JDBC.
• Responsible for monitoring RMAN backup jobs and analyze tables and indexes of Oracle database periodically for better performance.
• Responsible for monitoring the daily jobs and resolving and finding reasons for failed jobs.
• Perform production system problem analysis and recommend corrective measures in a timely manner.
• Responsible for creating the sizing documents for databases as per storage provided by application team. Documented all the necessary work for future reference.

Confidential, Parsippany, NJ

Sr.Oracle DBA

Environment: Oracle 11g/10g, SQL, PL/SQL, Erwin, TOAD(10.1), Recovery Manager (RMAN), Tivoli, Oracle Enterprise Manager (OEM), SQL*Loader, TKPROF, Data Guard, Shell Scripts, AWR, ADDM, HTML, DHTML, Windows 2008, RHEL 4.0, AIX-5.3, E-business, JAVA.

Responsibilities:

• Responsible for installing(manually), maintaining, performance tuning, and monitoring of Oracle databases version 10g and 11g on AIX-5.3 in dev, QA, test and production.
• Worked with developers and management team to ensure smooth life cycle progress from development through testing and production implementation.
• Have set up the cronjobs for runalert, spacewatch monitoring, RMAN backup (level 0 and level 1) and recovery, archive log purge, deletion of archive logs and AWR reports on AIX-5.3.
• Used normal import and export and also datapump import and export for exporting and importing schemas, tables etc from one database to another.
• Extensively worked with dba jobs, dba scheduler jobs, functions, procedures and packages.
• Responsible for tuning the database performance issues like query tuning and memory tuning (SGA tuning) and also partitioned the tables and indexes for better performance.
• Have used different tools like TOAD (10.1), EXPLAIN PLAN, AWR, ADDM Oracle enterprise manager (GRID CONTROL) 10.2.0.4 to solve the performance issues.
• Kept tracking the database performance using oracle enterprise manager and checking the users sessions which consuming more CPU and taken the necessary steps to reduce the CPU usage.
• Monitored the databases and added the data files to the tablepsaces or resizing the tablespaces and monitored the sessions running on the databases.
• Analyzed the tables and indexes manually whenever required. Manually refreshed the materialized views (used for replication) whenever the job fails to refresh them.
• Created new schemas, tables, indexes, jobs, tablespaces and granting the previleges to the user as per demand and also written pl/sql code to delete million rows by committing after every 10,000 rows.
• Monitored and checked the invalid objects like jobs, procedures etc and recompiled manually after solving the problem for objects to become invalid.
• Installed the oracle dataguard on 11g (physical standby database) on IBM-AIX-5.3for high availability, disaster recovery and used dataguard broker for switchover and failover using utility DGMGRL.
• Deployed the patches for grid agent and oms for the version 10.2.0.4 and troubleshooted the problems in uploading agent and securing agent.
• Administrated the automatic storage management (ASM) like adding the disk groups.

Confidential, Manhattan, NY

Sr.Oracle DBA

Environment: Oracle 11g/10g, SQL, PL/SQL, Erwin, TOAD, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), SQL*Loader, RMAN, STATSPACK, Data Guard, Shell Scripts, Grid Control, AWR, ADDM, Shareplex, HTML, DHTML, Windows 2008, RHEL 4.0, HP-UX 11.0.

Responsibilities:

• Responsible for administration and supporting Oracle 11g and 10g databases on 24x7.
• Upgraded the databases from Oracle 10.2.0.4 to 11.2 and implemented the dataguard on 11g databases. Installed the RAC on 10gR2 and 11g databases.
• Worked with maintaining the OCR and VOTING DISK in normal and external redundancies and also worked with cluster ready services (CRS) and used CRSCTL for maintaining CRS.
• Responsible for creating the disk groups and adding the diskgroups for datafiles in ASM for RAC env which resides on SAN storage.
• Setting and troubleshooting of oracle listener, network connection, user security and administration. Tuning for optimum performance like SQL tuning.
• Responsible for user management like creating users, creating roles, granting roles and privileges and creating profiles and granting them as per need.
• Worked on import/export, import/export Data Pump and SQL- loader and also worked with RMAN backup and recovery.
• Extensively used 10g new feature automatic SGA tuning by setting up the sga target and tested the new features of recovery using RMAN in 11g.
• Responsible for administrating the space management like adding the datafiles and creating the new tablespaces and also requesting the system admins to add the space.
• Set up cron jobs to monitor file systems usage, archive logs, backup s and periodically cleanup these file systems, and also monitor RMAN hot backup scripts.
• Tested the standby databases during switchover and failover scenarios and also tested the flashback feature on 11g dataguard and also worked on flash back recovery in recovering the tables, tablespaces, datablocks etc.
• Experienced in changing the modes of the databases and also maintaining or changing the time lag for a database in dataguard.
• Performed Database and SQL tuning by using various Tools like TOAD, STATSPACK, TKPROF, and EXPLAIN PLAN, AWR, and optimizer hints and also worked on undo retention.
• Documented the upgradation, installation of dataguard and necessary steps to follow for database recovery using RMAN.

Confidential, Valley View, OH

Oracle DBA

Environment: HP-UX, Oracle 10g/9i, Windows 2003, RHEL 4.0, Oracle OEM, TOAD, Designer 2000, Erwin, RMAN, ASM, Shareplex, RAC, ASM, ADDM, Data Guard, Shell scripts, Perl Script, HP-UX, Linux, Sun Solaris 10.0, UNIX, IBM-AIX, LPAR.

Responsibilities:

• Responsible for installing, maintaining, performance tuning, upgrading and monitoring of Oracle databases version 9i and 10g.
• Upgraded and installed Sun cluster on multi-node RAC. Upgraded from 9i to 10g and installed data guard for reporting and failover for disaster recovery.
• Used oracle enterprise manager (OEM) grid control (10.2.0.4) for monitoring ASM instances, databases and also for performance tuning and also used RAC utility SRVCTL.
• Worked on Automatic Storage Management (ASM) for managing data in SAN. Worked with ASMCMD utility for monitoring the ASM and experienced in ASM like adding new disks, creating new disk groups and configuring these disk groups into ASM.
• Used dynamic performance views, data dictionary views for monitoring and also for tuning.
• Database backup and recovery. Used hot and cold backups. Involved in development of scripts to automate backup and recovery procedures for development databases.
• Worked on all the three modes maximum performance, maximum availability and maximum protection on datagaurd.
• Performed SQL tuning using TOAD, TKPROF, EXPLAINPLAN, and SQLTrace for the Better performance and performed the defragmentation to improve the performance.
• Implemented database refresh with hot backup using RMAN DUPLICATE. Used datapump export/import to do table level/full database defragmentation.
• Installation and implementation of Oracle OEM (Oracle Enterprise Manager) to monitor database and report on events as defined by the DBA group.

Confidential

Jr. Oracle DBA

Environment: Oracle9i/8i/7, SQL*Net, CRONJOB, UTLBSTAT/UTLESTAT, TKPROF, EXPLAIN PLAN, Windows 98/XP/NT, UNIX, MS Access, MS Office.

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Responsible for administering and supporting development in Oracle 8i Database.
• Creating primary database storage structures (tablespaces, rollback segments, etc).
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Responsible for loading the data from external tables using SQL*Loader.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.

Confidential

Jr. Oracle DBA

ENVIRONMENT: Oracle 8i/7, Sun Solaris, SQL, PL/SQL, TOAD, Erwin, SQL*LOADER, Oracle Forms and Reports, Export/Import Utility, SQL Plus, Java, JSP.

Responsibilities:

• Involved and later responsible for taking the backup of the database on daily and weekly basis.
• Developed Stored Procedures, Triggers and Packages to validate the data.
• Loaded and Unloaded data from and to the external flat files to and from database using SQL*LOADER.
• Responsible for creating the tablespaces and allotting them to users as per need.
• Responsible for creation and Export/Import of database objects, schemas using Export/Import utilities.
• Involved with the creation and modification of the different database objects such as tables, indexes, sequences, functions, procedures, packages.
• Involved in the migration of Oracle 7.3.4 to Oracle 8.1.6.3.