SUMMARY

• Over 6 years of experience in Oracle Database Administration in different versions of Oracle Products inEnterprise(9i, 10g &11g). Oracle Enterprise ManagerGrid (10g, 11g) - upgraded 10g (10.2.0.4) to 11g (11.1) (including agents upgrades, etc.)
• 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)
• Implemented and configuredASM, Data Guard, Data Guard Broker. BuiltOracle RACenvironment in mission critical largeOLTPsystems. Trainedfundamentals & advanced replication withGolden Gatesoftware, working with users to resolve replication issues and implemented Oracle Streams for data replication
• 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
• Created, Upgraded& Maintained Oracle databases on different flavors of UNIX & Windows environments
• Experienced in Cloning the database using cold and hot backups. 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
• Co-ordination with other IT team managers and support teams 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, Oracle 9i

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

SOFTWARE/ APPLICATIONS/ TOOLS: ORACLE 9i/10g,OAS 10g Recovery Manager (RMAN), Real Applications Cluster (RAC), Golden Gate ADDM, Oracle Enterprise Manager(OEM), Data pump, STATSPACK, ERWIN, SQL Loader, TOADWEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

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.
• Upgradedproduction 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 tuningofinstance(SGAandPGA) andPhysicaldatabasethat included resolving fragmentation and disk contention. UsePartitioning and indexingfeature of Oracle 10g to improve performance.Disaster recovery planning; implemented databasebackups and disaster recoverystrategies usingRMANanddata pump export, import. Troubleshooting andTuningof production &RACdatabases.
• Designed and Implementeddatabase securityusingOracle roles and privileges. 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. 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. Worked with Data Replication.
• 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, RMAN, OEM, Statspack, 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
• 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, Data Guard, SQL, Windows NT, Export/Import, Performance Tuning.

Confidential, Kansas

Oracle Database Administrator

Responsibilities:

• Providing 24X7 supports to maintain all Databases up and running in Production environment. Upgrade Oracle9i 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). Utilized TOAD to manage Database

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

Confidential, 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, user 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 & Synonyms. Performed Defragment a tablespaces when an object's storage parameters are sized improperly. Managed sql query tuning, SGA performance and tuning with OEM. Created and managed schedule 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.
• 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, HP-UX 10.20/9.04, Oracle Enterprise Manager, Windows NT