Summary

• Performing cross Platform migration and upgrade of databases.
• Utilized 11g new features like Real Application Testing RAT and Database Replay DB Replay to validate database performance on new Hardware.
• Expert in high availability technologies such as Oracle9i/10g/11g RAC, Data Guard/Standby Database, Database Replication/Clone.
• 8 years of experience as Oracle DBA, providing 24/7 support of both development and production 11g/10g/ multi terabyte databases on Various Platforms.
• Supporting databases for web based applications providing functionalities for CRM, Finance, Insurance and HR Operations.
• Excellent experience in Installation and configuration of Oracle 10g, 11g in UNIX/LINUX and Windows environment.
• Experience in Installation, configuration of Oracle RAC, implemented 2 node RAC environments for a 1TB database.
• Expertise in SQL, PL/SQL programming.
• Implemented strategy for partitioning and management of historical data tables.
• Experience in Upgrading databases 10g to 11g, 11g R1 to 11gR2 .
• Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 11g RAC.
• Proficient in performing day to day DBA activities like creating schemas, users and table spaces management, performing export and Import, Loading flat file data using SQL loader, Creating DB links, Materialized view creation, index creation and fine-tune queries.
• Planned and implemented DR high availability solutions using Oracle Data Guard, Golden Gate and RAC.
• Designed and implemented Oracle Real Application Clusters RAC on Linux for an OLTP application with Transparent Application Failover.
• Proficient in using Oracle Enterprise Manager OEM , Quest TOAD and Oracle SQL Developer.
• Backup of Databases Creating Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup, merged backups etc.
• Recovery of Databases Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc. .
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Developed, Modified and maintained PL/SQL code for running Batch Jobs.
• Proficient in Database Administration activities such as Upgrades, Patching, Performance Tuning, capacity planning, Shell Script Development.
• Root cause analysis of Database performance issues.
• Perform Troubleshooting of issues/errors/incidents, Collaborate with Oracle support for bugs problem resolutions and research.
• Expertise in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate issues.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Performed unidirectional as well as bi-directional replication between source and target Database using golden gate.
• Excellent working experience on EMC, NetApp, SAN and ASM Storage technologies.

Provide Performance tuning and best practices on Linux/Solaris/AIX environments. Utilized Oracle Real Application testing for workload capture, workload processing and workload replay.

• Expertise in Database performance-tuning with EXPLAIN PLAN, TKPROF, AWR, SQLTRACE, 11gOEM Grid Monitoring.
• Proficient in high-level Database/IT Skills such as System Analysis and Infrastructure Design, Operating Systems UNIX/Sun Solaris/AIX, Linux, and Windows , Computer Networks, Database Storage RAID, Raw Devices , Complex SQL queries, and data communication networks, data security, business model.
• Implemented SQL PLAN MANAGEMENT SPM based well performing well execution plans, running SQLT reports for queries on database to identify the best and worst execution plans and fixing them using SQL PLAN BASELINES.

Installation, configuration, upgrade and performance tuning of Oracle RAC.

• Planned and implemented high availability solutions using Oracle 10g and 11g RAC, Standby Database using Oracle Data Guard Physical as well as Logical .
• Expertise in supporting replication with Materialized Views and Streams.
• Expertise using Transportable Table spaces, Data Pump, Flashback Table, Flashback Database, Flashback Transaction Query, Flashback Version Query, Tablespace Management.
• Supporting Change and Release Management of database objects, code and data.
• Encrypting oracle traffic using Oracle Advanced Security.
• Expertise in maintaining Database Security using Auditing, Virtual Private Database VPD , Secured Application Context and System Privileges.
• SQL Tuning using Optimizer HINTS to speed up the SQL statements and Database Tuning using appropriate v parameter settings.
• Troubleshooting operational issues and documenting detailed resolution steps in ticketing system.
• Experience on Script Programming using Korn shell, bash shell and Shell Scripting knowledge on archiving tools like tar, gun zip.
• Experience with creating stored procedures, triggers, functions, packages, UNIX Shell Scripting and Partitioning.
• Experience with Oracle unique features like ASM, ASH, AWR, ADDM, ASSM, AMM, Undo management, Grid Monitoring and Recycle Bin.
• Experience with Oracle Configuration Management.
• Knowledge on Oracle Support processes for Service Request, bug fixes and Patch Planning.
• Knowledge of Data transfer between MSSQL Server and Oracle.
• Managed the migrations of MSSQL Server 2005 databases to MSSQL Server 2008.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Detailed technical documentation of database design, implementation and procedures.
• Excellent analytical and problem-solving skills.
• Result oriented, self-motivated, team player, ability to work independently.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS:

• Operating Systems : Sun Solaris, Linux, HP-UX, IBM AIX and Windows.
• Databases : Oracle 10g, Oracle 11g, MS SQL, MY SQL database, NOSQL Database.
• Languages : SQL, PL/SQL, UNIX Shell Scripting.
• Tools : RMAN, OEM, SQL Loader, FTP, WINSCP, EXP, IMP, Datapump, TOAD, SPM, SQLT,
• OSWATCHER, Sql Plus, Grid Control, DBCA, Data Guard, TKPROF, Golden Gate, TOAD, RDA, Streams, Oracle warehouse builder OWB .
• Other : EMC Storage, Net Backups, VERITAS, SAN Storage.