PROFESSIONAL SUMMARY:

• Over 8 Years of experience in wide array of technologies and good consulting experience with variety of clients in Oracle Database Production Administration 9i,10g, 11g which includes designing, installing, planning, configuring, Implementation, and administering Oracle Databases in Unix/Windows environments.
• Experience in Import, Export, migration, and Backup, Database Monitoring Tools and Application Support.
• In-depth understanding of security, backup, and disaster recovery plans, and procedures to ensure database integrity.
• Provided Oracle DBA support, and performance monitoring and Performance tuning.
• Manage databases from planning and testing stages through implementation and support.
• Experience in Oracle Performance Tuning, SQL tuning, and RAC tuning, and monitoring for high availability.
• Expertise in RMAN Backup/Recovery, Replication and Disaster Recovery planning including Cloning strategies.
• Management of Schemas, Objects Partitioning the Tables Indexes.
• Expertise in planning and implementing Database Security by creating Users, Roles and assigning grants to them.
• Managing server and clients, Stored Procedures, Functions and Triggers etc.
• Oracle Data guard for Disaster Recovery implementations.
• Oracle Enterprise Manager OEM 10g Implementation.
• Used SQL queries and UNIX Shell Scripts to test the data integrity.
• Planning, extensive Cloning, Implementation, and upgrading from 9i to 10g databases.
• Experience in UNIX commands and executing them on different LINUX Flavors.
• Troubleshoot various issues during installation and day-to-day activities.
• Successfully installed and configured Oracle ASM on databases. Experience in working with Production and Development Environments and handled the On Call Responsibilities.
• 24 X 7 Production Database on Call Support.
• Ability to excel in a team environment.
• Excellent Written, Verbal, and Communication Skills.
• Excellent presentation, technical-writing team work skills with ability to adapt to the nature of the job.

TECHNICAL SUMMARY

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

• Experience in testing of Client/Server Web-based applications on windows and UNIX platforms.
• Created multiple databases, and performed database cloning between the Production and Development servers.
• Managed Oracle Users, roles, privileges creating profiles for Database objects.
• Having experience in Real Application Cluster RAC .
• Maintained existing User / System Databases.
• Developed triggers, functions, stored procedures, data types etc.
• Expertise in UNIX commands and executing them on different LINUX Flavors.
• Solved database connection issues using Oracle Net Services.
• Experience using TOAD, OEM and configured database connectivity issues using NETCA, and solved listener configuration.
• Extensively used SQL queries and UNIX Shell Scripts to test the data integrity. Extensively used SQL queries and UNIX Shell Scripts to test the data integrity. Managed Oracle Users, roles, privileges creating profiles for Database objects.
• Experience in using Oracle export and import utilities.
• Troubleshoot various issues during installation and day-to-day activities.
• Schema and Security management.
• Set-up technical standards and procedures and ensured their implementation.
• Wrote scripts for automation of routine tasks.

Environment: Oracle 9i, 10g, 11i Sun Solaris, HP UNIX, TOAD, Windows NT/2000/XP etc.

Confidential

Oracle DBA Support

• Created multiple databases for Development and Testing.
• Worked on 9i for data transfer to different databases.
• Installation, configuration and upgrading of Oracle server software and related products, setup and maintain Oracle 9i/10g RAC databases.
• Cloning of Databases, installation, capacity planning, physical and logical database design, upgrade, monitoring database performance.
• Has experience in Migration of databases.
• Troubleshoot connectivity issues and solved listener configuration.
• Managed Oracle Users, roles, privileges creating profiles for Database objects.
• Experience in using Oracle export and import utilities.
• Created multiple databases for Testing, Development and Production.
• Extensive Experience with RMAN Backups. Hot backups, logical Backups with external tape backup system.
• Created and Managed Table spaces and allocated tables to different Table spaces.
• Wrote Scripts for Cold Backups.
• 24x7 on call support.

Environment: Oracle 10g, 8i, 9i, SQL, PL/SQL, Linux, Sun Solaris, TOAD, RMAN

Confidential

Oracle DBA

• Implemented Oracle Database 10g two node Real Application Cluster RAC using Oracle Cluster ware and responsible for high availability and load balancing.
• Installed, configured Oracle 10g databases on Linux and also upgraded oracle databases from 9i to 10g version.
• Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High availability, Data protection and maximum performance by maintaining both physical and logical standby databases.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.
• Extensive use of Oracle Data pump, Exports/Imports utility for moving data among the servers.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Implemented Oracle database backup recovery solutions using RMAN.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Performed automated backups and scheduling using scripting.
• Written Stored Procedure and Triggers for database maintenance and management using PL/SQL, UNIX shell scripts for backups.
• Used oracle configuration assistants like Database Configuration Assistant DBCA for creating databases, Database Upgrade Assistant DBUA for upgrading databases and Network Configuration Assistant NETCA for creating a Listener, TNS names to establish a Client-Server environment.
• Configured and implemented Oracle streams Advanced Replication for high availability.
• Also migrated data from Oracle to SQL server for testing, reporting and analysis requirements.
• Generated Automatic Database Diagnostic Monitor ADDM , Automatic Workload Repository AWR for monitoring database performance.
• Involved in gathering requirements from end users.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs change requests for future reference.

Environment: Oracle 11g/10g/9i, Red Hat Enterprise Linux 4.x,5.x, A.I.X 5.2, HP UX 11i, OEM, Oracle 10g RAC, TOAD, STATSPACK,EXPLAIN PLAN, SQL Server 2005.

Confidential

Jr. Oracle DBA

• Installed and maintained Oracle 9i software on Linux systems.
• Migration of the database from sun Solaris to Linux.
• Monitoring of hot backups, exports on Linux and Windows.
• Performed Refresh of databases on Linux servers
• Create Schema Tables, Indexes, views, sequences, synonyms, roles, and packages , grant roles to users.
• Monitor databases using OEM, re-organization of database tables and indexes.
• Tested and implemented different physical, logical Backups and Recovery methods like point in time recovery, Media recovery, full and partial recovery using export, import.
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Write various SQL and PL/SQL scripts and procedures to support applications.
• Set up and administered table spaces, data files, tables, indexes, views and sequences Configured and managed users, security and Redologs.
• Performed database cloning to create Test and Development environments from Production.
• Implemented Physical Standby database using DataGuard in ORACLE9i/10g.
• Performance tuning for Oracle Day-to-day maintenance and management of the several different databases in development, test, regression and production environments proactively monitoring production environment for any exceptions/ issues.
• Have written shell scripts for automation of various database-monitoring activities.

Environment: Oracle 10g, 8i, 9i, SQL, PL/SQL, Linux, Sun Solaris, TOAD