SUMMARY:

• Enterprise Resource Planning ~ Systems Analysis ~ Database Administration
• Dynamic, results oriented Oracle Applications Expert with 20+ years of proven success in leading, hands on dba work and delivering medium / large - scale projects on time and within budget. Sophisticated hands-on technical leader with in-depth knowledge, experience in Oracle ERP, and DBA applications. Excellent problem solver with strong analytical skills and superb decision-making abilities. Consummate professional who thrives in high-pressure, rapidly changing environments. Outstanding communicator; effectively bridge the gap between business and technology teams. Enterprise IT infrastructure expert with strong aptitude for learning new technologies quickly; additionally proficient in:
• DBA Lead activities Manage Release activities On-shore/Off-shore activities
• Change Management Strategic Planning RAC Implementation
• UNIX Shell Scripting Database Upgrades SQL Performance Tuning SOA Admin OEM Grid / Data Guard Hands on DBA activities
• Oracle Application Servers RMAN Backup/Recovery Prod support lead

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications (11.0.2, 11.5.1 - 11.5.10 , 12.1.3)

Databases: Oracle 5, 6, 7.x, 8.x, 8i, 9i, 10g, 11gR2

Technical: Database and System Administration, Application Object Library, Flex fields, Oracle Web Application Server, 9iAS, OAM, Platinum 3.1-5.1, Oracle Framework (5.7, 5.10), Autoconfig, OAM, OEM

Modules: HRMS, SCM, Financials, Manufacturing, Order Management, CRM modules, Self Service Web applications, Workflow

Operating Systems: Linux, Sun Solaris, HP, Windows (95/98/2000), AIX

Front End Tools: Forms, Reports, Discoverer, FrameworkOracle Related Software: Vertex (for HRMS US legislations), Statspack

Software Languages: SQL, SQL*PLUS, PL/SQL, SQL Developer

Other Systems / iAS / Tools: HP PPM, Kintana, Demantra, GRC, SOA, SQL*Loader, TOAD, MS Office Suite, AIM, Data Loader, SharePoint, WebLogic, Apache

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Applications DBA / Architect

Responsibilities:

• Upgraded Oracle E-Business suite 12.2.5 from 11i (11.5.10) on Exadata RAC system
• Implemented: adop (new edition based patching system)
• Cloned Oracle E-Business 12.2.5
• Implementation of OBIEE: Convered 11i Discoverer logic to 11g RPD using DOMA, OBIEE 12c Install, upgrade, configure
• Installed WLS 10g, 12c, FMW
• Implemented integration of Oracle E-Business 12.2.5 and OBIEE 12c
• Implemented securtiy: roles and resposibilites for OBIEE
• Support of EBS 12.2.5 upgrade from 11i
• Support OBIEE 11g and 12c testers, developers, and other users community
• Linux administration
• Prepared and reviewed STIGs for OBIEE

Confidential

Senior Oracle Applications DBA / Architect

Responsibilities:

• Working on implementation of Financials, HRMS on 12.2.3, 12.2.4
• DBA liaison for client and Oracle on-demand activities; Work closely with SDMs of OOD
• Provide efficient solutions in managed environment; Knowledge transfer to client
• Lead DBA activities, production release activities
• Manage overall strategic vision and integrate a broad range of ideas regarding database analysis and development.
• Plan and monitor assigned projects and communicate project progress

Confidential

Oracle Applications Lead DBA / Release Manager

Responsibilities:

• Lead projects viz., 11.5.8 to 11.5.10 upgrade, GRC implementation, Demantra implementation, Moving HR from 11i to R12
• DBA liaison for on-shore / off shore activities; coach / mentor dbas on / off shore; Orientation; ; Knowledge transfer
• Lead DBA activities, production release activities
• Release manager activities: conduct / lead quarterly releases for 11i / R12 instances for database upgrades, database security patches, apps patches, promoting HP PPM’s packages on: development, test, patch, SIT, UAT, performance, and production instances
• Constant interaction with change control team on release activities
• Lead projects viz., 11.5.8 to 11.5.10 upgrade, GRC, Demantra, moving HR from11i to R12
• Lead on migrate 11gR2 instances from Oracle Linux 5 to AIX 7.1
• Lead on performance tuning
• Constant knowledge transfer to DBA team on technical changes
• Constant knowledge transfer to management on system changes
• Continued interaction with help desk team leads on improving customer support for technical solutions
• Continued interaction with QA team lead in assuring good performance tests
• Performed rman backups, recoveries and duplications.
• Lead workflow admin activities and resolve OTL issues
• Lead 24/7 support of ALL production Oracle apps (11i,R12) non-apps (local grown) instances
• Constant interaction with change control team on release activities
• Maintain release track instances: development, test, patch, SIT, UAT, performance instances
• Conduct release meetings
• Conduct weekly meetings on 11i R12 issues / help desk tickets
• Install, Clone, Patch R12 Oracle RAC Non-RAC application instances
• Technical documentation on installation / Strategic planning / Topology and various issues resolved; Help Sutherland helpdesk team in building knowledge base documents
• Constant interaction with Oracle accounts manager / support on various issues
• Co-ordination with Security team on auditing and security compliance

Confidential

Sr. Oracle Apps DBA

Responsibilities:

• Production support lead for Oracle applications (Financials, HRMS, HTML applications - SSWA)
• Break fix of production issues
• Maintaining application servers (powered by Apache) for several Oracle instances
• Patching of applications (one-off, patch-set, mini pack, maintenance release)
• Cloning (Multi-node to Single-node; Multi-to-Multi node) and its related issues
• Supporting family pack patching, release upgrade and its related issues
• Processes streamlining (JavaMailer, Concurrent Managers, Autoconfig, GSM, OAM, HTTP Load Balancer, PJC Jspell, ADI WebADI )
• Regular monitoring of production with respect to various resources and performance
• Backup, restore and recovery of production database
• Knowledge sharing, educating established process / procedures
• Constant support to local dbas, developers, business users on many application related issues
• Working with Oracle support in resolving various ‘Service Requests’
• Documentation of the established processes

Confidential

Oracle Apps DBA / Database Supervisor

Environment: AIX, Windows, Oracle applications (11.5.7, 11.5.10)

Responsibilities:

• Providing complete support to clients production, test and development 11i application instances
• Implementation and administration of all internal and external applications
• Supported Oracle Financials (GL, AP, AR), Oracle HTML applications - SSWA modules
• Supported Oracle manufacturing modules (Discreet Mfg./Inventory/Order Entry/Product Hub/WMS)
• Managed multiple instances; cloning production instance every weekend (Multi-node to Single-node; Multi-to-Multi node)
• Monitored Day-to-day support to the development activities
• Interaction with Oracle support in regard with resolving issues (TAR related)
• Supervised all Oracle and Application Servers
• Providing an instance (Installing or Cloning) on Linux on a regular weekly / fortnightly basis
• Designed and supervised sandbox for testing and development
• Supported the maintenance activities (system backups, patching, compiling forms, reports and other related)
• Lead / Support on-line and offshore community of DBAs / developers / users
• Troubleshooting issues on a daily basis
• Supported Oracle upgrade 11.5.3 - 11.5.9
• Primary role was to help build up and upgrade the test instances before going onto production instance
• Knowledge Transfer
• Designed and documented hardware configurations
• Co-ordination of meetings, seminars, and conferences
• Honoring Sarbanes-Oxley
• Excellent verbal, written, presentation and client relationship skills
• Supervised a team of 8 DBAs / developers
• Mentored and trained DBAs

Confidential, OH

Oracle Apps DBA / Database Supervisor

Environment: AIX, Sun Solaris, HP Unix, Linux, and Windows NT; Oracle application (11.5.7 - 11.5.9 ) dB Professionals, IL

Responsibilities:

• Supervised team of 3 DBAs / developers
• Trained and mentored DBAs
• Remote administration of Oracle application servers
• Upgrading applications from 11.5.8 to 11.5.9
• Installation and Configuration of Oracle Applications 11.5.8 on multi-node
• Worked extensively in different modules like OM, AR, AP, PO, FA, GL and HRMS
• Identify existing problems and resolve them through necessary actions and with help of Oracle support
• Wrote Unix shell Scripting for batch jobs
• Oracle applications administration includes user setup, printer setup, menu changes, custom responsibilities registration
• Monitoring applications 24/7 through customized scripts and Oracle Applications Manager.
• Supporting user community 24/7
• Troubleshooting Oracle Applications using TAR and Oracle Support for the same.
• Patch management-administered patches for bug fixing, performance, upgrade and other related issues
• Testing and analyzing Oracle Applications environment after patch application.
• Coordinate change control meetings.
• Lead QA efforts before any move into production.
• Coordination with data center, development team and operations team.

Confidential, Redwood Shores, CA

Senior Consultant

Environment: Linux, and Windows NT; Oracle application (11.5.8 - 11.5.9 )

Responsibilities:

• Oracle applications installations (11.5.2 - 11.5.8 ), setup, maintenance, support, performance tuning and troubleshooting of Oracle Applications Database, HTTP server (Web/Apache Server), Discoverer, Fulfillment server setup, maintenance, support, performance-tuning and troubleshooting. Extensive on-line and off-line application support to 75 technical, functional consultants, and general users
• Support the instance all the way through the implementation of the business flow
• Supported 32 business flows for which installed and maintained nearly 50 instances
• Worked on the internal implementation of the following business flows which are published in metalink.oracle.com and supported by Oracle are Accounting to Financial Reports, Call to Resolution, Click to Resolution, Contract to Renewal, Dispatch to Repair, Depot to Repair, Order to Cash, and Procure to Pay to name a few
• Major modules involved in the project were GL, AP, AR, FA, INV, OM, WSH, PO, PA, HR, MRP, INV, WIP, BOM, CRM BFA modules, People-to-Paycheck (part of HRMS)
• Set-up an Oracle application instance fresh and vision, for each of the business flow on request basis.
• Perform a general check list (technical: database up and running, Apache, forms, Report review agent FNDFS, CCM running, patch levels) on each instance
• Cloning of instances using various methods like adclone, rapid clone, traditional instance copying
• Applying patches, setup profiles, validation of objects, and building any new Jinitiator, request jobs to purge data, Discoverer setup, load seed data
• Backup and maintenance of the systems (Hot, cold, RMAN); Compiling forms and reports depending on issue or situation
• Multi-node installation on HP and Sun systems. Implementation of flows, Technical documentation
• Wrote Unix shell scripting for batch Jobs
• Coached and mentored team members/management on implementation issues
• Handled day-to-day apps DBA activities using Oracle application utilities and tools (adadmin, adpatch.. OAM)
• Installation and configuration of development test and production instances for Oracle Applications.
• Worked closely with clients functional and development team during the implementation
• Configured and worked with forms server, web server, Apache Server, Oracle Alerts, Workflow, OAM and Discoverer
• Assist developers in application tuning and performance improvement
• Managed backup schedules using RMAN and Unix Script
• Check alert logs, archive logs and backup verifications
• Monitored space and memory requirements on a regular basis to increase productivity and avoid problems
• Perform database monitoring, tuning and maintenance. Develop and set-up automated database monitoring scripts.
• Configure the concurrent managers and transaction managers and set-up system profiles
• Troubleshooting Oracle applications and database issues using TAR and Oracle Metalink for the same
• Administered patches for bug fixing and upgrade and bug fixing and timely issue resolution
• Archiving and purging old data from Oracle Applications 11i
• Defined and implemented various alerts for the system performance
• Database upgrades from 8.1.6 to 8.1.7 and 8i to 9i
• Provide 24x7 support to user / development community
• Knowledge Transfer

Confidential, Oakbrook, IL

Senior Oracle DBA, Consultant

Environment: Sun Solaris, HP Unix, Linux, Windows-NT; Oracle applications (11.0.2, 11.5.2 - 11.5.9 ); ERP financials / CRM, Self Service Web apps, iStore, iProcurement, call-to-order, click-to-order, people-to-paycheck, Discoverer, OAM, HR - Vertex

Responsibilities:

• Database Conversion and technical support was the main purpose of the project.
• Conversion of an Oracle based customer information database from Novell NetWare 3.11 to WINDOWS NT 4.0, and from Oracle 6.0 to 7.3.3 Enterprise Version
• Utilized Forms 4.5 and Developer 2000 for the conversion and generation process
• Compiled and debugged the Pro*COBOL programs, utilizing Micro-focus COBOL and the Pro*COBOL pre-compiler
• Proactive plan to support Oracle products at each assigned customer site
• Created new users and roles for the four applications in the new Windows NT environment and wrote all the necessary documentation
• Provided a complete backup and recovery plan for the production database
• TAR maintenance

Confidential, Sunnyvale, CA

Senior Oracle DBA, Consultant

Environment: Toad, Oracle internal switch tools, Oracle8i, Sun Solaris, AIX

• Database Conversion and technical support was the main purpose of the project.
• Provided technical help and support to Andersen consulting agency.
• Provided space management installation, performance tuning, troubleshooting, security management, and documentation of the 128 GB Oracle 7.3 database
• Data loading monitoring
• Developed backup and recovery strategy and procedure
• User creation, profile maintenance
• Multiple instance support
• TAR maintenance
• As a Senior Oracle Database Administrator/Consultant, I provided configuration and support of two production databases: A technical support database and a human resources database running under PEOPLESOFT.
• Installed and maintained software, and provided performance tuning and security management, including setting up users and defining access privileges.
• The technical environment consisted of Oracle Databases, WINDOWS NT Servers and workstations, and SQL*Plus, PL/SQL, SQL*Net, Enterprise Tools and SQR.
• Provided configuration and support of two production databases: A technical support database and a human resources database running under PEOPLESOFT.
• Developing a migration strategy for replacement server equipment.
• Designing and implementing procedures for backup, archival and disaster recovery.
• Regularly exporting information from production databases to testing and databases. Trained client staff on database administration procedures.
• Installing software and setting up databases on an AIX server. Communicating with vendors, including Confidential, to resolve any client/server or database problems.

Confidential, Cyprus, CA

IT Dept Manager / Senior Oracle DBA

Environment: Platinum DBA tools, Toad, Oracle8, Sun Solaris, AIX, and Windows-NT

Responsibilities:

• Managed and supervised a team of 12 dbas / developers / instructors
• Database development, conversion, and technical support to different projects including hospital, material, transport, and library management systems.
• Participated in the development of the system
• Assisted with initial case study, installed systems, required software, maintained software and established connections.
• Created the database and perform administration duties, including configuration, performance tuning, security management, backups, recovery planning and of client staff
• User creation, profile maintenance
• As a programmer Analyst for the institute affiliated to a major common wealth university, developed and administered a variety of database applications, including a Student Management System and a Financial Accounting System. These applications were written using Oracle 6.0 and 7.1 under SCO UNIX, NetWare, WINDOWS 3.x and MS DOS
• Web site of the VSPGS: www.vspgs.com database development, conversion, and technical support for different projects including hospital, material, transport, and library management systems