PROFESSIONAL SUMMARY

• Around 8 years of IT experience in Oracle Database Administration on various operating systems including UNIX/LINUX, Solaris and Windows environments.
• Expertise in database administration, design, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, troubleshooting.
• Performed Full range Oracle DBA activities like monitoring of mission critical databases, troubleshooting performance issues, Backup and Recovery, Database tuning, Capacity planning, Production support and documentation.
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g, 11g, 12c in UNIX/LINUX and Windows environment.
• Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, Data Pump tools
• Proficient in Oracle High Availability features like RAC 11g, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL - Tuning Advisor, EXPLAIN PLAN, TK PROF, and STATSPACK.
• Oracle RAC Database Administration including Installation, Configuration, Analysis, Design, Backup and Recovery.
• Experienced with tools/utilities: OEM, RMAN, STATSPACK, TOAD, PUTTY, SQL*Loader, Data Pump (expdp/impdp).
• Experience on SQL Server 2008, 2012 installation and configuration. Working on T-SQL, Sql server mirroring, replication, Backup and restore
• Experience in Real Application Clusters (RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management (ASM).
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting issues.
• Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) for database monitoring / performance /diagnostics.
• Proficiency in Disk management and problem resolving techniques with a good understanding of capacity planning and efficient usage of disk space.
• Database performance tuning at system and application levels, for dev. and production databases.
• Experience in developing database scripts for task scheduling, monitoring and maintenance.
• Hands on experience in SQL, PL/SQL Programs, Packages, Stored Procedures, Triggers, Cursors, Dynamic SQL, SQL*Loader, SQL*Plus, Performance tuning and Query Optimization.
• Comfortable with both command-line and GUI interface.
• Domain knowledge such as Manufacturing, Telecommunication and Automobile.
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Creating and reviewing documentation for change management, implementation plan and proof of concept (POC).
• Efficient in communicating and coordinating with other groups during implementation of change.

TECHNICAL SKILLS

RDBMS/ DATABASES: Oracle 12c/11g/10g/9i /8i/7, MS Access, SQL Server 2000/2005

HARDWARE: IBM, SUN, HP, Red Hat Linux and Windows Servers

SOFTWARE: Oracle 12c/11g/10g/9i, Oracle Client, SQL*Plus, OEM, PL/ SQL and TOAD

DBA TOOLS: SQL*Plus, OEM, QUEST TOOLS - TOAD, SQL Tuning ADVISOR

ORACLE TOOLS: SQL, Grid Control, SQL*Loader, Tracing, STATSPACK, Explain Plan, AWR, ADDM, Data Pump, Shell Scripting, ASM, Upgrades, Tuning, Patching, Advance Compression

Web Servers: Apache Tomcat, Web logic

OPERATING SYSTEMS: AIX, Sun Solaris, HP-UX, and Windows

LANGUAGES: SQL, PL/ SQL, Perl/Shell Programming

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Oracle DBA

Responsibilities:

• Oracle Database 11g Real Application Clusters (RAC) Installation and Configuration on Linux Server release 5
• Patching, Upgrading databases and Migration of databases 10g to 11g
• Setup and maintenance of DATA GUARD on 10g and 11g for Disaster Recovery and reporting purpose
• Performed the installation and configuration of both Oracle and SQL Server Databases
• Refreshing Test Databases from Production Databases using EXPDP/IMPDP
• Writing SQL and SHELL scripts for monitoring database.
• Automation of database maintenance using OEM, SHELL scripts. Configure alert, thresholds, matrices and email in OEM
• Installed and implemented 10g RAC with 4 nodes with ASM
• Experience in replication using Golden Gate and Materialized Views
• Replication and Extracting data and applying on production database's using Golden Gate
• Providing connectivity and troubleshooting of connectivity problems.
• Creating users, roles and granting required privileges for the project teams
• Monitoring various database activities like number of users, memory usage, alert log file, trace files.
• Generated AWR/Stats pack report for database performance health checkups.
• Monitored Schema level performance issues and performed the tasks like analyzing tables, rebuilding indexes and gathering Stats on a timely basis
• Monitor and report status of databases (capacity planning, size/limit, performance, etc.)
• Solving space related issues like Table space sizing and fragmentation.
• Moving the database objects from one database to another database by export and import
• Ensure space management on servers and user management at the database level.
• Created tables, Functions, Triggers, procedures and packages for the application as per requirement.
• Created, Upgraded, and Cloned Oracle databases for Development and testing databases.

Environment: Oracle 8i/9i/10g,11g Oracle Enterprise Manager (OEM), RMAN, IBM AIX,HP-UX, RHEL, RAC, Data Guard, Shell Scripting, PL/SQL, SQL*Plus.

Confidential - Saint Louis, MI

Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g and 11g database on SUN SOLARIS.
• Configured Physical Standby for Production databases and converted Physical standby to Snapshot Standby and ACTIVE data-guard.
• Installed, configured and maintained Oracle 2 /3 Node Real Application Cluster.
• Configured disaster recovery databases using Data guard and perform switchover & failover and monitor using Data Guard manager command line.
• Worked on Active data guard and performed Troubleshooting data guard environment.
• Applied patch set and interim patches whenever required to make the database software up to date.
• Exports and imports data, schemas, tablespaces, and databases from development to production and vice versa using Datapump, Export and Import, Sql*loader, MySQL Dump, MySQLAdmin Conducts performance tuning on database and SQL
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities.
• Migrated the Database from Non-ASM to ASM, Configured and Implemented Cold/Hot Backups.
• Implementation and configuration of Oracle GOLDEN GATE.
• Configured Extract and Replicate pumps for Golden gate replication. Troubleshooting issues in GOLDENGATE Environment using LOGDUMP.
• Scheduling the databases backup using Cron tab and VERITAS net backup.
• Extensive experience in RMAN recovery in RAC and stand-alone database.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Monitoring SQL Server 2012 both production and non-production environments.
• Scheduling the backups for the database using Enterprise Manager 12C cloud control.
• Cloned schemas, objects and data between servers using Data pump.
• Configured Oracle Transparent Application Failover (TAF) setting for Production databases.
• Performing backup and recovery operations using RMAN.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Performed Block Recovery and Data file recovery using RMAN.
• Performed database refresh from production to test environment in both RAC and NON RAC environment using RMAN.
• Performed data refresh at Table level, Schema level, and tablespace level using DATAPUMP.
• Performed Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects.

Environment: Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Sun Solaris, ASM, Golden gate, RAC, RMAN, AWR, ADDM, ASH, TTS, Data pumps, Exports/Imports.

Confidential - Buffalo, NY

Oracle DBA

Responsibilities:

• Supported 100+ databases ranging in size between 30Gb to 50Tb.
• Planned and Implemented Disaster Recovery (DR) and High Availability using RAC, and Data Guard.
• Installed and configured RAC (2 node) and Performed up-gradation of grid infrastructure and Oracle databases from 11.2.0.1 to 11.2.0.3.
• Performed health checks in RAC instances using Crsctl and Srvctl utility.
• Performed Database refresh from Production RAC environment to TEST RAC environment.
• Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c.
• Starting and stopping the agents to clear metric alerts and collecting ADDM reports in OEM.
• Creating blackouts and templates in OEM and migrated databases from Non ASM TO ASM.
• Involved in Tuning the RAC interconnect Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.
• Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk online and offline and troubleshooting issues in ASM environment.
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.
• Create thorough documentation of installation procedures and administrative tasks in the clustered environment.
• Generated and automated Statspack/AWR reports from Oracle 11g/10g/9i database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth.
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.
• Used Explain Plan, Oracle hints and creation of new indexes, identifying the join methods (Nested/Hash/Merge join/Sort merge join) between the row sources for tables, to improve the performance of SQL statements.
• Addressed developers/testers requests to clone production databases for the purposes of testing using RMAN.

Environment: Oracle 11gR1, 11gR2,11.2.0.3,12c RHEL 5.8, HP-Unix 7, Solaris 10, OEM, DBUA, RMAN, EMC SAN, Oracle Enterprise Manager Grid Control, RAC, ASM, Data guard, SQL*LOADER, AWR, ADDM, ASH, VPD, Oracle Wallet, Data pumps, Exports/Imports.

Confidential - Irving, TX

Oracle DBA

Responsibilities:

• Supported different Oracle 10g and Oracle 9i Databases of Production, Testing, Staging and Training.
• Database Creation, Parameter Assignment in init file or session level assignment; database startup and shutdown process.
• Database configuration on parameter file and operating system file.
• Database User Creation with limited rights as per specific module under specific client. Creating roles and profiles as per system study and assign to users.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking.
• Configured listener for external procedure calls.
• Database backup & Recovery with RMAN and Export/ Import.
• Upgrade the databases from Oracle 9i to Oracle 10g using DBUA and Manual Upgrade methods.
• Creation of database objects like Tables, Indexes, Views, Users, etc.
• Oracle SQL*LOADER, Oracle Export/Import Tools and utilities.
• Responsible for Data load on different databases using SQL*Loader.
• Provided guidance for developers in writing and tuning PL*SQL stored procedures and SQL queries.
• Developed PL*SQL stored procedures, Indexes, cursors and database triggers to implement business rules.
• Alert monitoring and Ticketing.
• Worked on Data Guard i.e., setting physical standby database and setting the migration from primary to standby databases.
• Managing table spaces, user profiles, indexes, storage parameters.
• Responsible to provide 24 x 7 database administrative activities over different database servers, representing various RDBMS as Oracle 9i.

Environment: Oracle 9i/10g, RMAN, Window NT/2000/2003, Oracle Enterprise Manager, RHEL, RDBMS, SQL, PL/SQL, TOAD7.5, Shell Scripting, HTML, Stored Procedures, Triggers.

Confidential - Wilmington, DE

Oracle DBA

Responsibilities:

• Installation, configuration and upgrading of Oracle databases.
• Tuning the Oracle database memory parameters based on the requirements to use automatic memory management (AMM) and Automatic Shared Memory Management (ASMM)
• Administering and installing oracle ASM instances and creating new disk groups.
• Experience in changing an oracle database character set using CSSCAN tool.
• Refreshing the oracle database using the oracle DATAPUMP utility.
• Cloning the databases using Oracle RMAN and restoring the database to point in time.
• Performance tuning of Oracle, which includes Memory, SQL tuning and implementing the SQL Profiles.
• Design and develop table structures, PL*SQL stored procedures, indexes and database triggers to implement business rules.
• Install and upgrade Oracle software using OFA structures. Applying patches and bug fixes. Appling security baseline to the Oracle file systems and oracle binaries post installations.
• Monitoring and administering oracle databases using oracle 11g OEM.
• Experience working with Oracle Internet Directory (OID) and Oracle Directory Server (ODS)
• Troubleshoot DB issues and provide immediate response for critical Production databases. Experience in raising service request through oracle support for solving critical production issues.
• Used SQL*Loader to populate the data from Flat files to Oracle Database Tables.
• Recover user errors using both Oracle Flashback based recovery and also time based incomplete recovery by applying archived redo logs from backups.
• Co-ordination with System Administrators and Network Administrators to achieve zero down time and better performance of the servers.
• Regular monitoring of database for inactive and hanged sessions, which affect the performance of the database.
• Provided on-call support for Production databases and also resolved the issues working with development team.

Environment: Oracle 11g/10g/9i, RAC, Oracle Fail Safe Manager, Erwin, OEM, Oracle Data guard, Oracle Universal Installer, Oracle Configuration Assistant, BMC patrol, Power Builder, PL/SQL, Unix Shell scripting, RMAN, Quest tools, Rapid SQL, Perl, HP-UX, Linux, Windows 2003, Windows 2008 server