PROFESSIONAL SUMMARY:

• Over 8 years of experience in information technology which includes Oracle Database Administration, administration of UNIX and windows environments.
• Oracle Database Administration on 24x7 critical production and large databases using Oracle 10g RAC, 11g RAC, 9i, 8i.
• Implementation of High Availability solutions with Oracle 10g RAC, 11g RAC, Standby Database Data Guard for large financial applications.
• Installing and configuring ASM for the RAC storage implementation.
• Installations of Oracle 11g RAC, 10g RAC, 9i, 8i on Sun Solaris/Red Hat Linux, Oracle Enterprise Linux/HP - UX/IBM-AIX/Windows platforms and creating databases.
• Cloning database from production to test and development.
• Creating standby databases for disaster recovery and reporting purpose.
• Experience in Patching the Oracle Software and Databases.
• Upgrade/Migration of databases from Oracle 9i to 10g, 9i, 10g to 11g.
• Experience working with Export/Import, Data pump and Experience with Partitioned Tables.
• Working experience in OLTP and DSS environments.
• Implemented Disaster Recover Site with Data Guard, and maintained Physical and Logical Standby Databases along with Active Data Guard and Oracle Golden Gate.
• Performed Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Used tools like TOAD, DB Console, Confio, and Grid Control to monitor database performance.
• Build and administer SQL Server 2005/2008 standalone and cluster databases.
• Evaluated Oracle features and Oracle related products to leverage existing hardware/software/incenses. Build, configured and managed 9i/10g/11gdatabases.
• Experience with system analysis, design and Data Modeling.
• Experience providing 24X7 on-call support to maintain all Databases up and running in Production environment.
• Performance tuning using STATSPACK, TKPROF, SQL Trace, Explain Plan, AWR, ADDM.
• Replication using Oracle Golden Gate, Oracle Streams.
• Mentors the team on technology concepts and ensures team compliance to best practices for design
• Worked on 12c Grid Control to setup central alerting system for monitor targets to be proactive to ensure high availability while getting the best performance.

TECHNICAL SKILLS:

Operating Systems: RHEL, HPUX, AIX, Sun and Windows

RDBMS: Oracle 12c, 11/10g, 9i, SQL Server

High Availability: RAC, Data Guard, ASM

Languages: SQL, PL/SQL, UNIX Shell scripting, T-SQL

Tools: RMAN, OEM, sqlldr, exp, imp, expdp, impdp, TOAD, dbconsole, asmcmd

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, SQL Advisor, performance analyzer

PROFESSIONAL EXPERIENCE:

Confidential, MI

Oracle Database Administrator

Responsibilities:

• 24x7 Oracle Production Database Administration including Oracle 10g RAC
• Installed, configured and maintained Oracle Databases and Applications.
• Installing and configuring ASM.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Experience using Export/Import and Data pump for migration of databases.
• Working with Oracle 9i and 10g partitioned tables.
• Standby Database (Data Guard) setup and configuration.
• Creating and maintaining Materialized Views for replication.
• Cloning Oracle databases from Production to Development, Test
• Refreshing/cloning databases using RMAN.
• Working alongside programmers and contributing to the development process
• Defining and Setting backup and recovery procedures.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Partitioning large objects to improve the performance and manageability.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK, AWR, ADDM
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Environnent: Oracle 11g RAC/10g RAC/9i/8i, OEM (Grid Control), Oracle Data guard, ASM, RAC, PL/SQL, Unix Shell scripting, RMAN, Data pump, TOAD SQL*Loader, Import Export, AIX, HP-UX and Red Hat.

Confidential, MI

Oracle DBA

Responsibilities:

• Build RAC from scratch including OS and RAID configuration and Worked on VMWare.
• Used RMAN for backup/restores and Cloned databases from RMAN duplicate database.
• Setup and documented Oracle GoldenGate replication on 11g for support team.
• 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.
• 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, Data guard, Physical / Logical Standby environments.
• 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 cron jobs 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.

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

Confidential, MI

Oracle DBA

Responsibilities:

• Worked as Oracle Database Engineer on UNIX and Windows platforms.
• Configured Data Guard to provide high availability by implementing Physical stand by database.
• Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
• Cluster Installation and Configuration, Administering databases in RAC for high availability.
• Installation, Configure, setup of 11g RAC on Linux.
• Add new nodes to RAC 11g Cluster to distribute the load.
• Installed and implemented 10g RAC with 4 nodes with ASM.
• Upgraded Databases from 10g to 11g and applied patches as per requirement.
• Worked extensively on data center migrations on multiple database versions. i.e., 9i, 10g and 11g.
• Responsible for installing and configuring Golden Gate on Oracle Servers.
• Database migration from 9i to 10g to 11g.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• SQL, PL/SQL Tuning and Monitoring.
• Compared and contrasted multiple snapshots using AWR.
• Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
• Responsible for setting up Oracle Golden Gate to help in propagating information between databases.
• Recovered databases and clone applications Using RMAN.
• Responsible for resolving several complex recovery scenarios (including RMAN) with critical production database.
• Extensively used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
• OEM Grid Control installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable table spaces and RMAN.
• Performed Import and Export using Oracle Data pump utilities
• Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Used external tables and SQL*Loader to import data from flat files.
• Monitored database space requirements and adjusted for future needs.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues. Basic OS system administration.
• Strict adherence to policies and procedures - specifically in regard to change management.
• Perform database administration tasks as part of a scheduled change management task.
• Proficient in communicating directly with internal resources on a daily basis,
• Able to work effectively with multiple teams at once.
• Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills and discipline for Change Management practices processes
• Solid discipline in providing end-users timely updates on their problems. Installing server software.

Environment: Oracle 9i/10g/11g databases, 9i/10g/11g (Active) Data Guard, 10g/11g RAC, Data pump, Export/Import, SQL*Loader, Physical Backups, Grid Control

Confidential, MI

Oracle DBA

Responsibilities:

• Pre-Upgrade Planning, study and analysis of Applications and database
• Analysis of requirements upgrades from Oracle 8i to 9i.
• Database sizing, Capacity Planning
• Estimate System/Database performance
• Created/Configured test and development environments using Oracle export/import.
• Database refresh from production to test and development environments
• Implemented Oracle Reporting database using snapshots, materialized views from production environment.
• Install and configure Oracle 9i databases
• Performed various Unix Administration tasks and automated with cron jobs.
• Developed SQL scripts and shell scripts applied various database and Application patches
• Configured and implemented Backup and Recovery using RMAN
• Performed Export/Import of Oracle 8i Database
• Installed and configured Oracle 9i in test environment for Oracle Applications
• Successful installation and configuration of Oracle 9i in test and production environment
• Applied Oracle Database patches
• Database space management and Reorganization
• Reallocation of tablespaces to accommodate growth in data volume
• Assisted development team in Application tuning, query optimization and troubleshooting
• Day to day System Administration tasks on NT
• Automated tasks using Bash shell scripts.
• Database and System monitoring and troubleshooting
• Creation of new Database views and indexes
• Installed databases ranging from version 8 to 10g R2.
• Installing client and upgrading them to satisfy clients need for application.

Environment: Oracle 9i, 10g on Sun Solaris, RHEL, Window, TOAD