Summary of Experience:

• Sr.Oracle DBA with over 12 years of of IT experience in Oracle Database administration of 11g/10g/9i/8i/RAC, OEM12c,NON RAC, Support DBA/Oracle Apps 11i, R12.
• Expert in Implementation Oracle 10g/11gr2 Grid RAC, CRS, ASM, Database and Configuration for High Performance and High Availability with latest Cluster Technology.
• Expertise on Managing Oracle 11g/10g/9i/8i,RAC 24 7 on call production DBA Support on Linux, Solaris, HP-UX, Dynix, Win NT and Win XP/2000 Enviornment including E-Business Suite Implementations with full project life cycle experience skills.
• Expertise in Design and Implementation of Database Systems to provide database support for systems/projects, rehosts, migrations and conversions.
• Implementation of all Oracle's latest Tools/Products/ to the Advanced Global next generation Information Systems Client/Server Architecture Technology for large/medium/high Oracle Databases in Global Market Production/Development Projects in a good Advanced progressive environments.
• Experience in Configuring, Administration and Management of Oracle Dataguard in 10g/11g version.
• Performance tuning of Queries, Database Performance improvements on Critical production Enviornment. Performance tuning of SQL, PL/SQL Queries, tuning using dbms profiler, sqlt, Trace analyzer, RDA, ash reports, AWR report, AWR SQL Reports. Analysis of Wait events and analysis of trace files using debug commands.
• Experience in Implementing and administration of Oracle Ebusiness Suite projects and upgrades of Oracle Ebusiness Suite instance from 11.5.8 to 11.510.2 and 11.5.10.2 to R12.
• System administration and troubleshooting of Concurrent Managers, Forms, Reports, Web server Printer issues on the Ebusiness Suite 11i instance, R12 instance, OID and SSL configuration.
• Helped different Customers/clients to upgrade their databases of different sizes database sizes from 1 gig to 12 Terabyte support on different OS Environment.
• Experience in troubleshooting issues in Oracle golden Gate and Migrating databases from Oracle 10g to 11g using Oracle Golden Gate.
• Have worked on and implemented process as per the ITIL Framework Enviornment and adheres to operational/business SLA required for the organization.
• Excellent in Implementing Oracle 10g Interconnect DBA Support, Implementation.
• Handled large databases size in production ranging from 1GB to 30 TB.
• Oracle Data Centre Migrations, Consolidation and Upgrade/Migrations of Oracle Databases for different Oracle Versions and platforms. Patching and Cloning of Oracle and Oracle Apps Instances.
• Logical Physical DB Design involving Change Management process with ITIL Oriented framework with adherence to business SLA depending on the business environment.
• Worked on Oracle features in Oracle10g/11g Partition, Parallelism, Compression , Oracle 9iAS, SQL PLUS, Pro C, IMP/EXP, IMPDP/EXPDP, RMAN, ASMCA, DBCA, SQL Loader, Oracle Golden Gate Support.
• Exposure working in different domains such as wireless, manufacturing, telecom Banking and Logistics.
• Exposure on Managing other Database Variants like MSSQL Server 7/2000, MYSQL, Postgres Adaptive SQL, Sybase,DB2.
• Motivated to take independent responsibility as well as to contribute to be a productive team member. Strong Team building and mentoring skills and excellent Team leadership capability.
• Strong Logical and Analytical Reasoning Skills, Excellent Management skills, Excellent Communication with good Listening, Presentation and Intrapersonal Skills.

Technical Skills:

Professional Experience:

Confidential

Senior Oracle Database Administrator

• Description: Thomson Reuters is the world's leading source of intelligent information for businesses and professionals. It combines industry expertise with innovative technology to deliver critical information to leading decision makers in the financial and risk, legal, tax and accounting, intellectual property and science and media markets, powered by the world's most trusted news organization.
• The project involves maintenance, administration, monitoring and Implementation of Database support over international operations consisting of hundreds of servers including SOX critical database servers. The team to support 24 7 critical on call production oriented support for systems associated with Customers and Employees with strict adherence to Change Management Policy.

Responsibilities:

• Involved in supporting day to day activities in 24 7 Prod DBA Environment consisting of 9i, 10g, 11g RAC and Non RAC systems, Dataguard, stream, Golden Gate support, OEM support.
• Monitoring and troubleshooting of SM9 Alerts, OEM Alerts, Monitoring job alerts and other Critical alerts generated from various applications through various monitoring mechanism.
• Change Implementation of the CR,Troubleshooting, administration, Performance tuning, Dataguard services, Oracle Enterprise Manager issues, Oracle Golden Gate Services, Oracle Streams and support of Oracle Database issues in RAC and Non RAC environment running in different platforms and using different filesystems like Netapps,Vfilers for varied Unix Systems.
• Performance Tuning on Databases on adhoc basis based on operational activity. Performance tuning of SQL, PL/SQL Queries, tuning using dbms profiler, SQLT, Trace analyzer, RDA, ash reports, AWR report, AWR SQL Reports. Analysis of Wait events and analysis of trace files using 10046, 10053 debug commands.
• Staging CR and implementing the same and raise PCA for emergency issues arising out of the DB and ensuring necessary approvals before performing the DB operations. Restore and recover flex clone database using nfs snapshot filers.
• Raising TAR and solving issues as part of bugs arising during Production issues. Preparing Key -Reports, Metrics, RCA's etc. for the management.

Environment: Linux,Solaris,HP-UX,AIX,Oracle 9i/10g/11g databases,RAC,CRS,Oracle Golden gate, Dataguard, OEM 12c,Oracle Streams, Oracle backups using snapshot.

Confidential

Lead Oracle Database Administrator

Description: NBCUniversal is one of the world's leading media and entertainment companies in the development, production, and marketing of entertainment, news and information to a global audience. NBCUniversal owns and operates a valuable portfolio of news and entertainment television networks, a premier motion picture company, significant television production operations, a leading television stations group, world-renowned theme parks, and a suite of leading Internet-based businesses. The project involves maintenance, administration, monitoring and Implementation of Database support over international operations consisting of 500 servers including SOX critical database servers. The team to support 24 7 critical on call production oriented support for systems associated with NBC universal and its customers.

Responsibilities:

• Managing team of DBAs involved in Production support and Development activities and providing necessary support. Involved in supporting day to day activities in 24 7 Prod DBA Env.
• Monitoring and troubleshooting of M360 Alerts, OEM Alerts,Ctrl M job alerts and other Critical alerts generated from various applications through various monitoring mechanism.
• Troubleshooting, administration, Performance tuning, Dataguard operations, Oracle Enterprise Manager Issues, Oracle Golden Gate Services, Oracle Database Appliance and support of Oracle Database issues in RAC and Non RAC environment running in different platforms.
• Support databases with application services like SAP with database sizes ranging up to 30 TB.
• Upgraded Oracle Database Appliance from version 2.8.0. to 2.10.10.
• Expertise on installation, configuration of Oracle Enterprise Manager 10g,11g,12C and monitoring of Databases in RAC, Performance tuning, Dataguard operations using Oracle Enterprise Manager.
• Capacity planning and space management at Database level and adding Disk Space at ASM with rebalance. Management of Oracle 10g database using RAC, CRS, ASM services.
• Planning Implementation of Backup traditional RMAN , RMAN with Netbackup and SOX restoration including recovery scenarios based on the operational issues.
• Modifying, creating of various shell Scripts for Services management, Process monitoring, Clearing logs, setting environmental variables etc. proactively and doing RCA and Post-mortems for them.
• Setting up of Oracle Best Practice's Tools like Oswatcher, RDA for monitoring and analysis of the database servers.
• Raising TAR and solving issues as part of bugs arising during upgrade or patching. Documentation of Various Sysadmin tasks, Patching and Cloning Steps. Preparing Key -Reports, SDP Metrics, RCA's etc. for the management.

Environment: Linux,Solaris,HP-UX,AIX,Oracle 10g/11g databases,RAC,CRS,ASM,Oracle Golden gate, Dataguard, OEM 12c,Oracle Database Appliance, Oracle RMAN using NetBackup.

Confidential

Sr Oracle Database Administrator

Description: FedEx provides customers and businesses worldwide with a broad portfolio of transportation, e-commerce and business services. It offer integrated business applications through operating companies competing collectively and managed collaboratively, under the respected FedEx brand. Consistently ranked among the world's most admired and trusted employers, FedEx remains absolutely, positively focused on safety, the highest ethical and professional standards and the needs of their customers and communities.. The Project involves provide DBA services for the Client/Server platforms for several systems development areas within ITD.Involved in Implement database design requirements in continued support of HDS rehosting and Sybase conversions to Oracle. Provide database support for systems/projects prioritized for Prod,UAT,Test requests for DBA Air Ground Line Haul users .

Responsibilities:

• Assist development personnel in selecting the DBMS that best fits the application requirements and conforms to ITD standards.
• Estimate space requirements for production databases, tables, indices, and, as applicable, database backup and logging facilities.
• Capacity planning and space management at Database level and adding Disk Space at ASM with rebalance. Management of Oracle 10g/11g database using RAC, CRS, ASM services.
• Conduct design reviews with ITD Database Analysts, Computer Operations personnel, Systems Development personnel, and external vendors, as applicable, to validate the selected designs.
• Implementation of the database objects in Productions through change management procedures.
• Troubleshoot, fix regular issues arising in Production and development including performance issues arising in Production and Development databases.
• Schedule and perform database backup frequencies, media, and initiation procedures that conform to the application's data maintenance design and the physical constraints of the production platform.
• Cloning and refresh of the database from production to lower levels and between lower levels using database utilities.
• Migration of databases from 10g to 11g on various platforms based on application requirements.
• Migrate,rehost schemas, databases from Sybase to Oracle, oracle upgrades from 10g to 11g.
• Perform Migration using Oracle Golden gate and troubleshooting issues arising during Migration and rehosts using Oracle Golden gate.
• Monitor databases issue using OEM 12c and perform administration tasks using OEM and other Database utilities.
• Review architecture for compliance to architectural directives and recommend, as applicable, data mirroring and replication strategies.

Environment: Linux,Solaris,HP-UX,Oracle 10g/11gc databases,RAC,CRS,ASM, Oracle Golden gate, Dataguard, Oracle Enterprise manager 12c,Grid,Oracle RMAN using SQL-Backtrack.

Confidential

Oracle Lead Database Administrator

Description: Tata Communications Limited is a leading global provider of the new world of communications. The Tata Communications portfolio includes transmission, IP, converged voice, mobility, managed network connectivity, hosted data center, communications solutions and business transformation services to global and Indian enterprises and service providers, as well as broadband and content services to Indian consumers. The Project involved maintenance, administration, monitoring, Implementation of Database support over international operations consisting of 100 servers including SOX critical database servers. Using Database as means for managing entire network services including underwater communications globally. The team to support 24 7 critical on call production oriented support with ITIL framework and process oriented Enviornment adhering to business SLAs.

Responsibilities:

• Managing team of DBAs involved in Production support and Development activities and providing necessary support. Involved in supporting day to day activities in 24 7 Prod DBA Env.
• Upgraded Oracle CRS, ASM, and Database on 5 node cluster and scaled up 2 new nodes to existing cluster making it a 5 node cluster. Migration of Oracle CRS, ASM, Database from old 5 node cluster to new 4 node cluster with better hardware.
• Troubleshooting and support of Oracle Golden gate Replication issues.
• Upgraded and Migrated 12 TB Billing database server running on standalone Sun Solaris 5.9 to 2 node RAC server with CRS/ASM running on RHEL.
• Migrated a database as part of Server move with 4 TB in Size and Upgraded to 10gR2.
• Patch Upgrade from 10.1.0.5 to 10.2.0.4 on all Critical RAC Databases in the cluster. Migration and Upgrade of RAC/Non RAC databases from 10.2.0.1 to 10.2.0.4 and Patch set Upgrades. Patch set upgrades from 10.2.0.4 to 10.2.0.5 on all RAC and Non RAC database servers.
• Implementation of Oracle 10g/11g Database on Active-Passive Sun Cluster.
• Expertise in Configuring, Administration and Management of Oracle Dataguard in 10g/11g R2 versions.
• Expertise on installation, configuration of Oracle Enterprise Manager 10g,11g,12C and monitoring of Databases in RAC, Performance tuning,Dataguard operations using Oracle Enterprise Manager.
• System administration of Oracle 11i/R12 version of Ebusiness Suite Production Enviornment.
• Upgrade of Ebusiness Suite Instance from 11.5.10.2 to R12 Oracle Apps Instance and DB Upgrade from 10gR2 to 11gR2.
• System Administration of Oracle Apps 11i/R12 instance. Patching and Cloning of Oracle Instances and Oracle Apps Instances.
• Capacity planning and space management at Database level and adding Disk Space at ASM with rebalance. Management of Oracle 10g database using RAC, CRS, ASM services.
• Planning Implementation of Backup traditional RMAN , RMAN with Netbackup and SOX restoration including recovery scenarios based on the operational issues.
• Modifying, creating of various shell Scripts for Services management, Process monitoring, Clearing logs, setting environmental variables etc. proactively and doing RCA and Post-mortems for them.
• Setting up of Oracle Best Practice's Tools like Oswatcher, RDA for monitoring and analysis of the database servers.
• Support on other RDBMS variants like MYSQL, Postgres Advanced Server.
• Raising TAR and solving issues as part of bugs arising during upgrade or patching. Documentation of Various Sysadmin tasks, Patching and Cloning Steps.
• Preparing Key -Reports, SDP Metrics, RCA's etc. for the management. Providing Architectural Suggestions and New Proposals based on the technical requirement.

Environment: HP-UNIX, Dynix, Solaris, Linux, Windows NT,Oracle Application 11.0.3, Oracle Applications 11.5.8,Oracle Applications 11.5.10.2,R12, Oracle 8i/9i/10g/11g dtabases,RAC,CRS,ASM, Oracle Golden gate, Data guard, Oracle Enterprise manager,Grid,MYSQL,Postgres advanced server, Oracle RMAN using Net backup.

Confidential

Oracle Lead Database Administrator

Description: Tata Communications Limited is a leading global provider of the new world of communications. The Project involved maintenance, administration, monitoring, Implementation of Database support over international operations consisting of 100 servers including SOX critical database servers. Using Database as means for managing entire network services including underwater communications globally. The team to support 24 7 critical on call production oriented support with ITIL framework and process oriented Enviornment adhering to business SLAs.

Responsibilities:

• Managing team of DBAs involved in Production support and Development activities and providing necessary support. Involved in supporting day to day activities in 24 7 critical Prod DBA Env.
• Migration and Upgrade of RAC and Non RAC databases from 8.x to 10.2.0.1.Patch analysis and Applying of Security and bug Patches in 10.1.0.5 database.
• OEM Agent Install and Configuration of Repository database for Grid Monitoring on RAC and non RAC instances.OEM Metrics and Policies customized to monitor specific to database.
• Re-organizing the database involving partitioned tables and organizing database's OS file. Space management at Database level and adding Disk Space at ASM with rebalancing.
• Management of Oracle 10g database using RAC, Clusterware, ASM services.
• Planning Implementation of Backup traditional RMAN , RMAN with Netbackup and SOX restoration including recovery scenarios based on the operational issues.
• Monitoring Memory, CPU and IO activities periodically tuning them. Performance Tuning of Queries SQL, PL/SQL and Databases on adhoc basis based on operational activity. Troubleshooting connectivity like tnsnames, listeners and intelligent agents.
• Setting up of Oracle Best Practice's Tools like Oswatcher, RDA for monitoring and analysis of the database servers.
• Managing the services for the Telecom application, network components.
• System Administration of Oracle Apps 11.0.3, 11.5.8, 11.5.10.2.Patching and Cloning of Oracle Instances and Oracle Apps Instances.
• Modifying, creating of various shell Scripts for Services management, Process monitoring, Clearing logs, setting environmental variables etc. proactively and doing RCA and Post-mortems for them.
• Support on other RDBMS variants like MYSQL, Postgres Advanced Server.

Environment: HP-UNIX, Dynix, Solaris, Linux,Windows NT,Oracle Application 11.0.3, Oracle Application 11.5.8,Oracle Application 11.5.10.2,Oracle 8i/9i/10g/11g databases, Oracle Golden Gate, Oracle RAC,CRS,ASM and Grid, MYSQL, Postgres advanced server, Oracle RMAN using Netbackup.

Confidential

Sr. Oracle Database Administrator DBA /Tower Lead

Description: Barclays RBB, Part of the Barclays Group, Retail and Business Banking RBB operates across 21 countries and is most recognizable on the high street. Located globally in Europe, Asia and Africa, the RBB Technology team makes up the majority of this group. The Project involved discovering the IT infrastructure services Servers, Databases, Applications, services and creating a mapping based on the associated services and dependencies between them and identifying risks associated with all services and presenting to management for preparing road map for upgrade to latest versions.

Responsibilities:

• Involved in Manual discovering of the Database and it is relevant details in Northampton Data Centre for various variants Oracle, MSSQL, Informix, Ingres, DB2, MYSQL, Postgres, and Sybase. Done Physical Audit of all the Windows/Unix Servers in Northampton Estate.
• Identification of the Service and Server Mapping for the discovered Servers and databases. Mapping of dependency between servers, databases and applications. Capturing details of the live, decommissioned Databases, Obsolete version of Databases, DR details for the databases and Risks associated with the Database Servers.
• Discussions with Application SME for the data collection and preparation of Dependency Details and Mapping them. Updating the Validated and Verified data into CMDB Atrium Database.
• Preparation of Migration Plans for the Windows Servers and Associated Databases in the data Centre. Preparation of High Level Design document and implementing them.
• Suggestions for Decommission of obsolete Services, Servers, Databases and Providing Upgrade Methodology for the Database Servers across various variants.
• Involved in Server Migration of Databases from old hardware to new hardware platform based on the criticality of the IT services. Decommissioning old database servers.
• Capacity Management adding Disk Space at ASM and Rebalance activities. Database restores and validations of Backup Tapes. Involved in supporting day to day activities in 24x7 Production DBA Support environments. Re organizing the database involving partitioned tables and organizing database's OS file.
• Resolving issues based on the Incidents, Requests in Service now/Service run. Management of Oracle 10g RAC, ASM, Clusterware services. Troubleshooting Database incidents.

Environment: Windows/Unix Servers Different platforms , atrium, Oracle 8i/9i/10g, MSSQL Server7/2000, 2003, Ingres, DB2, Informix, Sybase, Postgres and MySQL

Confidential

Sr.Oracle Apps Project DBA

Description: Alcoa is the world's leading producer of primary aluminum, fabricated aluminum, and alumina and is active in all major aspects of the industry. Alcoa serves the aerospace, automotive, packaging, building and construction, commercial transportation, and industrial markets, bringing design, engineering, production, and other capabilities of Alcoa's businesses as a single solution to customers. The Project involved setting up of Oracle Database and Oracle Ebusiness Suite Implementation for managing their critical industry with implementation of Oracle latest trends of technology in their industry for better manageability and productivity.

Responsibilities:

• Setting up Shared and Distributed Appltop architecture with upgrade from 9.2.0.5 to 10.2.0.2 with Cross platform HP-Unix/Linux architecture Integrated with PeopleSoft Data and Payroll Data.
• Upgrade of ITG Mercury Production Instance from 11.5.8 to 11.5.10.2 Oracle Apps Instance and DB Upgrade from 9.2.0.4 to 10.2.0.2.Relocation of Australian Production Instances Commercial/HR/DWH from Australia to North America data center.
• As a Project DBA was involved in OAI Interconnect Upgrade on Production from 9i to 10g and adapter configuration, troubleshooting of the adapters and monitoring repositories. Installing, configuring and maintenance of OAI Servers.
• Perform routine DBA tasks arising as part of OAI activity like maintaining Space, Schema and troubleshooting the DB. Troubleshooting errors and track messages of OAI.
• Modifying, creating of various Scripts Shell, Perl for Services management, Process monitoring, Clearing logs, setting env variables, applying patch, dequeueing messages from the adapters for OAI.
• Involved in Commercial Apps Instance Upgradation of Production database from 11.5.8 to 11.5.10.Analysis, Planning, Implementaion, Estimation and Preparing Project Plans in the team for Oracle DBA Projects.
• Supported in setting up of Global Data warehousing Oracle Apps Instance with 10g Upgrade and ASM on RAC.Cross platform Export Import. Setting up of secure url.
• Patch analysis, Upgrade Patching of Family Packs for the Oracle Apps instances. Applying of Security Patches for RDBMS Home and Oracle Applications. Cloning of the instance to build test/dev/qa/uat and prod servers.
• Turnover of the Apps Instance, which includes setting up Backup Policy, Security Scans and rules for the sensitive data.
• Troubleshooting of Concurrent Managers Issues as a part of System administration of Oracle Apps.Perform routine DBA tasks like maintaining Space, Schema and troubleshooting the DB.
• Managing the services for the application, network components. Installation, configuration of third party utilities like Project Loader 2.5 ClearOrbit.
• Preparing Capacity Requests for the Instances.Kintana packages migration.
• Documentation of Various Sysadmin tasks, Patching and Cloning Steps. Change Management, Raising TAR and solving issues as part of bugs arising during upgrade or patching.

Environment: HP-UNIX 11.11, Red Hat Enterprise Linux AS Release 4,Oracle Application 11.5.10.2,11.5.8,Oracle 9i database, Oracle 10.1,HP-UNIX 11.11,Oracle Application Interconnect 9.0.2,Oracle Application Interconnect 10.1.2,Kintana.