SUMMARY

• 8 years administered several DBA operations on oracle 11gR2, 11g,10g, 9i, 8i on various platforms like HP - UX, SUN SOLARIS, AIX, RedHat Linux, Windows NT and SQL Server
• Installation, Configuration and Administration of Oracle Databases DB2/R2/11g/10g/9i/8i, upgrading 8i/9i to 10g & 10g to 11g
• Installation of Real Application Cluster (RAC) on 4 node with ASM on LINUX environment
• Planning and implementation of high availability solutions using Oracle 10g RAC, Standby Database using Oracle Dataguard
• Applying RDBMS patches, security patches(CPU/PSU), proactive monitoring of databases and applications
• Expertise in using Oracle streams, Golden Gate tool for data replication and OPTIM (Archiving)
• Worked on Data Export/Import & Data pump for various requirements
• Performing backups and test recoveries using conventional hot & cold backups and RMAN
• Proficient in creating Duplicate database using RMAN for testing purposes
• Performing Cumulative, Differential and Incremental backups using RMAN
• Implementation of recovery methods like PITR(Point In Time Recovery) and TSPITR(Tablespace Point In Time Recovery) using RMAN
• Restoration and recovery of data using Veritas NetBackup
• Proficient in using Oracle Exadata for OLTP and OLAP databases
• Efficient use of Flashback technology to meet the requirements
• Proficient in creating Materialized views to create summaries in data warehouse environment and also replicating data in distributed environments
• Frequent usage of Database links for distributed query or distributed transaction
• Experience in using SQL*Loader and External Tables
• Partitioning tables by determining the suitable methodology to improve performance and manageability
• Oracle database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM ASMM etc.
• Tuning memory with System Global Areas like Shared Pool Area or Data Buffer Cache to ensure performance
• Implementation of switchover and failover using Dataguard
• Creating Users, Roles and Profiles, Privilege management with role-based security
• Resolve connection issues using Oracle Net Configurations through listener, tnsnames or sqlnet
• Proficient in PL/SQL, SQL and SHELL Scripting
• Experience in capacity planning, space management & Undo segments
• Monitoring alert log files and trace files in a database for troubleshooting purpose
• Preparing documentation for ongoing maintenance and support
• 24/7 production database support
• A self-motivated, responsible and key contributor with a set of strong technical skills enthusiasm of learning new technologies and problem diagnosing skills

TECHNICAL SKILLS

Operating Systems: HP-UX, Sun Solaris, IBM AIX, Linux(RHEL), Windows NT

RDBMS: Oracle8i, Oracle 9i,Oracle 10g, Oracle 10g RAC, Oracle 11g RAC, SQL Server

Scripting: C shell, K shell, Cron scheduling, Vi Editor, Shell Programming

Languages: SQL, PL/SQL, Pro*C, Java, C, C++, .Net, UNIX Shell Scripting, PERL

Tools: RMAN, OEM(GC), SQL*Loader, EXP, IMP, Datapump, Erwin, TOAD, DBArtisan 4.0, GoldenGate, DBVERIFY, Veritas NetBackup, Dataguard, Oracle Streams, APEX,REMEDY

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH,ASMM, Oracle Tuning Pack

PROFESSIONAL EXPERIENCE

Confidential, Mettawa, IL

Sr. Oracle DBA

Responsibilities:

• Worked for Project Verona, transferring data to a different data center as per the business requirement
• Installation of Oracle software followed by creating new databases as per the standards
• Establish backup strategy for new databases using RMAN (Daily Incremental backup and weekly full backup), scheduled by Control-M jobs
• Troubleshoot different performance issues related to SQL, Memory and Processes certainly maintain high availability
• Update APEX with new servers, databases and DR for the same
• Effective utilization of BMC PATROL for database monitoring and troubleshoot issues
• Upgrade databases from 10G to 11GR2 as per the requirements
• Key role in ROLE SWAP ( Switchover using Dataguard) and make sure the databases or servers were unaffected due to the same
• Interaction with customers like BMC to ensure the standards followed by Organization and implement products with the same
• Detect the backups for corrupt blocks and ensure they are useful for restore using RMAN
• Perform data re-org due to major changes in the critical tables
• Creation of recovery catalog and registering the new databases for the same
• Provide round the clock support and contribute to on time project delivery
• Documentation of better backup strategies using cumulative backups in RMAN and contribute to better data recovery standards
• Auditing databases and changing user roles as per new policy

Environment: Oracle R2/11g/10g RAC, Oracle10g,9i, SQL Server 2000/2005 IBM AIX, Sun Solaris, RHEL,HP-UNIX,SLES,RMAN,PL/SQL,TOAD,SQL*PLUS,SQL Developer, Export/Import, Datapump

Confidential, Summit, NJ

Sr. Oracle DBA

Responsibilities:

• Key role in Modernization Project assigned by Confidential includes Upgrading Databases
• Performed several Database upgrades starting from 8i to 11G
• Efficient use of APEX for updating and enquiring status of databases listed in Modernization
• Extensively worked on BMC software REMEDY for eliminating recurring incidents also find the parent child relations between server and databases
• Running processes like dbQualityGate on several databases with Windows and Unix servers to ensure quality
• Applying CPU/PSU patches for databases as a part of Modernization Project
• Auditing databases on daily basis to ensure the usage of databases in the recent past and pull out ownership information
• Established connections using Oracle Net Configuration through listener, tnsnames, and sqlnet
• Monitored databases under Oracle Enterprise Manager (GC) and ensure functionality
• Documented upgrade plans for databases from 8i to 10G to ensure best methods are implemented
• Migration of databases to different servers using Export/Import and Datapump
• Effective usage of Cron utility for scheduling different jobs including backups
• According to software and hardware requirements conduct time-to-time analysis and produce reports
• Co-ordinated with IT-Managers and Application developers to ensure best results for Modernization

Environment: OracleR2/11g/10g,RAC,ASM,Oracle10g,9i,8i,IBMAIX,SunSolaris,RHEL,RMAN,PL/SQL,SQL*PLUS, SQL Developer, Export/Import, Datapump

Confidential, Bridgewater, NJ

Sr. Oracle DBA

Responsibilities:

• Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g & Oracle 10g to 11g
• Installation, Configuration and Administration of Oracle 10g & 11g RAC with ASM
• Extensively used Oracle Enterprise Manager (OEM) Grid Control for maintaining and monitoring databases
• Handling data growth issues using data archiving tools like OPTIM and avoid performance degradation
• Ensure privacy and security for data including data masking using data archiving tools (OPTIM)
• Efficient usage and maintenance of databases like DB2
• Setup of Standby database for faster disaster recovery and Data guard setup for high availability
• Perform hot, cold, incremental, cumulative, differential backups using RMAN
• Partitioning tables by determining the suitable methodology to improve performance and manageability
• Effective use of applications such as Oracle Exadata for heavy workload databases
• Key role in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, Oracle 10g AWR, ADDM, ASMM etc
• Checking of Alert log and Trace files to monitor the database on a daily basis
• Patched Oracle Database Server 9i and 10g using Opatch, apply security patches(CPU/PSU)
• Worked on GoldenGate, leading tool for data replication
• Tuned memory System Global Areas like Shared pool area, Data Buffer Cache, redo buffers, I/O, Contention, modified parameter file and rebuild indexes according to the requirement for performance
• Utilized recovery methods like Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN
• Creating users grant permissions and coping with the day-to-day demands and troubleshooting their connectivity, permissions and performance problems
• Wrote shell scripts and scheduled database backups using Cron utility
• 24 X 7 Production Oracle database support and administration
• Provided on-call support regarding production-related database problems
• Co-ordinated with IT managers and application developers to ensure the database integrity, high availability and security

Environment: Oracle R2/11g/10g RAC, Oracle 10g,9i, SQL Server 2000/2005 IBM AIX, Sun Solaris, RHEL,RMAN,PL/SQL,TOAD,SQL*PLUS,SQL Developer, Export/Import, Datapump

Confidential, Windsor, CT

Oracle DBA

Responsibilities:

• Installation, configuration and administration of Oracle 10g
• Established Oracle Net Configuration using listener, tnsnames and sqlnet services
• Configured and used oracle streams to capture, stage and consume data
• Applying RDBMS patches, security patches, proactive monitoring of databases and applications
• Developed PL/SQL packages, procedures, functions and triggers to support application
• Installing and configurations of Real Application Cluster
• Prepare Backup and Recovery plan
• Effective usage of utilities like Export/Import and SQL Loader
• Recovered database in case of database crash, disk/media failure by using RMAN
• Performed database monitoring, capacity planning and performance tuning
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN
• Specifically troubleshooting and bug fixes
• Strong and extensive use of DDL and DML tools/ Maintained database schemas and dictionaries.
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc
• Configured Physical Standby database for the production database with Data Guard
• Implemented switchover on Dataguard
• Troubleshooting of Database using alert logs and traces
• Database activities include allocation and maintenance of Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks
• Worked with users to determine system requirements
• Set up and maintain user accounts and profiles
• Prepared documentation for ongoing maintenance and support
• Worked as a production DBA in 24 x 7 support environment

Environment: Oracle 9i/10gRAC, Oracle Applications on HP-UX, Shell Scripting, Sun Solaris, RHEL, SQL*PLUS, PL/SQL, SQL Developer, RMAN, TOAD, Export/Import, Datapump

Confidential, Houston, TX

Oracle DBA

Responsibilities:

• Provided 24x7 on-call support as needed
• Maintained all areas of Oracle database environment, including networking, related OS and application areas quickly and efficiently by troubleshooting.
• Installing Real Application Cluster (RAC) with ASM
• Participation in Logical Design discussions and designing physical database
• Continuous monitoring of database performance during peak and non-peak loads using Statspack, AWR and ADDM report
• Documented backup and recovery plans and tuning procedures
• Analysis & Modeling of data, User management Space/Security Management
• Loading data into the database using SQL*Loader
• Export/Import data to meet the requirement of users
• Responsible for Database performance tuning, SQL tuning using different Oracle tools such as TKPROF, Explain plan, modifying initialization file’s parameters to tune the SGA
• Performance trouble shooting, with reorganization of Databases
• Implemented Backup and Recovery procedures of the database in archive (hot/online and cold/offline), no-archive modes using RMAN and also exporting databases, tables and other objects
• Configured Oracle Data Guard in maximum availability mode
• Provided data replication using tools like Golden Gate
• Applied High priority, security patches downloaded from Metalink
• User management, Memory Management and Monitoring of Databases
• Provided support for all the databases as an operational database administrator
• Detect corrupt blocks using DBVERIFY utility
• Handle day-to-day activities
• Scheduled jobs and managed resources groups
• Implemented database related security measures that proved very effective
• Collaborated with IT project managers, application developers, and system quality assurance to ensure the database integrity, high availability and security

Environment: Oracle 9i/10g RAC, SQL Server 2000/2005 IBM AIX, Sun Solaris, RHEL, Golden Gate, Exp/Imp, Datapump, RMAN, SQL*PLUS, SQL Developer, PL/SQL, TOAD

Confidential

Oracle DBA

Responsibilities:

• Installing and configuring Oracle 9i on UNIX and Windows NT
• Up gradation of databases from Oracle 8i to Oracle 9i
• Monitored Database for fragmentation and corrected them
• Planned Backup and Recovery Strategies for various database environments
• Contact to the development team to solve the issues with the new enhancement releases
• Responsible for optimizing the queries and application tuning
• Frequent Export/Import of data
• Maintain security standards
• Monitored the alert logs regularly
• Loaded data into the database using SQL*Loader
• Implemented 9i new features like Undo tablespace management, reusable space management features
• Size of the database and database objects were estimated
• Creating users and grant roles with effective user management
• Frequent management of table space growth, monitoring data files additions, extent growth
• Provided 24X7 support for all the production and development databases
• Co-ordination with Oracle Corporation for technical support

Environment: Oracle 8i/9i, SQL, Sun Solaris, SQL*Loader, Exp/Imp, RHEL