Summary

• 11 years of experience in working in Oracle, Sybase, Mysql and also Oracle Application DBA in Analysis, Database Architecture Design, Administration, Migration, Integration Design, Database Management, Backup and Recovery, Performance Tuning, Project Implementation and administration of Unix Operating System.
• Build-Installation, configuration, upgrading and migration across platforms of Oracle 9i, 10g 11gr2 RAC- DATAGUARD, Mysql 4 and 5x, Sybase 12 and 15 were installed patch fixes bugs and security patches are installed.
• Experience with Real Application Clusters RAC and Automatic Storage Management ASM , RMAN, Oracle Data Guard.
• Experience in installing, configuring and administering Oracle Databases and also in RAC , Oracle Enterprise Management OEM Grid, Extensive Experience with SQL language, proven problem resolution of Oracle DBMS, Experience creating installation scripts and procedures.
• Worked on diverse platforms on Oracle Databases covering HP-UNIX, IBM AIX, SCO UNIX, SUN Solaris, Linux and NT and Managed very large databases in 24/7 Production Environments, Upgraded the databases from 32 bit to 64 bit on Linux platforms
• Hands-on experience in planning designing Oracle Backups and Recovery strategies like RMAN, export/import -logical and physical backup also dump- load, bcp in/out of mysql and Sybase backup configured.
• Experience with Real Application Clusters RAC and Automatic Storage Management ASM , RMAN, Oracle Data Guard.
• Experience with Oracle Enterprise Management OEM Grid, Extensive Experience with SQL language, proven problem resolution of Oracle DBMS, Experience creating installation scripts and procedures. Experience in table partitioning, Materialized Views and replication technologies and Performed planned switchovers and unplanned failovers.
• Hands on experience in tuning experience with SQL queries of MySQL and Oracle RAC and Sybase databases, Implemented the database with ASM and SAN storage skilled towards database tuning and experienced in database security, backup, recovery, and archival concepts and procedures
• Proficient in use of tools like Oracle Designer, WEBDB tool, SQL loader, Recovery Manager, Oracle Enterprise Manager, Developer/2000, Discoverer ,Experience with different tools monitoring software and worked on Enterprise ticketing systems like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.
• Oracle Application DBA support, applying patches, mini-packs, family-packs and maintenance packs, upgrades, multi-tier installations, automatic routines DBA task, periodic refreshes ,oracle support dealing with functional , developers and end users.
• Refresh and Clone databases using RMAN and export/import/Data Pump methodologies on Databases Administration also Configured Data Guard/replication replicated db's on Oracle, Sybase and mysql with dump/load/BCP and mydbm tools.
• Extensive experience in Oracle Applications Releases 10.x,11i and 12i , Oracle Databases 7.x,8.x,8i.x,9i.x and 10g.x , Database Design and configuration, patching, cloning, migration, upgrades, Applications System/Database administrations, Backup and Recovery, Performance Tuning ,customization and load balancing
• Extensive experience in DBA activities including schema/user management, space management monitoring on Oracle, Sybase and mysql administration. Extensive experience and sound knowledge in performance tuning and application of implementing on development, QA production environments also trouble shooting database related problems in Oracle-Sybase-Mysql database administration
• Experience in modeling tool using ER/Studio modeling in high volume - usage data warehouse, applications also providing technical support to cross-functional platform and Mentoring team members on resolving various DB issues for multiple applications
• STREAMS Replication-Transaction-based, platform independent replication at database, schema or table level and Migrate DB Using RMAN, Alert configurations using OEM and operating system schedulers like dbms, AutoSys, Cron, etc. Migration and up-gradation of Databases from Oracle 9i to Oracle 10g Oracle 10g to Oracle 11gr2 and Patch set administration for Oracle - Mysql, EBF upgrades for Sybase.
• Hands on experience in Performance Tuning SQL query/ Memory/ Database/OS using tools like Oracle Enterprise Manager OEM , Automatic Workload Repository AWR , Automatic Database Diagnostic Monitor ADDM , Active Session History ASH , STATSPACK, SQLTRACE, EXPLAINPLAN, TKPROF, CRSCTL, SRVCTL, EMCTL, DBCA, CLUVFY for administration and tuning
• Excellent Leadership and Experienced in Team lead/Tech lead, Communication and Inter-personal skills.

TECHNICAL SKILLS

Database: ORACLE 9i/10g/11g RAC, Sybase 12/15 and Mysql 4x/5x and db2

RDBMS Tools: Developer2000 Forms 5.0/4.5 , Reports 3.0/2.5

Operating System: Solaris 5.8/9/10, True 64, AIX, HP and Linux

Application ERP Oracle Applications Release 11.0.3 to 11.5.10.2 and Release 12

Web Related Oracle webdb, Oracle web application server, 9iAS,SOA Tools Utilities Oracle Enterprise Manager, Oracle Designer, SQL Station, Oracle Express Server, Discoverer3I, OracleFinancial Analyzer, Sales Analyzer on Unix NT Platforms.

Languages: C , UNIX shell Scripts, SQL PL/SQL

DBA Tools Packages: Grid, Oracle Enterprise Manager OEM , Automatic Workload Repository AWR , Automatic Database Diagnostic Monitor ADDM , Active Session History ASH , STATSPACK, TKPROF, CRSCTL, SRVCTL, EMCTL, DBCA, CLUVFY RMAN, Export Import, Sqlloader, iSQL, Log miner. BCP, dump, load, mydbm and MS Office-2000/Xp,

High Availability: Oracle RAC, Physical /Logical Data Guard, Advanced Replication, Sybase rep server, Mysql slave-replication

Backup Tools: Tivoli, HP-Omni

Third Party Tools: Toad SQL backtrack v6. GUI Developer 2000,Case Tools ,Oracle Designer 6I, ERWIN and ER Studio

Professional Experience

Confidential

Role: Sr Apps DBA /Oracle RAC administrator

Confidential - Ecommerce Solutions and Services for ebay : Groupware Technology has been committed to our customers' enduring success. which will find a more responsive and dedicated partner n help solve your strategic business problems with technology solutions that provide more value, while reducing cost and complexity. Our charter is to provide value and insight, meet our commitments and deliver quality results that exceed your expectations

Roles Responsibilities

• Built 11gr2 both RAC and Non RAC servers on Linux both OVM and baremettal server -silent and gui mode and implemented database activities like monitoring databases servers, scheduling jobs, monitoring performance issues patches implementing on Oracle suggestions, setting up alerts, Asm Management, Data Guard implemented.
• Oracle Enterprise Manager OEM /11g Grid Control GC for various database activities like monitoring Target databases servers, scheduling jobs, monitoring performance issues implementing suggestions, setting up alerts, patch implementation, Data Guard management.
• Supporting/monitoring 3-node Oracle 11g RAC on Oracle Cluster ware platforms on high availability environment and writing shell scripting for various database maintenance and alerting activities
• Implementing and managing multi-terabyte Oracle 11gr2 RAC databases to deliver leading multi-OLTP and DSS applications, and implemented streams
• Tuned SQL queries of Oracle RAC databases, Implemented the database with ASM and SAN storage skilled Oracle RAC virual machines
• Production support for Oracle database cluster with databases running 2-3 and over 100 simultaneous connections and managed with over 4 TB size databases, performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on need basis. Applying patches, deployments and upgrades, implementation of database backup/restore methodologies, RMAN, hot/cold backups, export/import user ,Management User, Roles, database objects like tables, indexes, views, synonyms etc.
• Proven problem resolution of Oracle DBMS creating installation scripts and procedures troubleshoot network issues and resolve network connectivity issues. Implemented -enabled streams replication on tables/schemas, Locally Managed Table spaces, Automatic Segment Storage Management ASSM , Partitioning, Global temporary tables, Flashback, etc. and in supporting development/testing/UAT/SVT/pre-prod environments.
• Building and implementing backup and recovery using Recovery Manager RMAN , RMAN scripts and customized shell scripts on Oracle 11g data pump export/import for data transfers between various Oracle environments and for logical backups.
• Cloning the Oracle Applications from Production to Development servers, Supporting the development and testing team during implementation of the Project and on all DBA related issues
• Installed OEM grid agent 10.2.0.5 on all servers and configured them and Upgraded the OEM grid control console database from 10.2.0.3 to 10.2.0.5 and applied latest CPU patches /PSU db patches. Also applied CPU patches on OMS oracle home.
• Installed AMP 3.0 on our OEM grid control and configured our EBS databases for monitoring concurrent mgrs, forms sessions ,db locks, invalid objects and jdbc connections.Configured standby databases for our existing Production databases and activated for testing.
• Monitoring and supporting day today activities of the production and development databases and work on urgent issues when fired by pager and Creating Custom Concurrent Managers and Assigning Work shifts to it and Finding long running requests and sessions terminate them if needed.
• Applied database and application patches . Troubleshooting problems with web server, web listener, forms server, and concurrent managers, and database.

Environment: Oracle 11gr1/2/11gRAC-ASM and on Linux and OVM .

Confidential

Role: Sr. Apps Dba /Oracle RAC Database administrator

Confidential - J.P. Morgan is a leader in financial services, offering innovative and intelligent solutions to clients in more than 100 countries with one of the most comprehensive global product platforms available. We have been helping our clients to do business and manage their wealth for more than 200 years and we keep their interests foremost in our minds at all times. This combination of product strength, intellectual capital and character sets us apart as an industry leader. J.P. Morgan is part of JPMorgan Chase Co. NYSE: JPM , a global financial services firm with assets of 2.0 trillion

Roles Responsibilities

• Built 11gr1 and 11gr2 both RAC and Non RAC servers on Linux and sun box and implemented database activities like monitoring databases servers, scheduling jobs, monitoring performance issues patches implementing on Oracle suggestions, setting up alerts, Asm Management, Data Guard implemented..
• Oracle Enterprise Manager OEM /10g Grid Control GC for various database activities like monitoring Target databases servers, scheduling jobs, monitoring performance issues implementing suggestions, setting up alerts, patch implementation, Data Guard management.
• Supporting/monitoring 3-node Oracle 10g RAC on Oracle Cluster ware/Solaris platforms on high availability environment and writing shell scripting for various database maintenance and alerting activities
• Implementing and managing multi-terabyte Oracle 9i/10g/11g RAC databases to deliver leading multi-OLTP and DSS applications, enabled load balancing client-server, server-server as Transparent application failover TAF .
• Tuned SQL queries of Oracle RAC databases, Implemented the database with ASM and SAN storage skilled towards database tuning and Hands on experience in database security Advance security option ASO /auditing , backup, recovery, and archival concepts and procedures database security, backup, recovery, and archival concepts and procedures and tuning experience with SQL , Oracle RAC
• Operated with complete autonomy and influence and desire to be final level of support at Client for assigned database activities on Implemented 11gr2 with ASM and had an intensive experience with Real Application Clusters RAC and Automatic Storage Management ASM . And also setup Oracle Data Guard, Used Oracle Enterprise Management OEM Grid as tool for monitoring.
• Installing oracle applications on the test servers, upgrading migrating databases.
• Oracle Apps DBA R12/11i 11.5.10.2, 11.5.9 administration, New Design, Upgrades, migration, regular maintained activities. Resolving day to day issues with concurrent managers, Printer issues, Reports issues.
• Oracle Applications 11i/R12 Maintenance, Patching, Performance tunings Apps Development and Database Support Maintenance and Oracle Apps on AD utilities also Applied patches One-off, Mini-patch, Rollup Patch, CPU and performing AD activities and Trouble shooter several worker issues and used default files to reduce patch timelines.
• Resolve the view log/out files issue of concurrent requests, TAR support, database tuning, CM administration ,Monitoring tablespace free spaces, re-sizing datafiles, Alert log trace filesalso Responsible for cold/hot and rman backups.
• Cloning Oracle RAC Applications R12 from production RAC to uat RAC NON-RAC environment.
• Cloning Oracle Applications 11.5.9,11.5.10.2 from production to uat NON-RAC environment.
• Oracle 9i and 10g 2-Node and 3-Node RAC installation and configuration.
• Oracle Clusterware installation and database upgradation from 9i RAC to 10g RAC. Maintained a constant awareness of priority issues and how his/her availability for development, support and problem-solving affects these database issues, Supports, recommends and challenges decisions that have impact on the Oracle infrastructure.
• Production support for Oracle database cluster with databases running 2-3 and over 500 simultaneous connections and managed with over 4 TB size databases, performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on need basis. Applying patches, deployments and upgrades, implementation of database backup/restore methodologies, RMAN, hot/cold backups, export/import user ,Management User, Roles, database objects like tables, indexes, views, synonyms etc.
• Installed and configured and managed 11gr2 with Real Application Clusters database RAC with Automatic Storage Management ASM also troubleshoot problem resolution of Oracle DBMS with emphasis on Tuning and proven history with tuning Oracle Databases
• Installation and configuration of Oracle 9i RAC for E-Business Suite Environment.
• Sound troubleshooting, root cause analysis and performance tuning skills at database and OS levels with database backup recovery skills including hot/cold/storage backups complete/point in time recoveries.
• Data requirements analyzed, data modeling, conceptual/ logical/physical database design. Involved in complete system development life cycle SDLC in building large high availability and high performance databases including architecture, designing partitioning, database sizing, installation, configuration, implementation and administration of Oracle RAC databases.
• Building and implementing backup and recovery using Recovery Manager RMAN , RMAN scripts and customized shell scripts on Oracle 10g data pump export/import for data transfers between various Oracle environments and for logical backups.

Environment: Oracle 9i/10g11gr1/2/Oracle9i/10-RAC/11gRAC-ASM and on Linux ,HP and Sun box's.

Confidential

Role: Sr. Database administrator - Oracle-Sybase-Mysql

Confidential

Registration and Business Infrastructure Systems, Merchandising - Ad Operations Customer Care Operations, Session Management Services Revenue Systems Billing Operations hold under domain ORACLE, SYBASE and MYSQL databases operations.

Responsibilities

• Oracle Enterprise Manager OEM /10g Grid Control GC for various database activities like monitoring Target databases servers, scheduling jobs, monitoring performance issues implementing suggestions, setting up alerts, patch implementation, Data Guard management.
• Supporting/monitoring 8-node Oracle 10g RAC on Oracle Cluster ware/Solaris platforms on 24 x 7 high availability environment and writing shell scripting for various database maintenance and alerting activities
• Implementing and managing multi-terabyte Oracle 9i/10g/11g RAC databases to deliver leading multi-OLTP and DSS applications, enabled load balancing client-server, server-server as Transparent application failover TAF .
• Hands on experience in tuning experience with SQL queries of MySQL and Oracle RAC and Sybase databases, Implemented the database with ASM and SAN storage skilled towards database tuning and Hands on experience in database security Advance security option ASO /auditing , backup, recovery, and archival concepts and procedures
• Hands on experience in database security, backup, recovery, and archival concepts and procedures and tuning experience with SQL , Oracle RAC
• Experience with different tools monitoring software and worked on Enterprise ticketing systems like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.
• Production support for Oracle database cluster with databases running 5 nodes over 16 TB size and over 1000 simultaneous connections.
• Database performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on need basis. Applying patches, deployments and upgrades, implementation of database backup/restore methodologies, RMAN, hot/cold backups, export/import, Management of Tablespace, User, Roles, database objects like tables, indexes, views, synonyms etc.
• Provided assistance to the other members of development team with application tuning and identifying inefficient SQL statements written by the developers using Explain Plan, SQL trace and TKPROF and assisted the team in using Optimizer hints in the SQL statements to improve performance
• Sound troubleshooting, root cause analysis and performance tuning skills at database and OS levels with database backup recovery skills including hot/cold/storage backups complete/point in time recoveries.
• Analysis of data requirements, data modeling, conceptual/ logical/physical database design. Involved in complete system development life cycle SDLC in building large high availability and high performance databases including architecture, designing partitioning, database sizing, installation, configuration, implementation and administration of Oracle RAC databases.
• Designed and implemented batch jobs for data loading, pruning and archival, statistics collection using UNIX Crontab/DBMS SCHEDULER and OEM tools.
• Building and implementing backup and recovery using Recovery Manager RMAN , RMAN scripts and customized shell scripts on Oracle 10g data pump export/import for data transfers between various Oracle environments and for logical backups. Configured and maintained disaster recovery site database using standby database.
• Installation and configuration and Administration of mysql including various storage engines Mysam/inodb .
• Experience in various MYSQL tools like mysqldump/load also Implemented backup/recovery strategies as well as setup in MYSQL replication and slave setup , migrated Sybase databases to mysql on 5x version
• Upgraded from Sybase 12.x ASE and 12 Rep servers to Sybase 15 ASE/Rep server and migrated databases from Mysql 4.x to Mysql 5.x version.
• Carried out Database cloning, setup streams, benchmarking before implementing new database features or new functional enhancements or database upgrade/patching involved in different platform projects. Experience in handling Oracle Metalink service requests and bug patching/implementation.
• Experience in various MYSQL tools like mysqldump/load also Implemented backup/recovery strategies as well as setup in MYSQL replication and slave setup , migrated Sybase database to mysql on 5x version, Monitor database operations ,slave replication and implemented Automate database administration tasks.
• Installation and configuration and Administration of mysql including various storage engines Mysam/inodb on 4x and 5x and migrated dbs to 4x to 5 xs.
• Implemented -enabled streams replication on tables/schemas, Locally Managed Tablespaces, Automatic Segment Storage Management ASSM , Partitioning, Global temporary tables, Flashback, etc. and in supporting development/testing/UAT/SVT/pre-prod environments.
• Managed on Oracle Enterprise Manager OEM , Automatic Workload Repository AWR , Automatic Database Diagnostic Monitor ADDM , Active Session History ASH , STATSPACK, TKPROF, CRSCTL, SRVCTL, EMCTL, DBCA, and CLUVFY for Db administration.
• Installation, configuration, Login/User creation and authentication, Creation and Maintain Database, Various DB Maintenance operations Space monitoring adding/dropping devices , DBCC, Reindex, Update Statistics and Troubleshooting and QAR maintenances Re sync Database/table of ASE server.
• Sybase db maintenance activities like Database consistency check, Database backup, Reorg, Reindex, refresh Re sync Database/table .etc
• Involved in Schema Optimization, Index Selection and Tuning, SQL Coding Techniques and Server Parameter Tuning enabled Involved in standardizing, documenting and implementation and auditing of data governance/data security/ coding practices.
• Creating providing the L2 DBA team with the troubleshooting documents for various technical needs, Leading work/team - Mentoring conducting knowledge transfer sessions for the team, Actively involved with management areas like Incident, Problem Management, Change - Configuration management roles.
• Confidential involves production, UAT and Development databases for the following applications/categories.

Responsibilities

• 24x7 DBA support for Oracle databases in dev and production environments
• Installation of Oracle 9.x /10g across different platforms and Upgrading the Software/databases and applied periodical of latest patches for Oracle cpu/bugs patches as per oracle recommendation
• Database Refresh activities, Database movement from one machine to another
• Planning on Transaction volumes and database size its growth and Releasing locks as per the user request
• Production support for Oracle database cluster with databases running 4 nodes with over 10 TB size and over 1000 simultaneous connections.
• Responsible-handling backup and recovery, installation, creation and maintenance of databases, management of schemas, roles and profiles and database security and Scheduling periodic backups of all databases
• Involved in various administration jobs, like storage of database objects, monitoring extent and max extents, LMT, partitions, tables, indexes and tablespaces
• Configuration of Database parameters for optimal performance, Resolving connectivity problems with Oracle database, Rebuilding the Indexes to rectify segment fragmentation
• Creating a COB Continuity of Business / stand by databases setup from the production database and Monitoring Maintaining the synchronization of COB databases Writing scripts for regularly monitoring database growth and performance
• Taking logical backup table level, schema level, database level as per the clients' requirement And Transporting data using IMP/EXP/ and load utilities across different environments like production, development and UAT
• Devise and execute plans for DB backup and recovery. Maintaining archived data. Controlling of access to the production and test databases and identify the needs for changes to access control. Assess the application impact and co-ordinate with relevant application teams to plan and execute such changes.
• Monitor user access, unauthorized access and activities on the production DB, fix and report the impact and action plans to the management, configuring the TNS connections and troubleshooting network issues, Oracle Internet Directory ODI etc.
• Tuning and bottleneck analysis using Stats pack and monitoring the CPU load Memory utilization and I/O of Servers.
• Monitoring tuning I/O contention, resource contention addressing database fragmentation issues.
• Providing the highest level of support by performing on call duties and being available 24/7 for any Database related issues.
• Oracle 9i RAC Software in 4-Node Cluster server for US-Data warehouse Project
• Installation and Database creation
• Migrating Database from RAC 4- Node to Single Instance on oracle db
• Managing/administration of Load balancing
• Refresh Database with Backup once in a Quarter of a year
• Analyzed/rebuilding of indexes periodically
• Space management in tablespace, export and import etc
• Migrating databases from oracle 9i to 10g and 10g to 11g
• Administration of database objects such as indexes, tables, views, constraints
• Backup/recovery and import/export datapump Administration, Monitoring periodic backup's status for all databases and testing of backups through recoveries at regular intervals to ensure assurance of backups
• Ability to work within time and budget constraints of project production cycles as per standards

Role: Oracle DBA Oracle Database administrator

Responsibilities

• Check daily backup reports and re-run backups manually on failed database RMAN was used for backups
• Cloning of production databases for test and development purpose.
• Refreshed schemas on development/testing from production using export/import
• Worked on Data guard environments on both production and development., Created Oracle Databases on 9i and 10g and Setup and configure RMAN,
• Creating of table-spaces, extents and indexes, Install, upgrade, patches and configuration of Oracle 8i, 9i, 10g ,Create database schemas, tables, indexes, tablespaces, data objects, packages,
• procedures and functions
• Oncall support for Dev/QA and production environments and applications on all business days and 24 x 7 during holidays and weekends. Migrating Database oracle one platform sun box to another platform Linux box
• Installation and patching the database for Dev/QA and production hosts latest bug .Administration of database host outages, recoveries, migrations, installs, reviews, adhocs, small projects etc
• Handling the entire major rolls performance optimization, capacity planning, data integrity etc ... Writing scripts to automation most of the work and day-by-day activities
• Database Backups, Space Management and Customer External Data File Loads and Scheduled backups using RMAN and crontab
• Application of latest patches for Oracle bugs as per oracle recommendation
• Configuring the TNS connections and troubleshooting network issues
• Monitoring the CPU load, Memory utilization and I/O of Servers and UNIX shell Scripting, UNIX CRON jobs.
• Tuning and bottleneck analysis using Statspack -Monitoring tuning I/O contention, resource contention