SUMMARY

• 8+ years of experience in Information Technology in various roles, 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 12c/11g/10g, performing the role of Oracle Database Administrator according to the set standards and timelines.
• Extensive knowledge on database administration for Oracle 12c/11g/10g with experience in very large scale database environments and mission critical systems.
• Experience in Installation of Oracle Real Time Application Cluster (RAC) with ASM, and manage RAC instances using CRSCTL and SRVCTL utilities.
• Installed and configured Container and Non - Container 12c databases, Installation and the concepts associated with 12C database.
• Implemented and configured replication technology using Dataguard & Oracle GoldenGate installation.
• Worked on Oracle 12C Grid Control including monitoring/setup and performance tuning purposes.
• Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases.
• Experience in Uni-directional, Bi-directional and Integrated Capture data replication using GoldenGate.
• Experience in cross platform Migration from Solaris to Linux and Upgraded database from 11g to 12c using GoldenGate with Zero downtime.
• Upgraded Grid and Oracle Infrastructure on multi-node RAC cluster from 11.2.0.3 to 11.2.0.4
• Performed Migration between different datacenters, Non ASM to ASM, Single instance to RAC.
• Converting single Instance databases to RAC databases using RCONFIG, DBCA and manually.
• 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.
• Configured Database File System (DBFS) on EXADATA
• Expert with planning, creation, administration and troubleshooting of Oracle 11g/10g OLTP (multiple instances)/OLAP databases in production.
• Expertise in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU’s) in various environments.
• Installed and configured Cloud Control 12c, deploy 12c agents on the target servers and monitor databases.
• 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, Sun Solaris, HP-UX, AIX and Windows environments.
• Installed and maintained Oracle 12c/11g/10g RAC with ASM & OCFS2 File systems.
• 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.
• 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. Table recovery using RMAN a new feature of 12c
• Proficient in setting up and troubleshooting network connections (i.e. setting up Listener and TCP/IP Connections).
• 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.
• 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 EXPLAINPLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Training the new team members on Security Baselines and Installation Qualifications.
• Monitor and educate team with new processes and standards.
• 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

Database Systems: Oracle 9i, 10g, 11g, 12c, SQL Server 2005 and 2008

Tools: and Technologies: Oracle 12c, 11g, 10g, 9i, 8i Administration, Oracle enterprise managerSQL server 2010, PL/SQL, DBCA, DBUA, Netca, Netmgr, Oracle Data Guard, Oracle Golden Gate, OEM (GC), Tivoli, RMAN, ASM, ClusterwareShareplex, EXADATA, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), Putty, TOAD, MobaXterm, Erwin, Enterprise Architecture (EA), TOAD Data Modeler, SAN, SQL TRACE, EXPLAIN PLAN, TKPROFSTATSPACK, AWR, and ADDM.

Primary Skill Set: ORACLE database administration, UNIX shell Scripting

Operating System: Solaris 10, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Oracle DBA

Responsibilities:

• Installed, configured and maintainedOracle 11GR2Real Application Cluster (RAC)4 node RAC on EXADATA X2-2 HALF RACK
• Installed, configured and maintained Oracle Database 12c
• Deploy the 12c agents on the target servers and add the target Configuration Items to monitor.
• Plug-in installations on the target servers to extend the functionality of OEM
• Configure Oracle Advanced Security to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Setup physical standby’s (DATAGUARD) for several Databases (via OEM as well).
• 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
• Configure Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the dataguard status
• Upgrade existing 10g/11g databases to 12.1.0.1 on HP database machine using transportable tablespace method. Upgraded supported versions using DBUA (direct path upgrade)
• Implement Oracle Multimedia and Text options.
• 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)
• User management, Tablespace management, file system space management, backups management
• Create, Track and work and tickets (Change Requests, Work Orders and incidents) generated from Remedy on Demand (RoD) Tool.
• Generate reports needed to provide details with number of tickets closed, current status, average age on tickets to client from Remedy’s Business Analytics tool.
• Execute changes to database based on preapproved change requests
• Installs necessary tools on infrastructure (deploying agents, RMAN FRAMEWORK, control M, RMAN framework, 12c agents)
• Deliver the reports on time as agreed. Follow-up all actions items and provide status.
• Training the new team members on Security Baselines and Installation Qualifications.
• Monitor and educate team with new processes and standards.
• Effective Production Support and off hour support, support handover, off-shore co-ordination.

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, OMAHA, NEBRASKA

Oracle DBA

Responsibilities:

• Installed and configured Oracle 11g on windows.
• Performed migration of database from 10g to 11g in development, testing, and in production environment.
• Configured 2 node RAC in System Test and Production.
• Created ASM, ACFS and OCFS file systems.
• Done migration from non ASM to ASM environment.
• Had a good experience in migrating data using Exp, Imp, Expdp, Impdp.
• Successfully configured Oracle GoldenGate for synchronizing databases.
• Configured parameters for DDL and non DDL support for data replication.
• Had a good experience in resolving the issues while replication with goldengate.
• Implemented DataGuard physical standby database in 11g for disaster recovery.
• Suggested storage requirements for all the environments.
• Performed RMANIncremental and Cumulative backups and also developed backup strategies.
• Performed logicalbackups using both classic and Data Pump methods.
• Had a very good experience with the SpatialData like building spatial indexes, creating metadata etc…
• Performed Patching on Oracle databases using Opatch utility.
• Worked on creation of users, granting privileges to users and also table space management.
• Configured Oracle Enterprise Manager Cloud control 12c.
• Performed daily monitoring of Oracle databases from Oracle Enterprise Manager and alert log files.
• Installed Oracle Client in order to access to the oracle databases.
• Performed performance tuning of database by using AWR, SQLT, and EXPLAINPLAN.
• Maintained databasesecurity using security compliance auditing and profile management, password complexity in order to control access to database.
• Implemented Oracle Resource Manager for effective utilization of resources.
• Worked closely with the Oracle developers for the better performance of applications.
• Done documentation for all the environments.

Environment: Oracle 10g, 11g, RAC, Goldengate, Data Guard, TOAD, ASM, Resource Manager, Oracle Cloud Control.

Confidential, Lees summit, MO

Oracle DBA

Responsibilities:

• Installed and Configured 2node RAC on Linux.
• Installed and Configured and maintained oracle 10g and 11g.
• Oracle Grid Control 11g Installation and Configuration.
• Refreshing the Database from one version to another version.
• Configuration of Physical Standby database for maximum performance mode - Oracle Data Guard
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Performed rolling patch upgrades on RAC environment for bug fixing
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import
• Daily incremental backup and weekly full backup of databases using RMAN
• Involved in migration of applications of the clients.
• Loading data into database tables using SQL *Loader
• Implemented Materialized views, database links
• Regular database management on 10g and 11g OEM
• Working Knowledge of installation and configuration of GOLDENGATE in Unix environment
• Done Installation and configuration of golden gate on 11g database for the replication.
• Implemented Bi-Directional replication in golden gate from target to source and source to target.
• Resolving the conflicts between the target and source database.
• Configuring parameters for DDL support in golden gate replication
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement
• Creating batch files and automating the tasks
• Granting roles and privileges to end users
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily health checkup of the database using TKPROF, AWR, ADDM.
• Monitoring alert log/system log and managing Database Locks and blocking sessions
• Defragmentation of tables and indexes for improved performance and efficiency.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux

Confidential

Oracle DBA

Responsibilities:

• Managed and monitored theOracle Real Application Cluster (2 node RAC)
• Supporting more than125 production and development databases 10.2.0.4.
• Created and maintainedfailover logical standbydatabase.
• Migrated databases from 10g to 11g using transportable table space and data pump.
• Using OracleData-Pumpfor 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.
• Maintainedcatalogserver.
• Using SQL Tuning Advisor and SQL Access Advisor to fix the SQL statements.
• Installed and configuredOracle Enterprise Manager 10g GridControl.
• Worked onPerformance Tuning OracleDBA(11g &10g) on Solaris 10, AIX 5.2.
• Installed andupgradedOracle10.2.0.1database to10.2.0.4.
• Developeda bunch ofIndex monitoring scriptsin order to sort out the unused space occupied in table spaces.
• Implemented advanced features ofOracle10g such asAutomatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR)for monitoring database performance. Modified and updated thePerformance tuning scripts.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• PerformedTuning,codingandMonitoringforOracleReal Application clusters (RAC)nodes,Production Standalone Servers via Toad.
• Creation of materialized views and fine-tuned them for better performance.
• Working Experience with latestTOADhaving new features like PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.
• Tuning SQL statements usingExplain PlanandSTATSPACK.
• ModifiedSQL*Loadercontrol scripts for example to eliminate spaces generally used for data loading.
• ConfiguredPhysicalandLogical Standby databasefor reporting environment.
• Performed administrative maintenance, monitoring onOracledatabase systems in a global 24x7 operational environment.

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

Jr Oracle DBA

Responsibilities:

• Provide backup/recovery, problem diagnosis, performance tuning, data reorganization and database upgrade support for approximately 40 Oracledatabases.
• Installed, configured and maintainedOracle10gReal Application Cluster (RAC).
• Installation and maintenance ofOracle10gData Guard for Database Disaster Recovery.
• Involved inbackup 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 andData Pump.
• Database RestoreusingRMAN, Cold Backup and Export/Import.
• Responsible for planning, testing and implementing differentbackup and recovery strategies.
• Creatingand managing the database objects such as tables, indexesand views.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
• Responsible in configuring and backing up database usinghot backups, Cold backupsandLogical backups.
• Migration / Up-gradations of Databases.
• PatchedOracleDatabase Server10gusingOpatch.
• Implemented scripts for daily monitoring likedb status, no of extents, free space
• Upgrading/migratingOracledatabases from 8i/9i to 10g.
• Performance tuning on production databases supporting the application using stats pack/AWR.
• Develop, document, and implement security configuration forOraclesoftware and database instances to comply with existing standards.
• Refresh development/test databases from copies of production.
• Performance tuning viaOEM, STATSPACK/AWRfor 9i/10g.
• 24x7 Production-on call supports for all the production databases withOracle10g/9i.

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