Professional Summary

• Oracle Certified Expert and an accomplished IT professional with a strong portfolio of Oracle DB infrastructure management and over 12 years of experience in Oracle Database Engineering and Administration. Have strong skills and experience in all the aspects of Oracle DBA 11g, 10g and 9i including advance topics such as Oracle ASM, Oracle RAC, Oracle Partitioning, Oracle Data guard. Also very strong in SQL and PL/SQL programming along with good Linux / Unix Shell Scripting skills.
• KEY STRENGTHS:
• 24 7 Oracle DBA support and maintenance including advance configurations such as Oracle ASM, Oracle RAC, Oracle Streams, Dataguard etc.
• Very good experience in Oracle Database Backup Recovery methods including both Oracle RMAN as well as User-Managed methods cold backup and hot backup .
• Strong in performing Oracle database upgrades and recently performed a successful upgrade from Oracle 10g to Oracle 11g.
• Setup and Configuration of Oracle Automatic Storage Management ASM 11g starting from disk provisioning and partitioning on Linux and creating/managing ASM disk groups.
• Can be quite handy in SQL query writing and PLSQL development.
• Expert in installation and setup of Oracle RAC Grid Infrastructure. Implemented 2 Node RACs, 3 Node RACs and 4 Node RACs.
• Expert in setting up and maintaining the connectivity between Oracle and Heterogeneous databases MySQL, Microsoft SQL server, IBM DB2 .
• Expert in Oracle database upgrades and Patching.
• Expert in designing and implementation of partitioning schemes Range, List, Hash, and Composite for the database objects Tables and Indexes .
• Strong in Oracle RAC database maintenance and support activities including RAC database backup and recovery, administration and RAC to non-RAC database cloning.
• Ability to work and resolve database performance issues including both macro level performance issues such and micro level performance issues by working with application development teams and database developers.
• Good experience using Oracle tracing methods including SQL Trace with TKPROF analysis, Database wide event tracing for troubleshooting purposes.
• Strong in logical database backup and restore methods by using Oracle Data Pump Export exude , Data Pump Import impdp and SQL Loader.
• Gained expertise in pre-requisite verification, installation and configuration of Oracle RDBMS 11g, 10g, 9i in Linux platform.
• Very strong in Linux shell scripting and have written scripts for database monitoring activities such as alert log verification, daily table space free space monitoring and also for automating database backups using RMAN tool.
• Good experience in analyzing Oracle AWR Automatic Workload Repository reports for performance bottlenecks and for top resource consuming SQL queries. Additionally, I have implemented best practices for SQL and PGA sizing and involved in documentation of known database problems as they arise.
• Deploying Oracle Enterprise Manager Grid Control OEM with standard management, diagnostic, tuning, and change management packs to perform various administrative tasks.
• Performed Daily Monitoring of Oracle instances using Oracle Enterprise Manager, TOAD, monitor users, tablespaces, memory structures, rollback segments, logs, and alerts.
• Involved in on call Production support 24x7 rotation in Oracle DBA teams.
• Conceptually having Knowledge on Golden Gate.
• Conceptually having knowledge on Exadata
• Technical Proficiency

WORK EXPERIENCE

Confidential

Senior Oracle Database Administrator

The project is mainly based on state's automatized financial revenue generation system. It contains the different type of TAX collection system for Department employee and TAX payers throughout the state. Which involves DW solution for the Department to decide the business need. The automation system helps to track the loop holes and maintains citizen data for different business purposes which must be available 24 7 and able to handle the high concurrency of total portal users.

Responsibilities:

• Installed and Configured 11gR2 databases on Linux and also Upgraded Oracle databases from 10g to 11g on various platforms like HP UNIX 11.31, Aix 6.1.
• Implemented Maximum Availability Architecture MAA by setting up RAC standby data guard for RAC primary database.
• Maintenance of around 20 databases combined on all the production, development and testing environments with sizes up to 2.5TB.
• Managed multiple databases on both RAC and Standalone Database on Linux and AIX.
• Provided 24/7 on-call support for Oracle production/development databases to ensure maximum availability.
• Implemented Oracle Database 11g R2 Real Application Cluster RAC and responsible for high availability and load balancing.
• Upgraded and migrated the database to different version depending on Business requirements. For Example 10g R2 to 11gR1, 11gR2 to 10gR1 on different OS .
• Organizing Oracle Database operations, installation, creation, configuration, laying out database tables and database schema design, startup and shutdown of Databases.
• Cloned several production instances to Non-prod using RMAN and Datapump utilities.
• Implemented and configured many physical Standby Databases using Data Guard.
• Monitoring Day-Day Backups, Log's recovering them as per the requirement. Utilized LOG MINER Technology applied Application Database Transactions on other Databases.
• Proactive monitoring of databases for performance bottle necks and tuning accordingly using AWR, ADDM, Tkprof reports etc.
• Interacting with Functional Consultants to tune the SQL queries in Custom Applications to improve the performance.
• Carrying out EXPORT and IMPORT operations on Oracle Database, and monitoring the performance of the database using of OEM Oracle Enterprise Manager .
• Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and to work proactively on alerts.
• Installed and supported Automatic Storage Management ASM for stand-alone and RAC databases and performed migration of databases from cooked file systems to ASM.
• Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems monitored database usage, and reported on database performance and system availability.
• Providing Support through DR Demand Request and CR Change Request for Developer PPM request
• Worked along with application team to configure and install BI tools for a reporting project.
• Worked on designing and implementing backup and recovery strategies for many production databases using RMAN incremental backup methods.
• Performed RMAN backup and also developed backup strategies using incremental and cumulative backup methods.
• Used TOAD and OEM grid control to Optimize and test SQLs, PL-SQL statements developed by the Development Team.
• Implemented Change Control process for the Production Databases as and when required.
• Excellent experience in creating Service requests with oracle support to resolve critical issues and implemented various security patches and quarterly PSU's.
• Helped estimating SGA, PGA, REDO sizes and implemented the same.
• Proactivity deployed script which lists reporting SQLS running over 30 minutes and shoots an email to Support team at time when needed.
• Installed OSWATCHER.
• Involved in a discussion of Exadata implementation and strategy.
• Installation and configuration of Oracle Application Server.
• Performed Single node complete fail recovery in RAC with no downtime.

Environment: Oracle 11g, RAC 11g, HP UNIX, IBM-AIX, OEM, Grid Control, RMAN, ASM, CRS, Export/Import, SQL, PL/SQL, TOAD, AWR, ASH, ADDM

Confidential

Senior Oracle Database Administrator

The project is for the computerized system for Top 10 Gems manufacturing company located in different countries and geographical locations with 24 7 working requirement.

Responsibilities:

• Installed and configured 4 Node RAC on HP UNIX with ASM disk group suggested with HP team to gain maximum performance and Oracle Application servers.
• Administration and monitoring of Oracle Real Application Cluster with ASM disks.
• Performed disks add, disks drop and disk rebalancing as per required in ASM.
• Proactively managed the databases set up alarms for managing any exceptions in day to day management of the databases pre-empted and prevented issues disasters from happening.
• Implement plan to apply quarterly Oracle critical software patches.
• Backup strategy planning, Recovery as and when required.
• Solution for the production issues related to infrastructure setup.
• Monitoring and health checking for the production environment.
• Up gradation of the Production and test database version by installing the latest patch set.
• Monitor data growth and re-organize the table structures in separate tablespaces and developed appropriate support structure indexes, partitions
• Consultancy in the areas database management, performance tuning, storage designing.
• Performance tuning by giving valuable suggestions related to configuration, network, storage, Sql tuning according to SLAs.
• Design architecture for the database for new module in existing database or for new schema generation.
• Disaster Recovery with RMAN critical recovery as well as OS tools like NET VERITAS backup or HP data guard.
• Production Application server issue handling at performance level.
• Finding out the resolution with critical errors by investigating trace files and providing cost effective solution to client.
• Managing and handling team for the Performance management for DATABASE.
• Space management and support for 24 7.
• Involved in Report related module and implemented with Replication method in MIS reports.
• Managing Database Structure, Storage Allocation, Table / Index segments, Constraints, Database Access, Roles and Privileges.
• Performed cloning using RMAN to set up development and test databases from Production database and Automated the nightly RMAN backups for the Production and some development Databases in Crontab.
• Implemented the resizing the online redo logs in production and in standby database.
• Worked and suggested different stats gather strategies
• Planned, scheduled logical backup using data pump or export/import.
• created reboot/maintenance calendar and published
• Created, published and implemented quarterly capacity plan
• Created and maintained EXCEL based tool with macros to collect basic necessary information from oracle database and ease as one click for end user.
• Planned and coordinated multiple production environment downtimes including Database, Application servers
• Helped resolving problem of server maintenance, load balancer, networking in different locations
• Resolved numerous performance issues like top wait events, sub-optimal execution plans, outdated statistics, data fragmentation, latch contention, CPU constraints, physical logical I/O, disk usage, query optimization, hard/soft parsing by application tuning, disk I/O and memory tuning.
• Greatly helped reducing run time for problematic Sqls by using AWR, TOAD, OEM, Explain plan, also suggested guidelines for creating AD-HOC reports.
• Diagnosed Oracle bugs and coordinated with oracle support to resolve them in timely manner and applied patch sets to make application environment up-to-date.
• Suggested for upgrading to 11.2.0.3 and took follow ups and implemented the same
• Performed RCA and also raised SR severe 1 whenever necessary and took follow ups.
• Performed User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database
• Performed database block recovery successfully with RMAN

Environment: Oracle 11g, RAC 11g, RHEL,HP-Unix, OEM, Grid Control, RMAN, ASM, CRS, Export/Import, SQL, PL/SQL, TOAD, AWR, ASH, ADDM

Confidential

Database Administrator

Project is for providing solutions for Telecom and Data billing for most well-known organizations like BSNL, Veraz IM2, Augere and Vodafone.

Responsibilities:

• Involved in Installation and configuration of Oracle RAC 10g.
• Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Performance monitoring and issue handling for the production support in RAC environment.
• Wrote Stored Procedures and Triggers for database maintenance and management using PL/SQL.
• Involve in disaster recovery planning detailed out the processes and procedures of implementing disaster recovery implemented database backups and disaster recovery strategies using RMAN.
• Ensured DR servers are in Sync with production environment.
• Managed multiple databases on both RAC and standalone database on Linux
• Managed and updated several automated UNIX scripts used for the migration project to expedite the migration process with minimal manual intervention.
• Resolved numerous performance issues like top wait events, sub-optimal execution plans, outdated statistics, data fragmentation, latch contention, CPU constraints, physical logical I/O, disk usage, query optimization, 0ard/soft parsing by application tuning, disk I/O and memory tuning.
• Planned and scheduled physical hot/cold backups, logical import/ export, data pump backups, and incremental backups using RMAN on daily, weekly and monthly basis.
• Performed troubleshooting duties on Oracle production databases and determined RCA Root Cause Analysis and resolved known issues
• Handled performance tuning and application monitoring with Quest TOAD, Oracle enterprise manager, AWR and Explain plan and greatly reduced execution times of several problematic queries. Applied quarterly CPU and PSU patches to mission critical databases
• Diagnosed Oracle bugs and coordinated with oracle support to resolve them in timely manner and applied patch sets to make application environment up-to-date.
• Developed fully optimized SQL and PL/SQL scripts that successfully assisted with timely offloading of reporting data and analytical data

Environment: Linux, HP UNIX, Windows XP, 10g, 11gr1, DB console, Grid control, Data guard.

Confidential

DBA

Responsibilities:

• Managing Installations for Oracle Database software Release 9.2.0, 10.2.0 in Linux Windows Platform.
• Creation of Physical and logical standby database.
• Report generation as of requirement of clients. Good knowledge of PL/SQL
• Database cleansing project with data massaging applied as per requirement
• Maintains of DR setup. Query Performance Tuning.
• Configuration of RMAN and disaster recovery.
• Creating reports using test director report tool using sql server and oracle as database.
• Generate SR in oracle metalink and get resolution for the process.
• Installed Oracle 10G on Linux platform using ASM for a storage manager.
• Migration of existing database to CRESTEL database application.
• Leading migration module for TVARIT system migration to CRESTEL
• Replication through Materialized view for the data distribution.
• Performed Installation, Configuration, Designing, troubleshooting, performance
• Tuning and production Support of Oracle 10g databases on LINUX and AIX.
• Involved in performing migration from Oracle 9i to 10.2.0.4 database.
• Keeping the databases up to date with respect to Latest PSU's and very comfortable in applying patches.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Statspack, Explain Plans and monitor the database performance on daily basis.
• Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog.
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups with Export /Import , Database backup Hot cold .
• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery complete Incomplete .
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Involved performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion and Implemented 10g on a test basis.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade and 24x7 production support.
• Monitored and troubleshooting database issues with OEM control.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage and created database triggers using PL/SQL.
• Used shell scripts for monitoring jobs, for startup and shutdown, health check of databases, analyzing stats at different levels, rebuilding indexes and for purging as well.
• Additionally part of rotation on call DBA to support Production databases 24X7.

Environment: Linux, Windows, 10g, 9i, DB console, Enterprise manager, Load Testing, SQL server 2005

Confidential

Jr. Database Administrator

Responsibilities:

• Experience in Installation.
• Monitoring alert logs, trace files, disk space, etc. periodically through scripts and automating reports through mails.
• Managing table space by resizing or adding data files.
• Rebuilding the indexes when necessary. Creating of user, roles and profiles.
• Creation and re-organization of database, table spaces, rollback segments.
• Reviewing for database fragmentation and decrementing the same to ensure database performance by means of a Database re-org.
• Planning for backup and recovery of database information.
• Exporting of data from operational database to dump files Importing back during crisis.
• Creation Maintenance of Database Objects as and when the application has been designed.
• Backup and recovery strategy implemented
• User Management Security Administration.
• Collect and analyze data to assist end users with troubleshooting
• Prepared documentation requirements in order for users to learn how to manage the phases of the database

Environment: Oracle9i on Windows, Linux

Extra Activities

Sr. Oracle Instructor at Oracle University XDuce India Pvt. Ltd and ITS.