SUMMARY

• More than 7 years of IT experience in Software Analysis, Development, Support and Implementation of business applications
• Experienced in managing production databases, troubleshooting, inter-departmental coordination and escalation management.
• Database software installations, patch and upgrades.
• Experience in Design, Creating and maintaining the Oracle Database.
• Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad, PL/SQL Developer.
• Expertise in the creation of databases, table spaces, tables, indexes and other database objects.
• Expertise in managing Databases in Data Warehouse environments.
• In-depth knowledge of star and snowflake schemas/dimensional modeling and data warehouse methodology
• Expertise in Database partitioning
• Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments
• Expertise at using the import and SQL Loader utilities to load data and performing exports as supplemental to daily hot, cold and RMAN backups to be used for database restore and recovery.
• Experience in using RMAN advanced features for Oracle 11g.
• Detecting and diagnosing production system performance problem by analyzing Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views
• Hands on experience on Oracle Table Partitioning ,Data transferring and Refreshing with export/import utilities, Data Pump and data loading using SQL Loader and External tables and Log Miner Utility.
• Creation and configuration of Duplicate database by using RMAN utility
• Experience in using Flashback technology.
• Have extensive exposure to migrating normal databases to ASM.
• Oracle 10g RAC implementation administration using Oracle Cluster-ware Oracle Cluster ware setup on Solaris and configuration, RAC installation using ASM, Configuration and Patching, RAC Backup and Recovery
• Setup a 2 node RAC environment on AIX for testing purposes.
• Modify database structures as required by developers per the business or application requirements, clone development databases for testing and training.
• Hands on experience working on High Availability Environments
• Have setup Oracle Streams database configuration.
• Hands on experience on SQL Server installations, Managed backups and Data Migrations from older versions.
• Frequent interaction with development, network, system and storage teams
• Experience as On-Call 24x7 production DBA support, application/development DBA.
• Implemented ITIL V3 practices.
• Good understanding of the business, follow the ITIL process and adhere to customer's SLA's.
• Interface with ORACLE SUPPORT for technical assistance.
• Ability to learn new technologies and adapt to a dynamic environment.

SKILLS

• Languages C, C , SQL, PL/SQL, UNIX/NT Shell Scripting
• RDBMS Oracle 11g/10g/9i/8i, Oracle 10g Real Application Cluster RAC , ASM
• Operating Systems Windows 2000/NT/98/95, UNIX, HP-UX, IBM/AIX, RHEL
• DB Tool Oracle 11g, Oracle 10g, Oracle 9i, SQL Server 2008, Oracle
• Enterprise Manager, Oracle Recovery Manager, Oracle Data Pump,
• SQL Loader, Toad, Erwin 4.0, Informatica 8.6, MS Access,
• SQL plus, SQL Loader, Import, Export
• Web Technology ERP Portals, BMC Remedy, HP Quality Center, Ruby on Rails
• Certifications Oracle Certified Associate 11g
• Administration SAP BASIS, Oracle Administration

EXPERIENCE

Confidential

• Installed and Created databases on Oracle 11g, upgraded databases from 10g to 11g R2.
• Setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, Oracle Enterprise Manager OEM .
• Worked on database sizing, performance monitoring and tuning
• Administered database servers on RAC environment.
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, import/export and SQL Loader, RMAN-managed backup with or without catalog database and implementing backup and recovery strategies.
• Worked on creating and maintaining database users and roles.
• Implement and maintain database security by assigning privileges accordingly.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.
• Create or clone the Oracle Instance/Databases on ASM. Perform database cloning and re-location activities.
• Worked extensively on SQL, PL/SQL, and Shell Scripting.
• Designed STAR Schema, created PL/SQL Procedures, functions, Triggers.
• Optimizing SQL statements using TKPROF, EXPLAIN PLAN, and STATSPACK.
• Managed and maintained hosted production, development/test systems, non-hosted client systems, as well as internal systems running Oracle applications in a 24X7 environment.
• Performed backups, restores, cloning, or refreshing databases and applications.
• Documented and complied with company policies and standard operating procedures.
• Managed and resolved design issues during development.
• Developed automation scripts for database monitoring.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Created materialized views.
• Trained a new DBA in our environment.
• Tickets and Incident management using BMC Remedy
• Perform Oracle development activities on requests from development teams.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL Loader calling UNIX scripts to download and manipulate files.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Environment: Windows, Unix HP-UX , Oracle 11g, SQL Server 2008/2012, Load Runner, TFS, .NET

Confidential

• Installed Oracle 10g, 11g database on HP-UX 11.0 and Linux.
• Upgraded the application database from 9.2.0.7.0 to 11.2.0.1.0
• Installed and maintained Oracle 10g 2 node RAC and worked on ASM feature
• Installed, configured and maintained Oracle data guard primary and physical/local standby databases to ensure disaster recovery, high availability and data protection.
• Involved in setting up of OEM and Oracle grid control.
• Upgraded databases from 9i to 10g, 10.2.0.1 to 10.2.0.4 and applied patches.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Performing Data modeling using Erwin.
• Synchronize Databases with production for data and testing purpose.
• Creating Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups using OEM SQL commands.
• Involved in migrating databases from HP-UX to Linux.
• Define, implement and maintain ETL procedures and schedules to ensure the accuracy and timeliness of data in the data warehouse
• Involved in Oracle warehouse database administration including monitoring, backup/recovery, performance tuning, changes, and capacity planning, etc.
• Implemented design of physical data storage, maintenance, access and security administration
• Supported data transfer operations - import/export, SQL Loader and data pump.
• Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
• Used Logminer utility for precision recovery.
• Cloned Production databases using RMAN, hot and cold backups.
• Expertise in using RMAN for not only backup and recovery strategies but also to validate databases regularly to reduce redundancy and disk space usage.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Handful of experience in performance tuning using the reports generated by AWR, ADDM, Statspack.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Developed database and warehousing designs across multiple platforms and computing environments.
• Utilized advanced Oracle features such as table partitioning, Oracle Streams.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Developed UNIX shell scripts to perform the above tasks efficiently.
• Tickets and Incident management using BMC Remedy
• Help and co-ordinate with UNIX Administrators and development team for space management on various servers and help in Oracle installation, upgrading and database issues.
• Active participation in all team meetings and group meetings to meet the business requirements.

Environment: HP-UX 11i, Oracle 11g, Windows 2008, SQL Server 2008, RHEL, SUSE Linux

Confidential

• Upgraded and migrated databases from Oracle 9.2.0.8 to Oracle10.2.0.1 and applied patches.
• Upgraded the application database from 10.2.0.3.0 to 10.2.0.4.0.
• Configured Oracle data guard and Streams.
• Supported Oracle 9i and 10g databases on 24X7 shifts.
• Analyzed tables and re-built indexes regularly.
• Setup of Jobs startup/shutdown/export data pump using the Oracle Grid.
• Setup of the cold backup of test/development databases through RMAN for weekly maintenance.
• Automating the routine DBA tasks through the Crontab.
• Improving the performance using the AWR, ADDM, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data.
• Responsible for Load and Performance testing of the database servers and application servers, analysis and documentation of results.
• Online Database Backup, Archived redo log files and Offline backup
• Configuring Recovery catalog for RMAN
• Managing table spaces, data files, redo logs, tables and its segments.
• Maintaining data integrity also managing profiles, resources and password security.
• Managing Users, Privileges and Roles.
• Tune SQL statement against database and its objects.
• Write script to monitor the database with shell and PL/SQL code or SQL PL/SQL code such as procedure, function, and package.
• Coordinated with cross functional teams to accomplish several DB projects within timelines

Environment: IBM AIX, Solaris, Oracle 10g, Windows NT, Java, Oracle 10g, JIS, Weblogic

Confidential

• Create databases, configuring them to meet developer and user requirements.
• Installed ECC post installation activities completed
• Established three system landscape
• User Creation Management, spool configuration, Client copy, patch download updating,
• etc. are done simultaneously in the landscape as the project grown gradually
• Client administration which includes copying, export and import.
• Scheduled standard background jobs periodically
• Monitoring Logged Users locally and globally
• Creating and testing the RFC destinations
• Involved in applying of SAP Support Patches, Kernel Patches and upgrade of other SAP executables for fixing SAP bugs and smooth system runtime
• Package deployment using SDM
• Analyzing ABAP Dumps, System Logs, Update Statistics and Locks
• Maintaining Profile parameters
• Printer Configuration
• Monitoring work processes
• Analyzing of missing authorizations SU53 and assigning Roles to users
• SAP GUI Front End Installation
• Written PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business rules into the application.
• Involved in Data Extraction using UTL FILES in PL/SQL.
• Supported Oracle 8i, 9i databases on 24X7 shifts.
• Implemented Oracle Streams from Oracle 8i to Oracle 9i.
• Co-ordinate with UNIX Administrators for space management on various servers and help in Oracle installation, upgrading according to the standards Quality assurance.
• Tune database to ensure acceptable level of performance and availability.
• Install client side of Oracle on developers and end-users PC and configuring them with network connections.
• Extending the database storage capacity by creating new tablespace, adding datafiles to table space
• Manages and maintains the data dictionaries.
• Monitors database activity and file usage, and ensures necessary resources are present so that databases function properly by removing or deleting old or obsolete files.
• Configuration of physical standby database.
• Good understanding of the business, follow the ITIL process and adhere to customer's SLA's.
• Extensive experience in handling different kinds of ORA errors.
• Used Hints, Indexes, Explain Plan, Sql Trace and Tkprof for effective retrieval and processing of queries used for retrieving current details and also history of changes made for a version.
• Maintaining Archive logs and their spaces for routine administration alert and trace monitoring.

Environment: HP-UX, Windows NT, Oracle 8i, 9i and 10g, ERP applications