SUMMARY

• Over 6+ years of experienced with Oracle Database Administration, installation, configuration, migration, upgrade, backup and recovery, oracle patch apply, cpu apply, performance tuning, health check, database security setup, schema design, and production support of 24x7
• Experienced in Real Application Clustering (RAC) installation, configuration & administration
• Replication with Data Guard and active data guard (MAA)
• Experienced with Weblogic 11g, Fusion middleware 11g, ASM, Grid Control 11g/10g
• Experienced with Database up - gradation Oracle 10g/11g
• Experienced with designing logical and physical backup/recovery procedure
• Experienced with Sun Solaris, Linux and Windows Server environment
• Experienced in Performance Tuning Index, SQL Hints, SGA, ASH, ADDM, AWR & Statspack
• Experienced with database security, files, directory, user, group, and database profiles.
• Worked with Bug fixing, Patching of oracle Database.
• Extensive experienced with performance tuning of instance tuning and good knowledge on database waits events and oracle internals.
• Extensive DBA experience with export/import, datapump, indexing and administration tool like OUI, DBCA, NETMGR, OEM, srvctl, crsctl, opmnctl, emctl, sqlplus etc.
• In depth understating of oracle architecture, SGA & PGA memory and background process, oracle data dictionary and explain plan.
• Experienced with database objects like materialized view and modifying PL/SQL stored procedures, functions, packages, triggers, index, and sequences etc
• Expertise with UNIX shell scripting and automated task scheduling using crontab
• Experienced with large database of 5TB in size
• Worked with Capacity Planning of Database and server
• Experienced with all phases of Software Development Life Cycle

TECHNICAL SKILLS

Databases: Oracle 10g/11gr2

Operating Systems: AIX, Sun Solaris, Linux, Windows Server, VMware

Programming Languages: C++, Java 2.0,SQL,PL/SQL,HTML

Backup Recovery: RMAN secure backup, EMC.

Languages: SQL, PL/SQL, C#, Shell, HTML

Monitoring Tools: Grid Control, EM, Toad, Quest Foglight Agent

Others Tools: TOAD, PL/SQL Developer and MS project

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

GTI Oracle Production Support

Responsibilities:

• Perform and Monitor Daily and weekly full/incremental backup and Recovery using RMAN. Performed database restores and recoveries utilizing RMAN backups that resulted in 0 data loss.
• Performed logical backups using Export/Import and Data Pump utilities.
• Configure user quota, Group quota, File permissions, Group Permissions, User permissions on Linux. Scheduling the auto backup tasks ofOracledatabase using crontab and job Scheduler.
• Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
• Actively working with Prod, Dev, QA, databases for schema refresh and scripts apply for server and database consolidation. Administration of database objects such as indexes, tables, views, constraints, and stored procedures.
• Restore and recover database from the RMAN full back after data file corruption . Patching of Oracle database in Oracle 11g and Oracle 10g
• Scheduling maintenance and health check of the applications and databases. Other duties include: schema implementation, security, upgrades (installing patches).
• Resolved lock contention by detecting and modifying long running queries holding locks and applications explicitly locking objects.
• Provide on call support related to Oracle DBA activities. Monitoring the databases using trace file, alert log files, v$views, AWR, ADDM, Grid Control.
• Analyze SQL tuning advisor for Database performance recommendation and work with Data Modeler Team.
• Handled day to day database activities including performance monitoring and tuning to ensure the efficient and accurate operation of the database software.
• Performance & tuning the database by index & re-index, defragmenter, shrink table space and gathering statics, explain plan and outlining, Hints, and using wait events.
• Creating new Databases according to the project plan.Analyze AWR /ADDM report from command line for performance issue. Using EXPLAIN PLAN for SQL tuning.
• Monitoring and Maintaining the production databases and responsible for databases on a 24x7 basis and maintaining uptime.

Confidential

Oracle DBA

Responsibilities:

• Configured RMAN backup, perform RMAN backup and recovery, monitoring database health.
• Install & configure Oracle Enterprise Manager to monitor Oracle 11g, Oracle10g database.
• Performing and designing backup/recovery strategy using data-pump and RMAN.
• Working with database security setup files, user, group access, and database profiles security setup
• Maintaining the logical and physical organization of the database, like organization of database into different table spaces and organization of data files on different disks to reduce disk contention.
• User Management - creation and maintenance of users, creation of Roles and profiles.
• Monitoring system security, auditing of database objects, system privileges.
• Monitoring of free space and extents in table spaces. Technical documentation for backup/recovery and data archiving process. Database design, testing, implementation, tuning, and administration
• Schema Management and control, Synchronization of Production and Test environments
• Setting up Cron jobs for Monitoring Tablespaces and setting up daily logical backup. Monitoring and Performance of SQL queries with the help of OEM.
• Worked on Enterprise Manager (OEM) Control grid clients for Database Target management.
• Extensive use of performance tools like AWR, ADDM, ASH and Explain plan for performance monitoring and troubleshooting.
• Worked as team to Installation, Configuration and Administering Oracle Real Application Clustering (RAC). Administered several databases including single instance and multi-nodeRACinstances. Installed, configured 10g/11gr2 RAC on two node cluster
• Set up Oracle disaster configuration using Data-Guard (Physical Standby Database) in Oracle 10g/11g. Configure and manage Oracle 10g physical data guard and 11g Active data-guard (MAA).
• Configuration/Installations of Oracle Enterprise Manager (OEM) to automate the DBA activities on Production databases. Administer and monitoring database, file system, CRS and listener with Oracle 11g grid control.

Confidential, NY

Oracle DBA

Responsibilities:

• Provided support and Trouble shooting on 24x7 basis for Production environment.
• Involved in Tuning stored procedures that include PL/SQL stored packages, procedures and functions.
• Worked on exports/Imports, backup/recovery operations.
• Buffer Cache, Tuning of OS by Reducing Paging/Swapping, Tuning of SGA and Tuning of memory allocation.
• Responsible for all aspects of database administration including Oraclesoftware installation, database creation of development, testing, staging, and production databases.
• Applied patches and modifications to remain compliant with the security requirements.
• Tuning of I/O, which includes Separating of Data files and Redo log files on different locations, Striping of table data, and Separating of tables and indexes on different locations. Reducing Disk I/O Contention.
• Knowledge of data warehousing methodologies and techniques using star schemas, caching Techniques, DB loads, indexing, Physical and Logical data modeling etc.
• Implemented replication between the test databases.

Confidential, NY

Oracle DBA

Responsibilities:

• Designed, Developed, Updated, debug and Implemented forms and reports
• Created and updated table, view, index, and sequences for the application
• Performance & tuning of the databases using trace file, alert log files, statspack, v$views, & OEM
• Performed database Tuning using SQL tuning and memory tuning using memory SGA and PGA,
• Worked closely with developers providing them with database related assistance including database DDL, DML, performance tuning, monitoring, writing and tuning SQL queries.
• Index, and gathering statics, Tune SQL and PL/SQL code and explain plan
• Performed Physical and logical backup using RMAN and Export/Import
• Monitor database size/growth and perform space allocation on an as needed basis
• Implemented database security, directory permissions, users, group and database profiles
• Disk space management for data files and monitoring the table spaces
• Testing and taking measures for maximum performance utilizing optimization hints, processors, indexes, partitions, storages and query optimization
• Expertise in shell scripting and automated task scheduling using crontab

Confidential, NY

SQL DBA

Responsibilities:

• Creation of users, application development and maintaining the database, controlling user access right and managing data security.
• Installed SQL Server 2000/2005 windows 2003 advanced servers, applied services packs and security fixes.
• Designed and implemented data base backup and restore on SQL 2005.
• Involved in ERD Data Modeling, designing and building relational data bases.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Set up Database Maintenance Plan for the Database Integrity Checks, Update Database Statistics, cleansing and solving data base troubles.
• Administering the MS SQL server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Configured and implemented Snapshot, Merge, Transactional and Peer-Peer Replications.
• Maintain and Troubleshoot replication issues by continuous monitoring of Replication.
• Perform Full backups and Transaction Log backups; Restore them whenever necessary, creating backup strategies and scheduling them for execution.
• Regular monitor of servers, which includes backup job monitoring and troubleshoot all the issues on regular basis.