SUMMARY

• 8+ years of experience in System Analysis, Design, Development and Administration on Oracle 9i/10g/11g Database.
• Upgraded the Databases from Oracle 9.2.0.8 to 10.2.0.3 to 11.2.0.3 and applied patches according to the client requirement.
• Experience in Installation, Configuration, up gradation and Maintenance of Oracle Databases.
• Installed, Upgraded and Maintained Oracle RDBMS on Linux, UNIX & Windows platforms.
• ACHIEVED High Availability, Scalability and Performance by determining the Cluster architecture choosing the best MPP RAC servers and hardware configuring the raw devices for Oracle RAC.
• Installed and Monitored Oracle 11g/10 g RAC software and experienced on Performance Tuning on RAC.
• Implemented advanced features of Oracle 11g/10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Experience in Performance tuning, Application tuning and Query Optimization using Oracle supported tools such as EXPLAIN PLAN, TKPROF, AUTOTRACE, etc.
• Expertise in creating primary database storage structures (Table spaces) and primary objects (Tables, Views and Indexes).
• Hands on experience with tools like SQL*Plus, Export and Import Utilities along with Oracle Enterprise Manager (OEM), and TOAD.
• Hands on Experience in Space Management, Capacity Planning.
• Creating Users, Roles and Profiles, Privilege management with role - based security.
• Backup of database Logical and Physical (hot and cold) using Backup script procedures and also using RMAN.
• Experience in Auditing and Capacity Planning, Configuring & Managing Hot Standby Databases (Data Guard).
• Handling Tools such as Toad, SSH, SQL Navigator, and OEM.
• Ability to work under extremely tight deadlines and can maintain focus on objectives and processes and troubleshooting, implementation and development skills.
• 24x7 production database support.
• Keep abreast of current and emerging technologies to maintain skills levels necessary to provide quality service to customers.
• Proficient in documenting the processes.
• Good communication and Interpersonal skills.
• Commitment to team work concepts.
• Effectively handle multiple tasks simultaneously and have ability to acquire and apply knowledge rapidly.
• Co-ordination with Oracle Corporation for technical support, new products and releases, technical discussion/support.

TECHNICAL SKILLS

Operating Systems: Linux, UNIX, Sun Solaris, AIX 4.2, HP-UX 11i.

Hardware Platform: Windows, HP-UNIX server, RHEL-AS 2.1.

Languages: SQL, PL/SQL, C, Bash & Korn Scripting, PERL Scripting.Tools/Utilities SQL, Import/Export, Import/Export data-pump, RMAN, SQL*LOADER,AWR, STATSPACK, iSQL*PLUS, TOAD, ERWIN, Procedure-Builder,SQL*PLUS, Enterprise Manager Grid Control and Database Control,Knowledge of Oracle Internet Application Server, DBCA, OUI, WorkingKnowledge of Data Guard.

DBMS Tech: Oracle 9i, 10g, 11gRAC.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr Oracle DBA

Responsibilities:

• Implemented 100TB of Backup system for Exadata databases machine and Exalogic Elastic cloud computing servers & VDI environment involving Oracle ZFS 7420 storage systems and HP Data protector 6.11.
• Patched 11g Grid Infrastructure & RAC databases on Exadata Database Machines.
• Patched Oracle Exadata Machine 11g R2 Grid Infrastructure and RAC databases. Involved in Exadata switch patching and cell storage.
• Configured Oracle Grid monitoring system for Exadata database machine & Exalogic on separate network.
• Implemented Oracle Virtual Machine virtualization 2 node cluster on HP Blade G470c servers for different needs.
• Implemented Database Listeners on infiniband network from Exadata Machine to Exalogic Machine.
• Worked on Scan listeners for 11g grid infrastructure.
• Administering Cell Storage servers for Exadata Database Machines.
• Extensively Administered Oracle Apps r12, 11.5.10 e-business applications on RAC.
• Upgraded Oracle APPLICATION 11.5.9 to 11.5.10.
• Patched, Cloned and administered Oracle Apps 11i with ad utilities (ADADMIN, ADPATCH, ADCTRL, and ADMERGE).
• Solved issues related to Concurrent Manager on oracle apps 11i.
• Provided installation, configuration support of Oracle RAC9i, 10g, 11g RAC databases from building server to installing databases.
• Involved in upgrading Oracle9i to Oracle10g database
• Configure workflow notifications, printers, and form servlets in Oracle financial applications.
• Cloned 2-tier, 3-tier eBusiness suite application from production to test environment.
• Involved heavily in different kind of cloning requirements. Restoring databases in same cluster system and different cluster system to other database.
• Worked extensively on HP data protector and managed system wide backups. Configured backup polices for oracle databases and system wide backups.
• Involved in patching 10g ASM instances and CPU patching for RAC instances and single instances.
• Performed 10.2.0.3 Oracle RAC Cluster ware upgrade to 10.2.0.4. Upgraded 10.2.0.2. databases to 10.2.0.4

Environment: SQL Developer, Linux, UNIX, Sun Solaris, AIX, TOAD, Spot Light, VMS Server

Confidential, Reston, VA

Sr. Oracle Database Administrator.

Responsibilities:

• Upgrading Oracle Golden gate 11.1.1.0 to 11.2.1.0.1
• Installing Oracle Golden Gate for EBS Reporting Databases
• Oracle and SQL server Database Capture using Oracle Golden Gate 11g
• Data Extract, Conversion and Load using Golden Gate
• Configuring Extract Parameters for Golden Gate EXTORA, RMTHOST, RMTTRAIL
• Configuring Replicate Parameters ASSUMETARGETDEF, REPOR, DISCARDFILE
• Creating GLOBALS for Golden Gate and Adding database checking points.
• Migrated the data from old storage to a new EMC INVISTA Storage to minimize downtime and provide High Availability.
• Migrated data on different Oracle versions of 9i and 10g, 11g and on different operating systems of AIX/Sun Solaris/Linux.
• Migrated data from File System/Non - ASM to ASM storage.
• Migrated data from ASM disks to ASM disks by using Rebalancing techniques.
• Created an RMAN catalog databases and wrote an RMAN backup script for backing up more than 5
• Production databases and few development databases.
• Recovered data files from block corruption using RMAN.
• Reduced production outages by implementing best practices of patch management, purge/archival, code
• Optimization and applied rolling patches such as PSU and CPU on RAC after testing on DEV, QA and Staging.
• Taking backup of databases using RMAN.
• Used tools like export/import and data pump export/import.
• Involved in export and import of database objects in order to copy them from one database to another &for backup the tables.
• Created a physical standby for Disaster Recovery (DATA GUARD).
• Experienced writing UNIX scripts and troubleshooting issues.
• Upgraded Real Application Cluster (RAC) from Oracle 9i to Oracle 10g on HP-UX.
• Used tools like TOAD, SSH.
• Involved in Database Tuning for the performance of databases.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as TKProf, STATSPACK, Explain plan and SQL*Trace.
• Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between two oracle servers.

Environment: Oracle 9i/10g/11g, Oracle RAC/ASM on AIX/Sun Solaris/Linux/WIN, Oracle Golden Gate 11g (11.2.1.0 and 11.1.1.), Toad, SSH, RMAN, SQL*Plus, SQL, Import/Export.

Confidential, Richmond VA

Sr. Oracle Database Administrator.

Responsibilities:

• Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• Experienced in working and monitoring the databases by using Oracle Enterprise Manager (OEM).
• Supporting both production and development activities.
• Creating of databases for Testing, Development and Production.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Setup of Standby database for faster disaster recovery and Data Guard setup for high availability.
• Written PERL and UNIX shell scripts for digitization the process.
• Load balancing, databases/schema/table re-organization for faster performance.
• Performing Capacity planning and evaluations with regular Maintenance cycles.
• Installation of Oracle version 10g on Linux.
• Applying patches whenever required.
• Migration of Database from 9.2.0.6 and to 10.2.0.2 using DBCA and Performed Validation tests.
• Upgraded from SQL SERVER 2000 to SQL SERVER 2005.
• Created and scheduled the packages using SQL server DTS packages.
• Extensively used SQL server BCP utility and IMPORT/EXPORT to load the database from text files received from different applications Continuous Performance Monitoring and Tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, STATSPACK etc.
• Monitoring and Troubleshooting of Database Replication issues using Shareplex Tool.
• Maintenance of Oracle Database. Rebuilding of Indexes, creating and managing Tablespaces and allocation tables to different Tablespaces.
• Performance Tuning of Oracle Database Objects.
• Taking periodic Backup of the database and the software using RMAN.
• Handling Database storage, Reading Alert. Log and User trace Files and Diagnosing the Problem, Scheduling jobs through Oracle job Scheduler.
• SQL Tuning for Performance of Objects.
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for Startup and Shutdown, for Health Check of Databases and for Analyzing of Tables and Rebuilding of Indexes, Scripts for Cold Backups, Script to check Oracle errors in alert log file and Send Mails.

Environment: Oracle 10g, SQL SERVER, Oracle RAC on Linux, AIX, Toad, RMAN, SQL*Plus, SQLPL/SQL, SQL*LOADER, Oracle OEM, Import/Export.

Confidential, Cherry Hill, NJ

Oracle DBA

Responsibilities:

• Migrated Database from 9.2.0.1 to 10.1.0 on HP-UX.
• Administered all database installation, creation, modification, and tuning issues of Oracle.
• Configured database using features of Oracle 9i like Undo-Tablespace, Locally Managed Tablespace, Sorting Parameters
• Analyzed the database so as to allow Oracle optimizer to choose best plan in executing the queries
• Run oracle stats pack to tune the databases.
• Wrote SQL scripts for DB monitoring, and online backups.
• Experienced in Installing VERITAS HA Clusterware to eliminate downtime, increase productivity and performance.
• Experience in Installing, Configuring and Maintaining Oracle9i Real Application Cluster Database for High Availability, Scalability and Performance which includes: Determining the Cluster architecture choosing the best MPP RAC servers and hardware configuring the raw disks for Oracle RAC. Installed Oracle9i RAC software on HP 11i PA RISC based servers.
• Implemented Oracle Replication to enable database fail over in case of system or database crash.
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing etc. which are kept in CRONJOB
• Also worked for network management.
• Creating users granting the permissions and coping with the day-to-day demands and troubleshooting their connectivity, permissions and performance problems.
• Worked with users to determine system requirements.
• Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.
• Experienced in using utilities like Export/Import and SQL Loader.
• Developed PL/SQL packages, procedures, functions and triggers to support application.
• Provided 24*7 System support.

Environment: Oracle 9i/10g, HP UX, OEM, SQL*Loader, PL/SQL, SQL, TOAD, SQL*PLUS.

Confidential, Orlando, FL

Production DBA

Responsibilities:

• Installation, Up gradation and Maintenances of Oracle Server on Linux & HP-UX 11i platforms
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN
• Recovery of database in case of database crash, disk/media failure, etc.
• Provided System support for both development and 24/7 production environment.
• Taking care of all alerts for space issues and user requests.
• Assisted in configuring optimal Oracle 9i RAC architecture.
• Performance Tuning for Oracle Real Application Clusters(RAC)
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Applying patches and Migrations works and work closely with Oracle to keep application environment up to date.
• Prepared plans for up gradation of all critical Production Databases from 8.X/9i to 10g on Linux and Data guard implementation.
• Performed database cloning from old system to new system.
• Deactivated unnecessary reports and programs from the system.
• Cloned database on new servers.
• Converted rollback segment Tablespaces from Dictionary managed to locally managed Tablespaces.
• Implemented and tested backup strategies.
• Maintained 5 instances for development, test and production environments.
• Transported Tablespaces between production and development databases.
• Deleted large number of records from the tables and reorganized all tables for better performances.
• Running scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Experienced in escalation of different critical TARs.

Environment: Oracle 9i/ Server Red Hat Linux Advanced Server/Enterprise 2.1/3.0, HP-UX.

Confidential

Oracle DBA

Responsibilities:

• Working closely with functional and development teams, involved in migrating of data from legacy system
• Configuring the Printer (Style, Driver, Type) compatible to the reports
• Applying Patches/Patchsets/Mini-packs on database using Adpatch
• Monitoring the Database Growth and providing proactive Space Management for database of 50+ GB
• Designing the Backup Strategy, Testing Strategy, Taking Backup (Cold/Hot), Maintaining Backup and Archived files on tapes and Restoring / Recovering the database as and when required
• Configuring the Production Database to be in ARCHIVELOG Mode with mirrored Control, Redo Log files
• Developed Shell Scripts
• Refreshing the Development and Test instances (in NOARCHIVELOG Mode) with Production
• Data stage Administration and Support
• Validate / Schedule / Run / Monitor Jobs using Datastage Scheduler.
• Cloning Oracle 11i Instance for development and testing purpose.
• Create and maintain custom responsibilities and menus.
• Designed and maintained schemas involving creating tables and indexes with scripts,
• Creating triggers, and creating procedures.
• Used the oracle NET8 Configuration Assistant to establish network sessions between client and server machines using host names and local names methods. (Configuration of TNSNAMES.ORA and LISTENER.ORA).
• Responsible for troubleshooting of the connectivity problems for end- users by configuring tnsnames.ora, listener.ora and sqlnet.ora files.
• Allocating system storage and planning future storage requirements for the database system.
• Maintain database security, user roles and access profiles, Involved in taking cold and hot backups.
• Daily monitoring and checking the Background Dump File (alert SID Logs) and User dump Files for errors.

Environnent: Oracle Applications 11i, Oracle 9i, Linux, HP-UX

Confidential

Database Administrator

Responsibilities:

• Installed 9i, 8i, database on Windows 2000 and SUN SOLARIS.
• Backup of database using RMAN
• Wrote control files for SQL * loader to load data into data warehouse.
• Provided database related services to their development and QA environments.
• Was actively involved in constant site enhancements along with developers - code and data push between different servers and testing and moving to production.
• Logical and Physical backup procedures.
• Data exports from production and staging databases.
• Tuned SQL queries to pull data from data warehouse tables.
• Tuned production database performances and was instrumental in SQL tuning that improved application response.
• Run oracle stats pack to tune the databases.
• Wrote SQL scripts for DB monitoring, and online backups.
• Implemented database related security measures that proved very effective.
• Implemented Oracle Replication to enable database fail over in case of system or database crash.
• Backup and recovery using cold, hot and export methods.
• Wrote database triggers, functions and procedure by using PL/SQL.
• Automated a no. of database related jobs.
• Set multiple destinations for archives redo logs for safety.

Environment: Oracle 9i, UNIX-AIX 4.2, Window 2000.