SUMMARY

• Around 6 years of experience in Oracle Database Administration in different versions of Oracle 9i, 10g &11g
• Experience in Installation of Oracle Server, Client, Enterprise ManagerGrid (10g, 11g) including upgrades(9i to 10gR1 and R2, 10g to 11g R1 and R2) patching, agent upgrades,PSU’s
• Experienced in devising backup and disaster recovery(includingRMAN)strategies
• Involved in data access rules and security (role based access)
• Implemented Change Tracking File with RMAN and reduced the backup time significantly
• SQL & DB Tuning,Proficient in Application and Database Performance Tuning (SQL Profiles, AWR,ADDM, Tuning Memory, Tuning I/O, Wait Event, used 10046 trace levels to track SQL statements, analyzed high CPU spikes, etc.)
• Experience working in warehouse environment OWB (Oracle Warehouse Builder) 10x, 11xincluding upgrading, installation, configuration and maintenance.
• Implemented and configuredASM, Data Guard, Data Guard Broker
• BuiltOracle RACenvironment in mission critical largeOLTPsystems
• Trainedfundamentals and advanced replication withGolden Gatesoftware, working with users to resolve replication issuesandimplemented Oracle Streams for data replication.
• Experience with active - active replication using SharePlex for minimum downtime and high availability.
• Interacted closely with Change Management Team, Configuration Management Team, Development & Testing teams, etc. - Implementation of DB schema changes as per approved Work Request
• Extensively usedOracle Enterprise Manager (OEM),Toad and SQL navigatorfor maintaining and monitoring databases
• Excellent understanding ofOracle Internals, Architecture,Data Dictionary,Data Management,Automatic Storage Management (ASM)and System Management
• Implemented Cross Platform Transportable Tablespaces to move large databases across platforms
• Experienced in creating, upgraded& maintaining Oracle databases on different UNIX and windows environment like Linux RHEL 4x 5 x, IBM AIX 5.2, Sun Solaris, Windows NT/2000.
• Knowledge of OEM 12c R1(Oracle Enterprise Manager cloud control)
• Worked in Maximum Availability Architecture environment
• Good problem solving,communication, interpersonal and superior team skills.
• Proficient in performance tuning in largeOLTP(1.8 TB) and data warehouse environments
• Knowledge of network storage like NAS,SAN,NetApp
• Co-ordination with other IT team managers and support teams (onsite/offshore)to ensure the Business Ops are not impacted

TECHNICAL SKILLS

OPERATING SYSTEMS: HP-UX 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux RHEL 4.x, 5x and Windows 95/98/NT/2000/XP.

RDBMS: Oracle 11g, Oracle 10g, RAC 10g/11g, Oracle 9i/

LANGUAGES: SQL, PL/SQL, C, C++, XML, UNIX Shell Scripting.

SOFTWARE/ APPLICATIONS/ TOOLS: ORACLE 10g/11g, Real Applications Cluster (RAC),Dataguard,Golden Gate,Oracle Streams/CDC,SharePlex,RMAN,expdp/impdp,ADDM, Oracle Enterprise Manager(OEM)Grid Control 10x/11x/12c,Oracle EBS 11i,Data Pump,STATSPACK, OWB(Oracle Warehouse Builder) 10g/11g, SQL Loader, VMware workstation 6x,7x,8x

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, New York

Oracle Database Administrator

Responsibilities:

• Planning, analysis and implementation of Oracle database upgrade from 10g R2 to 11g R2.
• Performed database upgrade from 10.2.0.3 to 11.2.0.3 for DEV,Stage & Production environment including latest PSU’s as of July 2012
• Performed OWB (Oracle Warehouse Builder) upgrade and migration from 10.2 on Solaris to 11.2 on Linux for DEV,Stage and production environments
• Installed, configured and administered OWB(Oracle Warehouse Builder) onclient and server
• Involved in migration of database from Solaris to Linux using export/import datapump
• Created & maintained database on Stage, production & DEV
• Created Users, Index, Tablespaces, Views, Profiles, Privileges
• Involved in regular refreshes and database cloning.
• Setup RMAN backup with recovery catalog for Production.
• Created and performed weekly cold and hot backups scripts and cron for Production and DEV
• Created scripts for Tablespaces creation, schema, export/import datapump, RMAN.
• Created and maintained cron jobs for RMAN,export/import
• Performed disaster Recovery using RMAN.
• Performance tuning and troubleshooting warehouse environment using ADDM, ASH, AWR, SQL tuning Advisor, ExplainPlan, gather system/schema stats.
• Oracle database securities and auditing for safeguarding data.
• Designed & created audit table, logon/logoff triggersto generate user activity reports .Created job activity on OEM for constant user monitoring and generating weekly user statistics report including login log off timestamp,counts, last action .
• Database Analysis and monitoring of instances running on Oracle 9i & 10 R1 in order to plan their retirement and migrate & upgrade to oracle 11g on new servers.
• Migrating & upgrading database from Oracle 9i & 10g R1&R2 running on HP-UX to Oracle 11gR2 on Linux
• Provided 24 X 7 on call support for ETL/Finance teams in India and USA also worked as tier2 supports for internal GE’s Service Center.
• Daily monitoring of database using OEMand monitoringscripts.

Environment: OWB, Oracle 11.2.0.3, 10.2.0.3, 9.2.0.8.0,RHEL 5x, Solaris 10(SPARC), HP-UX,shell scripts,OEM grid control 11g,export/import using datapump, RMAN,cron

Confidential, Hoover,AL

Oracle Database Administrator

Responsibilities:

• Involved indatabase upgrade from 11.1.0.6 to 11.1.0.7for DEV and TEST environments.
• Experience in configuring and maintaining OracleReplicationby usingOracle streamsfor Data replication from production system to Data warehouse on RAC Environment.
• Implemented the database withASMstorage, skilled towards database tuning and hands on experience in database security (auditing), recovery, archival concepts and procedures.
• Configured and ManagedASMdisks and disk groups through Grid Control utility.
• Upgradethe production and development databases from10.2.0.1 to 10.2.0.4
• Created and maintainedstandby databasesusing databasereplication(Data Guard)for high availability.
• Installed, Configured & Administeredgolden gate.
• Cloned the database using cold/Hot backups and using RMAN
• Regular monitoring of the databases withOracle Enterprise Manager, Grid Controlfor operational databases with high sensitivity alerts
• PerformingSQL*Loaderjobs for loading data from text files. Used external tables to reduce data loading time from five hours to two hours.
• Actively worked onperformance tuningofSGA/PGA andPhysicaldatabasethat included resolving fragmentation and disk contention. UsedPartitioning and indexingfeature of Oracle 10g to improve performance.
• Disaster recovery planning; implemented databasebackups and disaster recoverystrategies usingRMANanddata pump export, import.
• Troubleshooting andTuningof production &RACdatabases.
• Experienced in optimizing SQL andPL/SQL tuningusingCBO,explain plan,TKPROF, STATSPACK, ADDM, and AWR.

Environment: Oracle11g, Oracle Enterprise Manager, Oracle Grid control,RHEL, PL/SQL, RAC,RMAN,TOAD and SQL *Plus, Golden gate.

Confidential, NJ

Oracle Database Administrator

Responsibilities:

• Duties included all aspects of Oracle Database administration including oracle installation and upgrade Oracle databases from Oracle 9i to 10g, configuration of ASM, RAC, 11g (Test environment).
• Performed database design, testing, implementation, maintenance, Create schemas, data structures and Seed data, control of the organization's physical, relational, and object-oriented databases across multiple platforms and computing environments.
• Setup Primary and physical database for Data guard.
• Used Streams for full transport mechanism (over e.g. HTTP) for data synchronization between 2 servers.
• Created database objects and maintain production environment.
• Active - Active replication, replication of tables/columns/records using SharePlex
• Patching, performance tuning, database maintenance with ADDM.
• Used RMAN to perform HOT database Backup and Recovery.
• 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 and Cron jobs for night backup, verifying night backup.
• Performed point in time data recovery with RMAN
• Install Oracle binaries and build databases on new servers Copy files for refreshing databases between environments.
• Performed backup and recovery of Oracle 10g RAC databases and tuned it for optimal performance
• Performed tuning by various tools like STATSPACK and Tkprof, V$View.

Environment: Oracle 10.2.0.3, OEM (Oracle Enterprise Manager) Grid Control, RAC and DataGuard, ASMSQL *PLUS,PL/SQL, RHEL, IBM AIX 5.2 OWB 10.2, RMAN, OEM, Statspack, SharePlex,Tkprof, Shell ScriptsSize: 900 GB Database.

Confidential, Lexington, KY

Oracle Database Administrator

Responsibilities:

• Maintain and improve high availability anddisaster recovery using Data Guard
• Created backend objects likeviews, synonyms, sequences, procedures, profiles and privileges.
• Created and monitored all database objects, includingtables, clusters, indexes, sequences, packages and procedures.
• Performed installation and maintenance of oracle database on IBM AIX 5.2 in testenvironment
• Created table spaces and managed table spaces adding/deleting/ resizing data files
• Managed Undo Segmentin order to avoid "ORA-01555:Snapshot too old" error
• Drastically reduced unscheduled downtime and improved performance by performing tuning of the databases
• Responsible for generatingSTATSPACKreports on weekly and daily basis
• PerformedtuninginvolvingMemory, Disk I/O, SQLandapplication tuning
• Migrated critical databasefrom one server to other with minimal downtime using oracle Stream.
• Actively involved in group meeting, user interaction to get feedback from users and to meet business requirements

Environment:Linux,Oracle9i/10g, RMAN, CLONING, IBM AIX 5.2,Data Guard, SQL, Windows NTExport/Import, Performance Tuning,Size: 900 GB Database

Confidential Corporation, Kansas

Oracle Database Administrator.

Responsibilities:

• Providing 24X7 supports to maintain all Databases up and running in Production environment.
• UpgradeOracle9i to Oracle10g
• Performed design, testing, implementation, maintenance, and control of the organization's physical, relational, and object-oriented databases across multiple platforms and computing environments.
• Performed SGA Tuning like parsing and upgrade the shared pool size.
• Setup data guard for backup database.
• Worked on schema refresh using Export/Import and Datapump
• Used RMAN in Backup/Recovery, also disaster recovery using manual commands and shell scripting for like verifying night backup
• Used Explain plan, ADDM, OEM (Oracle Enterprise Manger) for optimizing long running queries and tune database performance.
• Used TAR files to troubleshoot Oracle Software related problems.
• Experience in Automatic Workload Repository (AWR).
• Utilized ensure Maximum Security at the database level using Users, Roles and Privileges on command line and Grid Control
• Used Snapshots and Materialized Views.
• Performed Performance tuning with Statspack and manual.
• Managing database objects like Table spaces, Tables, Indexes, Views, and Synonyms etc. with GRID Control and OEM(Oracle Enterprise Manager)

Environment: Oracle 9i, Oracle 10g, Linux RHEL4, PL/SQL, SQL*Plus, OEM (Grid Control), ADDM, Data pump,RMAN, Snapshots, Statspack.

Confidential, St. Paul, Minnesota

Oracle Database Administrator

Responsibilities:

• Performed design, testing, implementation, maintenance, and control of the organization's physical, relational, and object-oriented databases across multiple platforms and computing environments.
• Upgraded Databases from Oracle 9i to Oracle10g and tuned SGA (System Global Area).
• Developed SQL scripts and CRON Jobs for automating various DBA activities.
• Improved the performance of various Databases and tuned SQL queries to reduce response time.
• Implement backup and recovery procedures using RMAN for oracle databases and test regularly in conjunction with operations. Configuring scripts for Backups (Hot, Cold and incremental).
• Plan and schedule the online/offline backup, Verify night backup
• Security User Management, Privileges, Role, Profiling, Authentication.
• Provided technical Support to development team to fine tune SQL and PL/SQL code using SQL execution Plan, SQL trace, ANALYSE DBMS STATS and evaluating and monitoring database to resolve performance issues including troubleshooting errors, recovering databases and failures as needed.
• Performed session tracing and used the Oracle Statspack diagnosis tool for collecting statistics.
• Applied database patches and security patches
• Schema Refresh using Export/Import. Creating the database, Tablespace, tables, indexes,logins, passwords (security).
• Table partitioning, creating Index Organized tables, creating locally Managed Tablespaces.
• Database sizing, Tablespace management and rollback Tablespace management, transaction management and security Administration.
• Performed Database cloning to create an Auxiliary database

Environments: Linux RHEL4, Sun Solaris, Oracle 9i, 10g, Cron Jobs, STATSPACK, TOAD, RMAN, Export/Import, Schema Refresh, SQL Trace, Explain Plan, LMT and DMT.

Confidential

Oracle Database Administrator

Responsibilities:

• Provided 24/7/365 Database support to customers in HP-UX, Windows NT, 9i OLTP environment.
• Performed installation, configuration of Oracle 9i database.
• Created database schema objects like table, synonyms, sequence, and index.
• Performed Backups of databases like Hot Backups, Cold Backups and export/import utilities for schema based backups.
• Managed database objects like Table spaces, Tables, Indexes, Views, and Synonyms etc.
• Performed Defragment a tablespaces when an object's storage parameters are sized improperly.
• Created and managedschedule jobs.
• Configured online and offline Database Backup using RMAN
• Scheduled backup with shell scripting and verifying backup.
• Monitored Alert logs on continuous basis.
• Performed Cloning Activities from Production to test environment and refreshed it periodically.
• Performed designing and implementing transformation, extraction and load process for Data Warehouse.

Environment:Linux, Oracle 9i, RMAN, PL/SQL, Sql*Loader, STATSPACK, RMAN, SQL Trace, Explain Plan.

Confidential

OracleDBA

Responsibilities:

• Administration of Oracle9i database including installation, creation, and monitoring database.
• Upgraded database from Oracle 8i to 9i.
• Monitoring listener services and listener logs (for access).
• Monitoring tablespaces and adding required space after it reaches threshold.
• Creating new objects like synonyms and providing required grants to users.
• Installing oracle client versions for developers.
• Trouble-shooting several client access issues (like toad client) and helped users to resolve those issues.
• Performed several schema/object refreshes.
• Monitoring CPU, IO, and memory usages.
• Creating the required table spaces, users, and roles for the application.
• Involved in backup and recovery of database information and maintaining Hot Backups, Cold Backups.

Environment: Oracle 9i/8i, HP-UX 10.20/9.04, Oracle Enterprise Manager, Windows NT