PROFESSIONAL SUMMARY:

• Around 9 years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle 9i, 10g, 11g on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows 2000/2003/2008 Platform.
• Experience in Configuring 10g/11gR2,12c Oracle Real Application Clusters RAC , Automatic Storage Management ASM and Data guard.
• Experience with very large scale database environments and mission critical OLTP and OLAP systems.
• Experienced in Installation, Patching, Cloning, and Upgrade of Oracle Databases.
• Experienced in Backup Recovery, Disaster Recovery options, Oracle Recovery Manager RMAN .
• Experience in Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Experience in Supporting EDW with OLTP and OLAP Data ware House applications.
• Involved in Implementing SHAREPLEX.
• Provided 24x7 production support
• Experience in working with Grid Control and Oracle Enterprise Manager OEM .
• Performed Strategic Planning, Logical and Physical Data Modeling Application Tuning.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, packages,performance Tuning ,UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Experience in maintaining Oracle Data Guard Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Experience in Migrating Data using Oracle Data Integrator.
• Experience in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Expertise Oracle Enterprise Manager OEM , Grid Control, TOAD, RMAN.
• Cloned Database from Production to Test and Development.
• Experience in migration of oracle databases and installing patches.
• Exporting and Importing of dumps using expdp and impdp.
• Experience on handling VERY LARGE DATABASES VLDB .
• Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 12c OEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
• Experience in SQL Server databases 2000, 2005, 2008, 2012 , SSIS and SSRS
• Installation, configuration and Testing of Oracle Database 12c

TECHNICAL ENVIRONMENT:

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA

Responsibilities:

• Successfully implemented 11g R2 RAC on 4 nodes for high availability.
• Hands on experience in troubleshooting RAC databases.
• Installation and creation of 10g and 11g databases for Testing, Development and Production.
• Successfully implemented oracle 11g grid control.
• Installed and applied patches for oracle 11g and 10g databases for supporting applications.
• Up-gradation and Migration of Database from 10.2.0.4 to 11.2.0.3 and applying patches whenever required.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Configured Automatic storage management ASM with EMC storage for managing data in SAN.
• Involved in 24x7 support for production databases with on-call pager .
• Involved in EDW Support for OLTP and OLAP Data ware house Applications.
• Installation of database software and with analyzing, designing, and implementing databases.
• Used Oracle Real Application Testing for performing tests in QA environment.
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL Trace,SQL profiling and TKPROF, STATSPACK.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Involved in applications administration including 11g Database/Applications cloning, tuning, patching and monitoring concurrent manager processing etc.
• Experienced in handling database issues using OEM as well as command prompt.
• Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the datable.
• Other activities like applying RDBMS patches, security patches, sox reporting proactive monitoring of databases and applications.
• Experience in DB capacity planning ,data normalization and rationalization
• Loads databases, reorganizes as necessary, and assists in monitoring database performance
• Developing and Implementing Disaster Recovery DR Plan using Datagaurd.
• I along with team implemented physical standy database using Datagaurd.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import Move procedures
• Daily Health Check Up of the Database using staspack, AWR, ADDM ASH.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Performance tuning of Oracle Database Objects by fixing row chaining.
• Taking periodic Backup of the Database and the software using RMAN and VERITAS Netbackup.
• Written shell scripts for digitization the process. Scheduling jobs through Oracle Job Scheduler.
• Maintaining security of databases and users.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption .
• Installation and configuration of Oracle Client software and Tools.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration
• Written Shell scripting which monitors the server's performance and logs output on periodic basis to database.
• Supported Production issues relating our data warehouse databases.
• Worked along with the teams supporting various applications relating to data warehouse.
• Written SQL scripts to monitor tablespace and extent growth.
• Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints
• Space Management which includes table space creation, adding new datafiles.
• Experienced with monitoring the database security issues and resolving them on timely basis.
• Successful in restoring and recovering database issues due to various causes like media failure.

Environment: Red Hat Linux, HP -UX 11.31, Solaris, MYSQL,Windows XP, Oracle 9i/ 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0,SQL DEVELOPER

Confidential

Role: Oracle Database Administrator

Project:

• Performed configuration, Installations of ORACLE 11gR2 RAC databases Including Grid Infrastructure.
• Configured application backups / RMAN, worked on Datapump, ASM and RMAN.

Responsibilities:

• Configuration, Installation and maintenance of Oracle 11gR2 RAC databases including Grid Infrastructure.
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Involved in setting up of data guard for 2-node standby.
• 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.
• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
• Experience in SQL Server and MYSQL databases.
• Experience in Supporting Teradata for data ware Houses and analytical applications .
• Involved performed Production Change Requests for PROD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities. Implemented 10g RAC on a test basis.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Involved in the matters of performance issues and auditing the required down time.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Skilled with AWR, ADDM, SAR to check health of database hardware.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements.
• Installation of Oracle database 10g software with RAC using Oracle Clusterware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
• Designed and developed Database structures Database triggers, Procedures, Functions to implement business Rules . Loaded data into Database using external tables.
• Expert in Oracle Utilities and Tools like OEM, Import-Export, RMAN.
• Exposure to AS400 IBM Server.

Environment: Operating Systems: IBM-AIX, SunSparcSolaris64bit, and Redhat Linux.

RDBMS: Oracle Database Server 10g/11g, Programming Language/Tools: TOAD, PL/SQL

Confidential

Role: Oracle Database Administrator

Description:

• Essilor owns the largest and most comprehensive optical laboratory network in the United States.
• Performed Installations and backups,migrating Databases from 10g to 11g and applied Patches.

Responsibilities

• Installed and administered Real Application Cluster 10g RAC environments adding and removing nodes to the cluster and handled performance tuning using AWR.
• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Have worked on different environments like test, development and production databases.
• Have worked on backup/recovery, performance tuning.
• Installation and creation of Oracle 9i databases on Production and Test Solaris servers. Responsible for upgrade migrating databases from 9i to 10g, applying patches.
• Experience in handling GUI software and OS.
• Database Restore using RMAN, Cold Backup and Export.
• Involved in Design and implementation of oracle 10g Data guard both physical/logical standby databases.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Used impdp /expdp and SQL- loader to load data into tables.
• Utilized Oracle Enterprise Manager OEM , Grid control to manage users, privileges, profiles, and schemas.
• Automated monitoring the databases, performance parameters, and backup/recovery activities by RMAN and VERITAS Net Backup, running Cron jobs and write UNIX shells scripts for job automation.
• Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER and SQL tuning advisor.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment: AIX 5.1, HP -UX 11.23, Solaris, Windows XP, Oracle 9i/ 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0

Confidential

Role: Oracle Database Administrator

AIG offers a comprehensive range of financial services bringing the freedom of mobility to consumers, businesses and government users. It is widely recognized for Business technologies

Responsibilities:

• Installing Oracle 9i and upgraded it to latest 9i patch set on HP-UX 11.23.
• Migrating applications from non-clustered oracle 8i/9i databases to new 10g RAC Database environments.
• Monitoring and supporting Applications using OEM 9i Grid Control.
• Configured two node Oracle 9i RAC cluster.
• Created PARTIONING of its types like Range, List Hash by the specific use.
• Implemented Oracle Streams for Replication.
• Implemented schema level, table level and bidirectional oracle streams.
• Registering Databases to RMAN Catalog.
• Planning and scheduling Backups, RMAN, taking Logical Backups.
• Experience in Export/Import and Datapump.

Environment: Oracle Grid Control, Oracle 9i, HP-UX 11.23

Confidential

Role: Oracle Developer/DBA

Responsibilities:

• Upgrading, analysis and testing of the test and production database.
• Perform capacity planning required to create and maintain the database environments.
• Implemented Oracle New features like SPfile, Shared Severs, Locally managed Temporary tablespace, UNDO tablespace and RMAN
• Involved in Gathering the Requirements for creating data models for data analysis and reporting.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Assisted in Installing Application Server, Report Server and Database Server.
• Worked on PL/SQL Oracle 9i, 10g , PL/SQL Developer/TOAD, Unix/Linux, Crystal Reports Business Objects XI .
• Involved in importing the production data to lower environments for testing purpose.

Environment: Windows 98/NT/2000, HP-UX, Oracle 8i/9i, Toad V8.0, Net8, Database Tools/Utilities.