PROFICIENCY

• Oracle Certified Professional with around 7 years of IT Experience.
• Around 7 years as Database Administrator with 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 the activities for data access security issues for production, testing and development database.
• Strong knowledge 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 from10g to11g.
• 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

Role: Oracle DBA Developer

Responsibilities:

• Implemented Oracle many Standalone Oracle 11g/10g/9i server as part of Agencies Data center migration.
• Upgraded the 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 ASMfailgroup 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 the product development team. Using arrays in pl/sql and bulk collect and fetch limit to optimize PL/SQL code. Working with 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

Role: Oracle DBA

Responsibilities:

• Installation and periodic upgrades of different databases on different versions UNIX boxes as per Change Management procedures.
• Upgraded the 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 the Disaster Recovery site with 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 the system global area as well as determine I/O bottlenecks on system.
• Supported the Weblogic/Broad Vision Support Team in the completion of schedule Run syncs and problem fixes.
• Worked closely with 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

Role:Sales and Oracle DBA

Responsibilities:

• Created Oracle databases for production, QA and testing purposes on Optimal Flexible architecture OFA manually as well as with DBCA.
• Installed single node RAC databases supported on ASM with 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 the 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 the developers in troubleshooting/resolving the performance problems by tuning the code.
• Automated various processes by configuring DBMS Jobs and CRON Jobs.
• Maintain/document database administration procedures and errors.
• Involved in the Capacity Planning for databases based the future business growth requirements.
• Audited the activities for data access security issues for production, test and development databases.
• Used vendor provided scripts to automate the 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.