SUMMARY:

• I have 6 years of hands - on experience as an Oracle Database Administrator. Am proactive, quick to comprehend instruction and apply new skills. I have the ability to multitask, prioritize duties and respond promptly to production and/or mission-critical issues and needs. I have excellent troubleshooting, problem-solving, organizational and documentation skills. Strong communication skills and consistently ahead of schedule. Good and flexible team player that gracefully accept changes to work.Extensively worked on Migration, Upgrades, Backup and Recovery, Performance, Installing, configuring Oracle 12c, 11g and 10g, Patch Installation, Cloning, Replication, Database Security, Memory Management Database on AIX, Linux, UNIX and Windows environments. Experienced in configuring and managing Oracle Real Application Cluster (RAC) 10g/11g and Data Guard for Oracle High Availability.
• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning. Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listner, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.
• Experience as 24x7 productions DBA as well the application (development) database administrator.
• Proven experience in troubleshooting issues related to Oracle RAC (Node Evictions, Node Reboots).
• Experienced with all facets of Oracle DBA day-to-day activities like production, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.
• Experienced in working with very large 24x7 Oracle RAC 10g & 11g databases on ASM of nearly 80GB to 22TB.
• Experience in database patching, cloning, upgrade, migration & maintaining standby db server (DR).
• Experience with database backup, recovery, and setting up disaster recovery Database servers.
• Experienced in writing and designing the SQL queries as well as have extensive knowledge of Relational Database Management Systems. (Normalization, De-normalization, Entity Relationship diagram, DFD etc)
• Extensive Experience in working with the Tools like OEM, AWR, ASH, ADDM Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines.
• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
• Installed & configured Oracle Management Server (OMS) & Oracle Grid Control.
• Extensive knowledge in maintain Oracle Cluster ware using svrctl, Crsctl, has, ocrconfig, cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage.
• Expertise in all the phases of Software Development Life Cycle (SDLC).
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.
• Experience in Data Migrations.
• Experience in doing upgrades including maintenance & monitoring implementation.
• Extensive knowledge in UNIX platforms includes HP, SOLARIS, AIX, and LINUX
• Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.
• Knowledge in configuring ASM (Automatic Storage Management)
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Worked on Data transferring with export/import utilities and Data pump.
• Highly experienced in performance monitoring/tuning/troubleshooting.
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• Experienced in working with DBVERIFY utility and other method to find Data Corruption.
• Experienced in resource management like data files with ASM (Automatic Storage Management) (Trouble shooting, Add, Remove Files etc.), online redo log files, control files. Allocating logical storage structures like tablespace, schema and extents as well as configuring Oracle databases on Multi-Threaded Servers Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.

TECHNICAL SKILLS:

Operating Systems: RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000, HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1

RDBMS: Oracle 12c, 11g, 10g, 9i, 8i, SQL server

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL.

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Oracle Database Administrator

Responsibilities:

• Used Oracle Enterprise Manager (OEM) 11g, 12c and 13c Grid Control for monitoring multiple database, notification of database alerts, and configured EM agents on multiple database servers. Have deployed OEM13c agents to targets.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 12c for re-organizing Databases/Schemas/Tables to improve the performance.
• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations. Hands on oracle cloud experience. Created oracle cloud services and performed database backups to the cloud.
• Have efficiently worked on ATG databases.
• Perform day to day activities like backup-restore, space management, monitoring database alerts, performance tuning.
• SQL query tuning using reports generated by tools like StatsPack, AWR, ASH, ADDM, TKPROF, SQL*Trace and Explain Plan
• Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS STATS package.
• Successfully setup a 2 node RAC infrastructure for SANDBOXS.

Environment: Oracle 11g/12cRAC, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, postgreSQL server, OEM.

Confidential, Cambridge, MA

Oracle Database Administrator

Responsibilities:

• Supporting multiple databases for production, development, test and staging purposes on Linux, Sun Solaris, and Windows environments.
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.
• Installation of 12c OEM and customize it to our needs.
• Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.
• Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
• Automated the Data Replication process using Materialized Views for reporting databases.
• Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g/11g environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Alert management, Created and setup alerts to send notification to Users from application wherever necessary.
• Perform day to day activities like backup-restore, space management, monitoring database alerts, performance tuning.
• Proficient in troubleshooting Node Eviction in Oracle RAC Environment
• Applied PSU patches and other database related patches.
• Have a good experience in administering Oracle Clusterware components.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption and Configured user log on load balancing and failover on RAC database.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace. Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Environment: Oracle 11g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential, Detroit, Michigan

Oracle Database Administrator

Responsibilities:

• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
• Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Databases migrated to RAC for improved resiliency and performance.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication. Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Knowledge in Golden Gate installation & Configuration setups in both windows/Linux environments.
• Provided valuable inputs for various performance tuning issues.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
• Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory. Refreshed/cloned databases using RMAN utility.
• Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• Experienced in cloning the databases using HOT and COLD backups
• Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, Suse Linux, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0., SQL server.