SUMMARY

• Around 8 years of experience as an Oracle DBA (12c,11g, 10g and 9i) in Production, Development and Test environments.
• Capacity planning, Architect, Installation, configuration and perform upgrades of Oracle RDBMS on different environments and platforms.
• Extensive experience of working on Oracle 9i, 10g,11g and 12c on Sun Solaris, UNIX, IBM AIX, HP - UX, Red Hat Linux, virtual machine (VMWare)
• Used Oracle Enterprise Manager (OEM) for database performance monitoring, job scheduling etc.
• In depth knowledge of Oracle Architecture Concepts.
• Create databases using DBCA and Manually. Configure Listener, Tnsnames, pfile, password file.
• Extensive experience in Recovery Manager (RMAN) and Export/Import/DataPumps backups.
• Designed and implemented Backup and strategy using RMAN (Recovery Manager)
• Good experience in applying Patch Set Update (PSU) and Critical Patch Update (CPU Patches) on Databases.
• Schema / Table level and query based normal Export & Import and also Data Pump Export & Import utility.
• Recovery of entire Database, Data files, Tablespaces using RMAN and User managed recovery.
• Good experience in Oracle Database Design, Installation, configuration and Administration, Backup and Recovery, Database Migrations. Installation of Oracle 11g RAC 2 nodes.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Automated many common tasks using crontab including Backups, exports and imports, archiving old records and verification of such processes.
• Worked on Real Application Testing (RAT).
• Upgrade of oracle database from Oracle 11g to Oracle 12c.
• Database Migration from Oracle 11g to Oracle 12c.
• Resolved database network problems using Oracle Net Configuration Assistant (NETCA) and also manually.
• Manage Data Guard, Create Physical/logical standby. Detect archival gap. Fail-over, switchover. Open physical standby. Flashback of database.
• Performance, Tuning of databases using AWR, ADDM explain plan, stats pack, TKPROF and dictionary views. Gather statistics, de-fragmentation of table, re-organize structure. Monitor memory, index, Schedule jobs, Partition pruning for big table. Top sql/session, bottle-neck issues. Tune init parameter. Full table scan and Index usage.
• Managed ASM, create and prepare disk for ASM Add/remove disk. Manage space on disk groups. Expertise on asmcmd commandline.
• Knowledge of Oracle Exadata.
• Raise SR to Oracle Support for Exadata related Issues, and works accordingly.
• Expertise in replication technologies including GOLDENGATE.
• Golden gate installation on linux environments.
• Golden Gate monitoring for online change synchronization, ddl synchronization.
• PL/SQL objects creation., SLDC, Create trigger/ function/ stored procedure/ packages. Manage cursor. Tune and trouble-shooting PL/SQL codes.
• Handle run-time errors. Write database Monitoring PL/SQL objects. Create Materialize view.
• Loading data using Import/export/ sql loader. Purging /cleansing data. Used Data Pump. Estimate timing for imp/exp. Refresh schema.
• Scripting - Shell, PL/SQL, SQL. Write script for Monitoring, maintenance. Audit and as per required.
• Supported production database servers and applications that provided secure mission and critical services.
• Worked on MYSQL environment for creation of databases and objects.
• Personal skills, Efficient in multi-tasking. Active participant, Quick start without KT. Documentation for proof of concept/process flow/Methodology. “Get it done” Attitude. Reasoning / Analytical skills.

TECHNICAL SKILLS

RDBMS: Oracle 10gR2, 11gR1/11gR2

OS: RHELv5, Linux, Hp-Ux, Solaris, AIX

Tools: TOAD, OEM grid control, Putty, sql developer, sql query Analyzer, RMAN, NETCA, DBCA, Imp/Exp, Expdp/Impdp, Data Pump, DataGuard Broker, RAC, Sql Loader, AWR, ADDM, 12c OEM, Explain plan, Statspack,SDL*Plus,Net configuration assistant, Golden Gate, Oracle universal Installer, Oracle database configuration assistant, MYSQL, MS Office

DB Utilities: SQL * Loader, Exp/Imp, Datapump Utilities, RMAN, Tkprof

Scripting Language: C/ C++, Shell scripting, Perl, SQL

PROFESSIONAL EXPERIENCE

Confidential, New York

Oracle DBA

Responsibilities:

• Worked on to gather requirements for Database upgrades from 10g to 11g. Creating the tables, table spaces, data objects, setting privileges, indexes, user logins, password (security).
• Installation and Creation of Oracle databases on standalone and RAC nodes on Solaris, Linux, HP UX and AIX.
• Provide Primary CARE DBA support for Oracle Applications and Administration, Configuration and Maintenance of RAC (Real Application Cluster) and Non-RAC Databases. Work within the production support team and maintain operational consistency and efficiency.
• Performed Backup/restore/recover using RMAN and user managed. Create backup/restore strategies. RMAN UNIX script for backup. Optimize backup/restore. Logical backup of schema using exp/imp. Clone database.
• Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups
• Upgradation of standalone and Oracle RAC databases from Oracle 11g to Oracle 12c.
• Migration of Oracle databases from Oracle 11g to Oracle 12c.
• Worked with network team to configure F5 Load Balancer.
• Logical backup using and full/ backup export/import and Data Pump.
• Applying PSU patching in a rolling upgrade fashion in RAC environment.
• Installation, maintenance and tuning of Oracle 11g RAC databases including ASM and CRS.
• Add node from cluster using addNode.sh script.
• Adding of disk groups and manage space on diskgroups in ASM.
• Set up, configured and maintained oracle Data guard (primary and standby databases) to ensure disaster recovery, rebuild standby databases.
• Tested disaster recovery by doing Switch-Over/Switch-Back before go-live.
• Configuring RMAN backup for tape using Symantec Netbackup solution and Schedule backup jobs in crontab.
• Data Modeling, Database Design and Creation using Sql developer data modeler.
• Installed Oracle 12c Enterprise Manager (OEM) for diagnosing and monitoring performance related problems and configured with Application servers on databases.
• Used OEM to monitor Blackout Servers in case of any maintenance activity. Database health, Bottlenecks, session information, table privileges, user roles and grants.
• Golden Gate installation on linux environments.
• Golden Gate monitoring for online change synchronization, ddl synchronization.
• Worked on Real Application Testing (RAT).
• Raise SR to Oracle Support for Exadata related Issues, and works accordingly.
• Expertize in Performance tuning of oracle databases using AWR, ADDM, STATSPACK and Explain Plan.
• Monitoring database locks, blocking sessions, long running sessions and killing as per request.
• Worked on PL/SQL, SLDC development with application team.
• 24x7 production support for several mission critical systems which utilize multiple Oracle 10g and 11g databases.

Environment: RHEL, AIX, SOLARIS, Oracle 9i/10g/11g/12c, RMAN, RAC, DATAGUARD, F5 Loadbalancer Broker, Standby, SQL, EXP/IMP, EXPDP/IMPDP, Goldengate, ASM, SQLLOADER, AWR, ADDM, Explain Plan

Confidential, Charlotte, NC

Oracle DBA

Responsibilities:

• Responsible for administration and supporting Oracle 11g, 10g databases on different linux OS such as RHEL, AIX, HP-UX, Solaris in DEV, QA, UAT and Prod environments.
• Installation, maintenance and tuning of Oracle 11g RAC databases.
• Created databases using DBCA and manually. Configured Listener, Tnsnames, pfile, and password files.
• Perform Database Refresh of production databases to development and test environments using RMAN.
• Performed Upgrades from Oracle 11.2.0.2 to 11.2.0.4.
• Extensive experience in applying patches on the oracle database.
• Managed Data Guard, Created physical standby database for High Availability.
• Configured dataguard broker. Switchover between physical and standby using dataguard broker.
• Implemented RMAN backup, recovery and cloning procedures for all RAC/non RAC databases.
• Setting up of RMAN on the database to perform necessary back-up.
• Created Oracle ASM Disk Group for 11GR2 RAC database.
• Having knowledge on LDAP configuration with Oracle database.
• Worked closely with Oracle Support in identifying and incorporating Oracle recommendations and best practices in the design phase resulting in minimal issues during implementation
• Golden Gate installation on linux environments.
• Worked on RAC Installation, configuration, administration and monitoring on LINUX platform. Experienced in adding/deleting RAC nodes and managed cluster failover.
• Extensive use of Export and Import for full database backup, schema level backup, Table level backup and metadata using Data Pump.
• Experience on Oracle OBIEE administration of application objects with database
• Performance, Tuning of databases using ADDM, AWR, Gather statistics, monitor memory, index and schedule jobs
• Monitoring the query execution and views to make sure the operations runs smoothly using Explain Plan.
• Research, analyze, and recommend patches, tools, and/or database upgrades to resolve issues and add features/functionality.
• Setting up and monitoring Cron jobs to schedule database backups with the help of RMAN scripts and daily night exports.
• Created trigger/function/stored procedure/packages. Tuned and trouble-shot PL/SQL codes.
• Set up database Users, manage database permissions, Oracle roles and privileges, space management, user and schema management.
• Performing database administrator tasks like monitoring disk usage, Tablespace usage, database logs.
• Monitoring and undertaking necessary re-organization of tables and indexes as and when required.
• Handling Customer Query, Work on change requests, Weekly Maintenance Activity, troubleshoot common SQL codes, Error Messages and Database issues.
• Writing up and Responsible for setting up shell scripts in crontab.
• Implementation of database deployment in production and development databases.

Environment: Oracle 11g/10g, RedHat Linux 5.x, Sun Solaris, RAC, Toad 9.5, LDAP,PL/SQL, SQL*LOADER, SQL PLUS, UNIX shell scripts, RAC,RMAN, Data Guard, ASM, AWR, Data Pump.

Confidential, Pennsylvania

Oracle DBA

Responsibilities:

• Designed, installed and configured Oracle 11gR2 RAC.
• Worked closely with Oracle Support in identifying and incorporating Oracle recommendations and best practices in the design phase resulting in minimal issues during implementation.
• Successfully completed upgrade projects from Oracle 10g to 11gR2 RAC in a timely manner.
• Automated routine database operations using Shell and Perl scripting.
• Implemented RMAN backup, recovery and cloning procedures for all RAC/non RAC databases.
• Setup and maintenance of DATA GUARD on 11g for Disaster Recovery and reporting purposes.
• Configure Listener, Tnsnames, pfile, password file.
• Troubleshoot Oracle connectivity problems.
• Add node from cluster using addNode.sh script.
• Worked with network team to configure F5 Load Balancer
• Implemented optimal storage solution using Oracle technologies like ASM and Advanced Compression. This resulted in improved performance and 30% reduction in storage costs.
• Created Oracle ASM Disk Group for 11GR2 RAC database.
• Created Oracle 11.2.0.2 Grid Infrastructure Installation and configuration for Production databases.
• Created RMAN backup for RAC databases using RMAN.
• Created monitoring of oracle RAC databases using GRID control.
• Performed schema and object level refreshes using export or Data Pump.
• Monitor the backup of databases and scripting for improvements in the backup procedure.
• DBA maintenance tasks include adding datafiles to tablespaces, resizing the data files, File system usage, Creation of users assigning privelges and roles, change of init parameters, code deployments, creating PL/SQL objects.
• Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Adhering to SLAs Reporting, Handling tickets/requests, Troubleshooting technical issues.
• Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown database.

Environment: Oracle 11gRAC, 9i, RedHat Linux, HP-UX, IBM Aix, F5 Loadbalancer, OEM, RMAN, SQL*Loader, DBCA, Netca, ASM, ADDM, AWR, Data Guard, EXPDP/IMPDP

Confidential, Sacramento, CA

Oracle DBA

Responsibilities:

• Responsible for administration and supporting Oracle 11g and 10g databases in DEV, QA, UAT and Prod environments.
• Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Installation of Oracle databases on standalone and RAC nodes on HP UX, Linux, AIX and Solaris environments.
• Analyzed and tuned the Database to identify potential database issues such as response delay, locking contention, even server down time by using tools like STATSPACK, EXPLAIN PLAN, and TKPROF.
• Extensive experience in daily batch and report monitoring, space management, index rebuilds, statistics collection and other Oracle housekeeping tasks.
• Implemented Data Guard on Oracle 11g with high availability and performance configurations.
• Extensive experience with Database Cloning and Refreshing pre-prod databases.
• Proficient with Database Administration activites such as Installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.
• Database Migration and Upgradation of databases.
• Worked on User management mainly on grants, privileges, roles and profiles.
• Using Oracle Data Pump utility making faster export/imports on larger databases and saving lot of time.
• Having knowledge on LDAP configuration with Oracle database.
• Performed daily database administration tasks: user management, space monitoring, performance monitoring and tuning, Alert log monitoring and database monitoring.
• Monitoring tablespaces issues, creation tablespace and adding datafiles.
• Export and import of database objects to copy from one database to another database, Schema / Table level and query based normal Export & Import and also Data Pump Export & Import utility.
• Developed Recovery Manager (RMAN) scripts for database backup and recovery for hot and cold backup options for both RAC and standalone instances.
• Scheduling and maintaining level 0 and level 1 RMAN ( Recovery Manger) backups.
• Handled daily Production problems /Change requests with Oracle.
• Expertise in UNIX shell scripting and automated many common tasks using CRONTAB including Backups, export and imports, archiving old records and verification of such processes.
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognization and resolution of database issues.
• Creating trigger/ function/ stored procedure/ packages. Manage cursor. Tune and trouble-shooting PL/SQL codes. Handle run-time errors. Write database Monitoring PL/SQL objects. Create Materialize view.

ENVIRONMENT: ORACLE 10g, SOLARIS 10/9, LINUX (RED HAT), LDAP,RMAN, TOAD, SQL LOADER, DATA PUMP, PL/SQL, Statspack, Explain plan, TKPROF.

Confidential

Oracle DBA

Responsibilities:

• Supporting 1500+ targets in GE Corporate which includes development and stage and Production targets
• Have good knowledge in using change control process like Service-now and its priorities.
• Working on daily database administrator activities like monitoring alerts, monitoring backup jobs and troubleshooting to fix them permanently.
• Worked on change requests like code movement, init parameter changes, dba activities during OS related patches, upgrades and all other activities.
• Have good knowledge on using OEM and grid control and handling issues related to it like when agent not reachable or any target is down or need to set blackout in OEM. Also troubleshoots the issue for 100% availability of the database.
• Have good knowledge on quarterly patches like PSU for all environments i.e., Production, stage and development databases.
• Working experience on Upgrading the database.
• Have good solving skills for our daily alerts like files system, RMAN backup job failures. Troubleshoots on them for permanent fixes.
• Worked on database creation / decommission activities and updating the client in timely basis
• Have basic knowledge on Real Application cluster (RAC) databases. Familiar to use its features like srvctl and crsctl.
• Relocating any listener services in case of node reboot.
• Have knowledge in taking backups using RMAN and also traditional backup.
• Performed schema and object level refreshes using export or data pump.
• Familiar with the Data Pump features.
• Performed database refreshes using RMAN cold or hot backups or using data pump.
• Worked on database clone activities like duplicate database having source’s backup pieces.
• Exposure in Oracle DBA three node RAC support.
• Worked on Exadata environment like adding tablespace, File system, executing DML, DDL .
• Performed service-now change tasks like creating schema user, granting specific roles or privileges, code deployments, creating database links (both public and private ), creating objects like tables, indexes etc.,
• Have knowledge on DR databases like troubleshooting if there is huge archive gap with primary databases. If required applying SCN level or full database restore.
• Monitoring the daily scheduled backup jobs includes RMAN hot and cold backups and troubleshooting on them using log files if requires.
• Creation of tablespaces, datafiles etc for project requirement.
• Monitoring long running sessions and killing as per request.
• Worked on databases related alerts like filesystem alerts, table space alerts, ASM diskgroup related alerts proactively on daily basis using OEM 11g. Troubleshoots for its permanent fix.
• Works on alerts related to performance and tuning like maximum CPU utilization or query is taking much time to run. Have basic knowledge in handling these issues.
• Worked on MYSQL environment for creation of databases and objects.
• Have good knowledge in using change control process like Service-now and its priorities.
• Generating AWR report for the database performance and analysis at a point of time.
• Works for 12*7 on-call weekend supports providing them all support from database related tasks or issu

Environment: Oracle 10g, 11g, Solaris 9&10, Linux 2.1/3.0.4, OEM, SQL Developer,SQL*Net,Data Guard.