SUMMARY

• Over 13+ years of hands on experience in managing databases on Oracle 8i/9i/10g/11g/12c versions - Software installations, Patching, Upgradations, RMAN backups, Performance Tuning, Disaster Recovery, DB migrations, Database creations, Automation through shell scripting, Troubleshooting etc.
• Hands on Oracle 12c Multi-tenant architecture databases - Container and Pluggable databases
• Monitoring and administering ORACLE RAC databases on oracle 11g/12c RAC Clusters.
• Designed and developed plans to achieve high availability, scalability, recoverability of teh databases.
• Proficient in applying various patches including One-off patches, PSU, Bundle patches and Release Update (RU) and Patch Sets on stand alone/RAC database homes and GI home binaries.
• Performance Tuning - Tuned various large critical OLAP and OLTP databases and SQL queries using various tools like STATSPACK, AWR, SQLTrace, TKROF, ADDM and Explain Plan etc.
• Expertise in Database Backup and Recovery concepts using RMAN utilities - Refreshed development and test databases from teh copy of production databases through active cloning, Restored and recoverd databases from tape backups, disk backups in a temporary databases.
• Hands-on experience in oracle RAC Clusterware/Grid infrastructure administration,configuration and Patching, RAC Backup and Recovery.
• Performed complete database reorganization to defragment teh very big tables and indexes in one of teh very large database - Released approximately 1TB free space in teh file system level and performance of few SQL queries was improved.
• Migrated databases to Super cluster and upgraded it to 12c version; Also, migrated very big databases to Super cluster (Linux to Solaris) using Transportable tablespace (TTS) feature.
• Scheduled UNIX shell script in teh critical production databases to generate long-running SQL query details and send it to DBA team group for further analysis.
• Hands-on experience in LOGICAL BACKUPS using EXPDP/IMPDP and EXP/IMP tools.
• Expertise in upgrading databases to latest versions - Different versions of Oracle 9i to Oracle 10g, oracle 10g to oracle 11g, oracle 11g to 12c, Oracle 9i to Oracle 11g etc.
• Designed and implemented Backup mechanism(Weekly once FULL backup, and daily INCREMENTAL backup and ARCHIVELOG backup when file system reaches 80% utilization) wif UNIX shell scripts.
• Hands-on experience on migrating databases to ASM storage from tradional file systems. Also, migrated very large databases to BIGFILE tablespaces.
• Performed SWITCHOVER exercise in oracle 2-node RAC databases to reduce downtime on critical databases during OS patching.
• Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
• Experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB tools. Also extensively used SRVCTL and CRSCTL utilities to manage RAC databases.
• Created UNIX shell scripts for automation of schema refreshes, pre and post tasks of database refreshes, database monitoring, daily schema backups, pre and post database outage taks etc.
• Good exposure on Oracle GoldenGate Architecture components. Implemented bi-directional mirroring for one of teh business critical application.
• Exposure on Enterprise Password vault (EPV) which will be used to store all teh databases schemas password wif appropriate securily. Also used Right Answers utility to create,maintain technical documents in most organized manner.
• Excellent Communication skills, co-ordination and communication wif system administrators, business data analysts and development teams.
• Quick learner wif ability to develop proficiency and adapt to new technologies and methods in a short period of time.

TECHNICAL SKILLS

Databases & Related: Oracle 12c/11g/10g/9i/8i Oracle 11g RAC, Oracle 12c Real Application Cluster

Technologies/Utilities: (RAC), ASM, ASM FD,RMAN, EXP/EXPDP, SQLLDR, Active Data Guard, Dataguard Broker (DGMGRL), TKPROF, STATSPACK,AWR, SQLTXPLAIN, SQL Trace,Oracle Golden Gate,ADDM, TOAD tool, CRSCTL,SRVCTL,OUI, Super cluster, Exadata,Oracle Enterprise Manager (OEM)

Operating Systems: HP-UX, Sun Solaris, Red Hat Linux and Windows

Languages: SQL, PL/SQL, C, C++, Java, HTML, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential

Technology Lead

Responsibilities:

• Installation and configuration of multi-node Oracle Real Application Cluster 12cR2 (RAC) databases for development,test,stage and production environments on Linux.
• Responsible for applying security patches on business critical application databases every quarter as soon as they are released.
• Upgraded various databases versions from 9i,10g,11g to 12c & Grid Infrastructure from 11g to 12c.
• Applied patches in Oracle RAC databases in rolling manner to avoid critical databases outage, thus eliminating business impact while we patch our RDBMS and GI home binaries.
• Create and/or, refresh development/test databases from production database using either RMAN duplicate or restoring from backups or loading tables/schema using Data Pump utilities (expdp/impdp).
• Install Oracle agent binaries on database servers and configured production database targets appropriately in OEM to get it monitored by Oracle Enterprise Manager (OEM).
• Setup and configure Oracle 11g/12c Physical standby databases (Data Guard) to ensure high availability, where teh standby database was used for disaster recovery as well as to offload teh read-only workloads (running of huge reports).
• Assisted application developers in creating database objects like Stored procedures, Triggers, Functions, Cursors and Packages etc. Supported development teams for moving changes to different development, test environments and move changes to teh live production environment.
• Performed database point-in-time recovery from tape database backups in order to get teh table(s) dat were mistakenly deleted by application teams.
• Enabled Extended Datatype feature (oracle 12c feature) in teh databases which enables application teams to store maximum size of 32767 bytes for teh VARCHAR2, NVARCHAR2, and RAW data types.
• Oracle RAC Node-evictions - Reviewed teh log files/trace files and identify teh issue and work wif relevant teams (UNIX,NETWORK and STORAGE teams) to fix teh issues.
• Installation of oracle components like Oracle OLAP, XML-DB, Oracle context etc as per teh requirements from application.
• Backup and Recovery - Designed and implemented backup and recovery strategies using RMAN backups. Scheduled UNIX shell script for FULL database backup (once in a week), INCREMENTAL backup (daily) and archivelog backup when archive log file system reaches 80% utilization.
• Performance Tuning - Proactive - Identify and tune poorly performed SQL queries using EXPLAIN PLAN, SQLTXPLAIN, SQL Trace, AWR, ADDM, STATSPACK, TKPROF tools.
• Performance Tuning - Reactive - Work wif application team and get teh details of poorly performing SQL query, verify, tune teh query using SQL plan base lines, SQL profiles, indexes, hints, ADDM, Automatic SQL tuning etc.
• Applied one-off /interim patches (Only when oracle support team suggest us) to fix teh known bugs in teh databases. These patches are also applied in rolling manner in oracle RAC databases.
• Implemented shell scripts and scheduled to automate daily backups of few critical schemas; Also, automated schema refreshes in some databases as per teh application teams request.
• Monitor and report Database server performance issues by identifying CPU, memory, me/O bottlenecks in teh server.
• Installation of Trace File Analyzer (TFA) utility and configured oswatcher,procwatcher tools in teh database servers which enables us to troubleshoot and fix teh critical issues.
• Available 24x7 for production database maintenance activities and on-call support for critical business application databases when required.

Environment: Oracle11g/12c, RedHat Linux,SunSolarix,Kornshell,GRID INFRASTRUCTURE 11.2.0.4,12.1.0.2,, RMAN, RAC and Active Data Guard, Explain Plan, Oracle Support, Data Pump, Toad, AWR, Exadata,Sql *Loader, Super cluster Exadata Half Rack, Enterprise password vault(EPV), Right Answers, OEM, TKPROF,SQL*trace, SQLTXPLAIN,ADDM.

Confidential

Sr Oracle DBA

Responsibilities:

• Supported 24x7 mission critical applications running on Oracle 9i/10g/11gR1 for Standalone and RAC databases on ASM storage.
• Worked wif relevant teams (UNIX,NETWORK and STORAGE) and created 4-node oracle RAC databases on Dev/Test/Stage/Production boxes and migrated data from old legacy system to new systems.
• Installed oracle 11G binaries in teh newly built systems and applied latest patch set on top of oracle base software. Migrated teh database to new system and tan upgraded teh database to 11g using manual upgrade steps.
• OEM Agent installation on stand alone/RAC database servers, discover teh targets in OEM and enable OEM monitoring for production database targets.
• Performed oracle 11g full client installations on Linux/sunsolarix/windows production boxes for client application database connection.
• Configured standby databases for high availability, data protection and disaster recovery for business critical databases.
• Performed table(s)/schema/database refresh in Dev/Test databases from teh copy of teh production database using RMAN and data pump utilities expdp/impdp.
• Worked wif UNIX teams, SAN storage admins for teh configuration of ASM disks and ASM Diskgroups.
• Intensively used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitoring (ADDM) reports for health check of teh databases.
• Performed capacity planning, space monitoring like tablespace growth using teh scripts and from teh AWR historical data. Also, Monitor teh CPU usage, memory usage, me/O contention on servers using top, iostat, sar, glance, vmstat, etc.
• Up-graded databases to Oracle 11gR1 from oracle 9i and Oracle 10g versions.
• Applied Bug fix patches (one off patches), CPU patches, patchsets on top of GI and RDBMS binaries using OPatch utility and OUI in RAC and non-RAC database servers.
• Discussed and developed long-term strategy to retain audit data for longer periods by keeping only last 7 days worth of audit data in teh AUD$ table in teh database.
• Implemented Flashback technologies to recover data from Human errors by creating guaranteed restore points in teh database periodically.
• Analyze, Identify and resolve locking conflicts in teh databases.
• Maintain consistentency in teh database parameters and system settings across all teh databases of development to test to stage to production life cycle.
• SYSAUX tablespace abnormal growth - Analyzed and identified teh list of components dat are contributing to SYSAUX tablespace growth and purged teh records from SYS tables dat are older TEMPthan retention period.
• Worked wif application teams and halped them to tune teh problematic SQL queries using SQL TRACE, SQLTXPLAIN, TKPROF, ADDM, EXPLAIN PLAN utilities.
• Scheduled UNIX shell script to generate long-running SQL query details and send it to DBA team group for further analysis.
• Provided 24x7 on call support for multiple large business critical application databases.

Environment: Oracle11g/10g/9i,Red Hat Linux,SunSolarix,Kornshell,ASM, CRS, RMAN, RAC and Active Data Guard, Explain Plan, Oracle Support, SQL Developer, Data Pump, Toad, AWR, OS WATCHER, Sql *Loader, ADDM, Data guard, OEM, EXPLAIN PLAN, SQL TRACE, OUI, EXPIMP, STATSPACK,OPATCH, EXPDP/IMPDP, Shell scripting, Performance Tuning.

Confidential

Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 9i/10g databases on Redhat Enterprise Linux platform.
• Applied patch sets, CPU patches and one-off patches on top of oracle RDBMS home binaries.
• Migrated teh data from old systems to newly build systems using logical backup data pump expdp/impdp tools.
• Prepared UNIX shell scripts to perform schema migrations from source database to target databases.
• Performed Table(s)/Schema/Database Refresh in Development and Test databases from live production databases.
• Proactive and reactive performance tuning. Worked wif application teams and gathered details on teh performance issues and halped them to tune teh queries by suggesting indexes,hints,query re-write etc.
• Designed and implemented backup strategy and scheduled a script to backup teh database regularly.
• Create, configure, manage schemas, users, tablespaces in teh databases.
• Worked wif application teams and understood about teh purpose of each schema in teh database and performed cleanup of elevated access from all teh schemas by assigning only appropriate mandatory system,objects privileges and roles to users in teh database.
• Enabled SQL trace for problematic sessions and generated TKPROF output file, analyzed teh file and fixed SQL query performance issues.
• Created LOGON trigger to restrict direct access to few schemas in critical production database from TOAD/SQL*plus/SQL Developer tools as per teh application team request.

Environment: Oracle 8i/9i/10g, Sunsolaris,Red Hat Linux, HP-UX, Korn shell,ASM, CRS, RMAN, Active Data Guard, EXP, IMP, EXPDP/IMPDP, Shell scripts,Explain Plan, Toad, SQL*trace,TKPROF, PL/SQLTriggers.

Confidential

Oracle DBA

Responsibilities:

• Responsible for installation,configuration and maintenance of different versions of oracle 9i,10g and 11g databases.
• Also, installed various versions of oracle client software in teh application servers.
• Applied critical patch updates (CPU) patches in business critical databases every quarter as soon as they are released.
• Upgradation of databases from 8i,9i,10g to oracle 11g version. Also, upgraded few old databases to oracle 10g version as well.
• Refresh table(s)/schemas/database in development and test databases from teh production databases using logical backup tools exp/expdp/imp/impdp and RMAN backup.
• Applied PSU patches and latest patch sets on top of RDBMS home binaries in which business critical databases were running.
• Create and manage users, roles, privileges,tablespaces,tables, indexes and other database objects.
• Analyze,identify and resolve Database Locks and blocking sessions.
• Rebuild all teh indexes dat are fragmented. Also, performed defragmentation of tables to get teh HWM right up to actual used space.
• Generated AWR,ASH,ADDM reports for teh databases during problematic periods; Configured statspack reports and scheduled a job to generate snaps for every hour for teh databases which we do not have AWR license.
• Generate SQL TRACE for teh sessions experiencing performance issues and use TKPROF to generate output file which can be easily analyzed.
• Gather table/schema/database statistics to get accurate statistics about teh objects which are mandatory for optimizer to generate appropriate execution plans.
• Restored database from teh tape backups in a temporary database to a specific point in time and performed recover in order to get teh data dat was deleted unknowingly by application teams.
• Worked on teh database alerts dat were generated by Oracle Enterprise Manager (OEM).
• Work wif application teams to deploy new objects/modify existing database objects in stage and production databases.
• Move datafiles across file systems either because of teh space issues in teh file systems and/or IO performance issues.
• Migration of databases from SAN storage to ASM storage.
• Enabled schemas to be capable of sending emails from teh stored procedure by installing appropriate packages and assigning privileges to schemas.
• Prepared UNIX shell script to list out stale application specific database standard roles, and teh list of objects for which privileges are missing in teh roles and teh script to be used to refresh teh roles. Scheduled teh script to be executed in teh production database once in a week and tan send teh report to application teams.

Environment: Oracle 8i/9i/10g/11g,HP-UX, Redhat Enterprise Linux (RHEL), Sun Solaris, ASM, RMAN, Explain Plan, Oracle Support, EXP/EXPDP/IMP/IMPDP, Putty, Toad,SQL*plus, iSQL plus, TKPROF,AWR, ADDM, Statspack, SQL *trace, Shell scripting.