PROFESSIONAL SUMMARY:

• 8 Years of extensive experience as Oracle 11gR1/R2/10g/9i Database Administrator.
• Experience as a Production support/Operations DBA with Multi-Terabyte large databases and as well as Development/Engineering/Data Warehouse DBA.
• Hands on experience in 11gR2/10g RAC Real Application Clusters .
• Experience with various replications software's like Data Guard.
• Configured managed Stand By databases both physical, logical Active Data Guard for disaster recovery with and without Data Guard Broker.
• Experience in installation/configuration/administration/Patching of Oracle 9i, 10g, 11gR1/R2 databases.
• Good experience in upgrading the databases from oracle 9i/10g to 10g/11gR1 R2.
• Experience dealing with database migration from UNIX, Solaris, AIX to RHEL.
• Good experience with installing and configuring Grid Control 10g/11g and as well as Agents.
• Experienced in virtual environment with Hands on experience on virtualization VMware Vsphere technologies.
• Implemented backup and recovery strategies using RMAN, HOT, COLD backups.
• Experience in Implementing and performing Disaster Recovery using Data Guard.
• Experience Working on E-commerce environment with OLTP databases.
• Expert level knowledge in PL/SQL Programming Writing stored procedures for Packages Implementing functions, triggers, collections .
• Experience in working with physical relational models of the database.
• Knowledge of SAN, NAS and RAID storage Technologies.
• Experience in Partitioning large tables in VLDB Data warehouse Environments.
• Good Knowledge on data management ETL tools like Informatica, ODI.
• Experience in healthacare domain.
• Supported the system 24x7. Ability to work beyond regular hours.
• Expertise in Oracle GoldenGate installation, configuration, troubleshooting GG issues.
• Performs GoldenGate replication monitoring, tuning, and capacity planning.
• Install and configure Oracle GoldenGate Veridata 3.0.
• Configured Oracle GoldenGate and parameter files in an active-active architecture.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Position: Sr. Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i/10g/11g databases on different platforms as well as the clients.
• Worked in Agile development to support multiple environments across the application.
• Upgrading oracle databases from 10.2.0.3.0 to 10.2.0.4.0, 11.2.0.2.
• Oracle server in installation and configuration on virtual environments.
• Cloned/Refreshed staging environment with production data using RMAN.
• Installing, Configuring and Administering Automatic Storage Management ASM .
• Installing, Configuring and Administering Real Application Clusters on 2 and 4 node cluster.
• Installing CPU/PSU and other security, bug patches for Oracle databases on Solaris, Linux Platforms.
• Cloned/Refreshed databases for testing/QA environments using export/import, data pump and cold backup.
• Implemented Hot and cold backups, Restore and recovery manually.
• Implemented RMAN backups and Restore and Recovery.
• Installed, configured and maintained Physical Standby Databases for the Production databases using Data Guard.
• Experience in Implementing and performing Disaster Recovery using Data Guard.
• Implemented replication between databases using advanced replication.
• Participating in Auditing of databases like PCI Auditing.
• Helped in migrating terabytes of data between different versions of analytics databases.
• Configuring and maintaining OEM.
• Active participation in code deploy for engineering releases.
• Written PL/SQL, Stored Procedures and also UNIX Shell scripts for monitoring database activities,
• Experienced at SQL Loader, expdp, impdp, exp, imp and other Oracle utilities.
• Experienced at administering database security by installing Ingrain, create users, grant/revoke roles, privileges to the users, creating and assigning profiles to the users
• Perform capacity planning required to create and maintain database environments.
• Management of schemas, Tablespaces, objects partitioning the tables indexes.
• Worked closely with application team members to perform SQL Tuning using Explain Plan, SQL Trace, Optimizer Hints, TKProf utility.
• Re-organization of database objects Tables, and Indexes etc.
• Generated SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Aided developers in writing efficient code and making efficient use of resource leading to better performance and optimization.
• Used Diagnostic tuning packs along with AWR ADDM reports
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Helped build extensive documentation for all Oracle related Administration

Environment: Oracle8i/9i/10g/11g, Sun Solaris 5.8 sparc/5.10 x86, Linux, SQL Plus, ASM, RAC, Oracle Enterprise Manager OEM , Shell scripting.

Confidential

Position: Oracle Database Administrator

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g using ASM on Linux machines.
• Migrated/Upgraded oracle databases from 9.2.0 to 10.2.0.3.0.
• Installed, configured and maintained Physical Standby Databases for the Production databases using Data Guard.
• Installed CPU patches on Solaris, UNIX and Linux platforms in RAC and Non-Rac Environment.
• Monitored RAC Instances Using Scripts For Backups, Performance Tuning, to find out Free space at Table Space , table Levels etc
• Configuration of Automatic Storage Management ASM , Configuration of Oracle Cluster File System OCFS2 , Installation of Clusterware in order to explore the RAC Database environment
• Created Recovery Catalog database for RMAN backups.
• Created tables, views, stored procedures and monitored insertions and upload of data as part of the Custom Logger built.
• Management of schemas, Tablespaces, objects partitioning the tables indexes.
• Extensively used Datapump for the export and import of schemas and tables.
• Extensively used SQL Loader to load the data into the schema.
• Implemented Hot and cold backups, Restore and recovery through RMAN as well as manually.
• Oracle server in installation and configuration on virtual environments.
• Security and Bug Patch implementation for Oracle 10g binaries.
• Written UNIX shell scripts to monitor ASM, listeners, monitor the alerts, RMAN backups, PL/SQL Stored Procedures and Triggers.
• Experienced at, expdp, impdp, exp, imp and other Oracle utilities.
• Created users, grant/revoke roles, privileges to the users, creating and assigning profiles to the users.
• Re-organization of database objects Tablespaces, Tables, and Indexes etc.
• Tuning the application using Oracle utilities like OEM, SQL Trace, TKProf and Explain Plan.
• Worked closely with application team members in writing efficient code and making efficient use of resource leading to better performance and optimization.
• Used Diagnostic tuning packs along with AWR ADDM reports
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Environment: Oracle 9i/10g/11g, RED Hat Linux, Sun Solaris, Windows 2003, , SQL Loader, RMAN, RAC, Toad, SQL Plus, Oracle Enterprise Manager OEM Grid Control, RMAN, Shell scripting.

Confidential

Position: Oracle Database Administrator

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i, Oracle 10g databases.
• Migrated oracle databases from 9i to 10g version.
• Perform capacity planning required to create and maintain database environments.
• Created RMAN database backup and used OEM to manage the data, accounts and tuning.
• Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters RAC on different nodes with Automatic Storage Management ASM .
• Created a number of database instances for development, testing and production.
• Maintained Development databases, Test databases and applied Patches
• Managed Oracle environment easily and consistently using Oracle Grid Control. Used Grid Control to manage Real Application Cluster.
• Running imports/export utilities, off-line backup, on-line backup various PL/SQL server Applications utilities, used File Transfer Protocol.
• Worked on Golden Gate Replication tool.
• Cloning of databases from production to Dev QA Databases.
• Provided partitioning of the large tables to reduce the access time.
• Created and maintained databases: Creating table spaces, tables, indexes, views and materialized views.
• Monitored table space size, resizing table space, relocating data files for better disk I/O.
• Created users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
• Written complex queries and stored procedures using sql plus and monitored databases using TOAD.
• Developed shell scripts and automated nightly jobs using cron to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB's.
• Experienced at SQL Loader, expdp, impdp, exp, imp and other Oracle utilities Used ERWIN for Logical Data modeling and creating physical database designs.
• Replicated materialized views with fast refreshes for transfers of information.
• Used STATSPACK, AWR, ADDM, Explain Plan, TKPROF and other utilities for Performance monitoring and tuning.
• Troubleshooting Oracle errors, fine-tune database parameters, and analyze STATPACK reports.
• Configured disaster recovery site with physical standby database for high availability.
• 24 7 production support and on call rotation.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL NET connectivity.
• Involved in testing stage of two-node RAC implementation on SUSE Linux.
• Extensively wrote UNIX shell scripts, PL/SQL, Stored Procedures and Triggers.

Environment: Oracle 9i/10g, Toad, SQL Plus, SQL Loader,, RMAN, RAC, Oracle Enterprise Manager OEM Grid Control, Golden Gate, ERWIN, RMAN,LINUX,HP-UX11i, AIX 5.1, 5.2.

Confidential

Position: Jr. Oracle DBA

Responsibilities:

• Upgrading, analysis and testing of the test and production database.
• Wrote various scripts to automate data loads, performance monitoring and backup.
• Database physical/logical layout design and procedures for production, development, test servers.
• Guided the Operations team in Creating, Cloning, trouble shooting Oracle Databases, Database Objects Designs, Partitioning, capacity planning of disk, table spaces, tables, backups and recovery.
• Helped the Production teams in Applications Performance Tuning and providing 24 7 Production Support.
• Performed capacity planning to create and maintain the database environments.
• Provided tuning support for SGA shared pool, buffer pool and log buffer pool etc .
• Managed archived redo files, DB-links Partitions, loading data for users by using SQL loader.
• Replication of materialized views snapshots with fast refreshes for transfers of information.
• Set up Cron jobs to monitor file systems usage, archive logs, backup logs and cleaning up of these file systems periodically, and also RMAN Hot Backup Scripts.
• Tuned Oracle Initialization Parameters.
• Gathered Database Instance Statistics generated reports using STATSPACK.
• Implemented Oracle New features like SPfile, Shared Severs, Locally managed Temporary Tablespace, UNDO Tablespace and RMAN.
• Created Partitions at O/S level, according to DB requirements.
• Installing Oracle 8i on Win'NT 4.0 Server and Setting up Oracle Clients.
• User Creations with allocation to appropriate tablespaces and quotas with necessary privileges and roles.
• Performed application SQL tuning using SQL Trace/Explain plan and TKPROF and database tuning for optimum performance.
• Wrote procedures, triggers and shell scripts.
• Cloning databases for development/testing environments.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL NET connectivity.

Environment: Oracle 8i/9i, PL/SQL, Developer 2000, Windows NT 5.0/ UNIX