SUMMARY:

• Outstanding 11+ Years of experience in Information Technology with vast Global Customer Experience, my expertise involves right from designing the Cost efficient infrastructure for Oracle E - Business Suite & Oracle Databases to troubleshooting mission critical issues in a post- production environment
• Experience in Infrastructure Assessment ­ Assisting customers on proper scaling of Infrastructure, and efficiently licensing software and hardware components. Experience in Database Assessment ­ Assessment of post­production database systems to maximize the protection, availability, and performance
• Extensive experience on Oracle E-Business Suite & Oracle Databases
• Extensive experience on Oracle POS & Oracle Retails (MOM) Suite
• Extensive experience on Oracle Fusion Middleware components like WebLogic Server, SOA Suite, GoldenGate, BPEL Process Manager, OBIEE etc.
• Experience in EBS Upgrades from 11i to R12 and R12 12.1.3 to 12.2.4
• Extensive experience in managing Microsoft SQL Server in Installation, Upgrades, Compression, tuning etc. under Cluster Environment.
• Extensive experience on VMWare, Microsoft Hyper-V and Oracle VM
• Experience in implementing Oracle Grid Infrastructure, ACFS, Golden Gate, RAC, ASM
• Extensive research in adapting to Big Data and NoSQL Databases such as MongoDB and Cassandra, looking forward to challenge myself and help Customers/Companies in implementation, administration, optimization, and solutions of all its demanding aspects
• Solid experience in designing business continuity plan for Oracle EBS & Databases ­ Experience in designing and setting up Disaster Recovery systems, Data Guard­Oracle’s DR Enterprise Solution, implemented 9i, 10g & 11g Data Guard
• Extensive experience and Excellent in understanding UNIX Operating systems (RHEL,
• HP-UX & IBM AIX) and capable of Administration. Extensive knowledge in Storage technologies
• Extensive research in adapting to 12c new features, tested 12c Multitenant Architecture, Dataguard, ASM, & RAC, looking forward to help Customers/Companies in providing solutions
• Experience in Team management ­ Assisting customers in building a capable and solid team for monitoring and managing their production systems
• Experience in Tuning Various Oracle Database Parameters and SQL Queries with Excellent approach & In­depth Analytical Experience of Oracle Database Architecture
• Extensive Experience in working with OLTP and DW systems
• Superior communication, presentation, analytical, and problem solving skills, highly self­motivated Ability to work well with all levels of business and management

TECHNICAL SKILLS:

Operating Systems: Solaris, AIX, RHEL, OEL, HP­UX, OSXWindows, & Android

Programming/Scripting: SQL, PL/SQL, CQL, MongoDBQL,Unix SHELL

RDBMS: Oracle 9i/10g/11g/12c, SQL Server 2005/2008/2012, DB2

ERP Administration: Oracle ERP 11i & R12

Oracle Products: Oracle POS, Oracle Retail Suite, WebLogic Server, SOA Suite, OBIEE, BPEL, GoldenGate

NoSQL: MongoDB 3.0.6, Cassandra 2.1.9

Hypervisor: Microsoft Hyper-V, VMWare, Oracle VM

Storage Products and Tools: Oracle ASM, NetApp Data ONTAP, Hitachi Unified Storage, EMC VMAX, VNX, VPLEX, Oracle ZFS, NFS, SAN, CIFS, IBM Storage NetApp SnapMirror & SnapShots

PROFESSIONAL EXPERIENCE:

Confidential

Senior Technical Consultant

Responsibilities:

• Install, Configure and Maintain Oracle E-Business Suite
• Install, Configure and Maintain Oracle Databases & SQL Server Databases
• Install, Configure and Maintain Oracle Fusion Middleware components like WebLogic Server, SOA Suite, GoldenGate, BPEL Process Manager, OBIEE etc.
• Migrated the E-Business suite R12 Database 11g (11.2.0.2) from single node to high available RAC environment.
• Migrated physical hardware platforms to VMs & Virtualized 80% of the DB Environment
• Migrated Database environments from 3PAR to EMC SAN Storage (20 DB Environments)
• Evaluated Database and OS Parameter Changes across all Databases as part of migration from source to target systems, Migrated and upgraded Grid Infrastructure
• Assessed and Evaluated new features associated with the OS and Database upgrade.
• Evaluated the Performance of Database systems while upgrading
• Designed Backup & Recovery Strategies based on Symantec NetBackup application.
• Level­3/4 Support for E-Business Suite & Database issues
• Migrated Databases from a 4 node Cluster to 3 node cluster, Configured Oracle Golden Gate, Upgraded Database to the latest Oracle Patch Set Release, Configured Various RAC Database Services, Integrated Golden Gate as a Cluster resource and demonstrated the failover, Failover demonstration of various events, services, and documentation
• Regular E-Business Suite Maintenance like AD Utilities, Creation of New Users, New Responsibility, monitoring Concurrent Managers
• Applying Cumulative, Mini, Bug Patches & Performing Upgrades.
• Implemented Disaster Recovery / standby database using Oracle Data Guard.
• Handling Microsoft and Oracle Cluster.
• Windows, Linux & HP-UX OS Administration Jobs
• Consolidated Database environment reducing server and license count.
• Providing management with comprehensive reports which helps in decision-making, Capacity Planning, etc. and are SAN Storage Utilization, DB Growth, Backups & Systems Performance, etc.
• Designing storage requirements as per best practice & work load type
• Performed Switchover and Switchback operations in the event of maintenance, and fail­over in the event of Disaster declaration
• Prepared DRP’s and SOP’s

Environment: Oracle 10g, 11g, Linux, AIX, EMC VPLEX & VNX, SAP, Oracle EBS R12, Datastage, SAP BO, Oracle SOA, MSSQL Server 2008, 2012, VMWare, Hyper-V

Confidential

Senior Consultant

Responsibilities:

• Migrated obsolete hardware platforms to VMs & Virtualized 80% of the DB Environment
• Evaluated Database and OS Parameter Changes across all Databases as part of migration from source to target systems, Migrated and upgraded Grid Infrastructure
• Managing HP Blade Environment using HP OnBoard Administrator and HP Virtual Connect Manager.
• Maintaining Microsoft Hyper-V environment
• Installed and configured Oracle 10g & 11i databases on standalone and RAC Environment.
• Upgraded Oracle 9i Databases to 10g & 11g.
• Designed Backup & Recovery Strategies based on Symantec NetBackup application.
• Level­3/4 Support for E-Business Suite & Database issues
• Designed SAP BO Architecture with SAP Team.
• Upgraded Oracle 9i Databases to 10g & 11g.
• Implemented Disaster Recovery Solutions using
• Mirroring
• Log shipping
• Replication - Snapshot, Merge and Transactional
• Consolidated Database environment reducing server count by 50%.
• Providing management with comprehensive reports which helps in decision-making, Capacity Planning, etc. and are SAN Storage Utilization, DB Growth, Backups & Systems Performance, etc.
• Performed DR Tests.

Environment: Oracle 10g, 11g, Linux, AIX, EMC VPLEX & VNX, SAP, Oracle EBS R12, Datastage, SAP BO, Oracle SOA, MSSQL Server 2008, 2012, VMWare, Hyper-V

Confidential

Senior Apps DBA (Team Lead)

Responsibilities:

• Installed, Configured and maintained Oracle VM Infrastructure
• Installed 4­node RAC Grid Infrastructure for Oracle Retail (MOM) Suite
• Installed & configured Oracle E-Business Suite R12
• Implemented 11.2.0.3 Database Systems on a four node RAC with ASM on platforms such as
• Solaris and Linux, Upgraded Databases from 10.2.0.3, 11.2.0.1 to 11.2.0.3
• Installed and configuration and administration of many Weblogic, Oracle 9i, 10g and 11g Databases, SQL server 2005 and SQL server 2008 for the Data warehouse, In-House Applications, E-Commerce etc.
• Implemented & Maintained Disaster recovery database using DataGuard and led DR Drill activities, performed Switchover and Switchback operations
• Configured services on RAC for various purposes based on load, application usage, and manageability, tested failover of Services, and manually relocated
• Validated Shell scripts for backups, rotating and purging alert/trace/listener logs
• Performed database recoveries following NetApp’s snapshot based mirroring as part of Data center migration
• Level­3/4 Support for E-Business Suite, Oracle POS, Oracle Retail Suite, Oracle & MSSQL Databases
• Responsible for all database architecture and program design
• Destroying databases and respective volumes mounted on host, and restoring from NetApp’s snapshot based backups, and recovering Databases, as part of Datacenter migration, handed over for load testing, and monitoring & diagnosing the performance
• Installed Oracle 12c agents across all database servers and Oracle EM 12c
• Installed and configured Oracle Golden Gate, created extracts and replicates between various source and target systems
• Validated Parameters across all Databases as part of migration from source to target systems
• Migrated the E-Business suite 11i Database 10g (10.2.0.2) from single node to high available RAC environment.
• Installed an additional Application node and configured Hardware load balancer between two Oracle Application nodes.
• Regular and day to day sysadmin activities like cloning/patching
• Major team player in Oracle Retail and Oracle Demantra Implementation and maintain Oracle Retail and Oracle Demantra Applications
• Installed and maintaining Oracle Application/Weblogic server 10g and 11g
• Upgraded Production Databases from Oracle 9i Databases to 10g, Oracle 10g to 11g.and MS SQL server 2005 to MS SQL 2008 & 2012
• Applied patches to keep the EBS and databases at latest patch level
• Regular E-Business Suite Maintenance like AD Utilities, Creation of New Users, New Responsibility, monitoring Concurrent Managers
• Developed Shell driven SQL Scripts for Database activities
• Windows, Linux & HP-UX OS Administration Jobs
• Involved in Analysis and Design Documentation, User requirements and maintained good documentation
• Tune the Databases by examining current workloads and hardware, making improvements, and measuring the results.
• Coordinated physical changes and performance monitoring of two replicated production servers, all Microsoft SQL Server 2005.
• Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.
• Profiled and tuned servers on a monthly basis to ensure fast queries and reports.
• Wrote installation and procedural manuals for support staff
• Developed SQL scripts for maintaining administration tasks.
• Tuned database parameters related to SQL operations such as open cursors, cursor sharing & DB BLOCK CHECKING, DB BLOCK CHECKSUM, and DB LOST WRITE PROTECT to prevent block corruption and resolved block corruption on Standby systems
• Documented various Database standard practices, and Standard Operating Procedures
• Monitored the health of OS, Storage, Network, and Databases by generating and analyzing reports such as AWR, ADDM, nmon (AIX), top/topas, vmstat, prstat, iostat, traceroute, and ping etc, and improved performance of the Database
• Identified resource consumptive SQL Queries using Enterprise Manager, SQL TRACE, & tkprof helped Customer in improving performance

Environment: Oracle 10g, 11g, oracle EBS 11i & R12, Oracle Retail, Oracle Demantra, Oracle SOA, Oracle Weblogic & AS, Oracle VM, Informatica, Cognos, Linux, Solaris, AIX, NetApp SnapMirror, SnapVault, SnapVault

Confidential

Database Administrator Manufacturing

Responsibilities:

• Involved in installation and configuration of Oracle 9i, 10g databases and SQL server 2005
• Applied patches and service packs to keep the Applications database at current patch level.
• Responsible for General Database Administration and Performance tuning.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.
• Responsible for General Database Administration and Performance tuning.
• Experienced in resolving deadlock and blocking issues for concurrent users.
• Worked with DTS packages to load the massaged data into Data warehousing system.
• Data Migration from legacy to master tables using DTS-Import and Export wizard.
• Performance tuning on SQL Server 2000 and 2005.
• Developed Database Backup Scripts and automated this process.
• Used MS Visual Source Safe 6.0 as a Version Control System.
• Partly Participated in system study and analysis of software applications.
• Applied patches and service packs to keep the database at current patch level.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in Analysis and Design Documentation, User requirements and maintained good documentation.
• Designed and implement database logical and physical Schemas using Erwin 3.5.2./4.0
• Supported production and development databases.
• Implemented SQL standards in writing Stored procedures, Triggers, Views, Sql functions and locking issues.
• Managed 17 databases at the headquarters running on 10 servers.
• Database version control using VSS.
• Developed SQL scripts for maintaining administration tasks.
• Backup and Recovery plans for Field office and Headquarters database servers.
• Maintained the field office database backups through SQL mail Scripts.
• Converted the legacy data from mainframes and dbase by using DTS packages.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures.
• Created and maintained users and user groups.
• Performing time to time Restoration test.

Environment: Microsoft SQL Server 2000 and 2005, Oracle 9i & 10g, Windows 2000, 2003 Server, Solaris 8, Linux Red-hat AS-4