SUMMARY

• Over 7 Years of experience in full application life cycle development, testing and production in Information Technology - Software Industry.
• Experience with Oracle 9i, 10g and 11g on Unix & Windows operating systems.
• Experience with RMAN, Oracle Enterprise Manager (OEM), OEM Grid control, Oracle Automatic Storage Management (ASM), Data warehousing, Oracle Data Guard, Oracle Data pump.
• Extensive knowledge of ORACLE Data Guard & Real Application Clusters (RAC).
• Extensive DBA experience in supporting multiple instances of ORACLE database including Development, Reporting, Data Warehousing, User acceptance testing & Production.
• Experience in cloning/replicating production database using RMAN & OEM Grid Control.
• Job scheduling through crontab, O/S updates and upgrades, patches loading.
• Experience in backup/restore, disaster recovery using RMAN & OEM Grid Control.
• Experience in using data pump import/exposure utility of ORACLE.
• Experience in database migration by designing and implementing database logical and physical storage structures.
• Experience in optimizing database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
• Extensive experience in daily batch and report monitoring, space management, index rebuilds, statistics collection and other Oracle housekeeping tasks.
• Developed database support processes and automated tasks through tools, PL/SQL and UNIX Shell Scripting.
• Oracle SQL*Net, SQL, PL/SQL, writing triggers, functions and PL/SQL procedures.
• Strong analytical and problem solving skills.
• Expertise in data modeling and database designing.
• Involved in data model design and database development including PL/SQL stored procedures, functions.
• Strong Oracle PL/SQL development background besides DBA skills.
• Experience in database security strategies by creating database users, user roles, profiles and audits.
• Upgrading and Migrating Databases from lower versions to higher versions.
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning, Refreshing test and development databases, Monitoring, Trouble shooting & Tuning.
• Experience in analyzing database & rebuilding indexes to improve database performance.
• Experience in Leading, Motivating and coordinating team of developers.
• Implemented & monitored daily, weekly and monthly batch jobs in database.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008.

DB Tools: Erwin, Toad, Export, Import, Data pump, RMAN, SQL Loader, Log Miner, Change Manager, Streams,AWR,ADDM,STATSTPACK,tkprof.,SQL developer.

Hardware: EMC Clarion with RAID5, Sun Sparc E15K/E4500/420, Sun-Fire v440/v890

Operating System: Windows 2003/2005/2008 server, Sun Solaris, RH Linux 2,3,4,5, HP-UX, AIX.

Oracle Tools: Oracle 9i IAS, Designer 6i, Discoverer 2000, Oracle Web Server, Oracle Enterprise Manager & Grid Control, Forms 4.5/5.0/6i, Reports 4.5/5.0/6i, AD Utility, SQL, PL/SQL.

Other Tools: AUTOSYS, Pac2000, Net meeting, VMware Server.

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

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr. Oracle DBA

Responsibilities:

• Installed, upgraded and patched Oracle Software and associated application.
• Involved in design and implementation of Oracle Data guard.
• Involved in Backup, Restoration and Recovery strategy.
• Responsible for Oracle database upgradation from 9i to 10g and 10g to 11g.
• Setup 2 node 11g RAC database using ASM on Linux.
• Implemented ARCHIVE LOG Process and procedures for automatic copying files to development server as they generated.
• Performed I/O tuning, Performance Tuning and benchmarking using TeamQuest
• Worked intensively with Oracle support in identifying and patching the 11gR1 bugs.
• Implemented backup and recovery solutions using Shadow Image technologies and RMAN.
• Built 2 node RAC databases using oracle 10.2.0.4 CRS/ASM/RDBMS on Sun T2000.
• Maintaining Tablespaces, Storage management (SGA), Undo Management.
• Routine database activities like applying patches, Cloning maintenance & performance monitoring.
• Configured RMAN backup to tape and scheduled through Autosys on dev and UAT RAC environment.
• Generated and analyzed STATSPACK reports and monitoring statistics for performance tuning of the database.
• Tuned PL/SQL, SQL with Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM)
• Performed Database health checks, and used the notification tool to send the alerts in OEM Grid Control.
• Supported and managed Oracle 9i Real Application Clusters (RAC) environment on Red Hat Linux.
• Applied Database software fixes/patches.
• Built Physical standby databases using Data guard as part of the BCP disaster recovery strategy.
• Monitoring and tuned daily Oracle database batch and reports by making available oracle resources.
• Created database security strategies by creating database users, user roles, profiles and audits.
• Involved as an architect for Interfaces and extraction routine for electronic transfer of files from/to different company using SQL, PL/SQL, Stored Procedures and Triggers.
• Shell scripting for automated batch process.
• Perform tuning of databases based on analysis of utilities such as TKPROF, EXPLAIN PLAN, etc.
• Used data pump import/exposure utility of ORACLE to create other development and test databases.

Environment: Oracle 10g/11g, RMAN, Data Guard, Shell Scripting, Toad, RAC, Windows2005/2008, UNIX, ASM, SQL, PL/SQL.

Confidential, Danbury, CT

Oracle DBA

Responsibilities:

• Involved as Oracle DBA and as a PL/SQL Sr. Programmer Analyst
• Database Backup and Recovery solutions including RMAN Hot and cold backups, data pump and export backups, and backup scripting.
• Monitoring and tuned daily Oracle database batch and reports by making available oracle resources.
• Configured RMAN backup to tape and scheduled through Autosys on dev and UAT RAC environment.
• Involved in creating database maintenance plans, collecting statistic, rebuild/defrag indexes.
• Involved in Oracle database upgrade from 9i to 10g.
• Implemented ARCHIVE LOG Process and procedures for automatic copying files to development server as they generated.
• Activities included allocation and maintenance of rollback segments, tablespaces, data files, redo log files, mirroring of redo log files across multiple disks, creating Standby Databases and applying patches.
• Installed, Configured and fine tuned RAC for the production databases.
• Implemented optimal backup and recovery procedures using RMAN, and planned for Disaster recovery sites.
• Successfully provided 24x7 support for production, development, and test database.
• Performed Schema Management, Index rebuilding, Analyzing the tables and indexes, removing the row chaining.
• Implemented Automatic Electronic Data Exchange as per HL7 Standards.
• Responsible for making sure data storage and transmission is Secure and Auditable according to HIPAA regulations.
• Involved in conversion of data from old DB2 to Oracle database.
• Upgraded and migrated databases from Oracle 9i to 10g.
• Created database security strategies by creating database users, user roles, profiles and audits .
• Involved in the writing Interface and extraction routine for electronic transfer of files from/to different Bureaus on Oracle database using SQL, PL/SQL, Stored Procedures and Triggers.
• Created Oracle PL/SQL programs, Shell scripting for automated batch process.
• Perform tuning of databases based on analysis of utilities such as TKPROF, EXPLAIN PLAN, etc.
• Used data pump import/exposure utility of ORACLE to create other development and test databases.

Environment: Oracle 9i/10g, RMAN, Putty, Shell Scripting, RAC, HL7, HIPAA Toad, PL/SQL Developer, Windows, UNIX, IBM RS6000.

Confidential, Coral Glabes, FL.

Oracle DBA

Responsibilities:

• Involved in development of different modules using Oracle PL/SQL.
• Involved in the writing extract & Interface routine for electronic transfer of files from/to different agencies on Oracle database using SQL, PL/SQL, Stored Procedures and Triggers.
• Design and implement database backup/recovery and security strategies.
• Responsible for Database monitoring and tuning.
• Extensively used Disaster recovery techniques using RMAN.
• Responsible for application programming, Implementation and Testing.
• Involved in documenting business/functional/design requirements.
• Developed data entry screens using object oriented programming concepts such as inheritance, reusable Objects reusable functions.
• Used window functions, Structures, used dynamic data window, extensively used PowerBuilder PFC.
• Involved in designing the application using PowerBuilder and advanced PL/SQL.
• Involved in developing data entry screens for ICPC, ICJ, DYC & others.
• Responsible for Object Oriented Analysis and design techniques.
• Used PVCS version control software for configuration management.
• Development of Oracle PL/SQL programming (dynamic procedures).
• Interacted with end user to solve their production related problems.
• Attended day-to-day Database related issues and trouble shoot to resolve them.

Environment: Oracle 10g/9i, UNIX, Windows Shell Scripts, PowerBuilder, SQL, PLSQL, RMAN, Crystal Reports.

Confidential

DBA

Responsibilities:

• Installing & upgrading the Oracle database server v 9i.
• Installing & applying patches to the Oracle database server v 9i on Linux.
• Monitoring and optimizing the performance of the database. Controlling and monitoring user access to the database.
• Generated and analyzed STATSPACK reports and monitoring statistics for performance tuning (SQL usingTKPROF) of the database.
• Database Recovery (both complete and incomplete) from media failure
• Sound experience in administrating the large live production (24X7) databases.
• Performed database administration tasks for the project.
• Responsible for writing Database stored Procedures & Triggers.
• Designed and developed the general accounts module.
• Implemented Locally Managed Tablespace to manage space more efficiently, to reduce fragmentation and to increase reliability.
• Good Co-ordination with System Administrators and Network Administrators to achieve zero down time and better server performance.
• Implemented the Master module of the Sales Order Processing System.
• Extensively involved in maintaining & updating the database documentation. Migrated the Sales Order Processing from PowerBuilder V5.0 to V6.0 then to V7.0.
• Conversion of the database from MS SQL Server V6.5 to V7.0.

Environment: Oracle Enterprise Manager, Oracle 9i/10g, MS SQL Server V6.5 & V7.0, PowerBuilder, Windows 95/98/2000/NT.