SUMMARY

• Over 7 years of Oracle DBA Experience
• Worked on Oracle Database which were on Windows, Solaris, IBM - AIX, HP-UX, Linux
• Worked on SQL Server 2005 and 2008
• Extensive experience in databases on Oracle 9i, 10g, 11g R2
• Experience in Installation and configuration of Oracle 10/11g Real Application Clusters (RAC)
• Automated Storage Management (ASM) for 10g databases.
• Experience in setting up Grid Control.
• Comfortable with both command-line and GUI interface.
• Troubleshoot Bad SQLs, tune SQL and indexes to enhance response time.
• Extensive troubleshooting using statspack, ASH, AWR, ADDM and SQL Advisor.
• Hands on experience in implementing 11g Oracle Golden Gate.
• Experience on Oracle Enterprise Manager-Database Control, Grid Control
• Experience in data transfer utilities like SQL*loader, Data pump and import/export.
• Upgrade of database from Oracle 9i to Oracle 10g to Oracle 11g
• Experience in handling recovery issues using Oracle Flashback Technology.
• Configured ASM for Oracle databases.
• Performance Tuning experience using Explain Plan, Autotrace, TKPROF and Statspack utility and Tuning database using AWR, ADDM.
• Experience on Adding and removal of nodes in RAC environment
• Proficient in handling databases on Oracle 10g, RAC and Dataguard.
• Experience on Backup and recovery using RMAN and import/export on 9i, 10g.
• Extensive experience in database cloning and refreshing.
• Experience in Toad (Tool for Oracle Application Developers)for database maintenance tasks
• Additional responsibilities have been Interaction/Communication with Oracle for Technical Support and handling day to day problems, assisting developers and other users in writing complex queries.
• Knowledge about PERL and Shell Scripting.
• Oracle Backup and Recovery (Cold backup / Hot backup / RMAN backup).
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import).
• Strong experience in OEM (Oracle Enterprise Manager), Oracle Data Guard, SQL* Net, SQL Loader and SQL*PLUS, STATSPACK, Explain Plan and TOAD.
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Experience in Application tuning using session trace file and TKPROF utility.
• Hardworking, result oriented good interpersonal and communication skills.
• 24/7 on-call

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g, MS Access, MS SQL Server /2005/2008

DB Management Tools: Oracle Enterprise Manager-Database Control, Grid Control, RAC and Dataguard, ASM, Import Export, Datapump, SQL*Loader, Statspack, AWR, ADDM, Oracle Scheduler, Tkprof, Data Pump, Shell Script, PERL Scripts RMAN, AWR, Toad, Cron jobs.

Operating System: MS DOS, Windows 98/NT/2000, Red Hat Enterprise Linux, Sun Solaris, HP-UX, IBM AIX, UNIX

Languages: C, C++, PERL, SQL, PL/SQL, UNIX Shell, T-SQL

Web Server/Tools: IIS, Websphere, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution for multi-terabyte database issues.
• Configured and Administered Oracle 10g/11g RAC high availability on ASM.
• Installed and configured OEM Agent.
• Upgrading database fromOracleversion 10g to 11g.
• Used Export/Import and Data pump utilities for full/partial backup.
• Optimal Sizing of Instance memory pools like SGA, db buffers, shared SQL area, log buffer based on the requirements.
• Maintained different homes for Oracle 10g/11g and ASM.
• Created and maintained additional ASM disk groups according to the necessity.
• Build and configure physical standby Data Guard
• Database cloning/refresh from production to production reporting, Backup and SIT.
• Implemented and maintained full, incremental and cumulative RMAN back up’s on NAS storage.
• Restored & recovered production database via hot backup using RMAN.
• Written RMAN scripts for taking backup and deleting archive log files exceeding the retention.
• Automated several scripts to monitor various processes, sessions and taking back up’s using crontab.
• Monitoring various scripts and alert log files to ensure that Data Guard, and the database are healthy.
• Monitoring and troubleshooting space related issues.
• Implementing oracle security as per the company standards.
• Writing Perl and UNIX shell scripts
• Setup and documented Oracle GoldenGate replication on 11g for support team.
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump
• Lead activities for decomposing product requirements into tasks and associated estimates
• Mentors the team on technology concepts and ensures team compliance to best practices for design
• Tested Oracle 11g R2 Golden Gate Uni-Directional Setup between two instances.
• Mentors the team on the best techniques to debug and troubleshoot issues
• Participates in code and design reviews to ensure quality and conformance to product standards
• Participate in Oracle Best Practices and new product web presentation.
• Helps motivate team members to get the best out of team.
• Installed 10g/11g databases and Clients on RHEL and other win/*nix platform.
• Configure ASM packages on Linux.
• Installed ASM disks.
• Manage ASM disk groups via ASMCMD and database control.
• Managed 4 node RAC cluster.
• Troubleshoot RAC issues with olsnode, crs stat, crs register, crs unregister, crsctl, cssd, crsctl, srvctl etc.
• Multiplex OCR and Voting Disk to different location for higher availability.
• Add and delete node in RAC environment.
• Stop and start nodes via srvctl and manually.
• Reconfiguring Services via srvctl utility
• Worked with Oracle to solve multiple RAC issues

Environment: Oracle 10g/11g RAC, Data Guard, OEM, RMAN, RHEL, TOAD

Confidential, Westmont, IL

Oracle DBA

Responsibilities:

• Designed, configured and installed Oracle Real Application Clusters on a 3 node Cluster.
• Performed backup and recovery activities on the RAC databases.
• Experience in taking backup of OCR.
• Experience in adding and removal of nodes in a RAC environment.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export.
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Designed the database schema and created any necessary database objects.
• Monitor production and non-production database through Grid Control, Optimize queries, startup, shutdown and configure agents to communicate with grid control for various different maintenance tasks.
• Configured and maintained Grid Control Repository and Deployed OMS Agents on different database servers.
• Added nodes to the RAC cluster for the increased load balancing and removed it.
• Applied patches or upgrades to the database as needed.
• Created number of LINUX shell scripts for various tasks.
• Worked on Oracle Metaling in case of problems.
• Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan, AWR and ADDM.
• Tuned memory structures such as the database buffer cache, shared pool, and library cache.
• Setup physical standby database to protect mission critical from any failures, errors or corruptions·
• Configured ASM for RAC setup and non RAC databases.
• Worked closely with application developers and system administrators to ensure all database needs are being met.
• Managed databases with size more than 2 TB.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Applied various database and Application patches
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Applied various database and Application patches
• Used Grid Control for Backup and Recovery tasks.
• Solved database connection issues using Oracle Net Services.
• Applied various patches which includes quarterly critical patch.
• Upgraded oracle clients as per application needs.
• Applied DST patches on multiple platforms. Multiplex OCR and Voting Disk to different location for higher availability.
• Add and delete node in RAC environment.
• Stop and start nodes via srvctl and manually.
• Configured Agents on different platforms to communicate with Gird Control.
• Configured and maintain Grid Control Repository.
• Configured Listener from multiple homes in one server.
• Provided full DBA support for Oracle Applications in Production, Test and Development environments
• Worked very closely with ORACLE for Data Guard implementation and other major issues.

Environment: Oracle 9i/10g, RHEL 4, IBM-AIX 5L, OEM (Grid Control), RMAN, RAC and Dataguard, ASM, PL/SQL, TOAD and SQL *PLUS.

Confidential

Oracle Database Administrator

Responsibilities:

• Duties included all aspects of Oracle Database administration including oracle installation and upgrade, patching, performance tuning, database maintenance and database backup and recovery.
• Used RMAN to perform HOT database Backup and Recovery.
• Installed and configured Oracle Database 9i, 10g.
• Performed database transfer using SQL *Loader, import export and Datapump.
• Performed Cloning of the databases from production to test environment and done subsequent refreshing.
• Utilized Oracle Enterprise Manager (OEM) Grid Control to manage Tablespaces, indexes, sessions, schemas and monitor instance locks, long running queries, listeners, free space, extents growth, etc.
• Scheduled jobs using Oracle Scheduler and Cron jobs
• Involved in data modeling with System Analyst and Lead DBA
• Provided guidance to developers for writing optimal code for better performance.
• Suggested/Implemented tuning measures both proactively and reactively.
• Performed tuning by various tools like STATSPACK and tkprof, v$views.
• Created logical standby database from hot backup of primary database
• Handling backup and recovery activities on RAC configured database.
• Handling Performance related issues on RAC environment.
• Configured ASM on Test environment.
• Performed physical and logical data modeling using ERWIN

Environment: Oracle 9i/10g, OEM (Oracle Enterprise Manager) Grid Control, RAC and Data Guard, ASM, SQL *PLUS, PL/SQL, Sun Solaris 5.9, RHEL, Windows NT, RMAN, OEM, Statspack, Tkprof, PERL Scripts.

Confidential

Jr. Oracle Dev/DBA

Responsibilities:

• Analyzed, developed and maintained Oracle Forms and Reports for a newly designed Management Information System.
• Designed coding specification and documentation.
• Studied the systems, analyzed and designed software, monitored the phases of SDLC (Software Development Life cycle), understood the user requirements
• Built Query, generated adhoc reports based on the user requirements in MS-Access and SQL
• Performed data migration from MS-Access to Oracle and vice-versa based on the user requirements.

Environment: Oracle Forms, PL/SQL, SQL *PLUS, SQL, Oracle 8i/9i, Windows NT, UNIX