Summary

Highly-accomplished IT leader experienced in databases architecture designing roadmap implementation business intelligence IT operations enterprise IT system management IT project management E-commerce applications Oracle fusion middleware EDI and cloud computing. Proven track record in defining and optimizing technology strategies processes and resource planning to improve operational efficiency reduce costs and to achieve bottom-line results.

Work Experience

Manager IT Operations Confidential

Roles and Responsibilities

Managed all aspects of the global IT operations ensuring 24/7 stability of ATD s enterprise business systems including Oracle e-business Suite applications Oracle RAC based databases Microsoft SQL databases Microsoft BI stack SSAS SSIS SSRS and DW E-commerce applications and electronic data interchange. Coordinated technical requirement analysis evaluation development applications integration application performance testing and production implementation of applications and system enhancements. Led a team of over 15 technologists consisting of database E-commerce Middleware and EDI administrators with four of them based in India providing of f shore support.

Professional Highlights

Managed production Oracle ERP e-business Suite applications system consisting of 9 applications and 7 database nodes RAC .

Provided a stable and well performing oracle ERP production environment supporting over 109 distribution centers in 42 states and in Canada.

Improved operational performance of ad-hoc user queries sales pricing and products reports by optimizing the BI infrastructure database and application code.

Ensured oracle applications and databases performance within the defined SLAs by pro-active monitoring and tuning of concurrent programs and top SQL.

Played a key role in the architecture design and review of oracle e-commerce and fusion middleware based applications and technologies.

Instilled the SDLC methodology by leading the project to create development QA and UAT environments for all oracle and e-commerce applications.

Created IT processes to coordinate and support the development QA and user acceptance of oracle concurrent programs and applications including supply chain warehouse shipping MRP AR GL AP orders and invoicing .

Managed over 200 production and non-production Oracle MYSQL and MS SQL databases with the largest being 8TB oracle database.

Successfully created and implemented production databases backup plan using

Netback/data domain utilities.

Implemented enterprise data archiving and purging Solix tool to comply with the data retention policy and to manage the production database growth.

Implemented processes to purge oracle applications interface log and temp tables for better application performance.

Coordinated cross-functional IT projects to conduct new oracle applications performance testing using HP load Runner and Dynatrace APM .

Setup the 12c Oracle Enterprise manager OEM to enhance databases management monitoring and troubleshooting capabilities.

Implemented India based off-shore technical support solution for 24 by 7 support coverage saving 200K annually.

Spearheaded the project to implement Oracle streams and Golden Gate for real time business data replication to oracle fusion middleware and e-commerce applications.

Developed processes to clone production to non-production environments using RMAN duplicate and backup/restore methods supporting application development and testing.

Architected high availability solution for mission critical oracle based systems using oracle data guard and EMC snapshot technology.

Supervised Oracle databases server virtualization effort to migrate to HP blades running VMware.

Managed the project plan to upgrade Oracle databases to 11GR2 and MS SQL to 2008R2 and 2012 Denali .

Provided operational support and leadership to migrate production and non-production oracle databases to Exadata platform.

Headed operational planning and coordination to support Oracle EBS applications upgrade from 11i to R12.

Conducted performance appraisals delegation of work assignments recruitment development retention and organization of staff in accordance with budgetary objectives and personnel policies.

Led weekly production change review planning and coordination meeting.

Implemented system documentation policy and process for information sharing and training purposes using confluence and SharePoint.

Section Manager- Infrastructure Division

Confidential

Roles and Responsibilities

Managed a team of database and oracle fusion middleware administrators ensuring 24/7 availability stability and optimum performance of application databases. Conducted performance appraisals delegation of work assignments and recruitment.

Professional Highlights

Implemented DBA on-call rotation support program to ensure 24/7 support availability.

Provided technical and project leadership in the Oracle databases upgrade project Oracle portal and upgrade of J2EE applications.

Performed technical management to implement Oracle identity management Oracle access manager OAM and JBoss enterprise application server.

Implemented Oracle licensing management application to track licensing footprint and reducing cost by optimizing oracle software usage.

Supervised the infrastructure project to upgrade Oracle RAC based SAP ERP system to Oracle 10g database.

Coordinated implementation of data domain to streamline backups and reduce storage footprint.

Served as a mentor to district employees for career guidance and development.

Senior Database Administrator

Confidential

Roles and Responsibilities

Responsible for the administration of the Oracle databases hosting asset management work management geographical information system GIS SAP business warehouse and decision support applications. Improved coordination and collaboration between the geographically dispersed Oracle teams to enhance operational efficiency and coordination.

Professional Highlights

• Implemented 8i 10g databases on IBM AIX Unix and windows platforms hosting a wide range of mission critical applications.
• Upgraded mission critical oracle databases to 10g.
• Supported implementation of high availability solution using IBM s high availability cluster multi-processing HACMP and EMC BCV SRDF and data guard.
• Helped implement data security and compliance policies to comply with sarbanes-oxley regulations.
• Implemented IBM Tivoli and 4D for job scheduling monitoring and status escalation.
• Set up standby databases using Data Guard as a disaster recovery solution for business continuity.
• Set up Oracle Enterprise Manager OEM for pro-active database monitoring and administration.

Trained and coached junior DBAs for resource planning and support availability.

Senior Systems Administrator

Confidential

Roles and Responsibilities

Supervised information systems group consisting of Oracle developers application and PC/Network administrators. Performed administration of Just In Time applications hosted on Oracle databases and UNIX platform.

Professional Highlights

Performed system administration duties to ensure stability performance and availability of landing gear and overhaul applications.

Played key role in the implementation of Just in Time landing gear mrp shipping warehouse applications.

Set up and supported various environments including development test qa and staging as per user and SDLC requirements.

Ensured optimum database performance and availability through regular database maintenance and effective monitoring using Unix shell and sql scripts as well as the Oracle enterprise manager OEM .

Set up and maintained standby databases for disaster recovery purposes.

Technical Expertise

Business Intelligence/Reporting SSIS SSAS SSRS DW.

ERP Oracle E-Business 11i/R12 Modules AR GL OM WMS Pricing Inventory Purchasing warehouse/shipping OIC OTM .

E-Commerce B2B B2C LAMP Hybris Celum Endeca SOA and Coherence based enterprise

e-commerce applications.

Middleware Web logic 11g 10g Oracle Application Server 10.1.2.3 Portal 10.1.4 OC4J Forms Reports Discoverer Oracle Identity Management Oracle Access Manger OAM Oracle Identity Manager OIM Oracle Identity Federation OIF Single Sign on SSO JBoss Enterprise Application Server 5.1 SOA OSB Coherence.

Databases RAC/ASM 11GR1/R2 MYSQL Sybase MS SQL Server 2008 2012.

Tools 12c OEM Grid Control Web logic management packs Oracle Configuration Manager OCM Oracle Application Testing Suite Embarcadero DBArtisan Quest Spotlight Toad Dynatrace Application Performance Management BMC Remedy BMC Control-M workload automation JIRA Solix EDMS. SQL developer SQL Sentry Jrocket.

Infrastructure VMware VSphere 5.5 HP Blade g7 Red Hat 5 SRM EMC VNX VMX Data Domain Deduplication. Sun SPARC Enterprise M4000/5000 Sun Fire SPARC V490 Sun Solaris IBM AIX HP-UX.