SUMMARY:

• 9 years of experience as an Oracle DBA and PL/SQL developer. Experience in Data Modeling, Design, and Development & Production Support on different UNIX environments like Sun Solaris, Linux and Windows 2000/2003 /NT.
• Experience in Upgrade of oracle database 11g R1 to 11g R2 using Oracle Database Upgrade Assistant (DBUA).
• Worked on ASM RAC and DATA GUARD. Installation of RAC databases, Maintenance of RAC using SRVCTL and CRSCTL commands.
• Adding disk in ASM diskgroup. ASM disk partitioning, rebalancing and handling disk failure issues.
• Datagaurd setup maintenance and log transfer.
• Strong knowledge of RMAN.Designed and implemented backup and recovery strategies.
• Experience in using RMAN for backup and recovery. Done time based, cancelled based recovery using Hot backup and block level recovery using RMAN.
• Experience in implementing Hot, Cold and Logical backup plans and experience in clonning .
• Data backup using export data pump and import data pump.
• Experience of installing, upgrading, patches. Duties included database creation, tuning, backup/recovery, user and security management, general troubleshooting and cloning.
• Installed and configured Oracle 11g on Linux Server on Development, Test and Production Systems. Performance and monitoring RDBMS (Relational Database Management System).
• Efficient in creating and managing users and objects.
• Efficient in SQL query optimization using Explain Plan, AWR, TKPROF reports, gathering statistics, pinning the objects, and running scripts.
• Extensive Experience in PL/SQL procedures, Functions, packages and efficient query writing.
• Specialist in functions, stored procedures, and triggers. Efficient in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks. Expertise in Loading data from flat files using External Tables, SQL*LOADER.
• Good Knowledge of UNIX shell scripting and experience in Perl.
• Experience in the management of schemas, de - fragmentation and partitioning the tables & indexes to improve the performance.
• Responsible for setting and managing user accounts, granting required privileges to users.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Operating System: UNIX, WINDOWS NT 4.0, Red Hat Linux 7.3, Sun Solaris 8.0, 9.0, HP-UX.

DBMS: ORACLE 8i, 9i, 10g, 11g

Tuning Tools: TKPROF, EXPLAIN PLAN, AWR

TOOLS: SQL Plus, Oracle Enterprise Manager (OEM), SQL * Loader, Data pump, TOAD, RMAN, Export/Import, DBCA, NETCA, DBUA, PL/SQL Developer

Languages: SQL, PL/SQL, Java, C Programming

PROFESSIONAL EXPERIENCE:

Confidential, Denver, MN

DBA

Responsibilities:

• Backup and recovery procedures using RMAN Cold backup and data pump Export/Import. Copying of data from by using data pump Export/Import.
• Backup of RAC databases. . Installation of RAC databases, Maintenance of RAC using SRVCTL and CRSCTL commands.
• Adding disk in ASM diskgroup. ASM disk partitioning, rebalancing and handling disk failure issues. Datagaurd setup maintenance and log transfer.
• Cloning using RMAN and Cold backup. Used data pump export import for data migration
• Created the indexes and analyzed the table for better performance.
• Restore and recovery using RMAN.
• TABLESPACE and Data block recovery using RMAN.
• Done time based, cancelled based recovery using Hot backup and block level recovery using RMAN.
• Faced Media failure issue.
• SQL query tuning. Worked with statistics explain plan hints. Worked with fragmentation and chaining issue. Index usage Monitoring.

Environment: Oracle 11g, RMAN, SQL Loader, Export Import, OEM, SQL Loader, Control-M

Confidential

DBA

Responsibilities:

• Created and maintained Database objects like table spaces, tables, indexes, views, Partitioned appropriate tables to optimize performance and simplified maintenance work, Administered database using Oracle Enterprise Manager, Created and executed various database queries.
• Installation of RAC databases, Maintenance of RAC using SRVCTL and CRSCTL commands.
• Adding disk in ASM diskgroup. ASM disk partitioning, rebalancing and handling disk failure issues. Datagaurd setup maintenance and log transfer.
• Tuned and optimized SQL Query using hints, index, statistics of objects and explain plan, Used External table and Partition exchange as efficient methods of data loading, Backup and recovery procedures using RMAN Copying of data from development to test and production by using utilities like Export/Import, Scheduled jobs to run on daily/weekly/monthly basis.

Environment: Oracle 11g, RMAN, SQL Loader, Export Import, OEM, SQL Loader, CONTROL-M

Confidential

DBA

Responsibilities:

• Extensively worked on PL/SQL procedure, functions, packages, Performed heavy data loads using SQL*Loader, Prepared control, bat file for bulk data load using SQL Loader, Created Test database using cloning method, Involved in creating tables and indexes, views.
• Installation of RAC databases, Maintenance of RAC using SRVCTL and CRSCTL commands. Adding disk in ASM diskgroup. ASM disk partitioning, rebalancing and handling disk failure issues. Datagaurd setup maintenance and log transfer.
• Created triggers, functions and procedures, Involved in RMAN backup, Managing and creating users and assigning roles and privileges to different users as per the requirements, created the indexes and analyzed the table for better performance. Data backup using export data pump and import data pump. Done time based, cancelled based recovery using Hot backup and block level recovery using RMAN.
• Moved the tables to different table space and rebuild the indexes, Faced issues like fragmentation and chaining, Use of table partitioning for very large tables, Creating and managing users and objects, Took export backup for data security, Use of table partitioning for very large tables.
• Used different hints to write critical queries, Used flashback utility, Performed data loads using SQL*Loader, Worked with explain plan of queries and statistics of tables and indexes.

Environment: Oracle 10g, TOAD, PL/SQL Developer, SQL Loader, export import.

Confidential

DBA

Responsibilities:

• Extensively worked on PL/SQL procedure, functions, packages, Led a small SQL team and guided them to write efficient queries using case, INSTR, Decode, exist, not exist and other key words, Involved in creating tables and indexes, views, Created triggers, functions and procedures.
• Installation of RAC databases, Maintenance of RAC using SRVCTL and CRSCTL commands. Adding disk in ASM diskgroup. ASM disk partitioning, rebalancing and handling disk failure issues. Datagaurd setup maintenance and log transfer.
• Done time based, cancelled based recovery using Hot backup and block level recovery using RMAN. Experience of installing, upgrading, patches. Duties included database creation, tuning, backup/recovery, user and security management, general troubleshooting and cloning. Installed and configured Oracle 11g on Linux Server on Development, Test and Production Systems.
• Creating and managing users and objects, moved the tables to different table space and rebuild the indexes, Index Monitoring and dropping unused indexes, Use of table partitioning for very large tables, used different hints to write critical queries, used flashback utility. Experience in the management of schemas, de-fragmentation and partitioning the tables & indexes to improve the performance. Efficient in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
• Performed data loads using SQL*Loader, Worked with explain plan of queries and statistics of tables and indexes, Offshore Onshore coordination and role of a team lead.

Environment: Oracle 10g, TOAD, PL/SQL Developer, SQL Loader, export import

Confidential

PL/SQL Developer

Responsibilities:

• Extensively worked on PL/SQL procedure, functions, packages, written critical queries using Rank, Dense Rank function inline views, Used Bulk collectors and Ref Cursors, Creating and managing users and objects.
• Assigning appropriate roles and privileges for different users as per the requirements of production, Creating and Managing stored procedures and triggers, Performed heavy data transfer using import/export utility, Performed heavy data loads using SQL*Loader.
• Tuned SQL Queries and guided other to write efficient queries, Data needed to be extracted from different tables in different schemas/databases for analysis, Worked with explain plan of queries and statistics of tables and indexes.

Environment: Oracle 10g, Data Loading, Export Import.

Confidential

Production support Executive (DBA)

Responsibilities:

• Worked on 5 node RAC environment in a Production database, Created and maintained Databases and their objects like table spaces, tables, indexes, views, Partitioned appropriate tables to optimize performance and simplified maintenance work, Administered database using Oracle Enterprise Manager, Created and executed various database queries. Installation of RAC databases, Maintenance of RAC using SRVCTL and CRSCTL commands.
• Tuned and optimized SQL Query using hints, index, statistics of objects and explain plan, Worked with wait events, gv$views to find out the reason for long running queries, Backup and recovery procedures using RMAN.
• Copying of data from development to test and production by using utilities like Export/Import, Scheduled jobs to run on daily/weekly/monthly basis, Extensively involved in design physical and logical models of the database.
• Provided 24x7 production support. Willingness and flexibility to work beyond regular hours based on business demands.

Environment: Oracle 9i, SQL Loader, Export Import, OEM, SQL Loader, CONTROL-M

Confidential

Oracle Developer

Responsibilities:

• Involved in installation and configuration of Oracle 9i database on Linux operating system, Extensively involved in writing PL/SQL programming, Involved in Creation of tables, Partioning tables, views, sequences, synonyms for the business application development.
• Written stored procedures, functions and packages for application development, Involved in troubleshooting using SQL monitor.
• Backup and recovery procedures using Cold backup and normal Export/Import. Used to take cold backup in every fortnight and export backup every day evening.
• Copying of data from development to test and production by using utilities like Export/Import, Loaded the flat file data into database table by creating multiple SQL Loader control scripts, Written database triggers for automatic insertion of tables on different schema.
• Created the indexes and analyzed the table for better performance, Development of product, quality testing and production database for new Oracle database 9i(Cloning), Managing and creating users and assigning roles and privileges to different users as per the requirements.
• Moved the tables to different table space and rebuild the indexes, Use of table partitioning for very large tables.

Environment: ORACLE 9i, SQL Monitor, OEM, SQL Loader, Performance and Troubleshooting