SUMMARY:

• Over 7 Years experience as Oracle Database Administrator. Oracle 11g RAC/10g RAC/9i/8i databases running on different environments such as Sun Solaris, HP-UX, AIX, Red Hat Linux, and Windows.
• Proficient in Oracle Database Administration activities such as Upgrades, Migrations, Patches, Cloning, Backup & Recovery, Performance Tuning, capacity planning, shell scripting, and documentation.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g & 11g with experience within very large scale database environment and mission critical OLTP and OLAP systems.
• Excellent experience in migrating the Databases.
• Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management, and monitoring
• Experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB).
• Hands On Experience in installing, configuring and managing Oracle 11g R2 RAC, Oracle 10g RAC
• Experienced at using Oracle Enterprise Manager/Grid Control (OEM/GRID CONTROL)
• Performance monitoring and tuning with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 10046 TRACE, AWR, ADDM.
• Successfully implemented physical Standby database using Oracle Data Guard feature for High availability configuration.
• Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation.
• Experience in Flash-Back Recovery, Data Pump, AWR, ASM, ASH and ADDM, Recycle Bin and Grid Monitoring.
• Migrated databases from Windows to Linux, Sun Solaris to AIX
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Knowledge on Oracle Support processes for technical requests through Meta link.
• Planning and scheduling for the backup of database information using UNIX shell script and Crontab jobs.
• Experienced in using Oracle's Transportable Table space (TTS) feature allows users to quickly move a user Table space across Oracle databases.
• Strong knowledge and experience of managing Oracle8i, 9i,10g and 11g RAC environments using the OEM Grid Control tools.
• Data transferring with Export, Import, Data Pump and SQL* Loader utilities.
• Experience in using packages like DBMS_JOBS, DBMS_SCHEDULER to schedule tasks and used DBMS_STATS to gather the statistics.
• Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.
• Skilled in database upgrades 8i to 9i, 9i to 10g R2 and 10g to 11g.
• Refresh/Cloning of Database and applications for development and testing purpose.
• On call 24x7 Production Support Worked beyond regular hours.
• Dealing with database security and auditing.
• Excellent communication, interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment.

TECHNICAL SKILLS:

Operating Systems : HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2,5.3,6.1,7.1 Red Hat Linux 4.x, 5.x,6.x, MS Windows 98/2000/ME/NT/XP/Vista
Programming Languages: SQL, PL/SQL, Unix Shell Scripting.
RDBMS : Oracle 8i/9i/10g RAC/11g RAC
Software’s, Applications and Tools: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, DB Artisan, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR and ADDM, SQL Developer, Golden Gate
Web Related and Other Tools : HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metalink, MS Visio

EDUCATION:

Bachelor of Engineering

Experience:

Confidential, Irving, TX December 2010 - Till Date
Sr. Oracle DBA

Responsibilities:

• 24x7 on-call production database support
• Installation and Configurations of Oracle 11g, 10g.
• Installed Oracle 11g RAC, 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Installation, configuration, maintenance and tuning of Oracle 11g and 10g databases.
• Upgraded Oracle Database from 9i to 10g, 10g to 11g.
• Applied CPU patches
• Migration of the database from Sun Solaris to IBM AIX, Windows to Linux.
• Expertise in recovering the database. Performed complete and incomplete database recovery.
• Configured and maintained Grid Control Repository and Deployed OMS Agents on different database servers.
• Automated the nightly RMAN backups
• Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
• PL/SQL Programming.
• Developed PL/SQL scripts for Extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.
• Using the 11g Grid control, OEM for the database tasks like adding the data file, resizing the data file, code compilation, User/Role creation and maintenance etc.
• Experience in taking backups with RMAN in both Catalog/ No catalog modes.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Recovery Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• RMAN Incremental backups
• Logical and Physical Database Design
• Capacity Planning and bench marking
• Partitioning of the tables for better performance and manageability
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed policies on data confidentiality, integrity, availability, and auditability, Based on Access Controls for Access to Data at the database level.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Cloning databases using scripts as well as RMAN.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Enabled the audit on all the dev/test databases, analyzed and reported the audit records about the suspicious activity in the database.
• Monitoring the database storage and day-to-day activities.
• Table partitioning for better performance.
• Golden Gate installation and configuration.
• Replication using Golden Gate.
• Performed all aspects of database administration including installs, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.

Environment: Oracle 11g RAC, Oracle 10g RAC, RedHat Linux, IBM AIX, Sun Solaris, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL*Loader, ERWIN, Data Pump

Confidential, Temple Terrace, FL October 2009 – November 2010
Oracle DBA

Responsibilities:

• 24x7 on-call production database support
• Installation and Configurations of Oracle 11g, 10g.
• Installed Oracle 11g RAC, 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Implemented Data Guard for Disaster recovery
• Setup and configure Standby database for high availability by using Data Guard.
• Migrated & upgraded databases from Oracle 10g to oracle 11g
• Installed and implemented Golden gate to replicate data between databases.
• Replication using Oracle Streams.
• Documented instructions for migrating & upgrading databases.
• Refreshed schemas from Production environment to Dev/Test environment using exp/imp and expdp/impdp utilities.
• Wrote various shell scripts to automate tasks.
• Creating PL/SQL procedures for Extraction, Transformation and Loading of data
• Created schema (tables, Indexes, views, sequences, synonyms, packages).
• Setup database auditing, granted privileges to users through system/object roles.
• Implement and maintain database security.
• Created db link for inserting large tables directly without taking export.
• Online index rebuilds
• Created PL/SQL Procedures, Functions, Triggers.
• Taking Hot and cold backups.
• Creating and managing partitioned tables and indexes.
• Monitor and tune database performance using STATSPACK, AWR, ADDM
• Increased performance of sql queries by creating materialized views and by enabling query re-write.

Environment: Oracle 11g RAC, Oracle 10g RAC, HP-UX, RedHat Linux, Sun Solaris, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL*Loader, ERWIN, Data Pump

Confidential, Pittsburgh, PA June 2008 – October 2009
Oracle DBA

Responsibilities:

• 24x7 on-call production database support
• Installation and Configurations of 9i, 10g databases.
• Installed Oracle 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Organizing Oracle Database operations, installation, creation, configuration of Databases, laying out database tables and database schema design, startup and shutdown of Databases.
• Load data into Oracle using SQL *Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Creating users and roles for database and give the privileges.
• Performance monitoring and tuning using Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM)
• Automated the Replication process using Materialized Views for reporting databases.
• Using the ADDM to analyze performance problem and with help of AWR reports for individual SQL statements. Analyzing recent session activity with an ASH report.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: locking, corruption, disk spaces and Performance issues.
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Created Standby databases for Disaster Recovery, using Data Guard.
• Load data using SQL*Loader
• Backup and Recovery
• Created database objects like tables, views, indexes, partitions.
• Develop, document and enforce database standards and procedures.
• Setting Oracle Streams for replication between two databases.

Environment: Oracle 10g RAC, Oracle 9i, Sun Solaris, RedHat Linux, IBM AIX, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL*Loader, Data Pump

Confidential, Dallas, TX October 2007 – May 2008
Oracle DBA

Responsibilities:

• 24x7 on-call production database support
• Installation and Configurations of 9i, 10g databases.
• Installed Oracle 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Performed backup and recovery activities.
• Daily database administration tasks including backup and recovery using RMAN, Import/Export.
• Designed the database schema and created any necessary database objects.
• Applied patches, upgraded databases
• Worked on all phases of the project lifecycle including mapping data requirements, data definitions and construction of logical data models.
• Performance Tuning of Applications/Databases using various Oracle tools like SQL Trace, TKPROF, Explain Plan, AWR and ADDM.
• Tuned memory structures such as the database buffer cache, shared pool and library cache.
• Assist application developers to meet their day to day requirements related to performance.

Environment: Oracle 10g RAC, Oracle 9i, IBM AIX, Windows, RedHat Linux, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL*Loader, Data Pump

Responsibilities:

• Responsible for maintenance of production.
• Created tables, views, materialized views
• Database administration tasks included performing regular Hot & Cold Backups, Job Scheduling.
• Managing Database Structure, Storage Allocation, Table/Index segments
• Cloned databases from PRODUCTION to create TEST, DEVELOPMENT and UAT
• Configured and managed OEM to stabilized oracle database into healthy environment.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Involved in numerous Unix Korn Shell Scripting pertaining to the activities of the DBA
• Maintenance & modification of Shell Scripts.
• Implemented Oracle's Advanced Features such as Partition table, Partition Index, Function Based Indexes and Loaded bulk data with SQL*Loader.
• Develop, document and enforce database standards and procedures.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth.
• Troubleshooting and fixing database listener issues.
• Worked in a 24/7 supporting environment with ON-CALL rotation

Environment: Oracle 10g, Oracle 9i, Oracle 8i, RedHat Linux, Sun Solaris, Windows, Shell Scripts, RMAN, OEM/Grid Control, SQL*Loader, Data Pump