PROFESSIONAL SUMMARY:

• Over 7+ years of experience as Oracle 11g/10g/9i/ DBA in Production, Development and Test environment on multiple platforms.
• Expert in Relational Database concepts and have been involved in Entity - Relationship modeling.
• Expertise in Installation, maintenance, upgradation, administration, backup and recovery Of oracle RAC database.
• Proficient in Installation and Configuration of 11gR2 cluster ready services and database in NFS and ASM file systems.
• Experience in Administering High Availability Databases.
• Basic & Advanced Replication environments
• Using RAID, EMC Symmetrix Configuration using SRDF/BCV (Time Finder) integrated with Third party tools.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Oracle Database Administration on 24x7 critical production and large databases of over 4 TB using Oracle 10g RAC, 9i.
• Experience in Installation, Configuration & re-configuration of Oracle for Large Database on Unix/Enterprise Linux, SUN SOLARIS and Windows environment.
• Setup Oracle Enterprise Manager (OEM) 9i/(Grid Control) 10g for database monitoring/performance/diagnostics.
• Performance and Tuning: Tuned various large critical OLAP and OLTP databases of Tera bytes size using various tools like STATSPACK, AWR, Oradebug, Tkprof and Explain Plan Methods.
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import) and proficient in RMAN.
• Expertise in configuring, maintaining replication using Oracle Streams at table level (Unidirectional, Bi-directional).
• Database Tuning - Tuning Applications, Tuning Memory, and Tuning Disk Usage.
• Oracle 9i RAC / 10g RAC implementation & administration using Oracle Clusterware (Oracle Cluster ware setup and configuration, RAC installation using ASM, Configuration and Patching, RAC Backup and Recovery)
• Experience in Standby, Data Guard.
• Effective troubleshooting of database and performance problems.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers etc.
• In-depth understanding of Logical and Physical Design of Databases.
• Managing Database Structure, Storage Allocation, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges
• Involved in different scenarios of OLTP as well as DSS databases.
• Experience in Database Security and Auditing.
• Enabling various alerts for Space Management.
• Hands on Experience in using tools like Data Pump, SQL* Loader..
• Performed Instance Cloning, Code migration processes, Oracle grid-control.
• Proficient in INDEX REBUILDING and INDEX TUNING.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).
• Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB).
• Have exposure to Automatic Storage Management (ASM) configuration.
• Excellent personal time management, organizing, analytical and problem solving skills.
• Implemented materialized views
• Good communication skills to work independently and in a team environment.
• Excellent team player and flair to learn and implement new technologies.
• Knowledge on Golden gates
• Ability to perform general DBA activities on Netezza
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

Databases: Oracle 11gR2/10g/9i/8.xLanguages: PL/SQL, T-SQL, SQL, C, C++, Java, Perl, UNIX Shell Scripting.

Operating systems: Windows 2000/NT/XP/2003, UNIX, Linux AS 4, Enterprise Linux5, Solaris 8/9.

Database Tools: Oracle Enterprise Manager, SQL Analyzer, PL/SQL developer, TOAD.

GUI Tools: Developer 2000 (Forms 4.5, 5.0, 6i), Visual Basic 5.0.

Others: Knowledge of HTML programming, Internet Technologies

Back up Tools: RMAN, SQL*Loader, Export/Import, Data pump, Net Backup

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr.Oracle DBA

Responsibilities:

• Installation, configuration and administration of oracle 10g/11gR1/11gR2.
• Installation, configuration and maintenance of Oracle 10g/11g RAC.
• Involved in administering more than 50+ Production databases of size ranging from 200GB to 5 TB on RHEL.
• Implemented oracle resource manager to control degree of parallesm, cpu resources.
• Responsible for regulating database load using ORM.
• Responsible for configuring ORM in RAC environment for load balancing on the server.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 6 nodes per cluster.
• Responsible for Migrating a 4TB 3 node RAC database from 10.2.0.4 to 11.2.0.2 on NFS storage.
• Responsible for migrating 4TB 10.2.0.4 standalone database to 2 node RAC.
• Responsible for adding a node to a 4 node Cluster.
• As part of BCP did switchover and switchback
• Installed and configured OEM GC and intensively used for Diagnostic & tuning activities.
• Setup and configured Oracle 9i/10g Physical Standby database (Data Guard) to ensure high availability, where the standby database was used for disaster recovery as well as to offload the running of huge reports.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g/11g.
• Applying Quarterly security Patches (CPU/PSU) and applying Patch set and One-off Patches.
• Used Recovery Manager (RMAN) to take full and differential incremental or cumulative incremental backups by registering databases in recovery catalog.
• Performed Logical backup of critical application databases using EXPDP/IMPDP with a scheduled jobs (Cron Job).
• Backup to virtual tape using VERITAS Net Backup, HPDP and shared storage Option.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Explain Plan (10046), Statspack, AWR, ADDM, ASH and monitor the database performance on daily basis..
• Configured and Implemented replication oracle streams at table level.
• Writing and modifying shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
• Implemented Partitioned Tables for regional data in centralized data warehouse for better performance.
• Extraction of data from different flat files into Oracle Database using SQL*Loader.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Performed database cloning to setup test and development database. knowledge on Golden gate for Replication.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Oracle support Services are utilized to troubleshoot the problems and issues.
• Performing general administration tasks using tools like OEM GC and Toad.
• Configuring TNSNAMES.ORA, LISTNER.ORA for SQL *NET connectivity.
• Implement Stored Procedures and Triggers based on business plans using PL/SQL.
• Provided 24*7 supports with an on call pager.

Environment: Oracle 9i/10g/11g, Linux, AIX, HP-UX, OEM GC, TOAD, RAC, RMAN, VERITAS, Explain Plan (10046), Data Pump, STATSPACK, AWR, ADDM, TKPROF, Oracle Replication, Data Guard, SQL*Plus, PL/SQL, SQL*Loader, HPDP, WinSCP, SFTP

Confidential, Hillsboro, Portland

Sr.Oracle DBA

Responsibilities:

• Primarily responsible for production support. To keep all databases up and running in production.
• Installation, configuration and maintenance of oracle 10g/11g.
• Upgrading Oracle database 9i to Oracle10G.
• Created and upgrade RAC database on Linux with ASM, Data Guard, Flashback 10g and 11g with ASM
• Responsible for Installation of 10g (10.2.0.4) Cluster Ready Services on 6 nodes.
• Responsible for Installation, configuring and implementation of 10.2.0.4 Database in ASM file system on 6 node RAC database
• Involved in implementing Load balancing and testing failover on 6 node RAC Database.
• Upgraded single instance 9.2.0.8 Database to 10.1.0.4, 10.2.0.4 RAC database.
• Involved in database migration from single instance to 3 nodes RAC Database.
• 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.
• Implementing capacity planning for large database objects in order to minimize the DSA. And improve the performance.
• Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
• Planning and implementing Backup and Recovery procedures (Hot Backups, and RMAN), scheduling daily backups and performed periodic recovery tests.
• Taking table level backups using exp and imp. Responsible for capacity planning and space management, setting up and monitoring alert logs for failures, monitoring lock activity.
• Tuned the system in terms of SQL optimization, Memory tuning and application tuning.
• Tuning Query performance by creating indexes.
• Monitoring, sizing and tuning undo segments by creating multiple undo tablespaces.
• Database Maintenance and clearing of deadlocks, cleaning of database logs, Re-indexing, Tablespace monitoring, database objects monitoring.
• Designing and developing packages in the database layer, stored procedures, functions and triggers.
• Applied patches whenever necessary by downloading them from Metalink.
• Implemented Data guard (standby) for maximum protection

Environment: Oracle 9.2.0.8, 10.2.0.4 & 11.1.0.6, RHEL 4.2, IBM AIX 5.2, Windows XP, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, Import/Export, TOAD.

Confidential, NJ

Sr.Oracle DB

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g/9i databases on various Operating Systems.
• Performing database analysis, design, coding, testing and implementing database structures.
• Creating and managing users, roles and profiles, auditing and monitoring databases and user access.
• Planning and implementing Backup strategy for the databases using RMAN, Scripting backups, once in two weeks on the application database.
• Developing UNIX shell scripts (Korn/Bourne), Crontab in UNIX and extensively used packages like DBMS JOBS, DBMS SCHEDULER for scheduling routine tasks.
• Trouble shooting performance issues using Explain Plan and TKPROF and well versed with STATSPACK.
• Implementing table partitioning and sub-partitioning to improve performance and data management.
• SQL and PL/SQL Performance Tuning and Identifying SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS PROFILER), Explain Plan, and Auto trace, TKPROF and tuned them to suit SLA.
• Creating database Objects, managing partitioned tables, and table spaces.
• Data loading using Oracle SQL Loader, developing SQL Loader scripts to load global data, and fine tuned SQL Loader performance using Direct-load mechanism
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• 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: Oracle 10g/9i, Quest Toad, SQL*Loader, SQL*Plus, PL/SQL, RMAN, Sun Solaris 5.9, and Windows 2003/XP.

Confidential, Irvine, CA

Oracle DBA

Responsibilities:

• Involved in database designing, creation and maintenance of Oracle 9i on UNIX/Linux platform
• Downloads and Installation of Patches to upgrade system configurations and activities.
• Handling day to day issues of the Production databases and resolving the problems promptly
• Performing Database Refreshes for testing and development, cold and hot backups and also used
• Planning and implementing Backup strategy for the databases using VERITAS Netback up, RMAN, Scripting backup.
• Recovery Manager (RMAN) utility to back up, restore, and recover data files, control files, and archived logs
• Export and import of database objects using EXP and IMP.
• Table partitioning to improve I/O access
• 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.
• Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis.
• Optimization of various initialization parameters, batch processes with Tkprof, SQL Trace and explain plan

Environment: HP-9000 Super Dome, Storage Devices: EVA 5000, VA-7400, Oracle 8i/9i RAC, PLSQL, UNIX Shell Scripting

Confidential

Database Developer/DBA

Responsibilities:

• Performing database design and development.
• Involved in analysis, design and development of the system.
• Providing back-end support for customized Forms like customer and supplier maintenance, bill, receipt, letter of credit, invoice, debit and credit notes.
• Developing PL/SQL Packages to monitor revenue earnings and expenses and to maintain the general ledger of the organization.
• Developing stored procedures and functions using PL/SQL for complex updates and audit trails.
• Testing PL/SQL procedures against the test cases. Involved in creating use cases and test cases
• Writing database triggers for audit and data validation.
• Designing the Entity-Relationship model and normalized database.
• Performing re-sizing of data files, managed tablespaces and data files.
• Implement Hot, Cold and Logical backup plans. Designed backup and recovery procedures for OLTP system
• Use TOAD tool to access the database. Used PL/SQL developer to create PL/SQL Procedures

Environment: Oracle 8i, SQL*Plus, PL/SQL, UNIX, RedHat Linux AS 2.1/3.0, and Windows 2000