Oracle certified Oracle Applications Database Administrator with Over 15 years of hands on experience with demonstrated successes designing and implementing database solutions that improve business functionality. Specializing in Oracle Fusion 11g, Oracle Database Administration, 11i/R12/E-Business Suite Implementations, and Upgrades with specific focus on architectural design, platform migration, and automated/web based pro-active solutions.

HIGHLIGHTS

• Over 15 years experience as an Oracle Applications Database 11.x to 7.x , E-Business Suite Applications Administration R12.x,11i,11.0.x , Oracle Fusion Administrator 11g, 10gAS, 9iAS , Oracle Identity management, OID/OAM/SSO 11g, 10g, Technical Support, Database Design and Software Development, Oracle Replication, Monitoring and Tuning, Backup and Disaster Recovery.
• Hands on expertise includes cross-platform projects,11i/R12 ERP Implementations, data backup/recovery, database and application performance tuning, disk layout planning, and high availability planning installing, capacity planning and configuring hardware/OS and Oracle databases tools per the organizational requirements.
• PL/SQL, C, Pro C, SQL Plus, Unix Shell Scripts under SUN Solaris, HP/UNIX, AIX and Microsoft Windows environments
• Proven track record of hiring, training, and leading successful teams of database administrators.
• Soft skills include strong communication, documentation, support skills with technical and non-technical users, troubleshooting problem solving.
• Resourceful and flexible coordinator with superb organization in fast-paced DBA settings.

Technical Experience

• Oracle Application Releases Oracle Applications 10.7, 11.0.3, 11i, R12
• Oracle Application Modules Oracle Financials, Human resources, Order management, Payables, Purchasing, Receivables, Inventory, Service, Customer support, Advanced supply chain planning, Self service web applications, iPayment, iStore, Install base, Quoting, Sales online, Oracle Applications Server Products iAS Family.
• Oracle databases 8.0.5.x, 8.0.6.x, 8.1.6.x, 8.1.7.x, 9i, 10g and 11g
• Oracle Application Servers Fusion 11g, 10gAS, 9iAS
• Oracle Identity Management 11g, 11.1.5.1 , 10g
• Operating Systems Solaris Operating system SPARC , Linux x86, HP Tru64 UNIX, IBM S/390 Based Linux, AIX Based systems, Microsoft Windows NT Servers
• Hardware Linux Dell Power Edge Servers, Sun Microsystems SunFire Servers

PROFESSIONAL EXPERIENCE:

Sr. Fusion/Oracle Applications server DBA Confidential

• Planned, executed and monitored number of projects for Forest Service NRM Natural Resource Management Application on Oracle Fusion Middleware 11g integrated with, OID, OSSO/OAM, Netegrity Siteminder and ESRI products.
• o Upgrade NRM applications from 10gAS 10.1.2.x 10.1.3.x to Fusion 11g 11.1.1.6/11.1.2
• o Upgrade OID/SSO from 10g to Fusion 11g
• o Migrated NRM application from software to hardware load balancer
• o Migrated production and non production Application server from Sun 68000 to M5000 servers.
• o Annual DR recovery exercise to COOP Site
• o Migration of single non production environment to multimode load balanced environments.
• Documented lessons learned and added to knowledge base.
• Supported training environments for Forest Service University program
• Trained other DBAs in the group on 10g Application server/ 11g Fusion
• Coordinated with Development and Testing teams for successful deployment releases.

Confidential

Sr. Oracle Applications DBA-

• Core Services Corporation provides end-to-end Oracle Applications Solutions by providing Oracle hosting, Oracle outsourcing and Oracle consulting. As a Senior Apps DBA, I delivered post-sales database and applications support to Oracle customer base while serving as an advocate for the customer needs. This involves working closely with the client to understand and manage their applications with expectations.
• As a lead Oracle Applications DBA my duties and responsibilities included but not limited to,
• Lead a team of over 15 DBAs and serving as DBA expert.
• Mentored 6 recent graduates to junior DBA positions in under 6 months
• Manage vendor relations work with cross functional teams like Unix administrator, development teams, Network team and functional teams.
• Develop and implement maintenance procedures and provided recovery options for critical path items for e-Business Suite Application version R12,11i, and 11.0.3
• Provided early forecast capacity for management and recommend upgrades and patches.
• Serve pro active role for prevention, detection, identification, and resolution of technical issues in the hosted and outsourced environment.
• Lead the upgrades of Oracle applications from different releases and versions. The latest upgrades were from 11.5.10.2 to 12.0.4 and then to 12.0.6 and also upgraded 11.5.9 to R12 version 12.1.1.
• Lead the database upgrades from different releases, 8i to 9i, 9i to 10g, 9i to 11g and 10g to 11g and version upgrades by applying the latest patchsets.
• Installation of 11i and R12 applications and databases.
• Enabling SSL on 11i applications and 10gAS using openssl and wallet managers.
• Installation of 10g AS for portal, discoverer using different topologies as per the business requirements
• Integration of 10gAS with 11i to enable Single Sign-on and Portal
• Implemented SSO with 11i e-Business suite and Microsoft Active Directory for couple of clients
• Installed and configured Enterprise Performance Management Hyperion Application 11.1.1.3 for various modules. FDM, HFM, ESSBASE, Planning, Financial Reporting

Sr. Oracle Applications DBA--

• Oracle database and applications 11.0.3, and 11i applications administration, support and maintenance
• Installations of Oracle9i,10g, Oracle Applications R12,11i,11.0.3, and Sizing/Capacity Planning efforts for the Oracle Database and Applications
• Upgrading the database from prior version to latest certified versions including 8.0.6, 8i, 9i from and to 10g
• Upgrading Application from 11.0.x to 11.5.x
• Migrating Oracle Application Production environment from another ASP to Core Services
• Migrating Application 11i across different OS platforms like from HP UX and Solaris to Linux.
• Configuring shared application file systems. Have configured multiple applications using shared APPL TOP, shared application file system concepts and F5 load balancers
• Configured Oracle 11i and R12 application modules in DMZ like SSHR, iRecruitment, iStore
• Load balancing Oracle applications by splitting single node application instance into multi node with Database server, Concurrent managers, reports server on one node and forms server and apache on a different node
• Installed Advanced Planning and Scheduling APS instance and did the necessary configuration to make the data collections work effectively
• Upgrading Discoverer from 4i to 10g.
• Troubleshooting the performance issue with 11i Applications and database.
• Design and implementation of Backup Recovery using RMAN and SQL scripts.
• Setting up Standby Database / Disaster recovery Instances to protect against failures. Configured the Standby Database in such a way that the database is kept synchronized with the Production Database by regularly transferring archived log files from the Production Server to the Standby Database Server
• Working closely with development team to facilitate the customizations, interfaces, printer drivers, data loading, and conversions.
• Integration of Custom Applications, database objects, and application files
• Working closely with the application development team for the Bug Fixes and Escalation, Application performance tuning using Parallel Query and table partitioning
• Tuning of Concurrent managers, database server
• Documentation
• Applying Patches, Maintenance Pack and Developer Patch set
• Disk layouts for physical and logical database using raw partitioning, Quick I/O considering RAID striping and mirroring.

Sr. Oracle Applications DBA- Confidential

• Key role in upgrading database and migrating oracle application from various clients to Hostcentric
• Worked closely with the application development team for the Bug Fixes and Escalation, Application performance tuning using Parallel Query and table partitioning.
• Setting up Concurrent Managers, Report Review Agent, ADI, Workflow.
• Teamed in supporting Oracle istore Application integrated with 11.0.3
• Integrated Custom Applications, database objects, and application files.
• Installed Oracle8 Server 8.0.x, 8.1.x and Oracle Applications 11i 11.5.8/7/4/3/2/1 ,11.0.3

Oracle Applications DBA-- Confidential

• Installed Oracle8 Server 8.0.5.0.0 and Oracle Applications 11i,11.0.3 and Sizing/Capacity Planning efforts for the Oracle Database and Applications
• Implemented comprehensive Backup/Restore mechanism using Legato Backup Utility.
• Installed and Configured Oracle Web Application Server 3.0.2 and Oracle Developer 2000 Server 1.6.1
• Integrated Custom Applications, database objects, and application files
• Tuned Concurrent managers, database server
• Documentation
• Applied the Interoperability Patches, Oracle Applications 11i,R11.0.3 Maintenance Pack and D2K Patch set

Oracle DBA -- Confidential

• Worked as Database Administration for all the ORACLE Databases.
• Installed ORACLE RDBMS and Application Tools on various OS platforms including UNIX and Windows.
• Involved in consulting on System configuration and design for various ORACLE Strategies.
• Responsible for Performance tuning and Performance/Query Optimization-Database Structuring Strategies and Procedures for Optimum Database performance.
• Conducted training on Database Administration, ORACLE internals, architecture, Application Tools and latest ORACLE technologies

Confidential The project involved Analysis, Design, Testing, User training, Implementation and production support of the BOM for the Office Furniture system Division the company. The work involved study of 'as-is' processes, collecting software requirements specifications, preparing test plans and carrying out testing, debugging, setting up the masters