SUMMARY

• 21+ years of IT technocrat experience as Sr. Apps DBA, DB Architect, DBA Manager, Systems Analyst, Designer and Developer & Programmer and 4 years as Industrial Engineer.
• Performed hardware & software requirements analysis, capacity planning, installation & configuration, maintenance, upgrades of various Oracle E - Business suites, Databases servers & software.
• Involved in various phases of product development and system development life cycle (SDLC). Performed Requirements Analysis, Data Modeling/Architecture, Design, Development, Implementation, Integration, Testing and Maintenance. Used UML & ERWIN for modeling
• Fresh installation and setup of Oracle 11g databases on 2 node and 4 node RAC servers
• Setup standby database using Oracle Data Guard for 9i/10g and 11g databases
• Supported multiple clients, onsite, offshore & remote Oracle 12c/11g/10g/9i/8i/7x/6x, MySQL, Sql Server 2000/2005/2008 & Informix 7.3/7.0/5.0 databases in Production, Development & Testing environments on various platforms and operating systems.
• Performed backups, restore and recovery of multi Terabyte Databases using RMAN to tape, disks & data domain library and a various
• Installed and implemented oracle 9i OEM, Oracle 10g/11g Grid for monitoring.
• Implemented Oracle Partitioning, Advance Queuing, Oracle Streams/Replication.
• Experience with Oracle 10g,11g Oracle 12c, RAC, ASM, Oracle Clusters, Grid Infrastructure
• Setup multiple databases on Sun hardware using VERITAS cluster ware, HP Superdomes, AIX server and Windows servers.
• Upgraded Oracle EBS from .1.1, databases from 9i to Oracle 10g/11g. MS Sql server from
• Migrated standalone databases to VMs & installed in Biz-cloud/Private and public clouds
• Setup oracle physical standby database using Oracle 9i/10g/11g data guard for Disaster Recovery (DR)
• Experience with EMC SAN, NAS storage, Veritas clusters and BCV split High Availability (HA) technologies
• Worked with Managed care, Hosted & SaaS Applications
• Extensive Working Knowledge on Oracle Exadata

TECHNICAL SKILLS

Cloud App & Services: Private cloud, business and public cloud environments, HP-SaaS, ServiceNow SaaS, Amazon web services (AWS), virtualization, cloud migrations & Confidential bizcloud

Hardware: Cisco UCS, VMware, Oracle Virtual Box, Oracle Linux, SUN Clustered servers, SUN Enterprise & Midrange servers, HP L2000, 9000 Superdome series, HP RP8400 servers, Sequent, IBM AIX 600/700/800 series Servers, AT&T Pyramid, Dell Windows Servers with raid, Gateway ALRs, PCs and compatibles.

Operating Systems&VMs: VMware VSphere, VirtualBox, Oracle Linux 6, RedHat Linux 6.5, Unix, HP-Unix, Solaris 2.3/2.6/8.0, AIX-Unix 4x/5x, SCO Unix, Lynix, Ubuntu, Dynix,VAX/VMS, Windows 8/7/2003/XP/Vista and MVS.

Databases & Software: Oracle 12c/11g/10g RAC, DynamoDB, CouchDB1.3.0, MongoDB, MySQL 5.6, Oracle E-Business Suites (Oracle Financials 12i/11i/11.0.3), Oracle Collaborative Suite,, Oracle GRID, Oracle OEM, SAP R/3, Oracle Application Express server 6.3x/11.58, OFA 6.3x, Oracle database server 12c/11g/10g/6.0/7.x/8i/9i, Discoverer 3.1/4.1 Oracle ADI 7.0, Noetix views, Oracle Application server 3.0/4.0/9ias, Citrix Metaframe 1.8, Terminal server, Oracle webdb/portal 3.0, MS SQLServer 2008/2005, Informix 5.0/7.0/7.3, Watcom SQL, Vax/Rdb, MS Access 2.0, SQL*Forms 2.3/3.0/4.0/4.5 , SQL*Plus 3.0/3.1/8.0, SQL*Reportwriter, PowerBuilder 4.0/5.0, SQL*TextRetrieval 2.0, CASE Dictionary 5.1, SQL*Loader, Transact-SQL, SQL Object Manager, Visual Basic 3.0, FormFlow 2.0, dBase IV, Erwin 2.1/3.0, Remedy, HP Sitescope, Tivoli & BMC Remedy, Service Now

Languages & Utilities: SQL, PL/SQL, T-SQL, UNIX Shell scripts, C/C++, erlang, Java, J2EE, Pro*C, Adpatch, Adconfig, Admerge, Adadmin, Adctrl, Sql loader, Data pump.

PROFESSIONAL EXPERIENCE

Confidential, Leesburg, VA

Lead Apps DBA

Responsibilities:

• Performed Cloning, Patching, Monitoring of E-Business Suite R12.1
• Supporting phase2 development for deploying the HR into production
• Managing the infrastructure vendor support, developing the process improvement for support and incident management.
• Supporting & monitoring Production, Development, UAT, Staging & training Oracle E-Business suite
• Supporting the OBIEE, Hyperion and Fusion middle production, development and testing environment
• Implementing the Oracle enterprise manager/Grid Cloud control for monitoring all the environments.
• Working with vendor to implement hardware load balancing and High availability environment using storage level real time replication.
• Leading the team of DBA & sysadmins

Confidential, Schaumburg, IL

Lead Application Database Admin

Responsibilities:

• Implemented Global ERP environment with Oracle E-Business R12 Suite (12.1) with Single sign on (SSO)/OID, Hyperion, VCP, GRC, Vertex and OBIEE on a 4 node 10g RAC and Apps on VM
• Migrated regional ERPs into Global ERP as part of Company's transformation initiative Implemented Oracle and SQL Server FARMs virtualization and Cloud computing adoption, Oracle ERP R12 upgrade from 11i, R12 Advanced Planning Suite (APS) modules Supply Chain Planning (ASCP), Demantra, Collaborative Planning (CP) and Service Parts Planning (SRP) modules implementation.
• Upgraded 8TB 8i data warehouse database to 9i and migrated to Solaris from HP-UX.
• Installed and supported Development, QA, Go-live efforts for various custom and COTS products
• Enabled Database Vault and other Oracle Advance Security features for SOX compliance & security hardening
• Worked with the team of 13 DBAs to provide oncall support, remote production support and project implementation support for 300+ various Oracle databases, including Oracle 10g RAC, Oracle financials, Manufacturing, Data warehouse instances, VLDBs.
• Implemented & managed disaster recovery environments using technologies like storage replication, Oracle Active Data Guard, Golden Gate & physical standby database.
• Supported business intelligence and reporting tools databases like OBIEE, Informatica, Hyperion, Oracle BI publisher
• Responsibilities included are installations, upgrading, patching, performance tuning and oncall support.
• Outage/crisis management, Root Cause analysis, Problem & change ticket management.
• Mentored offshore and Junior DBAs lead team of Oracle & Sql Server DBAs
• SOX audit process management, Customer & management relations during outage & project implementations
• Implemented HP Outerbay data archive solution and Oracle partitioning
• Different tools used are, Oracle Grid/OEM, Tivoli for enterprise monitoring processes & file systems, Kintana for application code migration, Remedy & BMC for service tickets, AD utilities for patching/maintenance, Netbackup/RMAN/Data Domain for backups and restore, Oracle 11g/10g/9i/8i databases and Oracle E-business suites 12i/11.5.x/11.0.3 on various HP, SUN, Windows and IBM AIX Unix servers. Installed, patched, upgraded and migrated various versions of oracle databases on various platforms including Oracle 11g and Oracle 10g.
• Manage multiple teams of Oracle and SQL Server database administrators
• Manage staff to ensure the pre-defined milestones are reached, aligned the team members to the senior management goals and expectations.
• Conflict resolution between team members so as to maintain a cordial work environment for team members’ productivity.
• Assign tasks to the team members and complex projects to the team leads.
• Manage day to day activities, prepared DBA on call rotation schedules for 24x7 database support
• Develop a process to respond to the crisis and service outage so that service is restored quickly.
• Develop the guidelines for practicing the database standards for installation & managing.
• Lead the team with the goals defined by organization goals and senior management (SLT). Appraise senior management on issues related to support, databases, scheduled changes and outages.
• Mentor offshore, Junior DBAs and provide the leadership and guidance.
• Review performance with the managed service support vendors periodically to ensure smooth operations and maximum service availability for BMC Remedy systems across the IT teams.
• Conduct weekly review meeting with vendors and provide technical guidance for resolving the issue and review the changes/software solutions and approve them as needed
• Worked as interface between customer, business users and technical personal and provided management reports during the SRTs
• Strong project management skills with experience in delivering cloud based solutions
• Worked cross-functionally, globally with multiple vendors and employees in a virtual environment.
• Maintained SLA doc for all the activities performed by the team, collect performance data, analyze and publish