SUMMARY

• Experienced and motivated Oracle Apps DBA with Oracle Core DBA accomplished in delivering Administration, Design and Developing Applications, performance tuning, installation, support, upgrade & migration of multiple database versions, backup and recovery.
• Over 7 years of experience in as an Oracle Database Admin (11g/10g/ 9i) in Production and Development environment. Worked in 24x7 production environment and provided on - call and day-to-day support.
• Experience in DBMS Products Oracle 9i/10g/11g, MS SQL Server 2005/2008.
• Experience in configuring and managing 7-node RAC database andused ASMCMD command-line utility to manage ASM disk groups,administering ASM storage by adding Disks to the Disk groups
• Experience in installing and managingGolden Gate on stand-alone and on multi-node RAC, upgrading Golden Gate software from 9.5 to 10.4, 10.4 to 11.1 and 11.1 to 11.2
• Experienced as an Oracle Applications DBA in Production Support, Handled System admin and DBA tasks - Concurrent Managers, Profiles, Custom Module deployment and Installation, Patching, Cloning and Upgradations
• Oracle Apps DBA R12/11i (11.5.10.2, 11.5.9) administration, New Design, Upgrades, migration, regular maintained activities, Worked on Oracle Applications Database upgrade from 11.5.9 to 11.5.10.2 and 11.5.10.2 t o R12 and on R12.1.1 to R12.1.3 (Applied AD Patch to upgrade patch level from R12.AD.B.1 to R12.AD.B.3 and RUP patch for enhancement to R12.1.3).
• Successfully upgraded from Oracle 9i to 10g and 10g to 11g can support smooth and accurate conversions from legacy Oracle (other database upon assessment) to the latest release of Oracle. Also, applied time to time Oracle Patches to the existing Production, development and test environment databases
• Proficiency in Programming Languages PL/SQL and Shell Scripting. Installing RPM’s and Hands on LINUX/UNIX Systems and Scheduling jobs using Crontab.
• I’m an adaptable and efficient team player with excellent communication skills at all levels. I’m looking for a role where I can develop my skills further, researching new technologies and reveling in new challenges.

TECHNICAL SKILLS

• Oracle 10g.x/11g.x
• Oracle RAC 10g.x/11g.x.
• Oracle Application 11.5.x/12.x.
• Ms-SQL Server 2005/2008.
• RHEL
• OEL
• Solaris
• AIX
• Windows
• UNIX.
• Golden Gate 9.x/10.x/11.x
• Flash back.
• Data guard
• Data pump
• Migration.
• Upgradations
• Patching
• Cloning.
• User management
• Security
• Roles.
• Oracle Networking
• SQL Scripting.
• Performance Tuning
• AWR
• ADDM.
• RMAN
• Sql * Loader
• ASM
• TKprof.
• Crontab
• PL/SQL
• Stats pack
• Profiles.
• Forms
• Reports
• Utl file
• AD Tools.
• Stored Procedures
• Triggers
• Cursors
• Toad 12.x
• Spotlight
• Toad Data Modeler.
• Benchmark factory
• Shell Scripting.
• SQL Developer
• Insider
• Golden Gate.
• SAN
• Open filer
• Cluster ware
• Cluvfy.

PROFESSIONAL EXPERIENCE

Confidential, Knoxville, TN

Oracle DBA

Responsibilities:

• Responsible in upgrading RAC and Stand-alone databases from 11.1.0.7 to 11.2.0.3 and 10.2.0 to 11.2.0.3.
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.
• Evaluated and implemented new technologies. Deployed and maintained 50+ servers that include VMware, Microsoft and Unix platforms
• Responsible in leading the project and writing shell scripts to automate the process ofupgrading Golden Gate from 11.1.1.1.1 to 11.2.1.0.14
• Refreshed/instantiated Physical standby database using advanced 11gR2 features like Active Database Duplication (ADD) from stand-alone to 2-node RAC and vice-versa.
• Used extensively Flashback’s feature of Guaranteed Restore point on standby-database to perform large sized data-exports to not disturb the Primary database and placed the database back to Standby mode
• Responsible in performing Data guard Switch-over and Switch-back exercises during the maintenance window.
• Responsible in leading the project and writing shell scripts to automate the process ofupgrading Golden Gate from 11.1.1.1.1 to 11.2.1.0.14 .
• Wrote shell scripts to automate the process of monitor file-system usage, switching Archive log destination, database monitoring etc
• Performed logical backup using export and import utilities. Creating table spaces, tables, views, scripts for automatic operations of the database activities.
• Performing the daily tasks of a DBA including alert logs, backups, space management and health check of the databases.
• DesigningTables, Constraints, Views, andIndexesetc. in coordination with the application development team.

Environment: Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM, Golden gate, RAC, RMAN, AWR, ADDM, ASH, TTS, Data pumps, Exports/Imports.

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

• Oracle Applications 11i/R12 Maintenance, Patching, Performance tunings Apps Development and Database Support & Maintenance.
• Oracle Apps on AD utilities.
• Applied patches (One-off, Mini-patch, Rollup Patch, CPU) and performing AD activities and Trouble shooter several worker issues and used default files to reduce patch timelines.
• Resolve the view log/out files issue of concurrent requests, TAR support, database tuning, CM administration
• Monitoring tablespace free spaces, re-sizing datafiles, Alert log trace files.
• Responsible for cold/hot and rman backups.
• Cloning Oracle RAC Applications R12 from production RAC to uat RAC & NON-RAC environment.
• Cloning Oracle Applications 11.5.9, 11.5.10.2 from production to uat NON-RAC environment.
• Oracle 9i and 10g 2-Node and 3-Node RAC installation and configuration.
• Oracle Clusterware installation and database upgradation from 9i RAC to 10g RAC.
• Good exposure of using Oracle performance tools like AWR/ADDM, STATSPACK, Explain plan, TKPROF, SQL Trace, ANALYZE Indexes Opatch.
• Performance analysis of different database objects. Development of the front-end functionality
• Create various Stored Procedures and Database triggers. Monitoring the Tablespaces Usage and Indexes usage regularly.
• Storage management, sizing the database objects, monitoring Disk usage. Monitoring the Backup Status. (Exports, Cold Backup, Hot Backup).
• Debugging the bugs in SQL using toad and troubleshooting end users problems. Migrating data using Import and Export utilities.
• Creating RMAN backup, recovery catalog. Gathering Statistics by using Stats pack.
• Loading data using SQLLDR from flat files.

Environment: Oracle Applications 11i/R12, Oracle 9i, 10g, 11g, RHEL 4.2, SQL, Windows 2003 with active directory, PL/SQL, OEM, TOAD, SQL Developer, SQL*Loader, NT, ASM.

Confidential, Allentown, PA

Oracle Database Administrator

Responsibilities:

• Creating HL-7 files using SQL scripting and PL/SQL. Supporting Medical Coding Department, Design and implement various structures for all physical objects.
• Creating Procedures, Triggers, and Cursors and writing Shell Scripts for loading data and Automation of Database Tasks.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2008/2005/2000 and Involved in upgrading SQL Server from version, Have good experience with partitioned schemas, partitioned tables and indexes, creating File groups using SQL Server 20005.
• Worked as an Oracle Development DBA Supporting Development Team.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues.
• Compared schemas, databases, TNSNAMES.ora file and Tablespaces for better understanding of databases between test and production environment.
• Unloading Databases data in to flat files and vice versa Using UTL FILE Package. Configuring Database Links, Managing Oracle Networking.
• Performed logical backup usingexport and import utilities. Creating tablespaces, tables, views,scripts for automatic operationsof the database activities.

Environment: RHEL, Oracle 9i, 10g, 11g, SQL, Oracle Grid Control, OEM, Database Control, TOAD, SQL Developer, SQL*Loader, NT, ASM.

Confidential

Junior Oracle DBA

Responsibilities:

• Involved in Installations, Upgradations, Patching, Cloning and Backups. Logical Backups Using Datapump utility.
• Installation and implementation of the Oracle9i/10g on Sun Solaris & Windows NT 4.0
• Manage the database for over 10T sizes.
• Implement the automated Hot Backup scripts for the Daily full backup created in bash Shell.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Changes were made dynamically whenever possible to fulfill high-availability requirements.
• Maintained standby databases, in both local and remote locations, for fail-over purposes.
• Performed RMAN Incremental and Cumulative Backups, Migration of Schemas from one Database to other Databases on different Platforms.
• Performance Tunning Using Insider Tool, Writing Shell Scripts & Scheduling jobs in Linux Platforms Using Crontab.
• Loading CSV files using SQL*Loader, Creating Cursors in Stored Procedures. Creating ROW and Statement Triggers.
• Supporting Medical Coding Department. Coordinating with Quntim Lead & Project Associates for evaluate all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects.

Environment: Oracle 9i, 10g, SQL, Oracle Enterprise Manager Database Control, SQL Developer, PL/SQL, SQL*Loader, NT.