PROFESSIONAL SUMMARY

• Eight Years of experience as an Oracle Database Administrator, my experience has scaled in providing client support, analysis, designing, development, testing, installation, migration, maintenance and administration for oracle databases, which included understanding the requirements, upgrades, performance tuning, backup recovery, cloning, and space management using ORACLE 11g, 10g, 9i, performing the role of Oracle Database Administrator according to the set standards and timelines.
• Extensive knowledge on database administration for Oracle 11g, 10g, 9i, with experience in very large scale database environments and mission critical systems.
• Expert with planning, creation, administration and troubleshooting of Oracle 11g/10g/9i, OLTP multiple instances /OLAP databases in production.
• Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates CPU's in various environments.
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, TOAD, Oracle SQL Developer in various versions.
• Worked on Linux, HP-UX, AIX, Sun Solaris and Windows environments.
• Installed and maintained Oracle 11g/10g RAC with ASM OCFS2 File systems.
• Configured Database File System DBFS on EXADATA
• Implemented OLTP COMPRESSION, PARTITIONING, Hybrid Columnar Compression for databases on EXADATA, and the basic, low, high compression methodologies.
• Installed, configured and maintained databases on EXADATA X2-2 half rack.
• Monitor databases using Cloud Control 12c and deploy 12c agents on the target servers
• Implemented replication DATAGUARD to create the standby by for many databases Physical standby/ Logical standby for DR high availability.
• Converting single Instance databases to RAC databases using RCONFIG, DBCA and manually.
• Data transferring and Refreshing with export/import utilities, Data Pump including Network links and DB links and data loading using SQL Loader and External tables.
• Introduction to 12C Pluggable databases Architecture, Installation and the basic concepts associated with 12C database.
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.
• Backup, Recovery and Cloning of databases using RMAN, also profound in using the new oracle 11g features in these utilities.
• Applying patches using OPatch and OPatch Auto.
• Proficient in setting up and trouble shooting network connections i.e. setting up Listener and TCP/IP Connections .
• Migrated NON-ASM databases to ASM using RMAN
• Storage Migration involving migrating the databases from NetApp to Hitachi including block level storage.
• Experience in writing PL/SQL Stored Procedures, Functions Packages and Triggers, various UNIX Shell Scripting for managing the user's roles and privileges, scheduled backups, manage statistics, Disk space management.
• Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues.
• Performance tuning of the database - SQL Tuning, Partitioning, parallelism, Used Tuning utilities like STATSPACK, AWR, ADDM, Database Replay and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.
• Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.

Technical Skills:

Confidential

SR ORACLE DBA

Responsibilities:

• Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.
• Converted physical standby to Snapshot standby and back to physical standby.
• Installed, configured and maintained Oracle 11GR2 Real Application Cluster RAC databases including a 4 Node RAC on EXADATA.
• Storage Savings specific Compress for Archive high/low
• Exadata Scan query specific Compress for query high/low
• HCC Hybrid columnar compression for EXADATA
• OLTP compression
• Research, Implement, Test and configured various compression methodologies including
• OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM. Monitoring the databases using OEM 12c.
• Storage Migrations: Solely responsible for migrating the Prod/Tst/Dev Databases from NetApp to HNAS and also to block level storage. Migrating the databases from Non-ASM to ASM
• Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.
• Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the dataguard status via command line and GUI.
• Setup the standby via OEM cloud control 12c for several databases.
• Setup physical standby's DATAGUARD for several Databases.
• Implemented DBFS on Exadata.
• Implemented PARTITIONING using EXCHANGE PARTITION method.
• Datapump including database links and network links.
• Migrated databases from NETEZZA, AS 400 to ORACLE 11g.
• Problem diagnosis and Performance tuning by implementing Partitioning, Parallelism, Compression.
• Setting up Hugepages - Calculated the recommended values and setup hugepages on linux severs. Also configured hugepages for the X2-2 half rack boxes.
• Worked on Oracle Puppet Module.
• Performed Database and SQL tuning by using various Tools like AWR reports, SQL Tuning Advisor, ADDM, Real Time ADDM, Database Replay and EXPLAIN PLAN analysis for query optimization.
• Built databases with different blocksizes and tested the performance with various parameter settings.
• Extensive knowledge on EXADATA specific features like Smart scan, HCC, Smart flash log.
• Capacity planning for the projects owned in the environment.
• Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and also for full database backups using datapump.
• Provided backup/Restore Recover of the databases using RMAN and FLASHBACK database procedures.
• Upgrade the binaries by applying patch set and interim patches using OPatch and OPatch Auto.
• Creation of new PL/SQL procedures and triggers based on the project requirement.
• UNIX shell scripting as and when required based on the requirement.
• Installed 12c pluggable databases on Sandbox. Have knowledge of the architecture, new features and good overview of pluggable database specs.
• Plugging from and Unplugging into XML files, creating the Container database and pluggable databases, Upgradation from 11.2.0.3 to 12.1.0.1 and migrating the 11g database to 12c pluggable database.
• Providing technical support to Application Support team for performance and database related issues.
• Effective Production Support and off hour support, support handover.

Environment: Oracle EXADATA X2-2 HALF RACK 4,7/Oracle 11g, Red Hat Linux 5.8, OEM 12c, RAC, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, Performance tuning, OPatch Auto, Introduction to 12c Pluggable databases, TOAD for oracle 11.6, Storage Migrations.

Confidential

SR ORACLE DBA

Responsibilities:

• Installed, configured and maintained Oracle 11GR2 Real Application Cluster RAC 3 node RAC.
• Installation and maintenance of Oracle 11g, 10g standby databases using Data Guard.
• Backup and recovery using RMAN. Provided backup/recovery, problem diagnosis, performance tuning, and database upgrade support.
• Migrating single Instance Databases to 3 Node RAC environments.
• Monitor the databases using 11g grid control.
• Oracle 11g,10g Datapump utilities as part of implementation.
• Involved in migration of databases from HP-UNIX to RHEL
• Verify and notify for the success of whole migration process and make live production databases.
• UNIX shell scripting as and when required based on the requirement.
• Setting up physical standby database/ logical standby, perform switchover/failover.
• Applying patch set and interim patches as and when required.
• Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues.
• Involved in the error checking and testing of the ETL procedures, worked with ETL group for understating mappings for dimensions and facts.
• Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration.
• Installed and Implemented Backup Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Upgrade the database by applying patches using OPatch.
• Performed Explain Plan analysis and SQL tuning.
• Performed Database and SQL tuning by using various Tools like AWR, TKPROF, EXPLAIN PLAN, and optimizer hints.
• Effective Production Support and off hour support, support handover, off-shore co-ordination.

Environment: Oracle 11g/10g/9i, Red Hat Linux, Data Mover, Application Designer, TOAD, RMAN, SQL server, Data Guard, Golden Gate, OEM, Grid Control, STATSPACK ,AWR ,Explain Plan.

Confidential

Oracle DBA

Responsibilities:

• In charge of maintaining DPH and EPA Production and Development Oracle databases.
• Managed and monitored the Oracle Real Application Cluster 2 node RAC
• Supporting more than 125 production and development databases 10.2.0.4.
• Created and maintained failover logical standby database.
• Using Oracle 10g Data-Pump for export and import.
• Involved in migration of databases from standalone ASM to cluster Environment.
• Using Automatic Shared Memory Management ASMM for optimal use of available SGA memory.
• Maintained catalog server.
• Using SQL Tuning Advisor and SQL Access Advisor to fix the SQL statements.
• Installed and configured Oracle Enterprise Manager 10g Grid Control.
• Worked on Performance Tuning Oracle DBA 11g 10g on Solaris 10, AIX 5.2.
• Installed and upgraded Oracle 10.2.0.1 database to 10.2.0.4.
• Developed a bunch of Index monitoring scripts in order to sort out the unused space occupied in table spaces.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor ADDM , Automatic Workload Repository AWR for monitoring database performance. Modified and updated the Performance tuning scripts.
• Tested database performance issues monitoring and tuning to ensure database optimization.
• Involved in creating Golden Gate EXTRACT and REPLICAT files.
• Performed Tuning, coding and Monitoring for Oracle Real Application Clusters RAC nodes, Production Standalone Servers via Toad.
• Creation of materialized views and fine-tuned them for better performance.
• Working Experience with latest TOAD having new features likes PLSQL SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.

• Tuning SQL statements using Explain Plan and STATSPACK.

• Modified SQL Loader control scripts for example to eliminate spaces generally used for data loading.

• Created bit-map Indexes for data warehouse databases.

• Configured Physical and Logical Standby database for reporting environment.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Environment: Oracle 10g/9i RAC on Solaris/Linux, RMAN, Data Guard, UNIX Shell Scripting, Quest Performance Analysis, Quest Space Management tool, DB Artisan, Toad, PL/SQL Developer, OEM, Windows NT/XP.

Confidential

Oracle DBA

Responsibilities:

• Provide backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade support for approximately 40 Oracle databases.
• Installed, configured and maintained Oracle 10g Real Application Cluster RAC .
• Installation and maintenance of Oracle 10g Data Guard for Database Disaster Recovery.
• Involved in backup and recovery using RMAN.
• Providing technical support to Application Support team for performance and database related issues.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Database Restore using RMAN, Cold Backup and Export/Import.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Creating and managing the database objects such as tables, indexes and views.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
• Responsible in configuring and backing up database using hot backups, Cold backups and Logical backups.
• Performed Schema as well as Table level Replication using Oracle Golden-Gate and also did set up Disaster Recovery solution usingGolden-Gate.
• Migration / Up-gradations of Databases.
• Patched Oracle Database Server 10g using Opatch.
• Upgrading/migrating Oracle databases from 8i/9i to 10g.
• Performance tuning on production databases supporting the application using stats pack/AWR.
• Develop, document, and implement security configuration for Oracle software and database instances to comply with existing standards.
• Refresh development/test databases from copies of production.
• Performance tuning via OEM, STATSPACK/AWR for 9i/10g.
• 24x7 Production-on call supports for all the production databases with Oracle 10g/9i/8i.

Environment: Oracle 8i/9i, SQL, PL/SQL, SQL plus, TOAD, Import/Export Oracle Enterprise Manager, Windows NT/2000, Sun Solaris 2.5/2.6, Red Hat Linux 2.1