SUMMARY:

• DBA Professional with over 14 years experience in Oracle, Sybase and Microsoft SQL databases, over 12 years experience in Oracle E - business Suite applications.
• Programming languages including Shell, Perl, Sybperl, T-SQL and PLSQL.
• Familiar with Unix, Linux, Windows platforms and VM, SAN storage, Data Domain and Netbackup.
• Strong analytic and problem solving skills. Track record of meeting critical deadlines.

TECHNICAL SKILLS:

Oracle EBS: Version 11.5.10.1, 11.5.10.2 and 12.1.3

Database: Oracle 8i, 9i, 10g, 11g and 12c. Sybase and Replication 11.9,12.0,12.5, 15.0 and 15.5. Microsoft SQL Server 2005, 2008, 2008R2 and 2012.

Oracle Utilities: RMAN, Datapump, ASM, Dataguard, Statspack, AWR, Oracle Sybase Gateway. Oracle RAC.

Sybase Utilities: Sybase Enterprise Connect to Oracle, DMA, optdiag, Sybase replication.

SQL server Utilities: SSMS, SSIS, SSAS and SSRS.

Paltform: Unix, Linux, Windows and Virtual platforms.

PROFESSIONAL EXPERIENCE:

Oracle DBA

Responsibilities:

• Upgraded Oracle database servers from verison 9.2.0.8, 10g to version 11.2.0.3.
• Upgraded an Oracle Server from version 11.2.0.3 to version 12.1.0.1
• Created Oracle 12.1.0.1 container database and pluggable databases.
• Migrated an Oracle 12.1.0.1 non container database to a pluggable database.
• Migraded all our Oracle servers from UNIX platform to Linux platform.
• Using RMAN and in house developed scripts to backup and clone databases.
• Designed and set up all our Oracle DR databases. Successfully failed over to DR and failed back to production for all production databases in our Data Center relocation process.
• Troubleshoot performance issues, resolved problems by redefining indexes, using fixed execution plan by using outline, sql plan baseline, utilizing large I/O block size tablespace and creating BITMAP indexes.
• Created some procedures and views in database to help performance tunning.
• Installed and configured Oracle Sybase Gateway 8i, 9i 10g and 11g. Created Oracle database links for Oracle users to access Sybase databases.
• Created scripts to automatically clone production database to QA environment daily.
• Created scripts to do weekly reorg space, defragment, rebuild indexes.

Sybase DBA

Responsibilities:

• Upgraded Sybase servers from version 12.5 to 15.0, and from 15.0 to 15.7.
• Redesigned and implemented data population from production Sybase servers to Sybase report server.
• Created scripts to populate Oracle data to the Sybase report server by using Sybase Enterprise Connect to Oracle and Sybase proxy tables.
• Performance tuning. Adjusted configuration parameters to reduce contention within server processes. Configured data cache with different I/O size of memory pools.
• Created and supported Sybase Replication Servers 12.5 and 15.5.
• Set up and supported Sybase replication for Warm Standby application.
• Set up a table replication by create replication definition and create subscription.
• Used Sybase showplan to troubleshot query performance problem. Helped user to create better indexes. Set up update statistics job and rebuild index job to run regularly.
• Using DMA to determine the Wait Event for the long running process.
• Created proxy tables for Sybase users to access tables in other Sybase servers.
• EWM & TM Direct integration
• Worked on special business processes like Resource related Billing (DIP Profile), Revenue Recognition
• Having good knowledge in cross function module integration with SD/MM, SD/PS and SD/FI.
• Having knowledge on SAP PS Module
• Achieved Sprint from the Intelli Group Asia.
• Worked in sap labs India as solution Architect for sap EWM & TM
• Attended SAP TechEd 2015 in Bangalore, covered technical lectures and hands on workshops on dynamic topics in Logistics and S/4 HANA
• Got spot from sap labs in 2015
• Worked on Archiving Management in Extended Warehouse Management
• Worked on SAP EWM 9.4 story board EWM & TM Direct integration, Transit warehouse& warehouse Billing
• Worked on S/4 HANA EWM
• Created linked server to Sybase, Oracle, and other Microsoft SQL databases. Designed and Created backup and maintenance jobs for production databases. Created a job to load production database backups to DR databases automatically. Supported user managemants and space managements etc.
• Set up and Supported MS SQL server clusters, replication and log shipping.
• Installed and supported MS SQL server SSIS, SSAS and SSRS.
• Helped our clients to troubleshoot their application problems, performance problems. Used Microsoft SQL Profiler to help user troubleshoot performance problem.

Oracle Apps DBA

Responsibilities:

• Upgraded Oracle E-business Suite from version 11.5.10.2 with database 10g to version 12.1.3 with database 11gR2.
• Migraded Oracle E-business Suite database from UNIX platform to Linux platform.
• Migraded Oracle E-business Suite 11.5.10.2 database tablespaces to OATM(Oracle Applications Tablespace Model).
• Migraded Oracle E-business Suite from two nodes installation with database, Admin, Concurrent Manager on one node, and Web server, Forms on the other node to two nodes installation with database on a Linux node, and all applications on an Unix node.
• Created project plans for all upgrade and migration tasks and worked with users to execute the tasks in steps.
• Configured and supported Oracle Workflow Mailer in Oracle Applications 11i and R12.
• Developed a monitoring script to monitor Oracle Workflow Mailer.
• Designed and set up our DR environment for Oracle E-business Suite. Successfully failed over and failed back our Oracle EBS Applications to DR site during the severe production problem and in our Data Center relocation process.
• Developed scripts to automatically clone our Oracle EBS production environment to QA environment daily.
• Performance tuning for Oracle Applications. Resolved the performance issue with Add/Delete Summary Templates job in both version 11.5.10.2 and 12.1.3.
• Cloned Oracle EBS environment in versions 11.5.7, 11.5.10.2 and 12.1.3.
• Upgraded Oracle EBS Financials from11.5.7 to 11.5.10.2 which includes upgraded Oracle server from 9.2.0.6 to 10.2.0.4 and also from 32 bit to 64 bit. Applied Oracle Application Technology 11i.ATG.PF.H.RUP7.
• Applied various patches to Oracle Financial Applications. Analyzed Oracle patches.

Confidential

Senior Sybase DBA

Responsibilities:

• Built and supported replication server 11.5.1 for warm standby application. Monitored and tuned our server performance. Helped our users to improve their application performance by improving their SQL program, and using proper indexes. Backup and restore databases. Created users, and set up permissions etc. Supported mission critical servers.
• Installed Sybase server 11.9.2 and SQL BackTrack 4.1 for migration. Successfully migrated our production databases to the new server. Responsible for debugging and troubleshooting of various problems from our Sybase SQL servers and replication servers.

Confidential

Sybase DBA

Responsibilities:

• Installed and supported replication server 11.5.1 for warm standby application. Modified the Sybase replication setup, remove, switch active and latency scripts for our applications. Developed Sybperl scripts to check consistency between a production database and its warm standby.
• Upgraded Sybase SQL server 11.0.3 to 11.9.2. Performed SQL server performance tuning. Responsible for debugging and troubleshooting of various problems from our Sybase SQL servers and replication servers. Backup and restore databases. Created users, and set up permissions etc. 24x7 support for mission critical productions.
• Developed and Implemented a Perl script to monitor the operation of servers and LTMs. Developed Sybperl scripts to monitor log space and latency for Sybase servers.
• Wrote and tested the recovery procedures for the Disaster Recovery requirement. Performed primary server switching over when our production UNIX server had serious problems.
• Some experience on Oracle and Microsoft SQL server.

Confidential

Parallel Batch Administrator

Responsibilities:

• Developed scripts in AutoSys production reset and monitoring to enhance and automate AutoSys production environment, reducing PBA’s workload significantly. Upgraded AutoSys instances to 3.4.2 which is Y2K compliant.
• Supported AutoSys production. Responsible for debugging and troubleshooting various production problems in both UNIX and NT environments. Assisted users to migrate their production cron jobs into AutoSys.