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 OracleASM 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 SKILLS

Relational Databases: Oracle 8i, 9i, 10g, 11g (Oracle 10G & 11G with ASM, RAC, Golden Gate, Data Guard).

High Availability and Tuning/Monitoring: Real Application Cluster (RAC) 10g, 11g Oracle Enterprise Manager (OEM) 9i & 10g,Database Cloning, Standby Databases (Manual, RMAN), RMAN, Statspack Reports

Platforms: Solaris 10 SPARC, AIX, Windows (XP, 2000, 2003,)Linux (Red Hat, Oracle, HP)

Operating Systems: Solaris, Window XP, Red Hat Linux, Window Vista

Tools: /Utilities: OEM, RMAN, SQLPLUS, ISQLPLUS, DB console, Netca, DBCA, DBUA, export/import, Data Pump, SQL*Loader, Crontab, Oracle scheduler, TKPROF, SQL Trace, STATSPACK, OEM, SQL Advisor.

DBA tools: TOAD, SQL-Developer

PROFESSIONAL EXPERIENCE

Confidential, Dubuque, IA

Oracle Database Administrator

Responsibilities:

• Responsible for installation, Creating New databases and configuration of Oracle 9i, 10g, 11g databases.
• 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.
• Involved in Performance tuning of the databases.
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Maintain the Oracle 10g RAC environment and troubleshoot performance problems
• Used RMAN utility for HOT/COLD backups and performed Disaster Recovery.
• Experience in testing of Client/Server & Web-based applications on windows and UNIX platforms.
• 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.
• Updating with latest service packs and applied Quarterly CPU’s (critical patch updates) patches.
• Extensively used SQL queries and UNIX Shell Scripts to test the data integrity.
• Maintained both System level and Object level Roles and Privileges for various users.
• Involved in Space Management by estimating Table sizes and Record sizes.
• Maintain all the documentation include installation and data conversion Procedures documents.
• Solved critical production problems and performed point in time recovery plans.

Environment: Oracle 9i/10g/11i, RAC, RMAN, Sun Solaris, HP UNIX, TOAD and SQL Plus.

Confidential, Lawrenceville,NJ

Oracle DBA

Responsibilities:

• Experience in installation, creating new databases and configuration of Oracle 9i, 10g, and 11i databases.
• Updated and Applied Quarterly CPU’s (critical patch updates) patches and latest service packs to keep the database at current patch level.
• Created Database Objects like Tables, Stored Procedures, Functions, Views, Triggers, and user defined data types.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Migration of databases from Oracle 10g to 11i databases.
• Implemented database standards and naming convention for the database objects.
• Developing SQL scripts for maintaining administration tasks.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Extensively used SQL queries and UNIX Shell Scripts to test the data integrity.
• Involved in developing stored procedures, triggers for the application.
• Estimating of Table sizes and Record sizes. Maintaining proper licenses.
• Solved critical production problems and performed point in time recovery plans.
• 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, Detroit, MI

Oracle DBA Support

Responsibilities:

• 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, Farmington Hills, Michigan

Oracle DBA

Responsibilities:

• 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 Dataguard 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

Responsibilities:

• 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