SUMMARY

• More than seven years of experience as an Oracle Database Administrator having hands on experience in QA, development and production environment.
• Experienced in installation, configuration, updating patches, performance tuning, backup and recovery, cloning, space management, database security, and auditing Oracle database.
• Created and maintained Physical and Logical standby database using Data Guard.
• Installed Oracle Database Server (9i/10g/11g) and Application tools for different environment.
• Experienced in Installation, configuration and maintenance of Oracle RAC.
• Seasoned in writing PL/SQL Stored procedures, functions, packages and triggers.
• Worked as a SQL developer, skilled in optimizing SQL, PL/SQL queries.
• Installed, configured and managed the ASM(Automatic Storage Management) for Oracle multi - instance database environment
• Four years of experience in UNIX (Bash, Korn and Perl) Shell Scripting and scheduling it using Crontab.
• Hands on experience in Oracle 9i/10g/11g Database administrations in high availability production environment.
• Experienced in Oracle database migration and Upgrade.
• Good knowledge of varieties of operating system environment like HP-AUX, Sun Solaris, Red Hat Linux, IBM-AIX and Different version of Windows.
• Experienced in third party tool like Quest SQL navigator and TOAD.
• Implemented Oracle Streams for schema and table level replication.
• Used Oracle Golden Gate for replication in homogeneous / heterogeneous environment.
• Tested and Implemented different physical and logical backup and recovery methods. like crash point in time recovery and data transfer utility import/export and data pump.
• Experienced in database cold/hot backup, full/incremental /cumulative backups and duplication using RMAN with or without using Recovery catalog.
• Utilized Oracle Enterprise Manager to manage users, privileges, profiles and schemas.
• Installed and configured Oracle Enterprise Manager, Grid Control.
• Good experience in database instance tuning.
• Performed database performance tuning using SQL TRACE, TKPROF, Explain plan, STATPACK, AWR and ADDM and proactive monitoring, identifying areas that needs to be improved in application.
• Applied LogMiner tool for query flashback.
• Selective and multi-table loading of bulk data from external files into Oracle database using SQL*LOADER.
• Experienced in installation, setup, configuration and management of SQL Server 2000/2005 for business functions.
• Migrated SQL server database to Oracle database.
• Performed day to day SQL server database maintenance tasks, database monitoring, backups, space management, and resource utilization and responsible for object migration between all production database servers.
• Strong knowledge in Oracle basic concepts and new features.
• Worked as a part of team and provided 24x7 supports when required.
• Strong presentation, verbal and written communication skills.
• Able to quickly master new concepts and application.

TECHNICAL SKILLS

Operating Systems: Solaris 8,9,10, Hp-Unix 10.x, 11.x, RHEL 3.x, 4.x, 5.xAIX 5.3/5.2, Windows 98/ME/NT/2003/XP, Vista, Windows 7

Databases: Oracle 11g/10g/9i, SQL Server 2003, MySQL and 10g/11g RAC

System Management Tools: SQL*Plus, SQL Developer, Oracle Grid control, TOAD, Oracle Enterprise Manager, Oracle RMAN, ASM

Oracle Tools: RAC, Data guard, SQL, SQL*Plus, PL/SQL, Export/ImportSQL*Loader, Backup and Recovery, Tuning, Network, Recovery Manager (RMAN), OEM. Oracle Golden Gate, Oracle Streams.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, SQLTXPLAN

Programming Languages: C, C++, Java, MATLAB, VB, C#.net

Scripting: CSS, HTML, XHTML, JavaScript, VBScript, Perl PHP, Korn Shell/ Bash Shell scripting

PROFESSIONAL EXPERIENCE

Confidential - Wilmington, DE

Oracle DBA

Environment: Oracle 10g,11g,RAC 10g,11g, AIX 5.x,6.x, Linux RHEL 5.x,SQL developer, Symantec Enterprise Security Management (ESM) tool for oracle database, LDAP server 3.0,Cyber-ark Privileged Identify Management system, Enterprise Change Management System(ECMS), Enterprise Manager 11g Grid control, AIX System Performance Monitoring, X-ming, Cygwin Bash Shell

Responsibilities:

• Participation in an on call rotation to provide 24x7 database support for resolving production issues.
• Installed grid 11.2.0.2 infrastructure software, ASM and 11.2.0.2 Oracle RDBMS software on RHEL 5.4(Tikanga) platform.
• Applied various patches to clusterware as well as Oracle RDBMS software.
• Configured and monitored targets on OEM 11g grid control.
• Installed and configured OEM agent software.
• Build databases on different platforms.
• Configured ASM and Maintaining ASM Disks, Diskgroups, Instances.
• Upgraded oracle 10g database to 11g database.
• Used CSSCAN utility for character set migration from US7ASCII to UTF8 and closely worked with the dev team to fix the associated data loss issues.
• Migrated more than 20 databases sizing ranging from 50G - 8TB 10g databases to 11g from AIX to Linux platform.
• Upgraded the grid/ASM infrastructure from 10.2.0.4 to 11.2.0.2.
• Database Upgradation from 10.2.0.4 to 11.2.0.3
• Installation and configuration of Symantec Enterprise Security Manager (ESM) for oracle databases.
• Created Oracle External Tables (Flat files, CSV files, ASCII files) and handling issues related to External tables.
• Resolved issues related to Materialized view refresh, performance and db-links.
• Wrote scripts to manage db-links(private and public db links creation, password changing and dropping)
• Tuned SQL queries with performance issues using tools like AWR, ADDM, TKPROF and Explain plan for optimum performance.
• Used SQLTXPLAN tool to get the enhanced explain plan for SQL query performance optimization.
• Monitor database security violation discovered by security compliance tool (ESM) and remediate issues as needed.
• Implemented LDAP based name resolution method across all data-warehouse servers and managed the TNS entries.
• Created, Maintained and supported physical standby databases with/without ASM
• Troubleshooting, Maintaining, Restoring and Recovering Clusterware components like OCR, VOTING DISK.
• Wrote scripts for Tablespace Point In time Recovery (TSPITR) and carried out TSPITR to prevent blotched update operations.
• Responsible for promoting stored procedures and database schema into multiple environments i.e. QA, UAT and Production.
• Used Transportable Tablespace to move tablespace one database to another.
• Analyzing the growth of tables and undertaking necessary re-organization of the database when required database size ranging from few GB to 64 TB.
• Closely worked with Oracle support in resolving ORA-600, ORA-7445 and ORA-3113 issues.
• Responsible for providing application development support for Query Optimization, Stored Procedures, Triggers, Indexes etc. for multiple development applications.
• Worked as team member for the Oracle Software Configuration Assessment for critical databases and implemented the recommendation provided by Oracle Advanced Customer Support team.

Confidential, PA

Oracle DBA

Environment: Sun Enterprise 4500, 5500, HP 9000/Integrity Servers, Oracle 10g,9i/8i/8.0., RAC 9i,10g11g,Oracle11i, HP UX 11 /AIX 5.x/4.4.3/4.2, Sun-Solaris 2.7/2.8/2.9, Linux RHEL4,5,VMware ESX, SQL Navigator, DB Artisan, Erwin, Shareplex, Oracle 10g Grid Control, Oracle Enterprise Manager 1.6.6 /2.0, Windows NT/2000,2003 and TOAD.

Responsibilities:

• Installation of Oracle 11g, 10g, Configuration and patching. Created the Development, Test and Production databases. Setup Oracle 10g Grid control.
• Installation of Oracle RAC (2/4 nodes) 10g/11g by using OCFS, VCFX and RAW Devices.
• Upgraded RAC from 10g to 11g
• Installed & Maintained RAC with ASM
• Installed Configure and maintained Physical/Logical Data guard between Primary and D/R Data center.
• Upgraded 9i to 10g, 10g to 11g.
• Cloning databases from Production with RMAN and Hot Backup
• Team member in a 20 member DBA team, which is supporting 120 production Instances and 200 development/testing/UAT instances with overall data-warehouse size of 50TB.
• Developed E-R and data flow diagrams, Performed Data Modeling and Architecture using ERWIN Data Modeling tool.
• Coded and tuned PL/SQL scripts for Batch Jobs.
• Reverse Engineering of Schema and Database Objects. Responsible for maintaining Application schema, Schema changes and Schema versions.
• Have written shell scripts for automation of various database-monitoring activities.
• Database security - this activity includes creating/revoking users. Creating roles, grant/revoke roles from users/roles. Implemented Security Standards.
• SQL for diagnosing the various operations of database.
• Actively involved in Shell scripting for various CRON jobs to be run.
• Handled 10g/11g RAC switchover and failover configuration, testing and Implementation.
• Performance Tuning of Production database which includes identification of Resource consuming SQL and thereafter tuning of SQL.
• Analyzing STATSPACK, AWR, ADDM and TKPROF and 10046 traces for diagnosing root cause of the issues.
• Actively involved in tuning of long running Batch jobs and Ab-initio jobs so as to provide services to the clients before the expected time.
• Analyzed, consolidated and tuned production databases for optimal efficiency.
• Monitored the performance of Linux servers by using HP Performance Manager and recommended hardware (Memory, CPU, Network, I/O) upgrades in case of resources bottlenecks.
• Implemented and maintained oracle Partitioning (range, list, hash) for very large tables and Indexes (Existing and newly designed tables) to take full advantage of partitioning features of ORACLE Technology.
• Wrote shell scripts for automation of various database-monitoring activities. Actively involved in Shell scripting for various cron jobs to be run.
• Tested and implemented Backup and Recovery Strategies. Created Backup scripts to ensure backups were occurring as expected
• Setting up the Master/Client, database links, variables and grants on snapshots to refresh data from the Master Site Trouble Shooting in case of problems in Replication.
• Created and maintained Materialized Views for different refreshing strategies for better performance of the reporting queries.
• Installed and configured RMAN for Veritas Netbackup (Enterprise Database Backup software)
• 24 X 7 Support to the Production database, which includes off-hour support also.

Confidential, Kansas

Oracle DBA

Environment: Oracle 11.1.0.7/10.2.0.4/9.2.0.8 , 10g RAC Quest Toad Ver9.0, SQL*Loader, Sun Solaris 5.8/5.9, HP-UX 11.1, Red Hat Linux 5.2, Windows XP, SQL Developer, Oracle Golden gate v10.4.x.

Responsibilities:

• Worked as a production DBA in a 24x7 environment.
• Supported customer for resolving their critical production issues.
• Installed and configured oracle 9i/10g/11g across various platforms.
• Developed UNIX shell scripts for various tasks such as monitoring, backup, maintenance, etc.
• Debugged, enhanced and maintained Shell Scripts.
• Upgraded oracle database from 9i to 10g, 9i to 11g and 10g to 11g.
• Migrated databases from SQL server 2008 to Oracle 11g.
• Created and maintained various database with replication using materialized views.
• Maintained both Logical and Physical standby databases using Data Guard.
• Performed automation of RMAN backup of the databases (running hot backup daily and archive log backup every 30 minutes).
• Worked with TSM team to setup and configure the tape backup of the file systems.
• Maintained various databases ranging from 100G to 50 TB.
• Troubleshoot performance issues with STATSPACK and AWR along with explain plan, SQL trace and TKPROF.
• Provided performance tuning on 10g RAC database on UNIX platform.
• Handled issues related to RAC, DATAGUARD and ASM.
• Applied patch to Oracle RAC database.
• Estimated the growth of the database for peak season and requested more storage to be added as per the estimates.
• Performed database refresh using export/import as per the request from application support team.
• Implemented table partitioning and sub-partitioning to improve performance and data management.
• Implemented and handled issues with Backup and Recovery strategies for oracle databases.
• Used Oracle Golden Gate tools for replication in homogeneous/heterogeneous environment.
• Actively involved in setting up Prod/Development/QA & Test database environment.
• Set up database auditing for various auditing scenarios as requested by audit team.
• Configured and automated health checks on the databases to send a monthly alert. Manage database user and security administration.
• Remotely administered the production database through VPN connection. This included monitoring the database growth, checking for the performance bottlenecks and taking backups for disaster recovery.
• Maintained documentation and coding standards, lessons learned best practices, and quality improvement documentation.
• Experienced in using packages like DBMS REFRESH, DBMS JOBS, DBMS PROFILER, DBMS SCHEDULER, etc.
• Worked with the application team for coordinating, scheduling and implementing new Releases.

Confidential, Houston TX

Oracle DBA

Environment: Oracle 9i/10g/11g, Linux 7.1.9 &Windows NT, RAC, OEM, Grid ControlRMAN, DBCA, ASM, Data Guard, Putty, TOAD 8.1, Oracle Streams.

Responsibilities:

• Installed, configured, maintained and patched 3 node Oracle 10g Real Application (RAC).
• Handled large Data-warehousing and OLTP databases.
• Configured ASM and maintained ASM disks, Disk groups, and instance.
• Installed and configured Enterprise Manager Grid Control on RAC databases.
• Handled issues related to RAC and ASM.
• Involved in performance tuning on 10g RAC database on Linux platform.
• Monitoring of disk space utilizations, sizing, and capacity planning. Adjusting database sizes and restricting maximum size appropriately.
• Taking backups with help of RMAN into both Catalog/Nocatalog modes.
• Running Cron job to do scheduled task of database like backup with help of RMAN scripts.
• Proactive database monitoring using 10g grid monitoring tool.
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Created and revalidated materialized views.
• Upgrading development and production databases to Oracle 10g, applied patches to Oracle Databases.
• Cloned/Refreshed Oracle Databases and Oracle applications for development and testing.
• Configuring, troubleshooting and maintaining Oracle Streams among Oracle Databases.
• Analyzed STATPACK, AWR, ADDM, ASH and TKPROF for diagnosing the root cause of performance issues.
• Responsible for optimizing the queries and application tuning, Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database
• Upgrading from Oracle 10g to 11g.
• Performed daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, database auditing and managing user groups, database security, OS space monitoring etc.
• Analyzed and sustained capacity and performance requirements.
• Carried general administration tasks using tools like OEM and TOAD.
• Worked with IT managers and application developers in resolving Critical database issues.
• Provided 24x7 database administration supports for production and development databases for customer clients.

Confidential

Database Administrator

Environment: Oracle 9i/10g, SQL Server 2003, HP-UX, Sun Solaris 9, AIX 5.2/5.3, SQL Developer, windows 2000, 2003

Responsibilities:

• Provided 24x7 Database supports for QA, Development and Production Environment.
• Implemented Physical Standby Database for BCP/DRP (Business continuity plan and Disaster Recovery Plan).
• Configured & maintained Oracle Recovery Manager (RMAN).
• Upgraded Database from 9.2.0.4 to 9.2.0.8
• Managed more than 10 databases (9i/10g) including VLDB Databases on UNIX environment.
• Administered standby database, performed switchover and failover, monitored archive log apply.
• Performed various activities i.e. Oracle installation, Patches, Instance Management (Start-up/shutdown, configuring parameter files, Troubleshooting),
• Performed Database Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, tuning using 10046 event, Wait Events, Buffers and Disk I/O tuning
• Used tuning tools i.e. Explain Plan, SQL*Trace, TKPROF for performance tuning.
• Wrote Shell scripts for scheduling backup, and space monitoring.
• Managed space which included table space creation, add data files, Rollback Segments, Redo Logs and other Database objects.
• Installed and configured Oracle 10g, ASM, and 10g Grid control.
• Applied Oracle 10g Interim Bug patches using OPatch.
• Monitored database using 10g Grid control.
• Restored databases in Test Servers and to test validity of backup.
• Responsible for Cloning of databases.
• Performed user administration i.e. creating new users and assigning roles and profiles
• Created of application objects i.e. tables, partitioned tables, indexes, views, materialized views, synonyms, sequences, triggers, procedures and functions with proper grants to all the users and roles.
• Installed, managed and configured SQL server 2000/2005.
• Worked with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Migrated SQL server database into Oracle database.
• Worked with software engineers to develop the database in MS SQL Server 2000/2005.
• Performed day to day SQL server database maintenance tasks like monitoring, backups, space management and resource utilization.
• Performed import and export of data from text files and Excel to SQL Server database using bulk copy insert and BCP utility.
• Took full, differential and transactional backup and restore as needed.
• Experienced in setting up traces and profiler to troubleshoot database performance issues and tuned database objects.
• Dropped and recreated the Indexes on tables for performance improvements.
• Took file backup with Windows on tape of user files and restored as needed.
• Analyzed data to develop MIS reports.

Confidential

Junior Oracle DBA (Intern)

Environment: Oracle 9i, UNIX, Linux, RMAN, DBCA, Data Guard, OEM, TKPROF, Windows 2000

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Responsible for administering and supporting production and development Oracle 9i Databases.
• Maintained 24x7 production databases to support production operation.
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Tuning the databases for optimal performance.
• Monitoring the Database storage and performing day to day activities.
• Configured scripts to monitor activity with database.
• Creating different users and granting them appropriate privileges and roles
• Taking care of Rollback/Undo segment Issues
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Taking Backups on scheduled time and monitoring scheduled backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Day to day performance monitoring and tuning of database.
• Monitoring Growth of tables and undertaking necessary re-organization of database when required