SUMMARY

• Over 7+ years of experience in IT industry as Oracle Database administrator, having exclusive experience in database administration, installation, configuration and upgrades with Oracle Software 11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.
• Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 8i,9i to 10g and 10g to 11g applied oracle patches.
• Extensively used Database Administrative tools like Oracle Enterprise Manager, DBA Studio, SQL*PLUS, TOAD.
• Experience in fulfilling DBA daily activities, schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, views, sequence).
• Worked on space management (tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• Involved in performance tuning and database reorganizations. Performed SAN analysis and provided recommendations .Worked on Disaster Recovery and Implementation
• Setup and installed Oracle 11g,10g RAC software with ASM & OCFS2 File systems.
• Maintenance and tuning of RAC Applications. Used rapid install and other Oracle Application maintenance utilities like OEM, CRS Cluster.
• Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Experience in designing, implementing and supporting highly available RAC clusters for companywide single sign on application, as well as other database solutions using advanced replication and standby (data guard) options.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup. Incomplete recovery and disaster recovery using Standby database or Data Guard by implementing RMAN backup.
• Experience in performing Oracle 11g databases on single RAC Cluster and also Configured two node Oracle 9i RAC cluster.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, data migration, data clean-up, data archiving, etc.
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Database replication using snapshots, materialized views and advanced replication methods.

TECHNICAL SKILLS

Relational Databases: Oracle 11g, 10g, 9i, MS SQL Server

Languages: SQL, PL/SQL, UNIX Shell Scripts, HTML, Java, C

Tools: OEM/Grid Control, Toad, Visual Studio, Microsoft Office Visio, SQL Developer, WinSCP, Putty, SSH Client, Telnet, PL/SQL Developer.

Oracle Utilities: RMAN, Data Pump Export/Import(expdp/impdp), SQL* Loader, DBVerify, DBCA

Disaster Recovery and High Availability: Oracle Data Guard, Oracle RAC 11g

Data Modeling Tools: Microsoft Office Visio, Erwin

Storage Systems: ASM (Automatic Storage Management), Veritas, Hitachi, NetApp& EMC

Operating Systems: UNIX, Sun Solaris, Red Hat Enterprise Linux, Windows Servers

PROFESSIONAL EXPERIENCE

Confidential, Round Rock, TX

Sr Oracle DBA

Responsibilities:

• Experience in Design, Creating and maintaining the Oracle Databases 9i, 10g and 11g from the scratch on UNIX, LINUX and WINDOWS environment.
• Involved in the 10g 2 Node RAC installation on RHEL 5.4 server
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
• Involved in the Migration projects Extensively using Data pump and Rman utilities
• Migrated 100GB database from Windows SQL server to Oracle server using SQL Developer tool
• Excellent in writing SQL scripts using SPOOL command
• Expert in using Data pump
• Involved in the migration of huge databases of sizes ranging from 100GB to 7TB
• Daily Health Check Up of the Database and SQL Queries using Statspack, AWR, ADDM and TKProf.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Experience in moving the data from one server to another server using SFTP,FTP and SCP
• Building new databases and schemas from the scratch on Linux and UNIX Boxes.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Schema Refreshing of databases using normal copy method and exp/imp utility.
• Cloned database and schemas using Data pump for 10g and 11g versions.
• Cloned 10g and 11g databases using RMAN duplication(with and without backup)
• Involvement in space management, rectification of lock problems, user management.
• Responsible to provide 24 x 7 database administrative activities over different database servers
• Regular Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump utility for oracle 10g and 11g servers.
• Configured Oracle Data guard for Oracle Disaster recovery on standalone database
• Troubleshooting ORA errors when occurred
• ASM Disk storage and user Management
• Performance Tuning for the SQL queries by scrutinizing the long running sql queries
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links using sql scripts
• Scheduled Oracle Jobs and Backups using CRONTAB.
• Experience in Online and Offline backups and recovery.
• Experience in backups and recovery using RMAN shell Scripts.
• Performed Schema as well as Table level Replication using Oracle Streams.

Environment: Oracle 11g/10g/9i, HP-UX UNIX, RHEL 4.x/5.x, ASM 10.2.0.4, OEM (Grid Control), RMAN and Data Guard, STREAMS, Explain Plan, SQL Developer, PL/SQL Developer, Data Pump, Business Objects, Toad 9.7.2.5, PUTTY,FTP, SFTP,SCP

Confidential, Stamford, CT

Sr. Oracle DBA

Responsibilities:

• Provided 24x7 support and On-Call rotation when needed for very large databases.
• Installed Oracle 10g on Linux and RAC 10g and worked on ASM feature of Oracle.
• Estimate the size of the database and its objects (in large database of 1 to 2 Terabyte).
• Upgraded database from Oracle 9i to 10g and 10g to 11g, having a good exposure on Oracle11g.
• Installation and configuration of Oracle 10g RAC 2 node on Linux.
• Applied CPU security patches in both RAC and standalone systems in ASM environment.
• Experience with Oracle 10g grid control.
• For the improvement of database performance implemented database tuning and its requirements and reviewed it.
• Involved in Database and Transaction log Backups and Restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them as required.
• Create Database users and roles and implement appropriate user security.
• Experienced with Oracle 10g ASM feature.
• Implemented active-active configurations usually require data conflicts to be managed by the application, suitable for custom applications.
• Implemented Oracle Replication through materialized view.
• 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.
• Experience with database partitioning and responsible for daily loads.
• Experience with DDL and DML operations and having sound knowledge.
• Good experience with Oracle performance issues in both application tuning &memory tuning.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Writing UNIX shell scripts to manage Oracle environment and application processes.
• Responsible for maintaining Oracle 10g data guard and 9i standby databases in Solaris, Linux and Aix platforms.

Environment: Linux 4,Oracle 9i/10g/11g RAC, Toad, 10g Grid, Windows NT/2000,OEM,Oracle Streams, Oracle Gateway, SQL*Plus, Shell Scripting.

Confidential, Troy, MI

Sr. Oracle DBA

Responsibilities:

• Provided Primary architectural and administrative support for new projects
• Installed Oracle 9i and 10g databases on HP-UX 11.0, Red hat Linux 4.x
• Involved in Installation of RAC on Oracle 10g and worked on ASM feature.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage
• Performance Tuning i.e., Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Involved in monitoring Streams environment using various tools like OEM Console.
• Oracle Grid Control Management Server Installation
• 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.
• 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
• 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
• Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, OS and java calls
• Developed UNIX shell scripts to perform the above tasks efficiently
• Worked as a member of production DBA team in perfect coordination with seniors and team members.

Environment: Oracle 10g/9i, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, Data Guard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, and TKPROF, Toad, Pl/Sql.

Confidential, Romulus, MI

Jr. Oracle DBA / Oracle DBA

Responsibilities:

• Maintaining the database availability and security
• Involved in maintenance & updating the database
• Manage several heterogeneous database instances
• Created Oracle tables in Oracle, Partitioned tables, Created Indexes.
• Trained on Data modeling using Erwin data modeling tool.
• Recommend alterations/enhancements to improve database optimization.
• Troubleshoot, diagnose and resolve complex database problems; ensuring high performance operation and minimal disruption of business critical systems.
• Planning, designing and implementations of strategies for backup & recovery
• Review of Database logical and Physical design
• Install, upgrade and maintain Oracle 9i, 10gi on Sun Solaris and Windows 2003, Redhat4
• Installation, setup and configuration of DATA GUARD
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database
• Write and modify UNIX shell scripts to manage Oracle environment
• Performed Data Migration as a part of enterprise data warehouse project
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup
• Cloning databases using scripts as well as RMAN
• Established database backup/recovery strategy for different databases
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files
• Logical and Physical data modeling using Erwin, Dimensional/ OLAP Data Modeling, Relational/ OLTP modeling
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store
• Performed scheduling Control-m for scheduling jobs

Environment: Oracle 9i and 10g, Sun Solaris, Red Hat Linux, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, AIX, TOAD, Erwin, STATSPACK