SUMMARY

• Overall 5 plus years of experience as Oracle DBA on 8i, 9i, 10g, 11gR2 database servers with RAC, ASM, Data Guard, Grid Control, and GoldenGate
• Oracle Backup and Recovery (Cold backup / Hot backup / RMAN backup).
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import).
• Maintain Oracle fail over databases (Physical and Logical standby databases - Data Guard)
• Oracle Tuning Pack. Oracle RAC Good knowledge of Flashback technology in Oracle 10g, and 11g.
• Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.
• Experience monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.
• Automated Storage Management (ASM) for 10/11g R2 databases.
• Experienced in applying CPU / PSU and one off patches.
• Comfortable with both command-line and GUI interface.
• Installation, up gradation, configuration, administration and maintenance of very large Oracle databases on most flavors of UNIX namely Sun Solaris, AIX, HP-UX, Linux and also on Windows.
• 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.
• Migrate and upgrade and maintained Oracle databases (11g, 10g R2)
• Worked on 12c Grid 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.
• Experience in Application tuning using session trace file and TKPROF utility.
• 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
• Timely monitoring of key tables to collect statistics on row-chaining/migration and implement methods to avoid redundancy thus eliminating performance bottle-necks.
• Coordinate work with onsite and offsite teams.
• Worked on Data Migration project.
• Very familiar with Materialize Views.
• Familiar with SQL Server 2005 and 2008 RDBMS.

PROFESSIONAL EXPERIENCE

Confidential | Bay City, MI

Oracle/Microsoft SQL server DBA

Responsibilities:

• Supported the environment as the primary on call person.
• Supported more than 120 servers including Linux and Windows.
• Supported ORACLE 9i, 10g, 11g and 12c databases.
• Supported SQL server databases with 2008 and 2005 platform.
• Involved in maintaining over 10 SAP systems.
• Monitored Backups and handled failures with corrections.
• Supported Solaris backups on BMC backtrack tool.
• Monitored ASM disk storage and worked with Server ADMIN.
• Monitored space alerts related to data files and tablespaces.
• Used to monitor and maintain RAC 11g environment.
• Worked regularly on OEM monitoring several daily job activities.
• Worked on performance issues related to database performance.
• Worked on query tuning for better and more efficient results.
• Supported queries with indexing for better query performance.
• Maintained database memory by working with application and Unix admins to regularly clean up unused data from the system.
• Created and maintain users, roles and privileges regularly.
• Scheduled meetings with 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.
• Database refreshes using export /import and data pump. Used RDA, ADDM and AWR reports to monitor the database performance.
• Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers. Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.

Environment: Oracle 10.2.0.4/11.2.0.3/11.2.02/11.2.0.4 , LINUX, UNIX, Solaris 10, Oracle Enterprise Manager Grid Control, RDBMS, SQLPLUS, PL/SQL, Shell Scripting, Stored Procedures, ASM, RMAN, RAC, Data Guard. Microsoft SQL server 2005/2008 R2.

Oracle DBA

Responsibilities:

• As an operational DBA, supported the database requirements of several applications with ensuring databases are up all the time and recoverable at point of failure.
• Installed, configured and maintained Oracle 11gR2 on UNIX, SOLARIS and LINUX.
• Upgraded databases from 11.2.0.2 to 11.2.0.4.
• Implemented backup continuity plans (BCP) using Data Guard.
• Installed, configured and maintained 12c agents.
• Prepared documentations for the Service Level Agreements (SLAs), Run Books for each database.
• Worked on rotation of production on call support, responding and resolving issues in timely manner.
• Worked on troubleshooting the on-call issues such as Space, Job Failures, login locked out, blocking and slow running queries.
• Applied Critical Patchset Updates (CPU) like July PSU & DNFS patches to the Oracle homes which are recommended by Oracle to fix minor bugs.
• Configured Physical standby database for the production environment using Oracle Dataguard using ASM storage.
• Managed and Coordinated offshore team.
• Involved in the manual switchover testing of the physical standby once in a quarter to test the application functionality on standby data centre.
• Performed Data guard testing by opening the standby in RW mode and switching back once the testing is completed.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Upgrading the Oracle 10g to the latest Release 2 and applied patches as required.
• Responsible for setup and implementation of 2 Node RAC on IBM-AIX in 10g and 11g R2 using Veritas Cluster Server.
• Used to Perform Cold/Hot Backups.
• Also performed database cloning using RMAN.
• Upgrading the Oracle 10g to the latest Release 2 and applied patches as required.
• Daily Health Check Up of the Database using AWR, ADDM.
• Configured Flash Recovery Area in Dev databases.
• Replication of tables to cross platform and Creating Materialized Views.
• Database backup & Recovery with export and import for non archive and archive database with RMAN commands.
• Used to Perform manual Backups using EXPDP and IMPDP
• Also performed database cloning using RMAN.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD from Quest software (DB Tuning).

Environment: Oracle 10.2.0.4/11.2.0.3/11.2.02/11.2.0.4 , LINUX, UNIX, IBM-AIX, Solaris 10, Oracle Enterprise Manager Grid Control, RDBMS, SQLPLUS, PL/SQL, Shell Scripting, Stored Procedures, ASM, RMAN, RAC, Data Guard.

Confidential | Chicago, IL

Oracle DBA

Responsibilities:

• Supported more than 30 databases including development/production sizes up to 2 TB for 24/7.
• Designed, Installed and configured the Oracle server software and related products. Upgraded databases from 9.2.0.6 to 10.2.0.1 to 10.2.0.3 to 11.2.0.0
• Completely built RAC from scratch including OS and RAID configuration.
• Scheduled meetings with 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.
• Setup and documented Oracle GoldenGate replication on 11g for support team.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Ensure databases adhere to corporate standards and policies. Worked with 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 the development team and handling release schedules.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.
• Used power designer, E/R Studio for data modeling and to estimate the database size, database design reviews.
• Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers. Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.
• Implemented SQL outline to get the better execution plan for the offending queries. Setting up analyzing scripts and coordinated with 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 with 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 the maintenance of the Oracle 9i/10g database for the Production as well as the development environments.
• Actively involved in designing/Testing of Disaster Crash recovery.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g.
• Performance Monitoring and Tuning of Oracle Application Servers using Statspack, TKPROF, and OEM for tuning on 9i and on 10g using SQL access manager, SQL tuning manager.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Created and maintain users, roles and privileges.
• Involved in discussions with the management regarding the 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 the 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 the 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 Oracle 10g AWR & 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, GoldenGate, OEM, SQL Developer