SUMMARY:

• Having 8+ years of experience as an Oracle Database Administrator and performed different tasks like database administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security.
• Excellent experience in Installation and configuration of Oracle 9i, 10g, 11g on a variety of operating systems including UNIX/LINUX, Solaris and Windows environment.
• Experience in Migration Projects. Hands on experience in - updating from Oracle 9i to 10g (10.2.0), 10g to 11g and applied oracle patches.
• Experience in Data Warehouse environment.
• Migrated databases using Golden Gate, Transportable tablespace and Datapump from 9i, 10g to 11g.
• Extensive experience in using Korn Shell scripts for Regular backup, instance startup and shutdown and for automation
• Installed Oracle 10g RAC software with ASM & OCFS2 File systems
• Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN).
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts.
• Co-ordinated with UNIX administrators for space managements on various servers.
• Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup, IBM TSM & LEGATO Storage Manager.
• Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space.
• Operational Responsibilities - Database refreshes/ backs, security, documenting standards and procedures, data migration, data clean-up, copy data archiving, etc.
• Monitoring and management of various database components (logical & physical) like table- spaces, segments and data files.
• Experience on Data Replication using Snapshot, Materialized views, import/export.
• Extensive performance tuning activities like Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Logical and Physical Database Design, Backup and Recovery procedures.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
• Have implemented ORACLE STREAMS.
• Setup, Configured and Maintained Oracle Data Guard to control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.
• Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD and Grid Controlling using OEM
• Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, 5.3 Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

RDBMS: Oracle 11g/10g/9i/10gRAC.

Languages: SQL, PL/SQL, C, C++, C#, VB.NET, JAVA, XML, UNIX Shell Scripting.

Tools/Utilities: RMAN, OEM, Oracle Management Server, SQL*Loader, Export/Import, TOAD, Data pump, MS Access, Data Guard, Golden Gate 10.4

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK,AWR,ADDR

Hardware Platforms: Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 6500 / 450, HP XP256 / XP512, IBM X series Server, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Oracle DBA

Responsibilities:

• Installed and configured Oracle 10g, 11g on a variety of operating systems including UNIX/LINUX, AIX, HP-UX and Solaris environments.
• Migrated Oracle 11g databases from HP-UX to Linux.
• Performed upgrade from Oracle 10g to 11g and applied oracle patches.
• Organized various migration review meetings with the application team to discuss the migration strategy based on business requirements.
• Configured and Maintained Oracle Data Guard to control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.
• Performed day to day DBA activities on Oracle 9i, 10g, 11g databases.
• Installed Oracle 10g, 11g RAC software with ASM & OCFS2 File systems.
• Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN).
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Provided estimation for new environment database storage with UNIX administrators for space managements on various servers.
• Implemented Data guard, Golden Gate, Streams for faster Disaster Recovery.
• Performed backup and recovery of GoldenGate replication and administrated GoldenGate replication security.
• Hot/Cold Backup and Recovery and Cloning of databases using RMAN utility.
• Experienced in SQL, PL/SQL, Shell Scripting, Partitioning, Logical and Physical Database Design, Backup and Recovery procedures.
• Database maintaining including backups, recovery, imports/exports and Exadata.
• Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space.
• Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD and Grid Controlling using OEM.
• Database refreshes/ backs, security, documenting standards and procedures, data migration, data clean-up, copy data archiving, etc.
• Monitored and managed various database components (logical & physical) like table- spaces, segments and data files.
• Setup and maintained documentation, policies and standards.
• Performed maintenance and improvement of databases including installation, configuration, upgrade, patches and bug fixes.
• Experienced on Data Replication using Snapshot, Materialized views, import/export.
• Performance tuning activities like Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Delivered Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.

Environment: Oracle 11g/10g/9i, Sun Solaris, AIX, HP-UX, Red Hat Linux, TOAD, RMAN, SQL server, OEM, Grid Control, Golden Gate.

Confidential, Irving, TX

Oracle DBA

Responsibilities:

• Part of 6 member DBA team for 24x7 on call support for Oracle 9i/10g/11g production, development, test databases.
• Administered 9i/10g/10g RAC/11g RAC in OLTP, Data Warehouse environments on RHEL, Sun Solaris.
• Assisted the team in Upgrade of databases in all environments from Oracle 9.2.0.8, 10.2.0.4 to 11gR2.
• Responsible for Oracle database security and patching, Oracle database capacity analysis and planning.
• Configured database entries and Monitoring of all the databases using OEM 10g/11g grid control and TOAD.
• Implement, setup of physical Standby database using Dataguard in Oracle for disaster recovery.
• Redesigned the database model for few applications in the migration from SQL Server 2005 to Oracle 11g.
• Database/Application tuning on daily basis using AWR reports, ASH, ADDM reports, OEM Grid control.
• Experience with SQL, DDL, DML, DCL, PL/SQL coding, stored procedures, functions, packages, triggers.
• Partitioned large tables, indexes, implemented local indexing to improve the performance of ETL file loading.
• Implemented backup and recovery procedures using RMAN on Oracle 10g/11g to tape drives, disks.
• Cloned databases using manual scripts as well as RMAN Duplicate.
• Handling all day to day activities including: tuning of SQL/PLSQL, performance tuning, database auditing and managing user groups, Database security, OS space monitoring, network issues, locking, database issues, etc.
• Datapump, Exp/Imp, Copy to migrate database objects from database to another/to other server.
• Generate flat files from SQL Server using DTS/SSIS packages, ODI, SQL *Loader for file loading on Oracle.
• Monitoring the ODI sessions using Oracle Metadata Navigator and resolving any database issues.
• Automated the replication process using materialized views for data aggregation for front end OBIEE reports.
• Experience with data modeling using Erwin data modeler, converting the logical model to physical model.
• Assisting developers with SQL, PL/SQL coding and delivering duties to development DBAs and developers.
• Coordinated with Oracle support for SR to resolve Oracle bugs and ORA-600 errors.
• Documented all Oracle database installations and database operations.

Environment: Oracle 11g/10g/9i, Sun Solaris, Windows NT / 2000, Red Hat Linux, Oracle E-business suite, TOAD, RMAN, SQL server, OEM, Grid Control, Data Guard, STATSPACK, AWR, Explain Plan.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Performed day to day DBA activities on Oracle 9i, 10g, 11g database
• Performed migration from 9i to 10g from AIX to Linux.
• Coordinate with UNIX administrators for space management on various servers.
• Installed Oracle 9i and 10g, 11g RAC database on Red Hat Linux.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle
• Installation of ASM into various storage parameters like SAN and NAS.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Upgrading databases to Oracle 11g from Oracle 10g.
• Creating and maintaining the Oracle databases.
• Createdand managing the database objects such as tables, indexesand views.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
• Unix Shell scripting in (cshell)csh, (korn shell)ksh for automating startup/shutdown of databases, getting system alerts.
• Applying patches both Server side and Client side.
• Setting up new environments (Development, Production etc).
• Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration
• Worked in data ware house environment.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Worked on import/export and SQL-loader.
• Setup backup and recovery procedures using RMAN.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Used hints for SQL tuning and optimization.
• Performed Explain Plan analysis for Query Optimization and SQL tuning
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAIN PLAN, and optimizer hints.
• Expanded PhysicalDataModel (PDM) for the OLTP application using Erwin

Environment: Oracle 11g/10g/9i, Sun Solaris, Windows NT / 2000, Red Hat Linux, Oracle E-business suite, TOAD, RMAN, SQL server, OEM, Grid Control, Data Guard, STATSPACK, AWR, Explain Plan.

Confidential, Tinley Park, IL

Oracle DBA

Responsibilities:

• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases using OEM.
• Installed RAC on Oracle 10g and worked on OCFS2 feature of Oracle
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Created database design according to the requirement of Application Software, monitored and configured databases.
• Involved in numerous Unix Korn Shell Scripting pertaining to the activities of the DBA
• Configured Oracle data guard and Streams.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Estimate the size of the database and its objects (in large database of 1 to 2 Terabyte).
• Devised & Implemented backup strategies using hot, cold, and exports based on the business requirements.
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer.
• Used SQL*Loader for loading legacy systems database data.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Troubleshooting of various database performances by proper diagnosis Confidential all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Developed UNIX shell scripts to perform the above tasks efficiently.

Environment: Oracle 10g with RAC, ORACLE 9i, Java, J2EE, SQL, PL/SQL, Toad, Pl/SQL Developer, Erwin, RHEL 4.2, HPUX, Windows 2003.

Confidential, North Chicago, IL

Oracle DBA

Responsibilities:

• Part of a 4 member DBA team which was involved in the maintenance of the Oracle 10g/9i databases for the Production as well as the development environments.
• 24x7 Production database and applications support.
• Implementation and configuration of OEM Grid, Oracle Management Server for maintenance and monitoring data.
• Configuring RMAN backup to various databases.
• Setup and configured Oracle Physical Standby database (Data Guard) for disaster recovery as well as to offload the running of huge reports.
• Experience working with Oracle Data Integrator (ODI).
• Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Database cloning to setup identical databases in the production and development environments.
• Create and maintain users, roles and privileges & auditing triggers.
• Upgrade/Migrated the production and development databases from 8i to 9i.
• Oracle 9i Streams Replication setup and Configuration.
• Setup and configured 2 node Oracle 10g RAC with ASM.
• Back end Programming/scripting using SQL and PL/SQL.
• Created table partitions and index partitions.
• Experience in troubleshooting production database issues/performance issues.

Environment: Oracle 10g RAC9i/8i, HP-UNIX, Linux, SQL, Oracle Replication, Explain Plan, Toad.

Confidential

Oracle DBA

Responsibilities:

• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Responsible for installing, upgrading and configuring the Oracle server.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Responsible for optimizing the queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Designed backup and recovery procedures for OLTP system
• Use TOAD tool to access the database
• Used PL/SQL developer to create PL/SQL Procedures
• Testing PL/SQL procedures against the test cases.
• Involved in creating use cases and test cases

Environment: Windows 98/NT/2000, HP-UX, AIX, Oracle 8i/9i, TOAD, Database Tools/Utilities, Oracle Enterprise Manager.