OBJECTIVE:

• To pursue intellectual and challenging career in the field of database administration. To work in an organization where professionalism and enthusiasm is recognized. To work continuously towards increasing my technical skills and professional expertise.

PROFESSIONAL SUMMARY:

• An Oracle Certified Professional 10g,11g &10g RAC Database Administrator with 3 years of IT experience as an Oracle Database Administrator. Currently working with Confidential INDIA PVT LTD for one of the biggest Organization. Worked with the most critical financial databases of the various geographical clients with different Oracle database versions, varied exposure with the different kind of database environment. Gained rich experience working individually and in a team with colleagues from different environments. Learned the urgency and out of the box thinking required for support while working with clients during their production database outages. Expert in handling all kinds of oracle databases issues including core DBA, Corruption, networking and Internal issues.
• Managing Pre - production, Production, Development, Test database having size around 5TB and over 225+ users.
• Creation of database manually & using DBCA.
• Cloning of Database using hot Backup, cold Backup and RMAN
• Managing hot/cold backups (using User Managed & RMAN).
• Oracle Database up gradation to Oracle 9i/10g/11g.
• Resizing and mirroring of Online Redo logs.
• Using Oracle utilities like Export, Import, Data Pump, SQL Loader and TKPROF.
• SQL & PL/SQL.
• Managing of User Privileges, Roles & resources as per application requirements.
• Database Objects Creation like Table, synonyms, Indexes, Materialized View and DB-link.
• Rebuilding of Indexes.
• Materialized view & Database link.
• Use of AWR, ADDM & Statspack.
• Applying Oracle Patches in standalone database, standby database & RAC database.
• Refreshing the Database schema and tables.
• Database level shell Scripting to automate various DBA activities.
• Cross platform database migration.
• Physical Standby Database and DR setup with manual log ship method.
• Implementing Recovery Strategies & recovering the database in case of crash to minimize the down time.

TECHNICAL SKILLS:

RDBMS: Oracle 9i, Oracle10g & 11g, RAC 10g, Data guard.

Operating systems: AIX, Solaris, Windows 2003,2008

Third Party Software: Tivoli Storage Manager

Languages: Knowledge in PL/SQL, C, C++.

Oracle Tools& Utilities: RMAN, ASM, Diagnostics tools (AWR,ADDMSQL-Tuning Advisory) & EXPDP/IMPDP Problem and Change Management & Ticketing Tool: Manage Now, HP Service Center, Assyst

Scheduling Tools: Control-M 6.2 and 6.3: Enterprise Manager and Desktop in windows

Data Backup/Recovery: TSM, HIPO

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Environment: Oracle 8i,9i,10g and 11g, RACon Confidential -AIX, Sun Solaris, RHEL, and all windows environments

Responsibilities:

• Daily and weekly RMAN Backup checkup
• Database monitoring using scripts and using 3rd party tool
• Database Logical backup according to requirement.
• Oracle 9i/10g/11g database software installation
• Database creation
• Database/schema refresh
• Database health checkup using statspack and AWR
• Project deployment in DEV, ST, UAT and production database
• Database cloning using hot backup, cold backup and RMAN
• Database up gradation
• Database patching in single instance and in multiple instance (RAC)
• Physical Stand by and active stand by database monitoring and administration
• Converting Physical database environments to Virtual environments vice versa
• Coordinating with oracle support and with customer direct vendor like server support, backup team etc.
• Handling and resolving, L2 /L3 level incident tickets
• 24/7 on call support.
• Supporting Weekly and monthly deployments in UAT and Live production environment.
• Following ITIL process and tools

Confidential

Responsibilities:

• Installation, configuration and maintenance of Oracle 9i,10g and 11g, databases on AIX &Windows.
• Reorganizing databases to avoid disk rotation for max performance
• Deployed and supported Development, Test and Production Databases. This includes database design Application development support and database production support.
• Planning and Performing Daily, Weekly and monthly Offline and Online Backups to avoid any data loss and maintain database
• Moving data between Database using oracle utilities like Export/Import Sql* Loader
• Experience providing 24X7 on-call support to maintain all Databases up and running in Production environment.
• Experience on Storage tasks, space management including creation and maintenance of Data- files and Tablespaces and other Database Structures like Rollback segments, sort segments, etc.
• Cloning the instances and reconfiguring them according to the environment.
• Performed RMAN Cloning and Hot backup Cloning.
• Experience on Backup tasks - using Hot and cold backup procedures and software specific backups. Oracle backups, generally through Export & Import utilities, (Full, User, Table), recovery manager, Strategies development for the backups.
• Extensive Database Designing - Oracle 10g. Experience. Common tasks include analysis of the particular system, which further included interaction with the end - users and the management to develop requirements and specification for the project.
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Proficient in Storage tasks, Data file management, log management, shrinking of Data files and truncation of logs
• Experience in Index management.
• Excellent backup and recovery skills using RMAN, with experience in troubleshooting
• Well-versed with routine database management tasks including user, space and resource management
• Expert in data analysis, database design, logical and physical modeling of the database
• Monitoring the growth of Tablespaces and taking proper action
• Monitoring and Dropping Database Users, Roles, Privileges and Profiles.
• Patch up-gradation for the Oracle Database Server and Periodically applying cpu patch.
• Db Link
• Troubleshooting the errors and Recovery of the database files and database objects.