SUMMARY

• Oracle Certified Professional wif around 7+ years of IT Experience.
• Around 7 years as Database Administrator wif demonstrated expertise in installation, configuration, administration and Production Servers maintenance of Oracle 11g/10g/9i.
• Expertise and Interest include Database infrastructure Design, Administration, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Used SQLPLUS PL/SQL, RMAN utility and SQL Tuning Advisor, Oracle ASM, AWR, ADDM, Statpack and support packs.
• Using EXPDP and IMPDP for export and import. Using SQL*Loader to load external data in database table based on requirement.
• Expertise in RMAN and Oracle Backup and Recovery.
• Design Relational Databases model and Implementation as per business needs.
• Audited teh activities for data access & security issues for production, testing and development database.
• Strong noledge in SQL, PL/SQL programming and debugging and strong UNIX, Linux Shell scripting experience.
• Experience in Batch processes, Import, Export, Backup, DB Monitoring tools and Application support.
• Experience in data migration from legacy systems (Data warehouse) to Oracle Databases using tools like SQL, PL/SQL, SQL* Loader and Unix Scripts.
• Expertise in very large Oracle databases of sizes up to 10 TB and experience in Oracle migration from 10g to 11g.
• Ability to adapt quickly to changing environments.
• Excellent communication and inter - personal skills.
• Accustomed to work in a team environment.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows 98/2000/XP, Vista. Programming Languages: Oracle PL/ SQL, SQL, UNIX shell scripting, C, C++, Core, JAV

Databases: Oracle 11g/10g, 9i/8i, MS Access 2000/97, MS SQL Server

Case Tools: Designer 2000, Developer 2000, Toad, Ultraedit.

Reporting Tools: Oracle Business Intelligence, Oracle Reports, Cognos

ETL Tools: Informatica, Talend

Utilities: SQL Loader, Tkprof, Explain Plan, Microsoft Office

Versioning Tools: SVN, Accurev

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Implemented Oracle many Standalone Oracle 11g/10g/9i server as part of Agencies Data center migration.
• Upgraded teh database to 10.2.0.4 from 10.2.0.1 version using Patchset.
• Upgrade Database from 10.2.0.4 to 11.2.0.1.
• Backup and restore using RMAN utilities, Disaster Recovery testing, recovery Catalog and refreshing databases on multiple environment.
• Oracle performance tuning support pack and Statspack, AWR, ASH, ADDM, RMAN, Oracle Universal Installer, OPatch and Patchset.
• Supporting Data-Guard (11g Active Dataguard) for customer data service.
• RMAN backup and recovery strategy using incrementally updated image copy backup.
• Configured and Maintain Dataguard for Production Database.
• AWR report generation and wait analysis for performance.
• Support customer having disk space issues, ASM disk repair when disk replaced by IT people.
• Re-creating ASM failgroup etc.
• Expdp and impdp utility for exporting database across 10g and 11g version. Using version parameter for version compatibility. Using various other parameters for exporting and importing.
• Writing SQL and PL/SQL for developmental work to support teh product development team. Using arrays in pl/sql and bulk collect and fetch limit to optimize PL/SQL code. Working wif developers to optimize SQL queries.
• Using and recommending partition if requires for large tables.
• Supporting physical standby database and data guard.
• Loading data in warehouse utilizing external table in no logging mode.
• Setting up materialized view for aggregate data summary.

Environment: Oracle 11g/10g/9i, Win 2008/03 Oracle unbreakable Linux 5, IIS, FTP, DTS, SSIS, ASP, XSL, XML Web Services, CSS, IIS 7/6, SSRS, SSAS.

Confidential

Oracle DBA

Responsibilities:

• Installation and periodic upgrades of different databases on different versions UNIX boxes as per Change Management procedures.
• Upgraded teh production and testing Oracle databases to 9.2.0.1 from 8.1.7 version using OPTACH & DBUA.
• Configured OEM as well as OMS (Oracle Management Server).
• Configured refresh of development and test/QA databases from production - planned as well as on-demand using export/import, SQL* Loader and cloning through RMAN.
• Performed & monitored backup strategies and plans - using cold, hot & logical backups; and full and incremental backup management using RMAN.
• Configured Physical Standby database and periodic transportation of logs to teh Disaster Recovery site wif Data Guard through maximum performance mode.
• Managed user accounts, password management, data security through data accountability through auditing; and access controls through privileges, roles and profiles etc
• Monitored memory, CPU utilization, disk utilization (I/O usage), locks/deadlocks and runtime of queries in Oracle databases.
• Performed database maintenance activities such as De-fragmentation, rebuilding tables and indexes, adding data files, rollback segments and respace management.
• Performed tuning for overall database performance, using tools as Statspack, TKPROF, & Oracle Enterprise Manager (OEM) to properly size teh system global area as well as determine I/O bottlenecks on system.
• Supported teh Weblogic /Broad Vision Support Team in teh completion of schedule Run syncs and problem fixes.
• Worked closely wif UNIX team for all UNIX related changes in production/testing environment.
• Manage database security, password expiration and database audit.
• Automate System administration tasks as scripts provided by vendor.
• Designed disaster recovery plans for mission critical systems.
• Participated in design discussions to support project.
• Regularly attended change management & problem management meetings.
• Produced and maintained documentation to controlled standards including project plans and status reports.

Environment: Oracle 10g/10gRAC/9i, RMAN,ASM, Data Guard, SQL Server2000, Sun Solaris, HP-UNIX, Windows 2000/2003, WebLogic, Websphere, ERwin, INFOMAN & OVSD

Confidential, Glenview,IL

Sales and Oracle DBA

Responsibilities:

• Created Oracle databases for production, QA and testing purposes on Optimal Flexible architecture (OFA) manually as well as wif DBCA.
• Installed single node & RAC databases supported on ASM wif logical unit number (LUN).
• Applied patches to databases as and when required using OPTACH utility.
• Upgraded Oracle databases from 9.2.0.8 to 10.2.0.1 using DBUA.
• Configured Physical Standby Database using DATAGURAD in testing environment.
• Used In-house scripts developed for Archive Log Shipping and synchronizing standby database.
• Database Partitioning of table, index, and index-organized.
• Monitored, analyzed teh database change and memory management trends using AWR, ADDM, and ASSM.
• Performed & monitored daily hot Backups using Net Veritas in production, test and development databases. Restored critical data according to user's request.
• Helped teh developers in troubleshooting/resolving teh performance problems by tuning teh code.
• Automated various processes by configuring DBMS Jobs and CRON Jobs.
• Maintain/document database administration procedures and errors.
• Involved in teh Capacity Planning for databases based teh future business growth requirements.
• Audited teh activities for data access & security issues for production, test and development databases.
• Used vendor provided scripts to automate teh system administration.
• Provided 24x7 support for production databases.

Environment: Oracle 10g/10gRAC/9i/9iRAC/8i, RMAN, ASM, Data Guard, Weblogic, WebSphere, Sun Solaris 9, Windows 2003, ER win, Net Veritas, INFOMAN & OVSD.