SUMMARY

• Highly accomplishment & deeply driven oracle database administrator with a successful 8 years of progressive experience in IT industry, out of which 8 years as Oracle DB Administrator, primarily in Production and Development environment, played different roles like Data Architect, Production/Development and Data Warehouse DBA.
• Experience in Operations, Build, Upgrades, Patches, Performance Tuning, Backup and Recovery, Automatic Space Management, Database Security, Cloning, Migration.
• Oracle implementation, planning, designing, installing and maintaining Database technologies (11g, 10g, 9i, 8i, 7) on multiple nodes in Sun Solaris 5.10, Unix, Linux 2.4.19, Red Hat Linux 2.1 AS, AIX 6.1 and Windows.
• Experience in Installation and administrations of Oracle 10g RAC, 11g RAC.
• Configuring and maintaining physical standby database using Oracle Data Guard to perform quick disaster recovery
• Configured Physical Standby database (Data Guard) using RMAN backup.
• Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).
• Strong Oracle RAC Installation, Configuration and Tuning Skills on Red - Hat Linux and Sun Solaris.
• Strong knowledge and experience of managing Oracle 9i and 10g RAC environments using the OEM Grid Control tools.
• Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN.
• Experienced in Backup and Recovery using RMAN, VERITAS Net Backup.
• Experience in performing Point in time recovery at times of necessity.
• Created Clone databases in Dev and Test environments using RMAN cloning procedure as well as User manual cloning.
• Experience in installations, backups and recovery using shell scripting, RMAN and media managers using Tivoli and Legato
• Worked on Performance optimization of large objects by monitoring redoes generation, increasing log buffer size, blocksize and changing archiving procedures and Query tuning using Statspack, TKprof and OEM.
• Performance Tuning of the database (I/O Tuning, Tuning Contentions) using oracle 11g tools like AWR, ADDM, TKPROF, EXPLAIN PLAN for the Better performance.
• Experience in Migration of Database from 9i to 10g, 10g to 11g.
• Good experience in resolving the issues related to installation, upgrades and patches.
• Experience in Implementing Streams, ODI, Data Pump, Export and Import utilities.
• Expertise in creating and scheduling jobs through OEM.
• Build Grid control for Monitoring 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.
• Expertise in cross platform data migrations using Transportable Table spaces.
• Excellent Troubleshooting skills in OS level and Database level.
• Experienced in using 10g features like Flash-Back Recovery Area (FRA)
• Written KORN shell scripts in UNIX and scheduled the job using CRON and Tivoli scheduling.
• Good experience in SQL, PL/SQL, Perl Scripting, Shell Scripting, Partitioning, Data modeling, OLAP, OLTP, Logical and Physical Database Design, Backup and Recovery procedures.
• Expertise in SQL, PL/SQL, and developing various Data Database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i, Oracle 10g (RAC, Data Guard & Streams), SQL Server 2008.

SOFTWARES, APPLICATIONS& TOOLS: DBCA, DBUA, Netca, Netmgr, Oracle Data Guard, Oracle Golden Gate, OEM (GC),Tivoli, RMAN, ASM, Clusterware, Shareplex, EXADATA, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, MobaXterm, ERwin, Enterprise Architecture (EA), TOAD Data Modeler, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.

WEB TOOLS: HTML, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metalink, MS Visio.

LANGUAGES: SQL, PL/SQL, T-SQL, C, C++, UNIX Shell Scripting, Ksh, bash Scripting, C#, ASP.NET.

OPERATING SYSTEMS: Sun Solaris 5.8, 9, 10, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP.

PROFESSIONAL EXPERIENCE

Confidential, Topeka, Kansas

Sr. Database Administrator

Responsibilities:

• Responsible to provide 24 x 7 database administrative activities over different database servers.
• Converted Single Instance databases to RAC databases.
• Created databases in RAC environment and involved in moving databases from TEST to Production Environment.
• Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment(11GR2).
• Involved in Tuning the RAC interconnect, Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.
• Maintaining ASM in RAC environment.
• Installed DR for databases using Data Guard for Single instance and also in RAC environment.
• Configured Physical Standby for Production databases and converted Physical standby to Snapshot Standby and ACTIVE data-guard.
• Maintained DR server and troubleshooting issues in DATAGUARD environment.
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM).
• Installed 12C GRIDCONTROL and involved in registering of Databases in GRID.
• Installed and Configured Enterprise manager OEM12C and 11g.
• Applied patching on 10g from 10.2.0.1 to 10.2.0.x.
• Involved in Up-gradation of HP- UNIX databases from 10.2.0.x to 11.2.0.x.(11gR2)
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for Migrating Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Export and Import of database objects using EXPDP and IMPDP.
• Cloned schemas, objects and data on new server using Data pump.
• Experience in backups and recovery using RMAN and Scripts.
• Maintained a Catalog server and involved in backup of Catalog database.
• Scheduled Oracle Jobs and Backups using CRONTAB.
• Experience in Online and Offline backups and recovery.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Performed Block Recovery and Data file recovery using RMAN.
• Involved in Database Security and Auditing to protect databases potentially including the data, the database applications or stored functions, the database systems, the database servers and the associated network links against compromises of their confidentiality, integrity and availability.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Performed data refresh at Schema level using EXPDP.
• Daily Health Check Up of the Database and SQL Queries using AWR, ADDM and TKPROF.
• Tuned the performance of the SQL’s using TKPROF and STATSPACK reports.
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Query optimizing using CBO(Cost Based Optimization) and RBO(Rule Based Optimization)
• Performance Tuning for the SQL queries which are Running slow and taking more CPU cost
• Involvement in day to day activities like Space management, rectification of Lock problems, managed quotas, Table partitioning to improve I/O access.
• Alert log Monitoring for critical databases every day in the production environment.

Environment: Oracle 10g/11g, HP-UX 7.x/11.x, RHEL 5.x, ASM, OEM, 12C (Grid Control), RAC 11gR2, RMAN and Data Guard, Explain Plan, SQL Developer, PL/SQL Tuning, Data Pump, Informatica.

Confidential

Sr.Oracle Database Administrator

Responsibilities:

• Manage ASM disk groups via ASMCMD and database control.
• Oracle RAC Planning & Implementation including Servers, Storage, Network and Management tiers.
• Installed, Configured and upgraded oracle server software.
• Designed E-R Diagrams, logical and physical data modelling.
• Worked on Implementation of Oracle10gRAC (Real Application Cluster) on Linux.
• Maintenance and Support for RAC Infrastructure components and Database.
• Configured Physical Standby database (Data Guard) using RMAN backup.
• Used Oracle 10g Grid control for Monitoring and Managing at enterprise level.
• Worked extensively on Performance Tuning using AWR and ADDM Reports.
• Worked on database migration (10g-11g) Database Patching and Cloning.
• Setting up of regular backup (Hot, Cold), recovery and regular testing of recovery in test environment.
• Customization and automation of regular DBA activities and operating system specific tasks using shell script.
• Expertise in Unix Korn Shell scripting, and good knowledge in Perl scripting.
• Worked on setting up Data Guard on RAC in Oracle 11g & Exadata.
• Worked with Oracle Cluster ware software for the node connections.
• Expert in device allocation and de-allocating commands and validation checks.
• A good knowledge of the way Oracle enforces data integrity.
• Experience in Data Conversion using Pl/Sql and XML.
• Transferred data using export/import and data pump utility.
• Worked with more complex database with analyzing, designing, creating and implementing.
• Supported development team by providing SQL statement tuning, optimizing ETL procedures and removing load and query performance bottlenecks by using tools like Explain Plan, SQL trace and TKPROF.
• Worked with data modeling by constructing data decomposition diagrams and creating data flow diagrams.
• Good Knowledge in Transportable table spaces.
• Partitioned very large database tables and indexes and placed them in separate table spaces.
• Working as a member of production DBA team in perfect coordination with Managers and team members.
• Worked as a production DBA in 24 x 7 support environment.

Environment: Linux, Oracle 10.2.0.2/10.2.0.4, Tivoli, GoldenGate, TOAD 9.5/9.6, ERWIN 4.1.4, RMAN, SQL Server 2005, OEM 10g, SQL, Pl/SQL, SQL*Loader, XML.

Confidential, New Hyde Park., NY

Sr. Oracle Database Administrator

Responsibilities:

• Provided database administration and 24*7 support for 1TB production and development Oracle 10g databases.
• Responsible for installation and creation of workstation databases for production development and user acceptance testing.
• Developed scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Implementing, configuring and testing RAC in test environment.
• Upgraded the database from 9.2.0.4 to 10.2.0.3 and applied patches when required.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, Stats pack, Explain plan and SQL*Trace.
• Populated staging tables with data using SQLLDR and PL/SQL.
• Created database objects, users, roles and profiles.
• Performed cloning using RMAN to set up development and test databases.
• Involved in database migration from single instance to RAC using database upgrade assistant and export/import.
• Responsible for configuring and taking level 0 and level1 incremental RMAN backups and resolving issues arising out of those. Performed daily health check of the databases by implementing above backup and recovery procedures.
• Start and stop database instances and listener. Responsible for automation of startup and shutdown on all production and development databases.
• An active member of the backup and recovery team and was responsible for configuration and implementation of backup and recovery using RMAN and Data Guard. Installed and configured Recovery Manager.
• Responsible for monitoring Oracle database activities using Oracle Enterprise Manager. Hence responsible for setup and configuration of OEM.
• Involved in Data refresh from production to test and development.
• Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.
• Resolution of problems and issues coming up in the database according to predefined mutual service statutes.
• Responsible for User Acceptance testing and supporting the end users by resolving problems faced by them.
• Experience in recovering the database in case of failure (Complete/Incomplete recovery)
• Wrote scripts for database maintenance activities such as monitoring the growth rate of tablespaces and extents.
• Responsible for all database activities such as space management, database security management, rollback segments & creation of DB links between two oracle servers.

Environment: Oracle 9i/10g, HP-UX 11, Red Hat Linux 4.x, Toad, Spotlight, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, RAC, RMAN, Data Guard, Import/Export, Forms 4.5/5.0, Reports 2.5/3.0.

Confidential

Jr.Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX/Linux and Windows environments.
• Responsible for administering, supporting production and development of Oracle 9i Databases.
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Responsible for setting and managing user accounts, and granting required privileges to users.
• Configuration of Automatic Storage Management (ASM).
• Loaded data from flat file to Oracle database using SQL*Loader. Created indexes on tables for performance tuning. Performance monitoring, tuning and space management in database with Grid control. Performed Troubleshooting and system maintenance.
• Involved in user creation and user access control. Involved in Schema creation and management. And Developed stored procedures, standalone functions and PL/SQL packages to comply with the requirements.
• In depth knowledge of setting up RMAN backups and maintaining catalog schema. Proficient in creating auxiliary and duplicate database using RMAN.
• Develop, implement and test Backup and recovery strategies for development databases.
• Performed Database Reorganization to remove row migrations and fragmentation using exp/imp utilities.
• Maintained the RMAN repository and customized recovery catalog and also involved in Production Support and Operations teams to resolve production issues in a timely and efficient manner.

Environment: ORACLE 9i, MS-SQL, SQL, PL/SQL, SQL* Loader, RMAN, Toad, Erwin, UNIX AIX 5.1, Windows NT/2000, UNIX Shell Scripting, export/import utilities.

Confidential

Oracle DBA/ Developer

Responsibilities:

• Managed table spaces, data files, redo logs, control files, tables and its segments
• Took the backup of the database as logical backup exp/imp and cold backup
• Implemented database and applications monitoring scripts and applications maintenance scripts.
• Applied patches for bug fixing, upgrading products and Oracle applications and log file checkup for error or success of the patch.
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management, and Security Administration.
• Wrote scripts for informing the DBA’s regarding the status, performance and Space Management of the Database.
• Managed database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Provided technical support and assistance to all database end-users
• Managed and installed application patches working with Functional and Development teams in issues resolution through metalink TARs and internal trouble Tickets.
• Provided Production support (24*7) and troubleshooting user (remedy) tickets in Production, Test and Development instances.

Environment: Oracle 8.0.5/8.1.7, Sun Solaris, Raid 0+1, Windows 2000, SQL, PL/SQL, OEM, TOAD, Replication, K-Shell, Java, EJB, JDBC, Erwin, MS-Visio.