SUMMARY:

• Around 8 years of experience as Oracle Data Base Administrator, providing 24x7 production support of both development and production 12c /11gR2/10gR2/9i/ databases on different Platforms
• Outstanding knowledge in Installation and Configuration of Oracle 9i, 10g and 11g in Linux/AIX/ SunSolaries/ Windows/ HP - UX environment.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 12c/11g/10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experienced in Performance tuning, creating new database,Backup
• Skilled in regular Database Administration activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, capacity planning, script development, and documentation
• Skilled in setting up/Installation and configuration of release 11gR2 RAC and 10g R2 RAC with ASM. Experienced in configuring & Managing the ASM
• Experienced with GoldenGate 11g replication for Oracle databases
• Planned and implemented Disaster Recovery & High Availability solutions using Oracle 11g/10g Standby Database using Oracle Dataguard, 9i and 10g RAC/11g RAC
• Skilled in taking backups using cold, hot and RMAN backups and also tested different recovery procedures also Cloning/Refresh
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances
• Knowledge in writing shell scripts for automation of jobs
• Hands on experience on Oracle 11g Active Data Guard/10g DataGuard with swithover, failover and Dataguard Broker
• Skilled in different environments like HP-UX, SUN SOLARIS, AIX and Linux.
• Installed and configured 10g RAC on LINUX platform with ASM disks for storage.
• Skilled in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment
• Co-ordinated in OEM12c Grid Control setup
• Skilled in Cross platform migrations from Windows to Linux, Solaris to Linux, Linux to AIX
• Skilled in database Upgrades 9i to 10g R2, 9i to 11gR2, 10R2 to 11gR2
• Skilled in using 11g/10g features Flash-Back Recovery, Data Pump, AWR, ADDM,ASH, ASM Recycle Bin, 10g Grid Monitoring
• Experienced in loading data from flat files using SQL Loader and External Tables.
• Skilled in using tools such as SQL Developer and TOAD.
• Dealing with database security and auditing
• Excellent experience in creation and maintenance of Logical Standby
• Skilled in Space Management and Security
• Skilled in MySQL, SQL Server Database Administration 2012/2008
• Experienced with Data ware house environment.
• Experienced with working on large database environment upto 25TB
• Awareness on Oracle Support processes for technical requests through Meta link

TECHNICAL SKILLS:

Operating Systems: Sun Solaris 9/10, HP-UX 11i v1.5, AIX 5.3/6.1/7.1, RHEL 3/4/5, Windows 2003, Windows 2000/NT, Windows XP.

Databases: Oracle 12C,11g, 10g, 9i, 8i, Mysql, Microsoft Sql Server 2005, Oracle 11g/10g Real Application Cluster (RAC), ASM

DB Utilities: SQL*LOADER, exp, imp, EXPDP, IMPDP, RMAN, Opatch, TK Prof, Utlbstat,Utlestat,Statspack, AWR, ADDM, QOPATCH, NID, DBVERIFY, SRVCTL, CRSCTL, ASMCMD, DBCA, ADRCI and DBUA

Scripting: Shell Scripting Korn & Bourne, C Shell

Monitoring Tools: Quest Fog light, VERITAS Net Backup, Legato backup, Cisco Tidal, Performance and Web Portals, BMC Remedy, HP Quality Center.

Tools: Oracle Enterprise Manager 10g/11g, TOAD 8.5, SQL Developer, Putty, SQL*PLUS, iSQL*Plus, ERWIN 4.14, SQL- Navigator, ERWIN, LogMiner and Flashback data Archive, Macromedia Flash, Dream-weaver, MS Office, Joomla.

Languages: SQL, PL/SQL for Oracle, C, Java, Php, XSLT.

PROFESSIONAL EXPERIENCE:

Confidential, Oakland, CA

Sr Oracle DBA

Responsibilities:

• Designed, Installed and configured the Oracle server software and related products. Upgraded 30+ databases 11gR1/R2 on RHEL.
• Supported multiple database farms including development/production sizes up to 5 TB for 24/7.
• Completely build RAC from scratch including OS and RAID configuration.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Setup and documented Oracle GoldenGate replication on 11g for support team.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and data pump. Used RDA, ADDM and AWR reports to monitor the database performance.
• Used power designer, E/R Studio for data modeling and to estimate the database size, database design reviews.
• Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers. Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.
• Implemented SQL outline to get the better execution plan for the offending queries. Setting up analyzing scripts and coordinated with development team to gather table statistics.
• Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Diagnosed Oracle bugs and coordinating with Oracle support through meta link to resolve them in timely manner.
• Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Worked on OLTP and Data warehouse farms.
• Have installed and setup Oracle 12c databases on test servers to test the multitenancy
• Refreshed multiple databases for Development and Testing upon rac and short request.
• Performance Monitoring and Tuning of Oracle Application Servers using Statspack, TKPROF, and OEM for tuning on 11g and on 12c OEM using SQL access manager, SQL tuning manager.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Perform Backup and Recovery thru RMAN.
• Strong exposure in Installing / configuring / maintaining RAC, Dataguard, Physical / Logical Standby environments.
• Provided technical troubleshooting and give consultation to development teams.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Implemented basic replication through Materialized Views.
• Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Used Oracle 11g, 12c AWR & ADDM to monitor database activities and performance tuning.
• Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
• Installed, migrated, configured and tested Oracle 11g, 12c databases in various environments.
• Extremely dedicated, self - motivated, Pro-Active and willing to assume responsibility.

Environment: Oracle 10g, 11gR1, 11gR2, OEM-12C, Linux 5.5, RHEL, Sun Solaris, IBM AIX, DBUA, RMAN, RAC, Grid, Dataguard, Exa-data, Control-m Job Scheduling, BMC Remedy Ticketing system, SVC EMC Data Domain, Net-Backup, Team quest tool.

Confidential, Hickory, NC

Sr Oracle DBA

Responsibilities:

• Worked on Oracle RAC with SRDF Implementations for cross data center replication.
• Administered the tidal job scheduler for datacenter automation tasks.
• Worked on HP Quality Centre tool for test/dev/qa code drops and environment true-ups.
• Implemented Oracle 11g, 12c OEM Golden Gate for replication project.
• Implemented Oracle 11g, 12c OEM Active Data guard for Disaster Recovery Solution.
• Worked on Implementing Oracle OEM 11g, 12c Agent cloning tasks for hundreds of servers.
• Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
• Handled Vendor applications and interacted with vendors regularly to understand and optimize the database operations.
• Actively participated on war room bridges during major releases and escalated to dba management as needed.
• Participated in database audits and following compliance rules and regulations always.
• Worked with HP service guard on top of Oracle 11g Databases.
• Participated in requirements gathering meetings with customer while building out new db environments.
• Effectively communicating with PM'S while working on project related tasks.
• Prioritizing db related tasks on daily basis and completing most of them before the close of Business every day.
• Participated in internal db team meetings with peers and management for db work/project status update.
• Worked with offshore team and co-ordinate with them always for any database changes by means of email/phone communication.
• Always uploaded the common share point repository with all updated work related documents for sharing purpose.
• Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4)& 11g Release 1(11.1.0.6,11.1.0.7) upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports.
• Production Support for Critical Application Databases, work closely with Application Team in identifying issues and provide solutions for various issues (created via IBM-CMR,IMR in-terms of incidents and work orders of different severity levels like Sev1, Sev2, Sev3, Sev4).Used IBM Mange Now.
• Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Responsible for installing(manually), maintaining, performance tuning, and monitoring of Oracle databases version 10g and 11g on AIX-5.3 in dev, QA, test and production.
• Worked with developers and management team to ensure smooth life cycle progress from development through testing and production implementation.
• GoldenGate installation, configuration for replication.

Environment: Oracle 11g/10g,12 OEM SQL, PL/SQL, Erwin, TOAD(10.1), Recovery Manager (RMAN), Tivoli, Oracle Enterprise Manager (OEM), SQL*Loader, TKPROF, Data Guard, Shell Scripts, Golden Gate, AWR, ADDM, HTML, DHTML, Windows 2008, RHEL 4.0, AIX-5.3, JAVA.

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

• 24/7 Production Database Administration Support
• Installed and Configured Oracle 10g/11g RAC.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 4 nodes per cluster.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC.
• Managing two node RAC databases on Red hat Linux advanced server 2.1.
• Performed Database migration from Oracle 9.2.0. To 10.1.0.3
• Implemented Golden Gate for Standby Configuration and developed procedures for Replication.
• Creation of Test and production databases of Oracle Enterprise Edition 8.1.7
• Monitored the growth of the database objects for capacity planning.
• Has primary responsibility for Oracle Data Base and Application performance tuning, physical/logical design and optimization and availability.
• Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and rewind entire database to a particular time respectively.
• Perform requirements gathering, data mapping, metadata management and databasemodelling.
• Designed and implemented OLS oracle 10g label cache to enable use of Hibernate with OLS and to improve performance by eliminating repeated use of Oracle conversion functions.
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.
• Backup and recovery utilizing RMAN.
• Working with the application support people to resolve database related issues and running the scripts for the application support people.
• Creating users and database links, snap shots on production and development servers.
• Maintaining system security, defining of roles, profiles etc.
• Checking CRON jobs. Monitoring Application specific background processes.
• Creating materialized views and materialized view logs to implement the table level replication for the MIS databases.
• Use Oracle Metalink Support to resolve different issues related to database servers, security patches.
• Installed and Upgraded Shareplex (3.2 to 4.1) a replication tool for reporting environment.
• Performing Online and Offline database backups on schedule.
• Scripting of Automated backup for Cold / Hot backups.
• Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.
• Installation and Maintenance of Shareplex Replication, Quest-Spotlight.
• Perform database cloning/exp/imp to setup identical databases in the production and development environments.
• Upgrade/Migrated the production and development databases from 10g to 11g.
• Involved in Database sizing, Capacity Planning.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and to see if these queries can be fine tuned for better performance.

Environment: Oracle 11g/10g, Solaris, VERITAS, OEM, EXPLAINPLAN, TKPROF, AIX, Oracle 10g,RAC,TOAD.

Confidential

Oracle DBA

Responsibilities:

• Involved in 24x7 supports for Production database and applications with on-call pager.
• Installation and creation of 10g RAC and 9i databases for Testing, Development and Production.
• Major activities include logical and physical database design, capacity planning, performance tuning, database security, disaster recovery, installation and ongoing maintenance.
• Configured Disaster Recover and Logical standby for Production database in 10G.
• Tune databases performance, Schedule backup, jobs using OEM Grid Control.
• Involved optimizing database schemas, SQL queries, database procedures, and installation.
• Cloned/Refreshed Oracle Databases using RMAN for development and testing.
• Worked with Erwin, ER/Studio, Data Warehousing, Extract Transform and Load (ETL), Oracle Warehouse Builder, SQL, PL/SQL.
• Responsible for setting and managing user accounts, Granting required privileges, profiles to users, Auditing Users.
• Written shell scripts for digitization the process and for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Supported upgrades from oracle 9i to 10g, 9i/10g.
• Performed migration from 9i to 10g from AIX to Linux.
• Tuning SQL queries using AWR, ADDM, TKPROF, EXPLAIN PLAN, and SQL TRACE.
• Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
• Worked on Data pump (Expdp / Impdp), Import / Export for logical database maintenance.
• Performing Backup/Recovery of all the Oracle databases using RMAN and also setup RMAN catalog for the same.
• Creating tablespaces sizing the system table space, allocating default tablespaces for users.
• Creating tables and indexes, sizing their extent, partitioning and so on.
• Creating users with restricted access, with default and temporary tablespaces.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Resolving SQL tuning issues and Tuning Considerations for Different Applications.
• Monitoring the table growth, database growth, current users, and system resource usage and so on.
• Experience in SQL*Loader, loading data from text files.
• Performed scheduling of Change Control-activities and scheduling jobs.
• Performed Database Reorganization regularly to remove row migrations and fragmentation using export and import utilities. Write UNIX Shell Scripts to schedule these activities.
• Contact oracle meta link to resolve database issues and to raise SR's.

Environment: Oracle 10g /9i, ASM, Sun Solaris 9, Red Hat Enterprise Linux 4.x, OEM, Explain Plan, Tkprof, SQL*LOADER.

Confidential

Jr Oracle DBA

Responsibilities:

• Installing, configuring and administering ORACLE 9i on LINUX and Solaris.
• Worked in Development Support for Oracle based systems and Unix based Server environments
• Perform capacity planning required to create and maintain database environments.
• Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and manageability.
• Planning Backup and Recovery Strategies for various database environments.
• Developed Recovery procedures that are applied for complete and incomplete recoveries depending on the type of failure.
• Created PL/SQL and shell scripts to automate batch jobs through crontab.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Writing scripts for the system and database for the effective functionality and report generation.
• Applied High priority, security patches downloaded from Meta link.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Monitoring Database for fragmentation and correcting them.
• Experienced with Space Management and Security.
• Management of table space growth, monitoring data files additions, extent growth
• Performed Database, OS and application tuning.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Used Database export/import using exp and imp utilities to take logical backups.
• Performed Data loads using SQL loader utilities.
• Contact to the development team to solve the issues with the new enhancement releases.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.

Environment: Oracle 9i, Linux, Solaris, Windows NT/2000, Toad.