SUMMARY

• Around 7 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 - migrating from Oracle 9i to 10g (10.2.0), 10g to 11g and applied oracle patches.
• Installed Oracle 10g RAC software with ASM & OCFS2 File systems.
• Implemented strategy for partitioning and management of historical data tables in RAC.
• 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.
• Co-ordinate 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.
• Proficienct in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space.
• Installed, Configure and troubleshoot Oracle GoldenGate.
• 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.
• Experience on Data Replication using Golden gate, Materialized views, import/export.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.
• Evaluated the procedures done in testing and analyzing computer applications by using knowledge of Perl programming.
• Developed advanced Web based soft wares by using Perl at a very advanced level.
• Good experience in SQL, MSQL, 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.
• Created many common components of UNIX and PERL Scripts.
• Experience in working with IBM OPTIM tool.
• Implemented flashback technology.
• Tune the Database, for linux, unix, and windows using OPTIM QUERY TUNER.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan IBM OPTIM.
• 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.
• Expertise in setting up Siebel servers, Siebel Web Servers, Database Servers, Actuate Report servers, Remote, Anywhere, migration, Server administration.
• Excellent knowledge in Siebel Server Administration, EIM, Workflows.
• User Administration, Siebel Server Installation/Upgrades & Release/Deployment coordination.
• Multimaster MySQL setup over 10 servers.
• Oracle Database Gateway for ODBC to integrate with low-end data stores such as MySQL, Foxpro, Access, dBase and non-relational targets like Excel.
• Used to transparently integrate SQL from an oracle environment using Database Gateway.
• 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 environments.
• Object Oriented Design and Programming, proficient in many programming languages as C, C++, VB.NET and C# multi-platform development, Web development and database design.
• Provided value added services to the company through thoughtful experience, testing habits, excellent written and verbal communication skills.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 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, MySQL, C, C++, Perl, C#, VB.NET, JAVA, XML, UNIX Shell Scripting, Siebel CRM.

DB Management: TOAD, OPTIM, OEM, DBArtisan, OEM Grid Control.

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

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

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

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

Sr. Oracle DBA

Responsibilities:

• Oracle Clusterware installed to provide infrastructure for RAC and configured 2 node Oracle 10g/11g RAC with ASM.
• Configuration, maintenance and tuning of Oracle 11g/10g/9i RAC.
• Performing various tasks like administering RAC using SRVCTL, adding nodes and instances, administering storage components, parameter management, configuring high availability features for RAC.
• Responsible for maintaining ORACLE RAC using OEM, maintaining Oracle Clusterware using CRSCTL.
• Immurement Oracle Streams on database level and table level.
• Responsible for taking regular backups including Cold / Hot backups, Export / Import, Data Pump of database, using RMAN, and recovery in case of disasters.
• Responsible for setting up Oracle Streams to help in propagating information within and between databases.
• Upgrading development and production databases to Oracle 10g.
• Applying Security patches and Patch set on Oracle Databases.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Implemented flashback technology.
• Performing Cross platform migration using transportable table spaces and RMAN.
• Extensively used AWR, ADDM, TKPROF, SQL and MySQL Trace for database performance statistics.
• Using OPTIM Configuration manager track configuration changes, resolve problems by working with current and historical configuration data, and manage client configurations.
• Tuning the Database, for linux, unix, and windows using OPTIM QUERY TUNER.
• Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Integration of systems using Oracle Database Gateway in heterogeneous environment.
• Development of application using Database Gateway for both Oracle and SQL Standards.
• Considerable knowledge of design, Administration, and performance tuning of MySQL.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Troubleshooting user related and database related issues using Oracle Support Services.

Environment: Oracle 9i/10g/11g, Sun Solaris, Red Hat Linux, AIX, OEM GC, ASM, RMAN, STATSPACK, AWR, ADDM, VERITAS Net backup, TOAD, SQL Developer, AppWave, Perl scripting, Shell scripting, SQL*Loader, MySQL, Data guard, Stored Procedures, Grid Control.

Confidential, Trumbull, CT

Sr. Oracle DBA

Responsibilities:

• Migrated Oracle 10g/11g RAC and non-RAC Single instance databases with ASM using Transportable Tablespaces Provided 24x7 on call DBA support for over 250 Oracle 9i/10g/11g production, QA, DEV databases on RHEL, HP-UX, IBM-AIX.
• Involved in the installation, configuration of multi node -- 2, 3, 4 Node Oracle 10g/11g RAC with ASM.
• Architect for the cross platform database migration comprising of VLDB multi-terabyte databases from Sun Solaris, HP-UX to RHEL using Cross platform Transportable Tablespaces (XTTS).
• (TTS), Datapump, SAN Synchronization SRDF.
• Upgraded production, Development databases from Oracle 9.2.0.8, 10.2.0.2, 10.2.0.4 to 11g/11g RAC.
• Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.
• Setup, reconfigured and monitored single instance and multimode RAC to RAC Dataguard for DR.
• Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.
• Created new databases/ instances on 11g/10g RAC and single instances using customized scripts, DBCA.
• Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.
• Developed, modified and optimized very complex queries to data retrieval usingExplain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat, etc.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
• Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
• Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.

Environment: Oracle 9i/10g/11g, Sun Solaris, Red Hat Linux, AIX, OEM GC, ASM, RMAN, STATSPACK, AWR, ADDM, VERITAS Net backup, TOAD, Perl scripting, Shell scripting, SQL*Loader, MySQL, Data guard, Stored Procedures, Data Vault, Grid Control, SFTP.

Confidential, Brooklyn, NY

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 ASM feature of Oracle.
• Expertise in setting up Siebel servers, Siebel Web Servers, Database Servers, Actuate Report servers, Remote, Anywhere, migration, Server administration.
• 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.
• 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.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, MySQL, Database design, database tables, indexes, Instance, memory, operating system and java calls.
• Verifying MySQL replication integrity with pt-table-checksum.
• Developed UNIX shell scripts to perform the above tasks efficiently.

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

Confidential, Tampa, FL

Oracle DBA

Responsibilities:

• Installation and creation of Oracle 9i databases on Production and Test Linux servers. Responsible for Upgrade & Migrating databases from 9i to 10g, applying patches.
• Performed various tasks like administering RAC using SRVCTL, adding nodes and instances, administering storage components, parameter management, configuring high availability features for RAC.
• Installed RAC on Oracle 10g and worked on ASM feature of oracle.
• Refresh test database from production using Recovery Manager (RMAN).
• Troubleshoot databases, provide reports on the database health check, follow up and recommendations.
• Great experience in using FTP utility program for copying files on Unix and Windows systems.
• Managing database instances for Production and test environments to ensure strong testing environment and smooth transition to production.
• Responsible for Monitoring and Estimating the size of the database & growth, and configuring the database accordingly.
• Responsible configuring listeners for Network Connectivity and Security.
• Diagnose and Resolve Performance, Connectivity, Security and Database corruption issues in a critical production environment.
• Responsible for taking regular backups including Cold / Hot backups, Export / Import of database, using RMAN, and recovery in case of disasters.
• Creation and Maintenance of stand by database by using oracle high availability method Oracle Data Guard.
• Interacted with Data modelers, Developers, Application owners for gathering the required information and resolving various issues.

Environment: Oracle 9i / 10g, OEM, RMAN, DBCA, Data Guard, Putty, XML, FTP, TOAD, UNIX, Solaris, Windows XP

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Installation, Implementationand Maintenance of the Oracle database.
• Created and managed the database objects such as tables, indexes and views.
• Create the users and roles.
• Created and managing the database storage structures which includes data table spaces, index table spaces, rollback table spaces and rollback segments.
• To improve the performance by Using the Hints, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data.
• Database maintaining including backups, recovery, imports/exports.
• Monitoring the database daily activities.

Environment: Oracle 9i, SQL,PL/SQL, TOAD, Oracle Enterprise Manager, SQL*Loader, Sun Solaris, Red Hat Linux.

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.
• 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 9i, TOAD, Database Tools/Utilities, Oracle Enterprise Manager.