SUMMARY:

• Accomplished IT professional with significant expertise in Oracle EBS Application and Database Administration across industry leading Databases including Oracle (11G), MS - SQL Server, Sybase and good working knowledge of Big-data technologies such as Hadoop.
• Provided industrial strength, scalable DB models managing data excessive of 19TB.
• Lead a team of DBAs and System administrators providing operational support to a business community of 25K spread across Americas, Europe and Japan.
• Responsible for planning and execution for High Availability, BCP, DR, DB Health, Technical Debt management and maintaining Software currency of databases and application servers.
• A fast learner, armed with articulate communication and interpersonal skills essential in establishing positive working relationship with individuals of diverse backgrounds

AREAS OF EXPERTISE:

• Project Planning and Management, Performance Tuning - Application, Instances, SQLs & PL SQL
• High Availability and Disaster Recovery Setup and Management, System Design, Python and Bash Shell Scripting
• Troubleshooting, Server Installations, Cloning & Patching, Cluster Management, RMAN setup and Backup
• 7x24 support
• Oracle EBS 11i/R12, Oracle RDBMS 8i/9i/10g/11g/12C;, 11gR2 ASM/RAC, Oracle WebLogic;, MS SQL Server 2008/2012/2014
• Oracle SOA and OBIEE, Sybase 12.0 Replication server, Sybase 12.0 & 15.7, Microsoft SQL server cluster, Cloud, Golden Gate 11gR2
• HP-9000 | IBM AIX | Sun SPARC Servers | Linux | Solaris | MS Windows

PROFESSIONAL EXPERIENCE:

Confidential, West Caldwell, NJ

Senior Oracle, Sybase MS -SQL Server, EBS Application & Database Administrator

Responsibilities:

• Carried out wide-ranging duties such as directing various technology projects, organizing processes for the DBA Support Team, and administrating the workload for a geographically distributed team
• Setup DR site at Macon, GA using Physical Standby database, designed and developed automated monitoring scripts with alerts
• Setup and Troubleshoot Quoting application for sales people using Oracle Sales cloud as SaaS
• Lead the Upgrade of Oracle EBS 11i to EBS 12.2.4 project
• Established a 24 x 7 support model, hand-holding shift leads on SRE activities leading to significant improvement in SLAs
• Liasoning with business stakeholders and coordinating production releases and scheduled maintenance activities
• Induced an innovation culture across teams, resulting in excess of $3M savings in operational, Compute and Storage expenses
• Implemented Zero Sign-on using OID, integrated with MS Active Directory
• Configured Parallel Concurrent processing (PCP) for HA and performance
• Upgrade database SQL Server 2012 to SQL Server 2014
• Configure MS SQL Server LOG Shipping and Mirroring.
• Configure secure data transfer using SSL s
• Setup Replication from Oracle DB to MS Sql server DB using Oracle GoldenGate
• Developed a procedure to provide report and maintaining records for sox compliances and coordinated Audits
• Increased Application efficiency by adding application nodes as well as OC4J instances
• Worked on project to Migrate a Oracle database to MS-SQL server database.
• In-depth knowledge of E-Business Suite 11i and R12 architecture
• EBS Configuration such as Profiles, Responsibility, Menus, Custom Top and hardwares (Printers etc)
• Streamlined EBS cloning and patching using shell
• Perform troubleshooting for Forms, Reports, Discover, Workflow manager and Weblogic server
• RAC DBA Activities
• Increased Database performance efficiency using Oracle ASM with RAC and cloning RAC database to single node
• Experience with Real Application Clusters RAC and Automatic Storage Management ASM, RMAN, Oracle Data Guard
• Monitor and troubleshoot RAC database using Oracle Enterprise Manager 12c cloud control
• Migrated Production Non RAC database(ie raw devices) to RAC using RMAN.
• Troubleshoot various RAC wait event issue in Production environment using EM, AWR, ASH and V$ tables
• Troubleshoot corruption issue in RAC database for datafile and ASM's voting disk and OCR

Oracle, SQL Server and Sybase DBA

Confidential

Responsibilities:

• Prepared and implemented project plan for migration from raw device file to 11gR2 ASM using HA Cluster
• Address SQL query performance issues using AWR, ADDM,ASH and SQLT
• Troubleshoot MS-SQL Server performance issue using SSMS, PERFMON and DMV
• Setup Database security using Oracle Database Vault
• Streamline Backup strategy using RMAN tool integrated with Veritas and TSM Tape drive
• Planned process to upgrade 11g database to 12c and evaluate the new feature
• Perform OLTP performance troubleshooting using session trace, EM and tkprof tools
• Worked as team member of Oracle DBA team for the “One Company, One system” project which had an objective to migrate from Mainframes (VSAM & DB2) to Oracle
• Setup and configured Sybase Replication server which was critical for creating business report and conversion of data from DB2 to Sybase which increase productivity of management reporting
• Developed an efficient tool using shell scripting to transfer data from various sources.
• Increased Database stability by monitoring it proactively using shell scripts and Oracle Enterprise Manager
• Guide developers to write properly tuned query to gain throughput and performance and avoid bottlenecks.
• Addressed database corruption issue using DBCC, BCP and backup tools.

Confidential, Washington, DC

Oracle Database Administrator

Responsibilities:

• Performed multiple tasks including administering and tuning databases
• Developed shell scripts for conducting daily load of data in database using BCP utility.
• Maintained active involvement in memory management, I/O, CPU utilization, query optimization, CPU versus I/O load balancing, and network congestion using SQL monitor
• Reconfigured systems parameters such as memory, devices, locks, and cache procedures to improve system performance

Confidential, Sioux City, SD

Sybase Database Administrator

Responsibilities:

• Lead the DB activities related to Confidential conversion and was responsible for meeting the project timelines.
• Architected a custom data conversion solution that helped eliminated manual effort and expedited the overall process resulting in a savings of over $ $350K.

Confidential

Oracle and Sybase Database Administrator

Responsibilities:

• Interact with various officers in Listing department to gather data about listed companies with BSE and developed a data model design and developed a listing software using PowerBuilder.
• This software helped listing department to take some critical decision about companies right thru their desktop.

Confidential

Oracle Database Administrator | Project Lead

Responsibilities:

• Client was a large Steel manufacturer with product lines ranging from Stainless steel sheets and custom forging for auto-manufacturers.
• Played the role of a team lead overseeing a team of 4 and participated in requirements gathering, Data model design and application development.