SUMMARY:

• 7+ years of Oracle database administration in heterogeneous system environment including Solaris, Linux, and Windows, supporting a variety of mission critical applications in enterprise, telecom and financial environment.
• 3+ Year experience Oracle Applications DBA release 11i,R12
• 1+ Year expereince in managing Weblogic add domains and deploying application
• 5 +Year experience in RAC 9i, 10g,11g installation,patching, performance tuning and performance monitoring.
• Thorough knowledge of the Oracle Applications Framework, architecture, and technology stack on Linux.
• Configured new 3node RAC 9i,10g,11g nodes using dbca and via manual method for existing RAC clusters on Linux Itanium servers
• Expertise in using Metalink.
• Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and monitoring the statspack report, generated from snapshots taken at the peak business hours.
• Daily Monitoring of alert log files for errors, trace files and archive log destination files.
• Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, troubleshooting, database design and documentation.
• Configured Oracle Cluster File System (OCFS2), CFS and raw devices to host redundant OCR files and voting disks.
• Responsible for software and hardware purchases, installations, upgrades, systems support, automation, performance tuning and optimization.
• Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access and Security and auditing.
• Ability to architect Oracle installation and configuration methods in a virtualized environment
• Installed oracle 9i,10g,11g RAC using VMWare
• Experience in SQL, PL/SQL, Database procedures, Triggers, Packages.
• Performing tuning of application with CBO, tkprof, explain plan, Autotrace , Statspack and Oracle Enterprise Manager
• Experienced with tools/utilities: OEM, DBArtisan, SQL* Loader and export/import and datapump in10g,11g.
• New 10g,11g features of ASM, ADDM and Data Pump export/import, temporary table space groups, flashback technology, RAC.
• Implemented data replication through materialized views.
• Used ADDM to get the useful feedback about the resource utilization and performance.
• Proficient with technology domains like User Management, Resource Accounting, Security and Network Management for various platforms like Microsoft Windows, Solaris, HP and Red Hat Linux.
• Extensive interaction with Business Analyst, Managers, Developers, QA and End Users.
• 5-7 year experience with AIX,UNIX,LINUXz series, Sun Solaris
• 3-5 year experience with RMAN Utility
• 3-4 year Designing Unix Shell scripts, Perl scripting
• 1 Year experience in datastage

Technical Skills

Languages :

C++, Java, PL/SQL, SQL * Plus, XML

Database Systems :

Oracle 8.x/9i/10g ,RAC 9i,10g,11g Oracle Applications 11i,R12

Java/Web Technologies:

Veritas Volume Manager

Other Technologies:

Veritas Netbackup,Datastage

Operating System:

IBM AIX, HPUX10.3/11, Windows 95/98/2000/NT/XP,Sun Solaris5.8, Solaris5.10, RHEL

Miscellaneous:

Routers,Swicthes,Bridges.

Professional Experience:

Client: Confidential, Apr ’12 – Till Date
Designation: Oracle Apps DBA

Confidential,is an eClinical software and services company dedicated to helping the world’s pharmaceutical, biotechnology, CROs, research and medical device organizations to maximize the value of their clinical research investments through the use of innovative and progressive technologies
Responsibilities:

• Creation and administration of oracle 11g2 RAC and non RAC databases
• Installation of Oracle Applications R12.
• Applied patches using adpatch
• Cloned prod to test instances using rapidclone.
• Configured Parallel Concurrent Processing.
• Extensivley worked with AD utilities
• Upgrade of 10g to 11gR2 databases
• Installation of Oracle Forms and Reports11g
• Experience in Database Upgrade from 9i to 11g and 10g to 11g
• Installation of Oracle Weblogic 10.3.5 and deploying application
• Applied Family packs and RUPs, cloning, Shared APPL_TOP Configuration
• Tuning concurrent managers by adjusting parameters like sleep cycle and cache size
• Applied Baseline Patches
• Working knowledge of workflow email notification.
• Database User / Space Management
• Created level1,level2 SRs and coordinated with Oracle Support to resolve issues
• Extensive performance tuning and recommended ways to improve performance
• Configured new 9i,10g nodes using dbca and via manual method Performance tuning of RAC instances
• Monitoring / Scheduling / Planning backup & recovery strategy using hot / cold & RMAN backups

Extensive experience in Data Refreshes using datapump

• Creation and maintenance of database objects (tables / views as per client requirement)
• Good experience in Performance Monitoring and Tuning activities using EXPLAIN PLAN, TKPROF, STATSPACK, TOAD, AWR and ADDM
• Performance Monitoring
• Running trace to identify problematic session and studying AWR reports to improve performance
• Refreshing schema using exp, imp / expdp & impdp
• Monitored AWR/ADDM report on RAC 9i,10g databases to identify tuning opportunities and optimized CPU, Memory, IO and network resource utilization
• Installing Oracle 10g and 11gR2 database and management of databases
• Performance monitoring of Oracle Database and identify critical issues.
• Implemented Fine Grained Auditing in Oracle 11g databases and also working knowledge of Tablespace Encryption in Oracle11g databases.
• Extensive performance tuning of 11g databases.
• Created new test,dev and prod databases 11gR2 .
• Experience in weblogic troubleshooting,creating managed server and deployment process.
• Calculated optimum values for database parameters such as amount of computer memory to be used by databases.
• Experience in collaborating with developers to design DB tables and structures to support applications
• Coordinating with the Development team to create efficient Queries, Indexes, Views, and Stored Procedures and triggers.
• Performance Tuning of PL/SQL objects
• Designing Unix Shell scripts

Environment: Oracle 8i, 9i/10g,11g, RAC SQL Plus, Oracle Enterprise Manager (OEM), Sun Solaris 5.8, AIX, zLinux, Weblogic10.3.5

Client: Confidential,Nov ’11 – Mar\'12
Designation: Senior Oracle RAC/Apps DBA

Confidential,a member of the World Bank Group, is the largest global development institution focused on the private sector in developing countries. We create opportunity for people to escape poverty and improve their lives. We do so by providing financing to help businesses employ more people and supply essential services, by mobilizing capital from others, and by delivering advisory services to ensure sustainable development.

• Maintaining databases in segregated development, test and production environments
• Installation of Oracle databases 11g ,release maintenance and server configuration.
• Installated, and configured RAC9i,10g,11g databases using ASM
• Cloned prod to test instance using Oracle R12.
• Patching of Apps using AD utilities.
• Trobleshooting concurrent managerd and patch related issue in R12
• Applied upgrade patches to RAC databases 9i,10g.11g, ASM, Clusterware
• Upgradation of oracle databases 10g to 11gR2
• Creation of database server from scratch and implementing ASM file systems
• Configured ASM in Oracle 11g Release2 databases
• Installation of Grid Control 11g to ensure all databases are monitored properly
• Optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views.
• Monitored AWR/ADDM report on RAC 9i,10g databases to identify tuning opportunities and optimized CPU, Memory, IO and network resource utilization.
• Monitoring / Scheduling / Planning backup & recovery strategy using hot / cold & RMAN backups.
• Created Non RAC and RAC databases in 10g,11g
• Involved in patching 10g ASM instances and CPU patching for RAC instances and single instances
• Monitoring SQL 2008 databases and perfornace tuning
• Installation of SQL 2008 databases
• Performance tuning of RAC instances considering cache fusion optimization, Init parameters optimization, service workload repository, networking issues and AWR reporting
• Performance tuning of applications and capacity planning
• Creating database objects like tables,views,indexes and partitions,roles
• Resolving any database issues like database down,file system space issue,corruption issues
• Mantain technical documentation to facilitate continued maintenance and enhancement of application
• Troubleshooting user connection issues and performance tuning of large intensive databases.
• Monitoring databases to check for errors and corruption issues
• Resolving trouble tickets regarding space requests,user creation.
• Monitored AWR/ADDM report on RAC 9i,10g databases to identify tuning opportunities and optimized CPU, Memory, IO and network resource utilization.
• Cloned existing Oracle10g,11g Homes to create new servers .
• Implement database level and OS level auditing in Oracle 11g databases
• Installed oracle10g,11g clients on AIX,Solaris
• Refreshed databases using Datapump10,11g in test,dev environments
• Tuned Large databases,closely studied AWR reports and interpreted performance problems.

Client: Confidential,FL-USA Nov ’08 – Oct \'11
Designation: Senior Oracle Apps/Oracle RAC DBA

Confidential,AAIS system provides a comprehensive integrated database for inventory, assignment, maintenance of provisioning facilities, and switch activation for wire line customers.

Responsibilities:

• Experience in installation, configuration and support of Oracle RAC9i,10g,11g
• Excellent experience in installing of different RDBMS using OEM like 9i, 10g,11g
• Experience in Installing, Administering and Managing Oracle Application11i, R12
• Thorough knowledge of the Oracle Applications Framework, architecture, and technology stack on Linux.
• Solved issues related to Concurrent Manager on oracle apps 11i,R12
• Experience with middle tier architectures (9iAS/10gAS).
• Familiar with Utilities Like ADADMIN, ADPATCH, ADCTRL
• Maintained separate RAC 9i,10g,11g database for testing and cloned production database
• Experience in installation, configuration and support of Oracle R12 and 11i.
• Installed 3-node RAC database
• Monitoring / Scheduling / Planning backup & recovery strategy using hot / cold & RMAN backups)
• Creation and maintenance of database objects (tables / views as per client requirement)
• Applied upgrade patches to RAC databases 9i,10g.11g, ASM, Clusterware
• Refreshing schema using exp, imp / expdp & impdp
• Monitored AWR/ADDM report on RAC 9i,10g databases to identify tuning opportunities and optimized CPU, Memory, IO and network resource utilization.

· Experience Configuring Automatic storage management (ASM) Instance, CRS for high availability databases.

• Excellent experience in various migration techniques like export/import, Datapump, backup restore, cloning, data guard.
• Calculated optimum values for database parameters such as amount of computer memory to be used by databases.
• Production support activities include space management, user management & performance related issues.
• Recovery manager backups (RMAN) are implemented for daily backups.
• Experience on 10g new features like Data Pump, RMAN, AWR, SQL Tuning Advisor, ADDM, database control
• Good experience in writing different backup and recovery scripts, shell scripts, CRON jobs, DBMS_JOBS, Data Pump and Export/Import scripts
• Good understanding and experience of concurrent managers and PCP
• Oracle Apps patch management; patch migration processes.
• Registering Concurrent Programs with Concurrent Managers, Registering of Reports and Creation of Additional Concurrent Managers and Maintenance
• Cloning of Production to Test Instance
• Developed complex packages, stored procedures and functions to implement business logic
• Patching of Apps using AD utilities.
• Installing Oracle and recommending kernel parameters.
• Created database objects like tables, views, indexes, partitions.
• Creating users and Creating Roles, and assigning roles, privileges and profiles to users.
• Wrote Shell Script to create DB objects for Products, Automate backup and monitoring and testing scripts.
• Monitoring of data guard in the production environment
• Applied upgrade patches to 9i,10g,Oralce Apps 11i,R12 databases
• Executed data refreshes, build new databases and space monitoring (Tablespace expansion)
• Excellent experience in Performance Tuning of database, instances, OLTP, SGA, I/O,and Rollback segment using different methods and detecting locks.
• Analyzing the database tables and Indexes and then rebuilding the indexes if there is fragmentation in indexes.
• Troubleshooting Production problems and working effectively with other team members to identify and address problems.
• Performance tuning and monitoring, database backup and recovery on all instances.

Client : Confidential,NJ –USA Oct ’07- Oct ‘08
Designation: Sr. Oracle DBA

Confidential,a world leader in insurance and financial services, is the leading international insurance organization with operations in more than 130 countries and jurisdictions.
Responsibilities:

• Creation and administration of oracle databases in Sun cluster environment
• Maintained separate RAC 9i,10g database for testing and cloned production database
• Database User / Space Management
• Installed 3-node RAC database
• Configured new RAC 9i,10g nodes using dbca and via manual method for existing RAC clusters on Linux Itanium servers
• Performance tuning of RAC instances considering cache fusion optimization, Init parameters optimization, service workload repository, networking issues and AWR reporting
• Monitoring / Scheduling / Planning backup & recovery strategy using hot / cold & RMAN backups)
• Migration / Up gradation of oracle databases from 9i to 10g.
• Creation and maintenance of database objects (tables / views as per client requirement)
• Good experience in Performance Monitoring and Tuning activities using EXPLAIN PLAN, TKPROF, STATSPACK, TOAD, AWR and ADDM
• Monitored AWR/ADDM report on RAC 9i,10g databases to identify tuning opportunities and optimized CPU, Memory, IO and network resource utilization
• Calculated optimum values for database parameters such as amount of computer memory to be used by databases.
• Performance Monitoring
• Refreshing schema using exp, imp / expdp & impdp
• Monitored AWR/ADDM report on RAC 9i,10g databases to identify tuning opportunities and optimized CPU, Memory, IO and network resource utilization
• Carrying out Problem Management and Change Management activities in Corporate Information Services across the Information Technology stack. Tracking issues in Production / Stage /Development with respect to Database Servers, N-Tier Applications, Network Elements, ensure 24x7 uptime and availability.
• Calculated optimum values for database parameters such as amount of computer memory to be used by databases.
• Experience in collaborating with developers to design DB tables and structures to support applications
• Developed RMAN scripts to automate backup of RAC/Standby/single instance databases
• Worked in Data Warehousing environment dealing with Reporting Data warehouses
• Coordinating with the Development team to create efficient Queries, Indexes, Views, and Stored Procedures and triggers.
• Designing Unix Shell scripts

Environment: Oracle 8i, 9i/10g, RAC SQL Plus, Oracle Enterprise Manager (OEM), Sun Solaris 5.8, AIX, zLinux, DBArtisan,Datastage

Client : Confidential,NY Aug ‘06 – Aug07
Designation : Sr Oracle DBA

Confidential,is a leading player in France and Europe in retail banking and related businesses such as consumer credit, specialized financial services, asset management, private banking and insurance.
Responsibilities:

• Installing Oracle and recommending kernel parameters.
• Developed complex packages, stored procedures and functions to implement business logic
• Installed, configured and upgraded three-node Oracle 10g RAC release databases on LINUX and SUN Solaris Operating System..
• Installation, design and maintenance of Oracle 10g databases on AIX 5.3 (Standalone and RAC).
• Installation of clusterware, RAC software and ASM on solaris.
• Installation, configuration and maintenance of ASM on Oracle 10g
• Configured Grid Control agents to collect database and instance level metrics and specific metrics to monitor RAC configurations
• Created database objects like tables, views, indexes, partitions.
• Maintained separate RAC database for testing and cloned production database
• Creating users and Creating Roles, and assigning roles, privileges and profiles to users.
• Wrote Shell Script to create DB objects for Products, Automate backup and monitoring and testing scripts.
• Monitoring of data guard in the production environment
• Worked with AIX environment
• Monitoring the alert logs and trace files regularly. Administering the Client’s Oracle 10g Database.
• Excellent experience in Performance Tuning of database, instances, OLTP, SGA, I/O,and Rollback segment using different methods and detecting locks.
• Monitoring the Tablespace Usage and Indexes usage regularly.
• Gathering Statistics by using Stats pack.
• Storage management, sizing the database objects, monitoring Disk usage.
• Monitoring the Backup Status. (Exports, Cold Backup, Hot Backup )
• Debugging the bugs in SQL using toad and troubleshooting end users problems.
• Monitoring RMAN jobs and events by using OEM.
• Compared schemas, databases, tnsnames.ora file and Tablespaces for better understanding of databases between test and production environment.
• Import/Export ,Data Pump ,SQL* Loader

Environment: Oracle8i, 9i/10g,RAC SQL Plus, Oracle Enterprise Manager (OEM),zLinux,Sun Solaris 2.9, UNIX

Client : Confidential,NY Feb’06 - Jul’06
Designation: Oracle DBA
Confidential,is a wholly-owned subsidiary of Lehman Brothers Holdings Inc. and is a registered broker-dealer under the Securities Exchange Act of 1934. Lehman Brothers Inc.\'s Mid-Year and Year-End Reports contain information on the Consolidated Statement of Financial Condition of Lehman Brothers Inc. and its Subsidiaries.

Responsibilities:

• Creating and Maintaining of databases: Creating table spaces, tables, indexes, data files etc.
• Created Users, Assigning Privileges, and Roles in multiple databases in Windows NT and HP-UX environment.
• Organizing Oracle Database operations like installation, creation, configuration of Databases, laying out database tables and database schema design, startup and shutdown of Databases.
• Setting init.ora parameters, maintaining Data Files, Control Files, Redo Log Files, managing Tablespaces, segments, extents, indexes and performing management of Undo Data. Maintained Test Database for testing and research work.
• Creating tablespace and planning the location of data, index and rollback tablespace redo log files and control files in adherence to the Optimal Flexible Architecture (OFA).
• Installed, created and upgraded Oracle databases as needed for development effort.
• Installation of Oracle 8i, 9i software and creation of databases for OLTP and DSS systems.
• Involvement in all phases of the project life cycle.
• Responsible for user and security management on production database.
• Allocating system storage and planning future storage requirements for the database system.
• Written, tested and implemented various Unix Shell scripts, PL/SQL and SQL queries to monitor the pulse of the database and system.
• Supported Developers, Users by running queries/output (spool file) in SQL-Worksheet/SQL*PLUS environment.
• Experience with UNIX AIX.
• Creation of multiple databases for development, testing, QA & user acceptance environments.
• Day to day production database monitoring activities.
• Troubleshooting various oracle run time and real time errors during development & in production environment.
• Writing combination of shell & SQL scripts to
• Automate daily monitoring for database availability, alert & trace file errors, disk space availability on host, free space availability in tablespaces, monitor DDL operations on production objects.
• Automate frequently performed operations like recreation of grants & synonyms, compiling invalid code objects after the change of primary objects.
• Worked in Financial datawarehousing application i.e Borkerage reporting
• Created synonyms, public database links and Materialized Views in Oracle environment.
• Performed Hot Backups, Cold Backups and also used Import/Export Utility.
• Installation, configuration, and administration of Oracle 9I,10g Database.
• Managing Oracle database administration function involving resolution of database start-up problems; managing diskspace, user profile creation and user rights management.
• Performed Tuning by generation of Stats-Pack Reports and Tracing of Queries.
• Implementation of backup and recovery, monitoring procedures, on-going support and performance tuning.
• Handling various technical aspects like product documentation, software design, coding of modules, quality compliance, monitoring critical paths & taking appropriate actions.

Environment: Oracle 9i/10g, SQL Plus, Oracle Enterprise Manager (OEM), Sun Solaris 5.8,AIX, UNIX

Education:
Bachelors in Technology, Computer Science.