SUMMARY

• Total of 8 plus years in Oracle Database Administration.
• Worked on 9i, 10g, 11gR2 Oracle and SQL Server 2005/2008 on SQL Server RDBMS.
• Proficient in Oracle Backup and Recovery using RMAN and user managed backups.
• Proficient in ASM creation, administration and management.
• Proficient in data refreshes and data movement wif export/import and Data pump
• Build, administered and managed Data Guard.
• Build RAC from scratch.
• Proficient in Flashback Recovery and other restore/recovery techniques.
• Experience monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.
• Worked on Grid control for monitoring
• Comfortable wif both command - line and GUI interface.
• Install and managed databases on Windows.
• Very proficient on Linux, AIX, HPUX and Solaris.
• Poses strong administrative skills in RHEL.
• Managed different sizes of database ranging from 100GB to 2.5TB.
• Experience in on-call support and 24x7 DBA for production environment.
• Extensive experience on providing solutions to developer/user requests.
• Extensive experience in resolving issues and bugs related to databases.
• Proficient in performance and maintaining large volume of data.
• Worked on migration project.
• Worked on Upgrade projects to upgrade from 9i to 10g to 11g R2.
• Worked on 12c Cloud control.
• Excellent command in creating Backups & Recovery procedures and Implementing BACKUP and RECOVERY strategies for hot and cold Backups.
• Hands on experience of database Backup and Recovery using RMAN.
• Strong experience in OEM (Oracle Enterprise Manager), Oracle Data Guard, SQL* Net, SQL Loader and SQL*PLUS, STATSPACK, Explain Plan and TOAD.
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Worked wif oracle while troubleshooting RDBMS/patching issues.
• Hardworking, result oriented good interpersonal and communication skills.
• Extensive experience in supporting multiple production databases running 24 x 7 mission-critical / OLTP applications demanding high availability and increased performance
• Created and managed remote server for Materialize Views
• Team Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists
• Performed analysis of RDBMS performance using ASH, AWR, ADDM, SQL tracing, tkprof, statspack etc.
• Worked wif different onsite and offshore teams.

TECHNICAL SKILLS

Operating Systems: RHEL, Windows, AIX, CentOS, HP-UX, AIX

RDBMS: Oracle 9i, 10g, 11g R1/R2

High Availability: RAC, HAS, ASM, Data Guard

Languages: SQL, Shell scripting, T-SQL

Tools: RMAN, OEM, SQL*Loader, exp, imp, expdp, impdp, ERWIN, TOAD, etc

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM

Database Modeling: TOAD

PROFESSIONAL EXPERIENCE

Confidential, IA

Oracle DBA

Responsibilities:

• Supported different clients wif multi-terabyte databases.
• Installed Standalone and RAC Database Servers
• Completely build RAC from scratch including OS and RAID configuration.
• Scheduled meetings wif application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Build Data Guard
• Worked and resolved Gaps.
• Setup and documented Oracle GlodenGate uni-directional replication
• Applied CPU/PSU patches.
• Worked on Migration project where a data center is moved.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to TEMPeffectively administer teh database environments.
• Ensure databases adhere to corporate standards and policies.
• Worked wif application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to teh development team and handling release schedules.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring teh scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor teh database performance.
• Used power designer, E/R Studio for data modeling and to estimate teh database size, database design reviews.
• Implemented SQL outline to get teh better execution plan for teh offending queries. Setting up analyzing scripts and coordinated wif development team to gather table statistics.
• Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Diagnosed Oracle bugs and coordinating wif Oracle support through metalink to resolve them in timely manner.
• Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Primary DBA for 1GB - 2.5TB database for 24/7 support.
• Upgrade Data warehouse Database from 8K block size to 32K block size to optimize performance.
• Worked on OLTP and Data warehouse farms.
• Refreshed multiple databases for Development and Testing upon short request.
• Served as part of a 7 member DBA team which was involved in teh maintenance of teh Oracle 9i/10g database for teh Production as well as teh development environments.
• Actively involved in designing/Testing of Disaster Crash recovery.
• Performed database cloning/exp/imp to setup identical databases in teh production and development environments.
• Created and maintain users, roles and privileges.
• Involved in discussions wif teh management regarding teh advantages/disadvantages and upgrade plans.
• Perform Backup and Recovery thru RMAN.
• Strong exposure in Installing / configuring / maintaining RAC, Dataguard, Physical / Logical Standby environments.
• Applied Quarterly CPU (CRITICAL PATCH UPDATES) on teh entire database farm.
• Performed Export/Import through Data Pump.
• Build Grid control for Monitoring 40+ database.
• Provided technical troubleshooting and give consultation to development teams.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Implemented basic replication through Materialized Views.
• Involved in monitoring teh lock processes, releasing locks in case of resource blockage and gathering statistics.
• Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.
• Used & ADDM to monitor database activities and performance tuning.
• Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
• Installed, migrated, configured and tested Oracle 11g databases in various environments.
• Extremely dedicated, self - motivated, Pro-Active and willing to assume responsibility.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 8i,9i, 10g, 11g; RHEL, AIX, Windows NT/2000, HP UX,TOAD, Grid Control, GlodenGate, OEM, SQL Developer

Confidential, CA

Oracle DBA

Responsibilities:

• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Configure ASM for Oracle 10G R1 installation wif RAW devices which include clustered file system for RAC.
• Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for teh Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Data modeling / Logical database design and implementation (including index design)
• Migration of system and applications from Oracle 9i to 10g, 10g to 11g using Database
• Configuring and using teh Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Create multiple 11g databases on RHEL5 in development.
• Schedule backup in 11g using db console.
• Improving teh performance of teh database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Constant monitoring of database space and space management
• Setting up Oracle Standby Data Guard.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Responsible to improve teh performance by Using teh Hints, Indexes, Explain Plan
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
• Devised an efficient backup and recovery strategy and implemented it in line wif Business requirements (SQL Backtrack and RMAN)
• Automating teh backup processes using shell scripts. Performing recovery in cases of system crashes.
• Worked wif RAC implementation team. Added nodes.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, 10g, 9iAS; Sun Solaris Unix, Linux Windows XP, Oracle Forms 10g, Oracle Streams Oracle Reports 10g, Oracle Developer

Confidential, IL

Jr. Oracle DBA

Responsibilities:

• Installed Oracle and SQL server Databases as per teh standards.
• Applied patches.
• Worked on TNS names
• Helped other DB users installing clients and updating drivers.
• Worked as Level-1 DBA then promoted to Level-2 DBA
• Worked wif oracle on troubleshooting networking issues.
• Worked wif oracle on new releases and bug fixes.
• Coordinated instance shutdown/startup using srvctl utility during maintenance times.
• Worked on VMWare
• Mostly handled deployments in development environments.
• Applied on-off and CPU patches.
• Worked on tablespace management.
• Written shell scripts to regular purge of log and trace files.
• Heavy usage of sharepoint to document procedures and make standards.