SUMMARY

• 12+ years of Oracle DBA experience in Oracle 11gR2/11gR1/10g/9i/8i on Linux (Red Hat Linux) and Windows platforms.
• Good understanding of Oracle Database architecture and has worked on all versions 7.3, 8i, 9i, 10g, 11gR1 and 11gR2.
• Experience in configuration and maintenance of the RAC (Real Application Clusters), ASM (Automatic Storage Manager), Data Guard
• Excellent in Oracle Enterprise Manager (OEM 9i/ 10g/11g/12c) to perform monitoring and Recovery Manager (RMAN) to perform backup and recovery operations.
• Experience in implementing and configuration of Oracle 9i, 10g, 11g and 11gR2 Standby Databases.
• Proficient in Oracle Database Tuning, SQL tuning using Explain plan, TKPROF, AWR, ADDM Reports and SQL Advisory etc.
• Experience on large databases and management of multiple databases.
• Managing Database Structures, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges and Database Auditing.
• Designed and implemented backup and recovery strategies. Performed Logical backups using full/ partial export/import and Data Pump.
• Effectively used RMAN for backup and recovery with/without catalog.
• My responsibility includes database creation, tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.
• Performed Performance Tuning of Database, System Global Area, I/O, Rollback segments using different tools like Toad, Explain Plan, TKPROF reports, Spotlight and OEM.
• Experience in analytical and troubleshooting skills and problem solving.
• Experience in designing the database from architectural level.
• Expert in Unix(HP - UX), Linux Red Hat Administration
• Experience with tools like EM Diagnostics Pack, and the EM Performance Pack
• Experience in Capacity Planning, Space Management, Database Upgrades / Data Migration .
• Expert in Data Replication using Golden Gate 11g, 12c.
• Data encryption and scrubbing for security purposes.
• Excellent skill in writing PL/SQL- Database triggers, functions and Stored Procedures and shell scripts
• On-call 24x7 production support.
• Willingness and flexibility to work beyond regular hours based on business demands.
• Team player with excellent communication skills.
• Worked on site - off shore - off site model of production and development environment.
• Excellent analytical, problem solving and leadership skills for dealing with day-to-day problems.

TECHNICAL SKILLS

Databases: Oracle 11gR2/11g/10g/9i/8i,HP 3000 ALLBASE, MS Access

Operating Systems: HP-UX, Red Hat Linux, Oracle Enterprise Linux, AIX,Windows NT/XP/ 2000/2003/2008

Tools: & Utilities AWR,ADDM,ASH, Export/Import, SQL *Plus and SQL Trace, OEM 11g/12c, RMAN, TKPROF, FTP, Telnet, TOAD, STATSPACK, SQL*Loader, SQLDEVELOPER, Data Guard, Perl Programming, Metadata, data dictionary, Expdp/Impdp, Grid Control, Golden Gate 11g/12c

Languages: SQL, PL/SQL, UNIX SHELL SCRIPTING, Oracle Forms/Reports, C/C++,Java,HP4GL,COBOL

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Senior Oracle DBA Consultant

Responsibilities:

• Supporting 24X7 most critical production databases and environments towards achieving high availability and performance.
• Expertise in doing various Oracle Database Administration tasks like new software installation, database setup, database upgrade, database patching, database cloning, performance tuning etc.
• Performed database migration/upgrade from 10gR2 to 11gR2.
• Expertise in installing, configuring and maintaining Grid Infrastructure and Real Application Cluster for high availability configurations.
• Expertise in converting non RAC oracle databases to Oracle RAC databases.
• Configured servers/clients for high availability.
• Performed troubleshooting for configuration related problems in Oracle RAC environment for Oracle Clusterware, ASM, and RAC.
• Configured and Maintained Data Guard and Active Data Guard.
• Installed and configured Oracle Golden Gate 11g/12c on Oracle Database 11.2.0.4.
• Established standards, policies and procedures for Golden Gate replication.
• Expertise in implementing partial and full database replication using Golden Gate including mining from Active Data Guard.
• Devised and implemented strategies for database backups and recovery using RMAN.
• Expertise in data loading/unloading using Sql*loader, Data Pump.
• Installed and configured OEM Grid Control. Expertise in OEM administration and usage.
• Expertise in system wide performance tuning using OEM, AWR, ASH,ADDM, SQL Tuning Advisor, SQL Access Advisor and SQL Performance Analyzer.
• Performed Real Time Application testing by capturing database work load on production servers and replayed on development/test servers.
• Expertise in identification and resolution of database availability and performance issues in a timely manner.
• Provided mentoring, guidance and general oversight to less experienced staff in a variety of database design and administration concepts and issues.
• Expertise in PL/SQL coding and shell scripting.
• Developed shell scripts for Oracle DB, Session, Process, Deadlock, File system monitoring, free space in the table spaces, Free Space in ASM Disk groups and free disk space in Archive log destination for production databases. Shell Script creation to automate the data loading process.
• Database Security Administration involving creation of users, managing their roles and privileges.
• Installation and Configuration of Oracle ASM (Automatic Storage Manager) on Oracle 11gR2.
• Scheduled jobs to run on daily/weekly/monthly basis using Crontab and DBMS Scheduler.
• Carrying out export and import operations on Oracle Database.
• Understanding the existing Database Structure and suggesting the database reorganization.
• Performed capacity planning and sizing of databases based on input from business.
• Providing 24x7 on-call supports.

Environment: Oracle 11gR2/11g/10g, 9i, AIX 7.1, Linux (RHEL) EL5, SQL, PL/SQL, OEM 11g,12c,RMAN, RAC DATA GUARD, TOAD, Golden Gate 11g/12c, TOAD

Confidential, Walnut Creek, CA

Senior Oracle DBA

Responsibilities:

• Installation and Configuration of Oracle ASM (Automatic Storage Manager) on Oracle 11gR2.
• Implemented backup and recovery strategies for Oracle 11 G R2 using incremental backups and recover for copy latest features of 11g R2.
• Working on AWR reports to resolve performance issues.
• Database Security Administration involving creation of users, managing their roles and privileges.
• Monitoring of Environments using Spotlight, Grid Control.
• Installation, Upgradation and Maintenance of Oracle 11g R1/R2 on RHEL
• Upgrade of oracle 11gR1 to 11gR2) on RHEL.
• Performed as key Oracle Database Administrator, responsibilities involved designing, installation and migration of databases.
• 11gR2 RAC implementation on RHEL ES 5
• Managed Oracle RAC, Instances, database storage structure.
• Engaged at architectural level design of Database.
• Setup all Database environments like DEV, QA, UAT, and Production.
• Installation, support and maintenance of Oracle 11gR1/11gR2 RAC.
• Created schemas for development and testing activities.
• Developed and maintained Oracle backup and recovery scripts for RMAN backup/recovery strategy
• Configured Physical Standby Databases using DataGuard
• Writing effective SQL, PL/SQL codes- Database triggers and Stored Procedures.
• Scheduled jobs to run on daily/weekly/monthly basis.
• Loading Data using SQL Loader.
• Carrying out export and import operations on Oracle Databases.
• Oracle Golden Gate 11g on Oracle Database 11g R2.
• Understanding the existing Database Structure and suggesting the database reorganization.
• Performance tuning of Oracle 11gR2/11gR1/10g/9i databases including optimization of Oracle init.ora, Oracle SGA, I/O balancing and memory tuning.
• Performed capacity planning and sizing of databases based on input from business.
• Used Data Guard for data protection and data recovery.
• Before/After upgrade helped developer and business users to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.
• Writing and maintaining shell scripts.
• Provided 24x7 on-call supports.

Environment: Oracle 11gR2/11g/10g,9i, RHEL ES 4, 5, Windows 2008, SQL, PL/SQL, ETL,TOAD, Spotlight, DbVisualizer, OEM, RMAN, RAC, Shell Script, DATA GUARD, Golden Gate

Confidential

Senior Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 9i/ 10g/11gR2 on RHEL & Windows platforms.
• Upgrade of oracle 9i to 1og, 10g R2 to 11g R2 on RHEL.
• Performed as key Oracle Database Administrator, responsibilities involved designing, installation and migration of databases.
• 10 g/11gR2 RAC implementation on RHEL.
• Managed Oracle RAC, Instances, database storage structure.
• Setup all Database environments like DEV, Test and Production.
• Remained Involved in creation of users, managing their roles and privileges.
• Developed shell scripts for tracing Oracle errors, free space in the table spaces and free disk space in Archive log destination for production databases.
• Shell Script creation to automate the data loading process.
• Monitoring of the queries with high response time and high disk reads per execution (Top SQL) and tuning the same using Explain Plan, Auto trace.
• Installation and Configuration of Oracle ASM (Automatic Storage Manager) on Oracle10gr2/ 11gR2.
• Implemented backup and recovery strategies for Oracle using RMAN
• Configured Physical standby Database using DataGuard.
• Did SQL, PL/SQL coding and shell scripts.
• Scheduled jobs to run on daily/weekly/monthly basis. export and import used a lot for logical backups and data migrations
• Understanding the existing Database Structure and suggesting the database reorganization.
• Performed capacity planning and sizing of databases based on input from business.
• Used Data Guard / Streams for data protection, availability and replication.
• Installed and configured Oracle Internet Directory (OID) on Oracle 10gR2
• Troubleshooting for user connections to Oracle database through ODBC, JDBC.
• Written and maintained Unix-shell scripting procedures.
• Provided 24x7 on-call supports.

Environment: Oracle 11g/10g/9i, RHEL (ES3,4), Windows 2003/2000/NT, SQL, PL/SQL,TOAD, OEM,RMAN,RAC, Shell Script, DATA GUARD

Confidential

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 9i on RHEL 9.
• Upgrade of oracle 8i to 9i
• Worked on SQL Coding.
• Worked on STATSPACK reports to resolve performance issues.
• Remained Involved in database maintenance activities like create user, maintain storage, scheduling jobs.
• Good experience on monitoring the space utilization, monitored and managed gusers for security, monitored RMAN backups, Run databases patches and has good knowledge on database software and resolving all the production issues.
• Worked on Oracle Database administration on Windows and Linux systems.
• Configured Physical standby Database using Data Guard.
• Performed database tuning using Explain Plan, hints, utlbstat/utlestat, Toad, and Enterprise Manager.
• Provided operational support for existing models including impact analysis and coordination of change management of schema, mappings, data transformations and other metadata.
• Transported tablespaces and data using exports /imports.
• Setup all Database environments like DEV, QA and Production.
• Designed, coded and implemented backup scripts
• Tuned unorganized SQL queries by viewing explain plans and created /modified indexes to optimize the performance.

Environment: Oracle 9i, Red Hat Linux 9, Windows Server 2000, SQL*Loader, UNIX Shell Scripts, OEM, Tkprof.

Confidential, Santa Clara, CA

UNIX (HP-UX) Administrator

Responsibilities:

• Fixed client problems through Help Desk and direct
• RE-IP numbered servers and workstations from HP to Agilent domain.
• Installed HP9000 servers and workstations
• Installed HP-UX(O.S.) and application software
• Planned and implemented security strategies for servers and databases
• System performance and resources monitoring using vmstat, top, SAR, SAM, Glansplus etc.
• Disaster Recovery using IGNITE-UX
• GUI CDE/HP-VUE
• Managed print servers and printers
• DNS, SENDMAIL,NFS,DHCP,NTP, BOOTP
• NIS,NIS+
• HP-OPENVEIW Node Manager
• Supported PDM and Work-Stream applications
• Installed and configured reflection-X and Samba Server
• Scripting: ksh, csh
• Backups and Recovery using fbackup, tar, tcio, dump, dd etc. Omni Backup
• Addition of new disks, disk arrays( Nike array Model 20, Auto RAID ) and disk modules
• Upgraded RAM
• Applied patches
• Worked with HFS and JFS file systems with/without LVM.
• Installed and maintained Cadence software
• Supported Informix Databases and Maintained Tape Management System in Informix Database under HP-UX
• Supported Cadence software under Sun Solaris 2.6

Environment: HP9000 SERVERS /Workstations of D, K, V, J class, HP-UX (9.0, 10.2, 11i), INFORMIX, ORACLE 8.0, 8i, Sun Solaris 2.6, Cadence

Confidential

Developer/HP-UX ADMIN

Responsibilities:

• ERP deployment, development, maintenance & provided support in HP4GL/ALLBASE,COBOL
• Deployed Integrated Design Office Management System (IDIOMS) in Developer 2000 /PL-SQ L/Oracle 7.3,8.0,PRO*C
• Developed and deployed Purchase and Inventory System in Developer 2000 /PL-SQ L/Oracle 7.3,8.0,PRO*C
• HP-UX (7.0,9.0,10.2 ) System Administration
• Administration of Unigraphics (CAD/CAM/CAE)
• Also remained involved with Oracle DBA (7.3, 8.0) Team