SUMMARY

• Certified Oracle Associate with experience (8+ 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.
• Handled High volume production databases around 25 TB size along with Physical standby databases
• Performed Data file recovery from logical and physical block corruptions
• Good understanding and Implementation expertise in RAC, ASM, Data Guard
• Experience with different tools monitoring software and worked on Enterprise ticketing systems 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 EXPLAINS 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.
• Developed UNIX shell scripts and SQL scripts to carry out routine 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, R2/10g/9i/8i

RDBMS: Oracle, Microsoft SQL Server, MySQL, DB2

High Availability: 10G, 11G RAC, DataGuard

Languages: SQL, PL/SQL, SHELL Script, Perl, C

Operating System: AIX, Sun Solaris, Linux (Red Hat and Suse),Windows

Development Tools: Sql developer, Toad, SQL*plus, SQL*Loader

Database Tools: OEM 11g, 10G Grid control, RMAN

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

Web Technologies: Html

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Environment: AIX, Sun Solaris, Windows

RDBMS: Oracle 9i, 10g, 11gR1, 11gRr2, RAC, Data Guard, ASM, Sql Server

Oracle Database Administrator

Responsibilities:

• Involved in 24x7 production support for 180 Oracle databases and 60 Sql Server Database and Applications Administrator
• Created new Cluster environments, ASM and databases as per the requirements.
• Created replication environments as physical standby for the prod databases using High availability feature Data Guard in Max performance mode.
• Worked for various Development environments for data refresh and user creations and the deployment tasks.
• 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
• Involved in database migrations, cloning production system, for testing and development.
• 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 .
• Experience in implementing hot, cold and RMAN scheduled backups and performance tuning of SQL statements.

Confidential, Dallas Texas

Environnent: AIX, Oracle 11g, RAC, Dataguard. ASM.

Oracle Database Administrator

Responsibilities:

• 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.
• Responsible for providing 24x7 support for production Oracle databases
• 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.

Confidential, San Francisco, CA

Environment: UNIX and Oracle

Responsibilities:

• Monitoring jobs, troubleshooting on failure and addressing alerts
• 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.
• Logical backups using IMPORT and EXPORT utilities.
• Resolving user issues on time.

Confidential, Stanchfield, MN

Environment: Oracle 9.2.0.3

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.

Confidential

Environment: Linux and Oracle

Responsibilities:

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