SUMMARY

Over Eight years of experience working for corporate clients in several challenging projects. Worked in various phases of analysis, design, implementation and support which include Databases, applications on SUN Solaris, HP/UX and Windows NT.

IT SKILLS

• Hands on Experience in installing, configuring and managing Oracle 10g/11gR2 RAC with ASM on RHEL Linux and Solaris environments.
• Experience in Configuration, Installation and Migration of oracle databases from oracle 8i, oracle 9i, oracle RDB to High Availability 10g/11g RAC environment.
• Experience in Database Administration activities such as Upgrades, Migration.
• Experience in taking backup using Import Export, Data Pump Utility.
• Experience in creating and configuring maintaining Data Guard and Standby database
• Experience in cloning the databases and performing database refreshes.
• Experience in using Oracle Recovery manager utility RMAN for various types of backup and recovery.
• Experience in taking backups using COLD, HOT and writing scripts for these backups
• Experience in writing proactive monitoring scripts like monitoring the disk usage and the memory usage of the server and monitoring table spaces.
• Experience in managing Table spaces like Undo table spaces and Temporary table space management.
• Experience in Extracting, Transforming and Loading ETL data using SQL loader utility.
• Involved in Performance tuning, database monitoring activities using Explain Plan, TKPROF, AWR, ADDM, ASH, SQL Trace, ORADEBUG, STATSPACK, 10g OEM Grid Monitoring, Oracle Diagnostics pack, Oracle Tuning Pack.
• Enrolling users and Creating roles, profiles and privileges and assigning to users.
• Expertise in developing SQL and PL/SQL codes through various procedures, functions, Triggers and Oracle packages to implement the business logics of database.
• Maintenance modification of Shell Scripts.
• Experience in working with reporting tools such as Crystal Reports, SSRS.
• Good understanding in optimization and Normalization in Oracle RDBMS.
• Expertise in handling database related errors using Exceptions.
• Developing UNIX shell scripts and SQL scripts to carry out routine checks on databases.
• Tuning, assigning proper indexes such as BIT map or B-Tree Index according to requirement.
• Experience in working with different Connectivity like SFTP, FTP, SCP, SSH and Connect Direct.
• Skilled in using tools such as SQL Developer, TOAD, MS SQL Server query analyzer, Visual Studio and loading data from flat files using SQL Loader and External Tables.
• Familiarity with Golden Gate and Oracle Streams.
• Experience in using Crontab in UNIX environment for scheduling routine tasks.
• Documented most critical procedures and trained backup staff to run them.

TECHNICAL SKILLS

Professional Experience:

Confidential

Oracle DBA Consultant

Responsibilities:-

• Installed, configured, maintained and tuned Oracle 10g and 11g databases.
• Installed and Configured Oracle 10g and 11gR2 RAC with ASM on 2 node RAC setup
• Installed Managed Physical Standby databases Data Guard for disaster recovery.
• Implemented replication using Golden Gate and Oracle Streams.
• Configured and monitored various databases using OEM Grid Control
• Used Oracle utility Recovery Manager RMAN to implement Oracle backup and recovery.
• Designing the Oracle backup strategy, scheduling and implementing database backup and restoration using Import/Export, hot backups, cold backups and data pump utilities.
• Migrating databases to different environment using Data pump.
• Performs databases cloning manually using scripts and Recovery Manager RMAN for QA Testing team, application team and for developers.
• Performed Capacity planning, capacity monitoring and management.
• Performs tuning and optimization on current and new applications using SQL Trace utility and DBMS package, and enhancing performance through regeneration and rebuild of indexes and creation of views.
• Manages users and security of database as per business requirements.
• Creates PL/SQL procedures, packages and functions as required by business needs.
• Used SQL Loader extensively to extract data from flat files and loading into the new application.
• Performed database analysis, design, coding, testing and implementation of database structures.
• Performs troubleshooting using Explain Plan, TKPROF, STATSPACK, AWR and ADDM.
• Monitors the database, Table space management and Sizing of objects and space utilization in database using shell scripts.
• Automated a lot of process to keep the systems up to date and to reduce manual errors by developing shell scripts.
• Upgraded Oracle binaries in the development environment and production environment.
• Involved in applying oracle patches like 10.1.0.1 to 10.2.0.2 and from 11gR1 to 11gR2.
• Generated working documentation and run book for DBA team usage.
• Optimizes database performance by analyzing database objects, generating statistics, creating indexes and partitions.
• Performance monitoring and Database/Instance/RAC tuning using Dictionary views, AWR, Stats pack, ADDM, ASH reports, OEM Grid Control.
• Oracle installation on Windows 2003 Server development .
• Cluster management and verifying cluster process to ensure smooth operations.
• Working with Oracle support to resolve like ORA errors issues.

Environment: Red Hat Linux RHEL 4.x, 5.x, Oracle 10g RAC and 11gR2 RAC, SQL, PL/SQL, SQL Plus, SQL Developer, TOAD 9.0, SQL Loader, OEM/Grid Control, RMAN, Data Guard, ASM, SCP/SFTP, TKPROF, Explain plan, AWR, ADDM, Cronjob, Shell Scripting BASH .

Confidential

Senior Oracle DBA

Responsibilities:-

• Installed and configured Oracle 10g/9i databases.
• Implemented Database Replication using Oracle 10g Streams.
• Performed patching like one-off, CPU, patch sets to existing versions.
• Collected database performance statistics from production databases for trend analysis.
• Hot Backups Exports, Restores Refreshes for regression tests.
• Development support, Coding standards, application database tuning.
• Preventive Maintenance re-orgs. Troubleshooting tuning.
• Ensured successful periodical Backup, Restoration Tuning.
• Developed, Implemented and administered database policies and procedures
• Migration of databases from DB2, SQL server to Oracle using utilities Toad, SQL Developer.
• Created and configured10gR2 RAC databases in shared as well as dedicated servers.
• Implemented Backup and recovery using RMAN.
• Performed data modeling using tools like ERwin,
• Wrote scripts for various database activities, troubleshooting errors etc.
• Experience in using AWR for database performance and statistics.
• Recommended changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems.
• A strong skill in PL/SQL procedures, packages, triggers.
• Performed database analysis, design, coding, testing and implementation of database structures.
• Maintained several databases ranging between 500GB to 3TB.
• Finest granularity approach to Oracle implementation and defragmentation.
• Maintained physical standby databases using Data Guard.
• Performed capacity planning, capacity monitoring and management.
• Experience in Database Security User Management, Privileges, Roles, Auditing.
• Performed transaction-sizing measurements.
• Managed databases on day-to-day basis in production as well as Development.
• Worked closely with the Oracle developers for the better performance in Applications in writing the efficient SQL and PL/SQL Packages, Procedures, Functions and Triggers.
• Seasoned experience with UNIX and a strong ability with UNIX shell scripting.
• Worked extensively in Oracle's Enterprise Manager OEM , Generating Stats pack Reports, Explain Plan, SQL Trace and TKPROF, ADDM, AWR, ASH.

Environment: Oracle 10g/9i/8i, Quest Toad Ver8.5, SQL Loader, Windows 2003, Erwin4.14, AIX5.3, Solaris5.

Confidential

Oracle DBA

Responsibilities:

• Installed Managed Standby databases Data Guard for disaster recovery.
• Handled Databases using hot /cold backups and dump/loads.
• Tested and implemented many backup and crash recovery scenarios on test environment 9i/10g , using RMAN tool.
• Registered the databases in Recovery Catalog Databases for the setting up the Backups.
• Extensively used export-import and Data Pump -- Expdp/ Impdp to take logical backup and migrate databases in different environment.
• Managed Undo Segment in order to avoid Snapshot too old error.
• Configured and implemented using 10g new feature BFT Big File Table space size of 2 Exabyte for storing large objects.
• Configured databases in OEM for monitoring purposes.
• Scheduling meeting with the Application Team in different location to gather the information for migration.
• Installed and maintained Oracle 9i database server software at Windows 2003 and RH8 Linux, including RDBMS, Apache servers, patching software, configuring clients
• Maintained data integrity and tune database for optimum performance and availability.
• Created schema tables, Indexes, views, sequences, synonyms, roles grant roles to users.
• Worked with Development team to fulfill the requirements of applications with Database design
• Performed tuning using UTLSTAT reports, Explain Plan and monitoring Alert logs.
• Identified the poorly performing queries using Explain Plan, TKPROF, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace SQL Tuning Advisor
• Extensively used FTP and SCP to copy the dump files from SQL to ROM servers.
• Used Remote export for migration of databases with used of DB links to migrate the data due to space constraints on the SQL servers.
• Good exposure of 10gR2 RAC databases in dedicated server's mode.
• Providing 24x7 on-calls Production Support on database and application side.
• Responsible for developing custom database monitoring scripts using Korn shell.
• Adding space to the data files to accommodate growth of tables paces.
• Automated the different tasks like Creating Databases, Binaries Installation using shell scripts.

Environment: Oracle 9i/10g, Putty, Sun Solaris 5.8, SQL Navigator, Quest Toad, OEM grid control management, PL/SQL, RMAN, Net Backup.

Confidential

Oracle Database Administrator

Responsibilities:

• Performed installations of Oracle software products and created databases and upgraded the databases.
• Responsible for data integrity and user security.
• Performed physical database designing, analyzed database space needs and growth analysis, and future storage requirements.
• Implemented backup and recovery strategies for archiving and non-archiving databases.
• Participated in planning and implementation of off-site Disaster Recovery planning and testing.
• Monitored the database for performance and tune accordingly.
• Created tables and indexes, sizing their extent, partitioning and so on.
• Created users with restricted access, with default and temporary table spaces.
• Analyzed design and data model solutions for business needs in cooperation with various levels of business and systems personnel.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Worked with development and operations staff in resolving problems quickly and efficiently.
• Specified appropriate storage specifications for indexes, tables, table spaces, hashed tables, clusters and rollback segments using Oracle's auto extend management feature.
• Tuned SQL queries using TKPROF, EXPLAIN PLAN, and SQL TRACE.
• Supported development life cycle of training, development and production databases, reviewing the backup and recovery procedures for production database.

Environment: Oracle 9i/10g, SQL, PL/SQL, TOAD7.6, OEM, SQL Developer, RMAN 5.0.9, SQL Loader, UNIX Shell Scripting.

Confidential

Oracle DBA

Responsibilities:

• Reviewed Database logical and Physical design.
• Installed, upgraded and maintained Oracle 10g, 9i on Sun Solaris and Windows 2003, Redhat4.
• Installed and configured of DATA GUARD.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc.
• Implemented Database Security, Management of role-based security.
• Applied Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Wrote and modified UNIX shell scripts to manage Oracle environment.
• Performed Data Migration as a part of enterprise data warehouse project.
• Extensive Performance Tuning, Memory SGA Tuning, Net backup, EMC Time finder and SRDF , RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Established database backup/recovery strategy for different databases.
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
• Constantly monitored the performance of the Databases and viewed Alert log files Trace files.
• Implemented schema level, table level and bidirectional oracle streams.
• Logical and Physical data modeling using ERwin, Dimensional/ OLAP Data Modeling, Relational/ OLTP modeling.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Performed scheduling Control-m for scheduling jobs.

Environment: Oracle 10g and 9i, Sun Solaris, RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL Loader, TOAD, Erwin, STATSPACK

Confidential

Oracle Database Administrator

Responsibilities:

• Involved with Maintenance and Support processes.
• Performed planning and implemented solutions to handle high speed data and high volume data effectively.
• Implemented recovery and backup procedures.
• Implemented backup using NetBackup
• Involved in PL/SQL coding, mapping of view templates to DCMs for defining views to extract data from tables.
• Performed Oracle applications installations, cloning and patching.
• Responsible for developing the new Master and Transaction Forms for the data Entry, Updating and for data retrieval.
• Loaded data from flat files and XML files to temporary tables in Oracle database using SQL Loader collections for better performance.
• Generated reports using Crystal Reports.

Environment: Oracle 8i 8.1.5.0 8.1.5.1 , SQL, PL/SQL, TOAD 6.5, OEM, Developer 2000, SQL Report, Form Builder6i, SQL Loader