SUMMARY

• 8+ years of experience in IT industry as an Oracle Database administrator, having exclusive experience in production support, installation, configuration, upgrades, cloning, space management and database security with Oracle Software 11g/10g/9i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.
• Possess high competency in advanced DBA skills such as backup, recovery & performance tuning.
• Successfully resolving problems which involve in-depth knowledge of oracle architecture, connectivity, backup/restore, database corruption, security etc.
• Problem determination and Trouble shooting in Development, Test and Production Environments.
• Providing 24x7 Production Support for Oracle databases.
• Performing periodic maintenance tasks like Index rebuilds, Table Analysis and data purge to ensure efficiency and reliability of the applications and databases.
• Preparation of High Level document, Detail Level Design document and other relevant documents for development process.
• Knowledge Transition by preparing plans, work schedule, understanding documents, managing transition calls and tracking transition status.
• Installation/Maintenance/Upgrade of Oracle RDBMS Server 9i, 10g and 11g.
• Refreshing, migrating and upgrading databases.
• Experience in implementing RAC Database in Aix platform.
• Conceptually strong knowledge on clustering.
• Conceptually having Knowledge on GoldenGate.
• Coordinating Oracle SR engineers for resolving the Issues

TECHNICAL SKILLS

Core Strengths: Oracle Database (RAC and Standalone) Administration, SQL, UNIX.

RDBMS: Oracle 9i, 10g, 11g Administration

Operating Systems: LINUX, AIX, HP-UX, Sun Solaris, Windows 2000, 2003, 2007

Programming Languages: SQL, Shell Scripting.

Tools: Enterprise Manager, Oracle Grid Control (10g, 11g and 12c), TOAD, SQL Developer.

PROFESSIONAL EXPERIENCE

Senior Oracle DBA

Confidential, Lincolnshire, IL

Responsibilities:

• Deploy database changes on production needed for new requirements, to fix application defects or performance issues on Sun OS, Linux and AIX.
• Knowledge Transition for database activities from the existing teams.
• Perform activities of data maintenance, table maintenance, database re-organizations, data archival and other efforts typically undertaken to improve the efficiency and reliability of the applications and databases.
• Perform database activities like schema backup/restore, import/export, required for the health of the application and release processes.
• Analyze database activity, perform application database performance and tuning activities and maintain development, test and production databases.
• Perform analysis and reporting of results from processing and database monitoring.
• Maintain Database Alerts.
• Proactively maintain stability of production databases.
• Hands-on experience in High-availability CRS, ASM and Data Guard
• Periodic data purge to follow retention policies and space constraints.
• Work with application team and production support team to debug production issues.
• Good Exposure in disaster recovery, routine maintenance for Oracle databases.
• Good Exposure in Oracle cluster ware and HACMP cluster ware concepts.
• Good Exposure in Oracle Recovery Manager (RMAN).
• Having expert knowledge in Configuring Recovery Catalog Database and maintaining RMAN.

Environment: Oracle 9i, 10g, 11g, RAC, Dataguard, Toad for Oracle, AIX, SUN Solaris.

Oracle DBA

Confidential

Responsibilities:

• Installation and Troubleshoot of Real Application Cluster (RAC) Database and Cluster ware.
• To troubleshoot and resolve all the Database Issues, Network Issues and the Application Issues.
• Worked in Production, Development, Testing and Implementation environment on Linux and AIX
• Involve in various Implementations like (DB Creation, Patching, Cloning and Up gradation) on Database Tier.
• Database Administration and Maintenance.
• Setting up BACKUP strategy and disaster recovery procedures to ensureminimal downtime and data loss.
• Good Exposure in disaster recovery, routine maintenance for Oracle databases.
• Involved in Implementation of RMAN backup strategies.
• Involved in configuring of ASM Databases and Migration of Non-ASM Databases To ASM databases Using RMAN
• Handling alone in validating the Developed scripts for Hot and Cold Backup and Database Refresh
• Implemented Symantec net backup.
• Monitor physical and logical backup for Integrity and checking the Data files consistency using DBverify.
• Check the log alert files if any problems occurred and necessary action to rectify them.
• Having expert knowledge in Configuring Recovery Catalog Database and maintaining RMAN
• Analysis and Documentation of the existing database architecture.
• Applying the Critical Patch Update (CPU) based on the requirement
• Preparation of High Level document, Detail Level Design document and other relevant documents for development process.
• Providing support as required and mentoring team members while solving technical problems and providing technical guidance on solutions.

Environment: Oracle 11g RAC database, AIX.

Oracle DBA

Confidential

Responsibilities:

• Migration Oracle Server databases.
• Database Administration And Maintenance
• Managing Tablespace and Datafiles.
• Managing Security (Creating users, logins and roles, granting permissions)
• Performance Monitoring and tuning.
• Checking database locks and clearing the blocking sessions.
• Worked on user managed backup strategies like online and offline.
• Implemented Backup and Recovery strategies using RMAN(migrated from user managed backup to RMAN)
• Performed Cloning of database.
• Integration of Patches, Creation and Modification of tables in the database, Execution of Jobs, Bug fixing etc.
• Resolving user requests for the technical issues as well as various other tasks for the development environments.

Environment: Oracle 9i, 10g, 11g, Toad for Oracle, AIX, SUN Solaris.

Oracle DBA

Confidential

Responsibilities:

• Installing and Configuring Oracle 10g, including service pack deployments
• Automatic Storage Management installation, configuration and management
• Migration of oracle databases.
• Database Administration and Maintenance.
• Implementing disaster recovery plans.
• Working on Stored procedure and Triggers
• Working Imports and Exports utilities.
• Managing Security (Creating users, logins and roles, granting permissions)
• Performance tuning of databases using AWR, ADDM and OEM
• Working on backup & Recovery
• Creating Index & managing other objects of Database.

Environment: Oracle 10g, 11g, Toad for Oracle, AIX, SUN Solaris