Professional 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:

PROFESIONAL EXPERIENCE:

Confidential

Role: 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

Role: Sr. Oracle DBA

Responsibilities

• Key role in Modernization Project assigned by MERCK 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

Role: 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

Role: 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

Role: 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

Role: 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