SUMMARY

• Certified Oracle Associate with experience (9+ years) in the software industry as an Oracle DBA carrying out activities on platforms like AIX, Sun Solaris, Linux, Windows NT/XP, and Windows 2008 Server.
• Duties included installation, patching, upgrading, performance tuning, space allocation and maintaining Oracle Server according to Oracle OFA Standards.
• Good hands on experience and working on oracle 10gR1,10gR2,11gR1,11gR2 RAC,ASM and Data Guard.
• Build - Installation, configuration, upgrading and migration across platforms of Oracle (9i, 10g &11gr2 RAC- DATAGUARD).
• Proficient in Database Administration activities such as installing, upgrades, patches, cloning, backup and recovery, performance tuning, script development, and documentation.
• Good hands on experience working on physical standby databases.
• Hands-on experience in planning & designing Oracle Backups and Recovery strategies like RMAN, export/import - logical and physical backup.
• Intensively used latest 11g & 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM), ASH reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control and 11g (11.1.0.1.0 )
• Handled High volume production databases around 25 TB size along with Physical standby databases
• Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, DBV.
• Performed Data file recovery from logical and physical block corruptions
• Good understanding and Implementation expertise in RAC, ASM, Data Guard like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.
• Exp on Cluster management, event management, application management, connection management, storage management, load balancing and availability.
• Extensive experience in DBA activities including schema/user management, space management monitoring on oracle.
• Large high volume site experience with database monitoring and tuning on OLAP 24*7*365 systems.
• Installing, Configuring, Administering, Cloning, Patching, Upgrading and Migrating the Oracle Technologies Database Products on Unix, AIX, Sun Solaris SPARC, Linux, Cent OS and Windows server family.
• Expertise in performance- tuning, SQL tuning services with EXPLAIN PLAN, TKPROF,STATSPACK,SQL,TRACE,AWR,ADDM to collect and maintain performance statistics and improve the database performance.
• Hands on Exp with recovery of datafiles and block corruption problems.
• Developer UNIX Shell scripts and SQL scripts to carry out routing checks on databases. This includes database health check, automate RMAN backups, disk space availability, alert log errors, stats gathering etc
• Experience with Data Guard, creation of physical standby and resolving the physical standby database gap.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN
• Experience in platform migration from Sun Solaris to HP Linux using traditional export/import and datapump utilities
• Supportive Individual capable of Managing incidents, being proactive in terms of preventive maintenance and knowledgeable in terms of risk management.
• Expert in Support and Maintenance, shell scripting, database upgrades and enhancements.
• Expertise knowledge working with srvctl commands.
• Hands on exp on administrating Large sized RAC databases
• Proficiency in Analytical, Presentation, written and oral Communication and Interpersonal skills.

TECHNICAL SKILLS

Database Admin: ORACLE 11gR1, 11gR2,10g/9i

RDBMS: Oracle, Microsoft SQL Server, MySQL, DB2

High Availability: 10G,11G, RAC, Data Guard, ASM

Languages: SQL, PL/SQL, Shell Script, C

Operating System: LINUX (4.x, 5.x, 6.x), Sun Solaris 8/9/10, SuSE Linux Advanced Server, and HP-UX 10/11.x, IBM AIX 5.1, 5.2, 5.3 & Windows Server 2003/2000/NT

Development Tools: SQL Developer, Toad, SQL*plus, SQL* Loader

Database Tools: SQL*PLUS, TOAD, Putty, OEM( 11g & 10g), RMAN, EBU, SQL* LOADER, imp, exp & Data pump (expdp and impdp).

Web Tools: IMPACT, Rational Clearcase, Clear Quest, Remedy

Web Technologies: Html

Ticketing Tools: Remedy, Impact

Tuning Tools: TKPROF,EXPLAINPLAN,STATSPACK,AWR,ADDM, ASH

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Confidential, Dallas, TX

Responsibilities:

• Involved in 24x7 production support for 180 Oracle databases and 60 Sql Server Database and Applications Administrator
• Involved in the project of creating and supporting new DEV, SIT, UAT, BAU, TechTest and Prod /DR Oracle 11.2.0.3 databases
• Created new Cluster environments, ASM and databases as per the requirements.
• Developing, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 10g/11g and 12C databases
• Involved in Implementing Oracle Golden gate between Production databases Active - Active configuration with CDR implementation.
• Migration of around 2000 Schemas across 65 prod databases to New 8 Node 12c PROD RAC database
• Creation of Deployment plans for the Cut overs activities
• Preparing the deployment plans with pre and post installation steps
• Created replication environments as physical standby for the prod databases using High availability feature Data Guard in Max performance mode.
• Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Performed Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments for testing Purpose’s
• Responsible for managing production, development & test databases and applications.
• Extensively worked with export/import and datapump utilizes to migrate data from Sun Solaris to AIX
• 24X7 production support and on call rotation
• Involved in database migrations, cloning production system, for testing and development.
• Plan and acquire the new technologies for and implementation, suitable for the applications in regard to the specific future requirements of the company's business projections and growth
• Extensively worked with indexes and table partitioning.
• Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Implemented custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Experience in implementing hot, cold and RMAN scheduled backups and performance tuning of SQL statements.

Environment: Oracle 10g, 11g, 12C, RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Linux( RHEL 4.x, 5.x 6.x), Sun OS 5.8/5.9/5.10, AIX OS 5.1,5.2,5.3, Toad, Shell Scripting, PL/SQL, SQL*Plus.

Oracle Database Administrator

Confidential, Dallas, Tx

Responsibilities:

• Developing, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 11g/10g databases
• Involved in Implementing Oracle Golden gate between Production databases Active - Active configuration with CDR implementation.
• Migration of around 2000 Schemas across 65 prod databases to New 8 Node PROD RAC database
• Creation of Deployment plans for the Cut overs activities
• Preparing the deployment plans with pre and post installation steps
• Created replication environments as physical standby for the prod databases using High availability feature Data Guard in Max performance mode.
• Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Performed Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments for testing Purpose’s
• Responsible for managing production, development & test databases and applications.
• Extensively worked with export/import and data pump utilizes to migrate data from Sun Solaris to AIX
• 24X7 production support and on call rotation
• Involved in database migrations, cloning production system, for testing and development.
• Plan and acquire the new technologies for and implementation, suitable for the applications in regard to the specific future requirements of the company's business projections and growth
• Extensively worked with indexes and table partitioning.
• Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Implemented custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Experience in implementing hot, cold and RMAN scheduled backups and performance tuning of SQL statements.

Environment: Oracle 11g/10g, RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, AIX OS 5.1,5.2,5.3, Toad, Shell Scripting, PL/SQL, SQL*Plus.

Confidential, Dallas Texas

Responsibilities:

• As a Oracle DBA my role was to support Client's Production and Development databases
• Supporting/monitoring 3-node Production Oracle 11g RAC on Oracle Cluster ware platforms on high availability environment and writing shell scripting for various database maintenance and alerting activities
• Creating RAC databases in various environments when ever required.
• /7 Production support and deployments of new releases.
• Maintained large sized prod and Disaster recovery databases of around 25 TB size
• Creation of New Cluster environments, ASM and Databases
• Maintaining 11Gr1 and 11Gr2 Databases.
• Performed upgrades from 11GR1 to 11GR2
• Created RAC11g standby database on 2 node cluster for large production system as per specification.
• Created new ASM disk groups using RAW disks, LUNS and adding, dropping disk members from ASM.
• Working extensively with Oracle support for Sev 1 issues like Datafile corruption, Block corruption problems in Production environment.
• Installed RAC 11G Staging database Installed and configured EM Central Grid control on 11g to administer and manage large number of databases and enterprise wide targets.
• Plan for backup, recovery, and fault tolerance of database; back up and restore the database
• Control and monitor user access to database; monitor and optimize the performance of database
• Allocate system storage and plan for future storage requirements for the database system
• Provide technical resolution to Oracle database related problems
• Create primary database storage structures and primary objects
• Create and maintain clone/staging database environment as well as hot standby database
• Responsible for installation, account management, backup/recovery of Oracle 11g databases
• Performing Rman Level 0 and leve1 backups daily and weekly.
• Performed automatic monitoring of users, tablespaces, tables, indexes
• Creating Shell scripts to automate database monitoring activities and regular Rman backups.
• Performed logical exports and imports of database, users, and tables as and when required.
• Manage and maintain SMT's Production and Development databases.
• Maintain MNF Tracker which directly goes to the client for verification
• Carry out day to day activities in production includes sanity test, schema management and space management.
• Work with various teams involved in this project as when needed to resolve issues.
• Refreshing Development Databases with production data
• Working as a team member of an integrated group that provides consistent support in a collaborative manner to the client.

Environment: Oracle 11g/10g/9i, RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Linux(RHEL 4.x,5.x),Sun OS 5.9/5.10, AIX OS 5.1,5.2,5.3, Toad, Performance Tuning Shell Scripting, PL/SQL, SQL*Plus.

Oracle Database Administrator

Confidential, San Francisco,CA

Responsibilities:

• Creating New RAC database as per the requirement.
• Space management, Uesr management
• Refreshing data from prod to lower environments for testing
• Creating the new jobs for report generation, Database monitoring and alert mgmt.
• Creating RMAN backup strategies as per the requirements.
• Creating, adding new disk groups and members to ASM for new databases
• Resolving user issues immediately and closing the issues on timely manner
• Monitoring jobs, troubleshooting on failure and addressing alerts
• Performed heavy data loads using SQL *Loader, Export, Import for backing certain tables.
• Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Monitoring table space size, resizing table space, relocating data files for better disk I/O.
• Designed Backup Strategies and Disaster recovery plans depending upon the criticality of the Databases.
• Performed large data loads through SQL*Loader.
• Managing archive logs, DB-links, partitions.
• Involved in database schema creations
• Monitoring the growth of the database to ensure the smooth functionality of daily activities.
• Performing logical and online backups.
• Monitor and resize Oracle database objects (table spaces, tables, and indexes).
• Creating privileges, roles and user profiles. Granting resources to users.
• Importing of schemas and tables.
• Plan and implement appropriate backup and recovery strategies for the database.
• Rebuilding indexes for faster access and to reduce disk I/O.
• Observing Logs generated every day.

Environment: Oracle 9i/10G/11G, MS SQL Server 2000/2005, Oracle Enterprise Manager (OEM), OEM 10g Grid Control, RMAN, RAC, ASM, DBArtisan, DataGuard, AIX OS 5.1,5.2,5.3,Linux( RHEL 4.x, 5.x),Sun OS 5.8/5.9/5.10, Toad, Shell Scripting, PL/SQL, SQL*Plus.

Oracle Database Administrator

Confidential, Stanchfield, MD

Responsibilities:

• Checking health systems of Oracle Database
• Involved in Oracle database logical and physical Backups
• Ensure the completion of all daily backups.
• Monitoring database growth and space management.
• Checking the alert logs regularly
• Configuring the database to archive mode
• Maintaining database security by creating users and profiles
• Resolving user process error
• Monitoring Database Performance by Dynamic Performance views.

Environment: Oracle 10g/9i, Toad, Oracle Enterprise Manager (OEM), RMAN, RAC, Data Suse Linux Advanced Server and AIX 5.1/5.2/5.3, TOAD, Performance Tuning, Shell Scripting, PL/SQL, SQL*Plus

Oracle Database Administrator

Confidential

Responsibilities:

• Creation of New databases as per the requirements for UAT, DEV and Test.
• Resolving connectivity issues with the database from clients
• Creating oracle clients on application end
• Creating new scripts to automate the monitoring jobs for faster response.
• Scheudling the backups and jobs to maintain the better performance of DB
• Performing exports and imports based on the application user requests
• Application trouble shooting with respect to Database issues.
• Backing up databases.
• Providing security privileges to developers.
• Managing Users and Giving appropriate permission’s.
• Managing Default Temporary Table space
• Creating and Managing Table space with Multiple Block Sizes.
• Involved in database schema creations and writing queries.

Environment: Linux, Windows and Oracle 9i, 10G.