Professional Summary

• 7+ years of professional IT experience in Administration, Systems Design Development, Maintenance, Testing, Integration, documentation in high-availability environments.
• Expert in Architecture of Oracle Databases 11g RAC, 10g RAC, 9i, 8i with objectives of saving costs and time.
• Excellent experience in Installing, Configuring and maintaining Oracle 8.1.x/9.x/10g/11g on Operating Systems such as Sun Solaris, IBM AIX, HP-UX, SCO-Unix, Red Hat Linux, Oracle Enterprise Linux and Windows
• Strong experience in supporting production, development, unit test, system test, Integration test, certification test databases under UNIX/LINUX.
• Experience in managing large mission critical databases high availability and disaster recovery environments in 24*7 using Oracle RAC, Standby databases (Active Data Guard).
• Experience in Upgrading databases (8i to 9i, 9i to 10g, 10g to 11g, 9i to 11g)
• Involved in doing Data Modeling, Data Mart, Data Warehousing, Data Transformation.
• Proficient in Database Administration activities such as Upgrades, Patches, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Expert in Administration, Productivity and Modeling Tools including OEM, Data pump, Exp/Imp, VERITAS, OLAP/Partition/RAC, Erwin, TOAD, SQL, Home-made Scripts.
• Expert in Database Health Maintenance using Stats pack, TKPROF, RACDIAG, RDA, Explain Plan ,Enterprise Manager, Self-developed Scripts & methodology, Procedures.
• Expertise in cloning databases using manual methods and using RMAN Duplicate DB to create Test, Development databases.
• Experience in Database Space Management, Memory Tuning and Application Tuning.
• Expertise in troubleshooting and performance monitoring and tuning
• Experience in Backup and Recovery activities using RMAN and conventional backups.
• Sound experience in different phases of a project life cycle including design, architecture, programming, testing, end user support, and preparing customer specifications as a part of software requirements.
• Expert in configuration of 11gRAC, 10gRAC, Standby Databases (Active Data Guard) for High Availability, Disaster Recovery and reporting.
• Extensive experience with proactive monitoring, Capacity planning, benchmarking, partitioning.
• Experience in SQL (DDL, DML, and DCL), and PL/SQL and experience in writing stored procedures, packages, functions, and triggers.
• Expertise in Replication of Oracle Databases using Streams and Golden Gate.
• Expertise in data archive and purge methodologies using korn scripting and pearl scripting.
• Expert in using Bitmap, B-Tree Indexes, Composite indexes, partitioning and histograms.
• Team player, maintained client/customer relationships by providing timely, quality and services, understanding of client/customer needs, opportunities and satisfaction criteria.
• Proficient in interpersonal relations, leadership skills, Project Management, Communication, Partner Teamwork, and Organization

Technical Skills

Databases : Oracle 11g RAC, Oracle 10g RAC, Oracle 9i, Oracle 8i, Oracle 7.3
Operating System : HP UX 10.x, 11.x SunOS 10, 9, Linux RHEL 4.x, 5.x, AIX5L Windows 9x/NT/2000, UNIX, DOS
Programming : PL/SQL, Pro*C, SQL*Plus, C, C++, Shell Scripting, HTML
Tools : RMAN, ASM, Golden Gate, Streams, DataPump, TOAD, SQL*Loader, AWR, ADDM, TKPROF, STATSPACK, Putty.

Education

Bachelor of Technology .

Professional Experience

Confidential,Atlanta, GA. Apr 10 - Present
Oracle Database Administrator

Responsibilities

• 24x7 Production database and applications support.
• Administering ORACLE Databases 9i, 10g, 11g and also Oracle10g RAC/11g RAC.
• Applied patching for upgrading database from 9i to 10g,10g to 11g and also for other updates.
• Experience in managing databases on high availability environment (Oracle RAC & Active DataGuard).
• Configured Oracle grid control to manage the entire database in single centralized location.
• Applied database patches using Opatch utility, building Clone instances for Development and Test teams.
• Managing multiple production, testing, QA and development databases.
• Cloned/Refreshed databases from production database to test and development.
• Implemented backup and recovery strategies using export/import, RMAN Incremental backups), Traditional hot, cold backups.
• Created shell scripts and scheduled them for monitoring Oracle Databases.
• Working with Development, QA and other teams to support the related issues.
• Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information givenbased on business requirements.
• Migrated databases from HP-UX to LINUX.
• Setup Standby databases including Active Data Guard for disaster recovery and reporting.
• Implemented Oracle RAC with Data Guard implementation for disaster recovery.
• Planning and implementing Backup and Recovery procedures (RMAN), scheduling daily backups and performed periodic recovery tests.
• SQL tuning using SQL Trace and TKPROF, Explain Plan, STATSPACK, AWR, ADDM.
• Tuning init.ora parameters for optimal performance and scalability.
• Running AWR reports to figure out the bottleneck and analyze using ADDM.
• Database Maintenance and clearing of locks, cleaning of database logs, Rebuilding indexes, Tablespace monitoring, database objects monitoring.
• Designing and developing PL/SQL packages in the database layer, stored procedures, packages, functions and triggers.
• UNIX scripting for automation backups, monitoring, statistics collection as well as for other routine tasks.
• GoldenGate installation, configuration for replication.
• Designing the security and database access strategies & cloning databases and partitioning tables.
• Creating and refreshing materialized views & performing SQL*loader jobs for data loading.
• Writing PL/SQL procedures for Extraction Transformation and Loading of data with External Tables.
• Applied database patches using Opatch utility & worked on conversion from single node to Multi Node RAC.
• Performance tuning and Monitoring using OEM/Grid Control.
• Problem resolution repository is built in custom DBA ticketing tool.
• Working with Development, QA and other teams to resolve the issues.

Environment: Sun Solaris, HP UX, AIX, Linux RHEL, Oracle 10gRAC/11g RAC, Data Guard, Datapump, RMAN, ASM, GoldenGate , PL/SQL, SQL Scripts, Shell Programming, TOAD, Putty.

Confidential,Omaha, NE Oct 08 - Apr 10
Oracle Database Administrator

Responsibilities

• Managed several production, test and development instances (24x7 Support).
• Installed, configured and managed Oracle 10g RAC/ 11g RAC, Standby databases.
• Administering ORACLE Databases 11g, 10g, and 9i.
• Applications Patch management: Patch application and impact analysis, and trouble shooting.
• Involved in implementing Dashboard-based Monitoring solution by developing shell scripts and SQL scripts.
• Performance Tuning Databases using SQL Trace, TKPROF, Explain Plan, STATSPACK, AWR, ADDM.
• Migrating Oracle databases from Windows to Linux.
• Monitoring growth of tables and undertaking necessary re-organization of database objects when required and generating trace files for problem resolution.
• Responsible for backup/recovery using and performing backups and recoveries.
• Responsible for setting-up and managing Standby databases.
• User Maintenance (Creation, modification and deletions) and Custom code migrations.
• Proactive database monitoring using Oracle 10g grid control.
• Worked on user documentation like Instance strategy, Instance management, Problem manager, Setup document and Change management docs.
• Problem resolution repository created to reduce issue resolution timings.
• Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given by the application developers.
• Creating and managing users, roles and profiles, auditing and monitoring user access.
• Planning and implementing Backup strategy for the databases, Scripting backups.
• Planning and implementing Backup and Recovery procedures (Hot, Cold Backups and RMAN), scheduling daily backups and performed periodic recovery tests.
• Involved in a project, which analyzes and applies quarterly Security patches (CPU&PSU).
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora
• Allocated system storage and planned for future storage requirement for the database.
• Created primary database storage structure for developers to develop and test the Application.
• Data loading using Oracle SQL Loader, developing SQL Loader scripts to load global data, and fine tuned SQL Loader performance using Direct-load mechanism.
• Estimating the space requirements for database growth for next 12 months and availability of hardware to support the processes.
• Developing, Implementing and administering database policies and procedures.

Environment: HP UX, AIX, Linux RHEL 4, Oracle 11g RAC, 10gRAC, Oracle 9i, PL/SQL, SQL Scripts, Shell Programming, TOAD, Data Guard, RMAN, ASM, GoldenGate, Putty.

Confidential,Las Vegas, NV. Aug 07 – Oct 08
Oracle DBA

Responsibilities:

• Configured and managed Large database using latest features of Oracle 9i/10g like Undo-Table space, Locally Managed Table space and Sorting Parameters.
• 24x7 Oracle Production Database Administration including Oracle 10g RAC.
• Wrote proactive scripts monitoring like monitoring the disk usage and the memory usage of the server and monitoring tablespaces and mailing alerts when required.
• Involved in Logical backups, RMAN backups, Hot backups and Cold backups.
• Created and configured Data guard for physical Standby database on a fresh server starting from Oracle Installation in No-Data-Loss mode.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Installed Oracle 9i and 10g, RAC database on HP-UX 11.0, Redhat4 and Sun Solaris.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks like Backups, exports and imports, archiving old records and verification of such processes.
• Used DBMS scheduler to schedule the jobs and DBMS stats to gather the statistics along with analyze command.
• Installation of Oracle RDBMS server software and version upgrades.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora
• Applied patches.
• Created Materialized views to make query response faster and have written shell scripts to refresh them.
• Created and managed tablespaces by adding/deleting/ resizing data files.
• Finest granularity approach to Oracle implementation and de-fragmentation.
• Creating DATAGUARD with logical- standby configuration with hot backup and testing it for fail-over and switch over in different modes.
• Extensively Installed Oracle10g and Upgraded the database from Oracle 10gR1 to 10gR2 on Linux platform.
• Monitored growth of data and purged old records through automated scripts.
• Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.

Environment: Oracle 9i/10g, RAC, Sun Solaris 5.9, AIX 5.3,Redhat LINUX, Windows Server 2003, OEM, SQL*Loader, SQL*PLUS, TOAD, RMAN.

Confidential,India Mar 06 - Jul 07
Oracle Database Administrator

Responsibilities

• Responsible for installing, upgrading and configuring the Oracle server.
• Supported different Oracle 10g, 9i Databases of Production, Testing, Staging and Training.
• Involved in logical and physical data modeling and schema design using Erwin tool.
• Created database manually using Oracle Database Configuration Assistant.
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Creating databases, tablespaces, objects, roles and privileges.
• Partitioned large tables to increase the performance and to improve I/O access.
• Responsible for Data load on different databases using SQL*Loader.
• Export and import of database objects using EXP and IMP Utilities.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Using database level triggers code for database consistency, integrity and security.
• Involved in the database design, installation, creation of various instances, and creation of tables, granting roles to users and maintain the security according to application.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc. Created users and roles, and maintained system security.
• Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, TKPROF, STATSPACK, SQL*Net, IMPORT/EXPORT, DataPump and RMAN.
• Managing table spaces, user profiles, indexes, storage parameters.
• Develop table structures, PL*SQL stored procedures and database triggers to implement.
• Responsible to provide 24 x 7 database administrative activities over different database servers.

Environment: Sun Solaris, HP UX, AIX, Linux RHEL, 10gRAC, Oracle 9i, Oracle 8i, PL/SQL, SQL Scripts, Shell Programming, Oracle Enterprise Manager, TOAD, Data Guard, RMAN

Confidential,Hyderabad, INDIA Jul 04 - Feb 06
Oracle DBA/Developer

Responsibilities:

• Configured and installed Oracle 9i on UNIX environment.
• Upgraded database from Oracle 7.3 to 8i, 8i to 9i
• Actively participated in team meetings with Business team for changes in design of the database.
• Worked on database setup and monitored the database growth on daily basis.
• Involved in the logical and physical design of the database tables.
• Sizing database objects for effective space management and optimal performance.
• Actively participated in Database and application developers troubleshooting.
• Developed scripts for hot, cold and logical backup.
• Performed Backup and Recovery using RMAN and user managed techniques.
• Modified and established backup and recovery strategies and procedures.
• Administrated User accounts by creating users, roles and privilege and managing those using grants and profiles.
• Created tables, views and other schema objects with appropriate table space sizes.
• Database maintenance, upgrades, and patches release.
• Worked on database performance monitoring using OEM.
• Carried out Physical and Logical database design and database reorganization.
• Written SQL, PL/SQL functions, procedures, packages and triggers.
• Written shell scripts for backup and cloning automation, custom monitoring
• Created database links for accessing data from remote databases.
• Used EXPORT/IMPORT utility for performing logical backup for table level and full databases.
• Used the Crontab in UNIX and Scheduler in Windows for Automatic Tasks (Analyzing tables, loading into Tables, Imp/Exp).

Environment: Oracle 9i, 8i, 7.3, SQL*Loader, SQL*Plus, OEM, ASM, PL/SQL, RMAN, LINUX, HP-UX, Sun Solaris, HP-UX,SQL Server 2005,My SQL, Erwin, Windows 2000.