Professional Summary

Over Sevenyears of experience in the Information Technology field as Oracle Database Administrator having hands on experience in database administration, development, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security on various environment like Sun Solaris, RHEL, HP-UX, AIX, LINUX and Windows.

• Extensive knowledge on database administration for Oracle 11g RAC/10g RAC/9i/8i.
• Expert in backup/recovery, installation, configuration,apply patches, troubleshooting, performancemonitoring, cloning, upgrading and migration of oracle software and tools.
• Solid experience in Oracle Recovery Manager (RMAN), and standby database using Data Guard.
• Expertise in the database infrastructure design which also include Real Applications Clusters (RAC), Standby Databases (Data Guard).
• Data transferring with export/import utilities and Data Pump and SQL* Loader.
• Good experience in SQL, PL/SQL Programming (Functions, procedures, packages and triggers).
• Developed SQL, UNIX and LINUX shell scripts to automate DBA functions. Diagnosed problems and implement corrective actions.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Listener, TNS Names, SQL*Net.
• Experience working with Oracle Data Integrator (ODI).
• Maintained large production as well as development/test/stage databases which involve Data warehousing and OLTP applications.
• Proficient with OEM, Erwin, SQL Developer, RMAN and Toad.
• Experience in implementing Oracle Streams and in installation and administration of GoldenGate.
• Experience in Capacity Planning and Bench Marking.
• Experience in all facets of the systems development lifecycle, from requirement development, architecture design, testing, and post implementation revisions.
• Capable of working under pressure and stiff deadlines with 24/7 Database support.
• Experience in analyzing, translating business requirements to technical requirements and architecture.
• Experienced in performance tuning of various aspects of the database by using oracle utilities like TKPROF, EXPLAIN PLAN, STATS PACK, SQL_TRACE, TOAD and Automatic Database Diagnostic Monitor (ADDM).

TECHNICAL SKILLS
Databases : Oracle 11g R2 RAC, 10gR2RAC, 9i, 8i, 7.x, IBM DB2.
Operating Systems : HP-UX, Sun Solaris, AIX, Linux and Windows.
Languages : SQL, PL/SQL, Java, C, UNIX Shell Scripting.
Tools : RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD, DB Artisan.
Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR, OEM Grid Control
ETL Tools : Informatica 5.1, Data pump.
Other : EMC, Net App, VERITAS

EDUCATION
Bachelor of Engineering

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL Oct 2009 to Till Date
Senior Oracle DBA

Responsibilities:

• 24/7 Production Database support of multi-terabyte Oracle 11g database.
• Performed all aspects of database administration including Installation, Configuration,Patches, Monitoring, Import/Export, Cloning, etc.
• Installation, configuration and administration of Oracle Real Application Clusters (Oracle 11g RAC/Oracle 10g RAC) and Standby Databases for High Availability and Disaster Recovery purpose.
• Plan, implement, and troubleshooting Oracle RMAN backup, restore, and recovery.
• Provide performance tuning, problem diagnosis, data reorganization and database upgrade support.
• Monitor and tune Oracle database for optimum performance. Assist in capacity planning of Oracle database servers.
• Responsible for Creating, Constructing, Operating and maintaining Interfaces using ODI.
• Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports and monitored statistics for performance tuning of the database.
• Performed Data replication and Data transformation.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Performed data loads using SQL*LOADER.
• Developed PL/SQL Packages, functions and triggers to implement various functionalities.
• Experience in Managing work repositories and creating reports.
• Installation and administration of GoldenGate.
• Wrote UNIXShell Scripts for Backup and cloning.
• Tune SQL, PL/SQL statements found in the reporting utilities and queries.
• Involved in the maintenance and trouble shooting of RAC Databases.
• Monitored and managed the space usage and table partitioning.
• Implemented and Configured Standby database (Data guard) for disaster Recovery.
• Primary point of contact between customer and core development team.

Environment: Oracle 11g RAC/10g RAC,RedHat Linux, Sun Solaris, HP-UX, AIX, Windows, Oracle Data Integrator, GoldenGate, SQL, PL/SQL, RMAN, SQL*Loader, Import/Export, Data Pump, Data guard, AWR, ADDM.

Confidential, Dallas, TX Feb 2008 to Sep 2009
Database Administrator

Responsibilities:

• 24/7 Production Database and Applications support.
• Installation and configuration of the Development, Test and Production databases.
• Installation, configuration and administration of Oracle Real Application Clusters (Oracle 11g RAC/Oracle 10g RAC) and Standby Databases for High Availability and Disaster Recovery purpose.
• Performed database logical and physical design, maintenance, archiving, cloning, administration and upgrades for Oracle.
• Performed and monitored Hot and cold database backups and implemented backup and recovery using RMAN and Knowledge of storage technologies SAN, NAS
• Involved in the Design of Backup and Recovery Strategies using RMAN and traditional backup methods.
• Involved in performance-tuning activities to improve performance of the Oracle database. Tune database through initialization parameter, SQL/PLSQL statement, and memory by performing routine checks of the SGA, CPU, logical and physical I/Os and contention.
• Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, recovery time allowed etc.
• Applied patches and updates to the Oracle database.
• Provided documentation as well as training on process and procedures for infrastructure architecture.
• Worked on Shell scripts to automate system and database administration tasks.
• Designed data files, log files and control files layout across disks.
• Developed PL/SQL Packages, procedures and triggers to implement various functionalities.
• Support and ensure the high availability of all the databases especially on Clustered Databases.
• Implemented Oracle Real Application Clusters (RAC).
• Generated and analyzed STATSPACK, AWR, ADDM,Explain Plan reports and monitored statistics for performance tuning of the database.
• Experience in setting up and administering Oracle Streams. Configured replication based on Oracle Streams.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Used Erwin database design tool and Oracle Enterprise Manager (OEM).
• Troubleshooting for Production database issues/Performance issues based on Remedial tickets.
• Documentation of RAC Database Setup, Stream Replication and administration of Server Environment.

Environment: Oracle Database 10g RAC/9i, RedHat Linux, HP-UX, Sun Solaris, AIX, OEM Grid Control, TOAD, RMAN, Data Pump, SQL*Loader, Erwin.

Confidential, Lehi, UT Dec 2006 to Jan 2008
Database Administrator

Responsibilities

• 24x7 Production support.
• Installation and configuration of Development, Test and Production Oracle 10g/9i databases.
• Performed periodical Backup and Restoration and recovery using RMAN (full & incremental) and RMAN incrementally updated backups.
• Installed and configured Oracle Databases and implemented 10gRAC. Also applied Patches
• Implemented the RAC on ASM.
• Installed OEM and Oracle Agent, Configured Data guard.
• Performance Tuning of queries using Explain Plan, tuning of other objects in the database, tuning of database, tune memory structures.
• Upgraded Database from Oracle 9i to 10g.
• Synchronized test and development areas with production and performed database design and re-design activities as necessary to support all projects.
• Extracted and loaded data using Oracle SQL Loader and Export/import.
• Wrote Shell Scripting for monitoring and backup and cloning automation.
• Implemented Database Replication for high availability by Oracle Stream.
• Used different v$ views to study the database activities taking care of SQL*Net related problems like listeners and connect strings.
• Implemented hot standby database for production database. Setup and successfully performed active failover in the event of production failure.
• Write and execute SQL statement against database and its objects.
• Write and execute PL/SQL code such as procedure, function, package or trigger as well as working with pre-defined Oracle package to administrate database.
• Dealt with High Availability and also Disaster recovery for 24 x 7 hour mission critical applications.
• Make recommendations and contributed to future architecture enhancements.
• Co-ordinate between Client and Development Team on critical fix's and Configuration Issues.

Environment: Oracle 10g RAC/9i, HP-UNIX, Sun Solaris, Windows Servers, SQL*Net, IBM-AIX 5L, SQL Loader.

Confidential, Hyderabad, INDIA Jun 2005 to Nov 2006
Oracle DBA

Responsibilities:

• Part of a 5 member DBA team which was involved in the maintenance of the Oracle 9i/8i 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.
• 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 partition and index partition.
• Troubleshooting for Production database issues/Performance issues.

Environment: Oracle 10g RAC/9i/8i, HP-UNIX, Linux SUSE, SQL, Oracle Replication, Explain Plan, Toad

Confidential, Hyderabad, INDIA Aug 2004 to May 2005
Oracle DBA/Developer

Responsibilities:

• Installation and Configuration of Oracle 9i/8i.
• Plan and build database instances and objects.
• Performed Periodical backups.
• Restoration and Recovery.
• 24x7 Production database and applications support.
• Performed all aspects of cloning, partitioning, troubleshooting, applying patches and database monitoring.
• Used Explain Plan and oracle optimizer hints to enhance performance of SQL statements.
• Performance Tuning of queries using EXPLAIN PLAN, TKPROF and SQL TRACE tuning of other objects in the database, tuning of database, tune the memory structure.
• Creation and maintenance of user accounts and system & user level database objects.
• Creation of the required objects for the application.
• Back end Programming using SQL and PL / SQL.
• Conversant with logical and physical design, configuring and layout of database.
• Understood the application architecture and suggested steps for improved performance.
• Responsible for porting data from the existing billing using data migration tools along with SQL Loader and Import/Export and consistency checking.
• Configuring TNSNAMES.ORA and LISTENER.ORA for Client Server Connections.

Environment: Oracle 9i/8i, SQL, PL/SQL, Sun Solaris, HP-UX, RHEL, SQL Loader.