SUMMARY

• Around 9 years of experience as an Oracle Database Administrator having hands on experience in database administration and performed different tasks like installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security, RAC, Data Guard, Goldengate, Grid Control and Enterprise Manager using ORACLE 12c/11g/10g on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platforms.
• Installation and administration of Oracle 11g/10g/9i on OEL, RHEL, Windows, HP-Unix, IBM-AIX and Sun Solaris in OLTP and OLAP environment.
• Installed, configured and maintained Oracle 11g Real Application Cluster (RAC) with ASM and ACFS filesystem.
• Knowledge on ExadataSmart Scan technology which improves query performance by intensive query processing and data mining scoring to scalable intelligent storage servers.
• Worked on Oracle Exadata Backup Configuration utility.
• Performed Migration and Upgradeof databases to 11g and 10g
• Upgradation of databases applying patches, patch sets and critical patch updates.
• As a DBA we use to give permissions to access the LDAPdatabases.
• Installation and configuration of Oracle Server 11g RAC with ASM on multi node systems, 11g, 10g and 9i in different operating systems for OLTP environment on Very Large Databases(VLDB).
• Experience on Oracle 11g/ASM/RAC and upgradation of standalone databases to 11g RAC environment
• Installed and Configured Enterprise manager OEM12C and 11g.
• Configuration of Automatic Storage Management (ASM)
• Configuration and Management of Data Guard on RHEL, OEL and Windows.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control
• Experience on Data Replication using Snapshot, Materialized views, import/export.
• Regular database synchronization for test database environments through automation.
• Installation and configuration of RMAN with and without Recovery Catalog.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Migrating the databases from one platform to another platform.
• Implementation of Flashback Technology
• Knowledge on Oracle Virtual Directory(OVM) an LDAP service.
• Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate issues.
• Extensive experience using SQL* Loader, External Tables and Oracle Application Express for data loading.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
• Experience in advanced Oracle features such as Table partitioning, Oracle Streams(Replication).
• Experience in SQL Tuning, Optimization, cost based optimization and Hints
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
• Proficient in INDEX REBUILDING and INDEX TUNING
• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Experience working with Database Resource Management
• Working experience in creating materialized views.
• Proficient in writing PL/SQL Procedures, Functions and Triggers.
• Experience using Erwin as a Data Modelling tool & Designing the ETL processes
• 24*7 on-call production database support and maintenance including remote database support
• Assisting in implementation of change control process in production.
• Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS

Operating Systems: OEL, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, 6.x HP-UX 10.x, 11.x, Sun Solaris 9.0/10.0, AIX 5.1, 5.2 and Windows 98/NT/2000/2003.

Databases: Oracle 11gRAC/10gRAC/10g/9i, SQL Server 2005/2008

Languages: SQL, PL/SQL, C, .Net,C++, UNIX Shell Scripting,Perl

Tools: /Utilities: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN,Goldengate TOAD, Patch Management, ODBC, Export/Import, Data pump, Data Guard, VERITAS Net Backup, VMware, CronTab, EXADATA

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Terminal Emulation: Putty, Telnet, FTP

PROFESSIONAL EXPERIENCE

Confidential, NJ

Oracle Data Base administrator

Responsibilities:

• Installed, configured and maintainedOracle 11GR2Real Application Cluster (RAC)4 node RAC on EXADATA X2-2 HALF RACK
• Install and configure Cloud Control 12c(OEM) and deploy 12c agents
• Installed, configured and maintained Oracle Database 12c on Oracle Sun Solaris T4-1 SPARC servers and 11g on T3-1 SPARC servers.
• Plug-in installations on the target servers and monitor databases.
• Configure Oracle Advanced Security to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Backup/Restore & Recover of the databases using RMAN and FLASHBACK database procedures.
• Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and also for full database backups using datapump.
• Database Installation, Upgrades and Patching. Upgrade the binaries by applying patch set and interim patches using OPatch and OPatch Auto.
• Capacity planning for the projects owned in the environment.
• Creating Solaris Zones, zone Snapshots for backup. Configuring the disks and slices for ASM
• Effective Production Support and off hour support, support handover.
• Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.
• 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)
• Research, Implement, Test and configured various performance tuning methodologies including
• OLTP compression
• HCC (Hybrid columnar compression for EXADATA)
• Exadata Scan query specific - Compress for query high/low
• Storage Savings specific - Compress for Archive high/low
• Implemented DBFS on Exadata.
• Implemented PARTITIONING using EXCHANGE PARTITION method to improve the performance of the database
• User management, Tablespace management, file system space management, backups management
• Execute changes to database based on preapproved change requests
• Installs necessary tools on infrastructure (deploying agents, RMAN FRAMEWORK, control M, RMAN framework, 12c agents)
• Meet SLA as defined in the SLA metrics and Make sure team meets and follow all the guidelines within database track. Handle P1/P2 tickets.
• Manage team and assign R&R for team members. Plan the execution of day to day tasks in relation to management of incidents, requests and any tickets related to monitoring events.
• Deliver the reports on time as agreed. Follow-up all actions items and report to NVS managers on status
• Monitor and track team members training status. Represent changes in weekly change board calls. Represent the changes in CAB and discussions with client
• On-Boarding & Training the new team members on SOP and SOM, Security Baselines and Installation Qualifications.
• Point of escalation for team members.
• Monitor and educate team with new processes and standards pertaining to compliances. Educate team with new process. Access control to tools.

Environment: Oracle 12c/11g/10gon Unix/Windows, Oracle EXADATA X2-2 HALF RACK 4,7/Oracle 11g, Sun SPARC T4-1/T3-1, Red Hat Linux 5.8, AIX 6, OEM 12c, RAC, Oracle Advanced Security, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, Performance tuning, OPatch Auto, TOAD for oracle 12.1/11.6, Storage Migrations.

Confidential, Cincinnati, Ohio

Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 11GR2 Real Application Cluster (RAC) databases.
• Migrate data from NETEZZA to Oracle Database Machine
• Setup dev, test, UAT and Prod environments on SUN/HP database machines.
• Setup physical standby’s (DATAGUARD) for several Databases
• Setup the standby via OEM cloud control 12c for several databases.
• Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the dataguard status via command line and GUI.
• Converted physical standby to Snapshot standby and back to physical standby.
• 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 single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.
• Plugging from and Unplugging into XML files, creating the Container database and pluggable databases. Migrating the 11g database to 12c pluggable database.
• Upgrade existing 10g/11g databases to 12.1.0.1 on HP database machine using transportabletablespace method. Upgraded supported versions using DBUA (direct path upgrade)
• Datapump including database links and network links.
• 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.
• 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.
• 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.
• 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, Pluggable databases, Dataguard including DG Broker setup, RMAN, Performance tuning, OPatch Auto, TOAD for oracle 12.1/11.6, Storage Migrations.

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Installed, configured and maintainedOracle 11GR2Real Application Cluster (RAC)3 node RAC.
• Installation and maintenance ofOracle 11g, 10g standby databases using Data Guard.
• Install 11g binaries and Upgrade the databases from 10g to 11g
• Migrate data from 10g to 11g via Transportable tablespace method.
• Backup and recovery usingRMAN. Provided backup/recovery, problem diagnosis, performance tuning, and database upgrade support.
• Database creation, sizing, import/export and backup procedures and other similar issues supporting Banner Software
• Migrating single Instance Databases to3 Node RACenvironments.
• Monitor the databases using 11g grid control.
• Oracle 11g,10gDatapump utilities as part of implementation.
• Involved in migration of databases fromHP-UNIXtoRHEL
• Performed Schema as well as Table level Replication using Oracle Golden-Gate
• Set up Disaster Recovery solution using Golden-Gate.
• Involved in creating Golden Gate EXTRACT and REPLICAT files.
• Verify and notify for the success ofwhole migration processand 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 patchesas and when required.
• Implementeddatabase refreshwith the hotbackup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Involved in the error checking and testing of theETL procedures, worked withETL groupfor understating mappings for dimensions and facts.
• Creation of new scripts to automate the procedures togenerate statistics on databasespace management, performance and forproactive monitoring.
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration.
• Installed andImplemented 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 likeAWR, TKPROF,EXPLAINPLAN, and optimizer hints.
• Effective Production Support and off hour support, support handover, off-shore co- ordination.

Environment: Oracle 10g/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

Confidential, Brooklyn, NY

Oracle DBA

Responsibilities:

• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup &recovery solutions using RMAN.
• Extensive use of Oracle Data pumps Exports/Imports utility for moving data among the servers
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
• Worked with Data pump to take the logical backups of databases.
• Experienced in performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names.
• Involved in designing logical and physical data models using Erwin.
• Created indexes to facilitate easy user interface implementation and tuning.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Environment: Oracle 11g/10g, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, Windows 2003/2008, OEM, Oracle RAC, Data-Guard, TOAD, Erwin, STATSPACK, EXPLAIN PLAN.

Confidential

Oracle DBA

Responsibilities:

• Installation and configuration of oracle database9i (9.0.2) on various OS platforms like HP-UX, Linux and Windows NT, 2000.
• Creating and Maintaining of databases.
• Creating table spaces, tables, indexes, data files etc.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Managing, troubleshooting and resolving oracle database and applications issues.
• Perform capacity planning required to create and maintain database environments.
• Helping to the developing team and data warehousing team.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Writing complex queries and procedures using sql *plus and toad.
• Developed shell scripts and automated nightly jobs using crone to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB’s.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Monitoring the background processes activity, setting the appropriate number of DBWR processes, changing the init.oraparameters etc.
• Creating users, allocation to appropriate tablespace quotas with necessary privileges and roles for all databases.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Monitoring table spacesize, resizingtablespace, relocating data files for better disk I/O
• Managing archive logs, DB-links, partitions.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases
• Maintain Oracle schemas and SGA region.
• Guiding and leading warehousing team for better performance.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.

Environment: Oracle 8i/9i, Oracle Enterprise Manager (OEM), RMAN, Import/Export and Linux, HP-UX, Windows NT/2000