SUMMARY

• A highly result oriented skilled Oracle DBA with extensive experience in Database Administration on Production databases, good team player, organization with excellent communication skills.
• I have over 8 years of active experience in installation and configuration, system implementation and problem trouble shooting. Experience with Oracle 9i, 10g, 11G Installation, Administration, Data Guard, RMAN, ASM, and RAC Involved in different scenarios of OLTP and data warehouse farms.
• Experience in creating development, test, stage, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts.
• Expertise in installation and configuration of oracle 10g, 11g, 12c on various platforms like Confidential - AIX, SUN SOLARIS, HP-UX, Red Hat Linux and Windows.
• Having a sound knowledge of new features of Oracle 11g R2.
• Experience in implementing DR (Disaster Recovery) & High availability solutions using DataGuard (11g/10g), Standby Database (9i) and oracle 9i, 10g, 11g RAC.
• Proactive monitoring in identifying bottlenecks in the application and database using Statspack, AWR, ADDM and 12c OEM Cloud Control Monitoring.
• Experience in client/server connectivity Query Optimization, Performance Tuning and Database Consistency Checks using DBCC commands.
• Up gradation/Migration of SQL Server 2005, 2008 databases to SQL Server 2008R2
• Hands on Experience on Install, configure Upgrade and setting up of failover clustering's in Microsoft SQL server 2008. Add and remove nodes in existing clusters, uninstall SQL server from existing nodes etc. Maintenance of failover clustering.
• Installation of Standalone and clustered SQL Server Instances
• Setting up and troubleshooting Replication on SQL Servers.
• Working with Infosys Limited as a SQL Server DBA supporting BMW Client.
• Installing SQL Server 2005/2008/2008 R2 / 2012 CUs, configuring SQL Server Database AlwaysON High Availability and Disaster recovery Plan, Troubleshooting, build the servers, decommission.
• Experience in development and design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Informatica Power Center/Data stage.
• Expertise in database backup/recovery strategy (BCV mirroring, RMAN, Export/Import & Datapump), Performance Tuning, Capacity Planning, Standby database (Logical, Physical), Oracle configuration management, database cloning, refresh, and patch management.
• Worked with latest 10g/11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
• Performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Application Tuning and Database/Instance Tuning.
• Experience in performance-tuning services like EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g/11g/12c OEM Grid Monitoring, custom scripts troubleshooting Oracle databases using sqltrace.
• Involved in oracle technical support process through Metalink and other procedures.
• Experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Expertise in basic and advanced replication using Oracle Streams.
• Experience in using OEM, TOAD, Data migrations using export/import, Data pump, RMAN.
• Experience in configuring and troubleshooting shareplex replication.
• Maintaining Database Security using security compliance auditing, capacity planning.
• Experience in using SQL *Loader and External Tables for Export/Import of data.
• Experience in optimization of SQL statements using Techniques like cost based and Role based optimization and accordingly Generated Explain plan.
• Experience in DBA activities like creating of databases, users and table spaces, partitions, Indexes, constraints and permissions.
• Extensive use of TOAD for extracting scripts from the dictionary.
• Strong experience in working with multiple projects in high-pressure environment.
• Quick learner and willing to contribute in a team environment.
• Installation, configuration & administration of Oracle Grid control.
• Worked on the BMC remedy ticketing system.
• Capacity Planning and bench marking the data growth year over year.
• Experience as On-Call 24x7 production DBA support, Application/Development DBA.
• Very familiar in creating TAR/SR with Oracle Support and Metalink to resolve the production database issues.
• Excellent verbal and written communication and presentation skills and Strong interpersonal skills, ability to interact with people at all levels.
• Excellent Communication, Presentation and Analytical skills.

TECHNICAL SKILLS

Operating Systems: RHEL, CentOS, Windows, HPUX, AIX, Solaris

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

Storage: Oracle 10g/11g ASM, Tivoli Storage Manager

Tools: SQL*Plus, PL/SQL, SQL*Loader, Quest - Toad, Oracle Enterprise Manager (OEM), Export/Import, Datapump, RMAN, UNIX Shell Scripts

PROFESSIONAL EXPERIENCE

Confidential, Dubuque, IOWA

Oracle Database Administrator

Responsibilities:

• Managing and creating Oracle database.
• Installed and configured Oracle 12c, 11g, 10g 64 Bit on Linux for Production, Development and Testing.
• Installed, configured and tested oracle 10g and 11g RAC environment and trouble shooting.
• Implemented Migration of Databases from 10g to 11g and applying patches whenever required.
• Implemented Standby Database (Physical/Logical) using Data guard for faster Disaster Recovery and HA.
• Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy-included development of daily, weekly and monthly strategy incorporating incremental backups.
• Monitoring & Managing the Tablespaces and datafiles growth
• Proficient in database design, triggers, snapshot and stored procedures in Oracle 9i,10g and 11G
• Database designing, Database administration.
• Defining backup & recovery plan, Database tuning.
• Refresh and Cloning of Database.
• Experience in Database migration from 9i to 10g,11g on Production/Development databases
• Enabling SSO services, Wallet manager, Oracle text installation
• Expertise on database backup/recovery strategy (RMAN, Export/Import & Datapump) on Production environment.
• Removing table fragmentation.
• Dataguard implementation and maintenance for Disaster Recovery.
• Alert Log Checking (Monitoring) and User trace File and Archive log maintenance.
• Creating users, granting roles, Creating and Maintaining snapshot.
• Database Export and Import Utilities.
• Monitoring locks and various sessions.
• Managing OEM.
• Performing Day-to-Day DBA tasks - performance tuning, database design, system security, database installation configuration, patching, technical database support in 24X7 environment.
• Responsible for quarterly patches, /maintaining/Monitoring/Upgrading the Production/Dev/Test and training databases for products.
• Setup/configured oracle RMAN for database backup and recovery. Application of different recovery procedures for complete and incomplete recoveries depending on the type of failure by using export/import & OS scripts like shell & cron job schedule.
• Installation of oracle database and clients on UNIX and windows (Silent installation, GUI installation.
• Restore and Recover of database from offline, online and RMAN backup.
• Maintaining 1300+ Database instances running on Linux in VERITAS cluster environments.
• Retrieval of backup from TSM (Tivoli Storage Management).
• OEM Monitoring (health, status, alerts, agents etc., Configuration of databases in different groups, Instances, agents, Listener, Setting/Removing Blackout)
• Managing Agent using OEM and manually (upload Matrix, Resynchronization etc.)
• Analyzing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes.
• Back up of Archive Log files and monitoring space in that mount point.
• Responsible for taking full hot/cold and Differential database backup.
• Cloning and Refresh of Database (using backup and duplicate).
• Database health check using Statspack report, Tkprof, AWR
• Managing and Resolving end user request via HPSC ticketing tool

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Involved in 24x7 support for production RAC databases with on-call pager
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Installation of 9i, 10g and 11g clients/databases on Solaris and Linux.
• Complete Build of 2-node 10g RAC Cluster on RHEL 4 from scratch.
• Migrated 10g database to 11g R2.
• Skilled with statspack, AWR, ADDM, SAR to check health of database & hardware.
• Used Performance tuning tools such as tkprof, explain plans, oradebug and trace files to tune SQL Queries.
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Migration of Databases and applying patches whenever required.
• Developed 10 PL/SQL Packages from the scratch for monitoring purpose.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC
• Handled RAC Node hangs and node eviction issues.
• Maintaining schemas and partitioning tables.
• Implemented the Security using Oracle Database Vault
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Index management for better performance, maintenance of Oracle Database
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Configure and manage tablespaces, tables, and users for custom applications.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced with Space Management and Security.
• Experienced with GUI and CLI to manage database farmhouse.
• Experience in client/server connectivity Query Optimization, Performance Tuning and Database Consistency Checks using DBCC commands.
• Up gradation/Migration of SQL Server 2005, 2008 databases to SQL Server 2008R2
• Hands on Experience on Install, configure Upgrade and setting up of failover clustering's in Microsoft SQL server 2008. Add and remove nodes in existing clusters, uninstall SQL server from existing nodes etc. Maintenance of failover clustering.
• Installation of Standalone and clustered SQL Server Instances
• Setting up and troubleshooting Replication on SQL Servers.
• Working with Infosys Limited as a SQL Server DBA supporting BMW Client.
• Installing SQL Server 2005/2008/2008 R2 / 2012 CUs, configuring SQL Server Database AlwaysON High Availability and Disaster recovery Plan, Troubleshooting, build the servers, decommission.
• Rebuilding of Indexes for better performance and maintenance of Oracle Database.

Environment: Confidential AIX, Solaris 9/10 Oracle 10g, 11g and 9i solaris9/10 and TOAD, RMAN, AWR ADDM, data pump, Oracle OEM 10g /11g and putty. Sql Server

Confidential, Grand Rapids, MI

Oracle DBA

Responsibilities:

• Supporting 24*7 Production databases along with development and maintenance databases.
• Proactive monitoring through OEM 10G GRID Control.
• Database refreshes using RMAN backups and hot backups also extensively using RMAN for all types of recovery/backup scenarios.
• RMAN Catalog maintenance, purging sufficiently old backups from TSM Server etc.
• Troubleshooting problems of development and application teams.
• Upgradation of databases from Oracle 8i to 9i, 8i to 10GR2, 9i to 10GR2 etc..
• Day-to-Day Maintenance of multiple 10G RAC environments on ASM
• Applying Patches to RAC/Non-RAC databases.
• Upgradation of RAC databases from 10.2.0.1 to 10.2.0.2 etc
• Space Management in ASM Disk groups Addition of new disks etc
• Configuring TAF
• Work on OEM issues i.e
• OEM Agent Installation on servers
• Configure OEM monitoring for Databases, Manage OMS Processes etc..
• Work on Physical Standby databases in Dataguard environment and perform related activities i.e Perform Role Switchover for maintenance of Primary database etc.
• Created physical standby setups in Dev/Production environments.
• Troubleshooting day-to-day Standby database issues.
• Installation and Creation of new databases in Dev and Production environments.
• Handling Production databases on High Availability Clusters (HACMP) on Confidential -AIX platform.
• Export and import of tables, schemas and Full db as per development/Application team req.
• Configure rman backups for databases and schedule them through Crontab.
• Resolve common database issues like Locking, Free Space, connectivity issues, Applying patches.
• Performance Tuning of problem queries.
• Work on Materialized views and handle related issues.
• Configure Listener and tnsnames configuration and troubleshoot related issues.
• Tracing problem user sessions and analyzing TKPROF reports.

Confidential, Grand Rapids, MI

Oracle DBA

Responsibilities:

• All the daily database administration tasks including backup and recovery thru RMAN, Import/Export, grants and roles etc.
• Monitor production and non-production 40 database thru Grid Control.
• Optimized queries and generated graphical SQL results from Grid Control. Starting and shutting down and configured agents for various different maintenance tasks
• Installing, Monitoring, Upgrading Oracle 9i/8i/8.0
• Database Backup, Database Restore and Database Recovery using various tools.
• Database Reorganizations for better space management.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Refresh schema level and full level production to non-production databases.
• Designed the database schema and create any necessary database objects.
• Perform Backup and Recovery thru RMAN.
• Full fill developers request to refresh schema's on a daily basis.
• Resolved db performance issues.
• Worked as primary on-call DBA.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Used SRVCTL utility for managing multiple instances and nodes.
• Worked with Real Application Cluster (RAC) databases.
• Applied various patches, which includes quarterly critical patch.
• Upgraded oracle clients as per application needs.
• Applied DST patches on multiple platforms.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
• Provided full technical support to various application teams before the databases go to production
• Experience in interaction with the top management and escalations of the complex issues
• Performed entries capacity planning (CAPMAN) required creating and maintaining the Databases.
• Perform Backups and Recovery, maintain 24 hours uptime for the database
• Managed the databases of various sizes ranging from 50GB to 2 TB.