SUMMARY:

• Have more than 27 years of experience as an Oracle DBA, Oracle Applications DBA, Oracle Applications System administrator, Project lead and Technical Manager.
• Manage clients and provide primary and secondary support for their databases and applications
• Manage projects and delegate the work to onshore and offshore teams
• Created and placed policies and procedures
• Implemented projects as project lead
• Mentored team members
• Supported both Production and Development environments.
• Have expert level skills of the following
• Designing, creating and administering large Databases.
• Installing and configuring Oracle on various UNIX platforms such as oracle Exadata, Sun Solaris, Linux, HP - UX, IBM RS6000 (AIX) and SGI-Irix.
• Installing, Upgrading and Migrating oracle software and databases (9i, 10g, 11g)
• Installing and configuring Oracle RAC including oracle cluster, ASM, databases and instances
• Creating and configuring standby databases using Data Guard
• Installing, Upgrading and Maintaining Oracle EBS(11i & R12)
• Installing, Upgrading and Maintaining Oracle RETAIL- RMS, RIB, RPM & ReIM (13.2.6 & 14.0.1)
• Applying patches to Oracle Applications
• Cloning Oracle Applications
• Implementing Backup and Recovery strategy for Oracle databases and Applications
• Monitoring/Tuning Performance
• Installing, configuring, upgrading and maintaining Oracle Fusion Middleware 11gR2 ( Forms, WebTier)
• Installing, configuring, upgrading and maintaining oracle Identity Management 11g ( Oracle Internet Directory - OID, Oracle Access Manager- OAM, WebGate)
• Installing, configuring, upgrading and maintaining oracle application server - OAS 10g (9.0.4.0, 9.0.4.1, 10.1.2.0.2 , 10.1.3.x) including components Internet directory (OID-LDAP), Single Sign On (SSO), HTTP server, Web Cache, Portal, Discoverer, Forms and Reports
• Installing, configuring, upgrading and maintaining oracle portal 10g (9.0.4.0, 9.0.4.1, 10.1.2.0.2 , 10.1.4)
• Installing, configuring, upgrading and maintaining oracle Enterprise manager Grid Control (9i,10g,11g & 12c)
• Installing and configuring Oracle Audit Vault
• Proactively researched and minimized downtime for upgrades and routine maintenance tasks
• Used different oracle and third party tools.

TECHNICAL SKILLS:

Hardware: Oracle Exadata, SUN, IBM RS6000, HP 9000, SGI, ALPHA, DG AViiON RISC System, PC.

Operating Systems: Sun Solaris, UNIX, LINUX, AIX, Irix, WINDOWSSoftware: Oracle (5.x, 6.x, 7.x, 8.x, 8i, 9i,10g, 11g), Oracle Applications (11i,R12), Oracle Application Server(OAS), Oracle Portal, Oracle Enterprise Manager, Other Oracle products..

WORKING EXPERIENCE:

Oracle Applications DBA Consultant

Confidential, Marlborough, MA

Hardware: Exadata(X2,X3&X4), Exalogic

OS: Linux

Software: ORACLE (11g &12c), Oracle EBS (R12, 11i), Weblogic (10.3.6), Oracle RETAIL- RMS, RIB, RPM & ReIM (13.2.6 & 14.0.1), Oracle Fusion Middleware 11gR2 ( Forms, WebTier), Oracle Identity Management 11g ( Oracle Internet Directory - OID, Oracle Access Manager- OAM, WebGate)

Responsibilities:

• Manage projects and provide primary and secondary support for databases and applications
• Manage projects and delegate the work to onshore and offshore teams.
• Analyze, plan and implement the following:
• Upgrade Databases
• Platform migration from HP-UX to Exadata of Oracle EBS application R12 (12.1.3 )
• Installation of Oracle RETAIL- RMS, RIB, RPM & ReIM (13.2.6 & 14.0.1)
• Upgrade of Oracle RETAIL- RMS, RIB, RPM & ReIM from 13.2.6 to 14.0.1)

Oracle Applications DBA Consultant

Confidential, Cambridge, MA

Hardware: Sun servers

OS: Solaris

Software: ORACLE (11g), Oracle EBS (R12, 11i),Oracle Application Server (AS 10g R3)

Responsibilities:

• Oracle EBS application upgrade to R12 (12.1.3 ) from 11i (11.5.10.2)
• Automate and enhance the R12 cloning process

Lead Oracle Applications DBA

Confidential, Marlborough, MA

Hardware: linux (physical & VM), Sun servers

OS: Oracle enterprise linux (OEL), Linux, Solaris

Software: ORACLE (11g, 10g), Oracle EBS (R12, 11i),Oracle Application Server (AS 10g R3)Oracle Portal, Oracle Enterprise Manager and other Oracle products

Responsibilities:

• Manage clients and provide primary and secondary support for their databases and applications
• Manage client requests by collecting client’s requirements and delegating them to offshore team.
• Analyze, plan and implement the following:
• Database upgrades
• EBS (oracle application R12 ) installation
• EBS(oracle application R12 ) upgrade
• Active contributor to the industrialization project

Sr. Oracle DBA

Confidential, Burlington, MA

Hardware: Sun, linux servers and Oracle Exadata

OS: Solaris, Linux

Software: ORACLE (11g and 10g), Oracle Application Server (iAS 10g Release 2)Oracle Portal, Oracle Enterprise Manager and other Oracle products

Responsibilities:

• Install, Upgrade oracle software and databases (10g and 11g)
• Install, configure Oracle RAC including oracle cluster, ASM, databases and instances
• Analyze, plan and implement the following:
• Oracle Application Server 10g (Release 2 and 3)
• Portal 10g ( 10.1.2.0.2 , 10.1.4)
• Oracle enterprise manager grid control (10g)
• Audit vault

Sr. Oracle Applications DBA

Confidential, Lexington, MA

Hardware: Sun and HP servers

OS: Solaris, HP-UX, Linux

Software: ORACLE 10g, Oracle Application Server (iAS 10g Release 2 and 3)Oracle Portal, Oracle Enterprise Manager and other Oracle products

Responsibilities:

• Install, Upgrade oracle software and databases (10g and 11g)
• Install, configure Oracle RAC including oracle cluster, ASM, databases and instances
• Analysis, plan and implement the following:
• Oracle Application Server 10g (Release 2 and 3)
• Portal 10g ( 10.1.2.0.2 , 10.1.4)
• Oracle OIM
• Oracle BI
• Oracle enterprise manager grid control (10g)

Sr. Oracle Applications DBA

Confidential, Waltham, MA

Hardware: Sun and Windows servers

OS: Solaris, Linux, Windows

Software: ORACLE 10g,9i,8i, Oracle Applications (11i), Oracle Application Server (iAS 10g)Oracle Portal, Oracle Enterprise Manager and other Oracle products

Responsibilities:

• Managed seven clients and provided primary support for their databases and applications
• Reasearched, planned and performd the following projects:
• Database upgrades
• EBS(ORACLE application 11i ) upgrades
• ORACLE Application Server upgrades

Sr. Oracle Applications DBA & System Administrator

Confidential, Marlborough, MA

Hardware: Sun and Windows servers

OS: Solaris, Linux, Windows 2000

Software: ORACLE 10g, 9i, 8i, Oracle Applications 11i, Oracle Application Server (iAS 10g)Oracle Portal, Oracle Enterprise Manager and other Oracle products

Responsibilities:

• Analyze, Plan and Upgrade Applications from 11.5.9 to 11.5.10.2 in a multi-node environment:
• Analyze, Plan and Upgrade Applications from 11.5.4 to 11.5.9 in a multi-node environment:
• Researched the patches required prior and after the upgrade to 11.5.9
• Researched the technology upgrade required for the applications upgrade
• Planned and laid out the upgrade path
• Upgraded the applications to 11.5.9 with the necessary patches and technology stack upgrades along with the necessary manual operations minimizing downtime.
• Documented the upgrade according to internal standards.
• Migrate and configure to AutoConfig environment from non-AutoConfig environment
• Analyze, plan and implement the following by applying patches and appropriate configuration:
• Rapid Clone
• GSM/PCP
• Oracle Application Manager (OAM)
• Analyze, plan and implement the following: iAS 10g (9.0.4.0, 9.0.4.1, 10.1.2.0.2 )
• Portal 10g (9.0.4.0, 9.0.4.1, 10.1.2.0.2 , 10.1.4)
• ILearning
• Upgrade Application Server (iAS) and Portal from 9.0.4.1 to 10.1.2.0.2
• Upgrade Portal from 9.0.4.1 to 10.1.2.0.2 and then to 10.1.4
• Analyze, Plan and application of HRMS family Pack C1
• Analyze, Plan and application of Financials Family Pack C
• Implement Oracle Internet Expenses (OIE)
• Implement Oracle Enterprise Manager (OEM) Versions 2.2, 9.2 and 10g (10.2.0.1.0 ) Grid Control
• Tune applications databases and improve performance.
• Clone production system to different development, test and patch systems

Sr. Oracle Applications DBA

Confidential, Boston, MA

Hardware: HP servers

OS: HP-UX, Windows 2000

Software: ORACLE 9i, 8i, Oracle Applications 11i, Oracle Enterprise Manager

Responsibilities:

• Analyze, Plan and Upgrade Applications from 11.5.3 to 11.5.7 with multi languages in a multi-node environment:
• Researched the patches required prior and after the upgrade to 11.5.7
• Researched the technology upgrade required for the applications upgrade
• Researched the set up of three additional languages: Latin American Spanish, Brazilian Portuguese and. Canadian French
• Planned and laid out the upgrade path
• Upgraded the applications to 11.5.7 with the necessary patches and technology stack upgrades along with the necessary manual operations minimizing downtime.
• Documented the upgrade according to internal standards.
• Analyze, Plan and application of HRMS family Pack C1 on different versions of applications
• Analyze, Plan and application of Financials Family Pack C on different versions of applications
• Clone production system and the standby database to different development and test systems
• Deploy mass code changes to production and non-production systems

Sr. Oracle Applications DBA & System Administrator

Confidential, Needham, MA

Hardware: Sun servers, NT servers

OS: Sun Solaris, Windows 2000

Software: ORACLE 9i, 8i, Oracle Applications 11i, Oracle Enterprise Manager with tuning pack and management pack for applications, Server Manager, PL/SQLNET8 Other Oracle products.

Responsibilities:

• Maintaining all production, test and development application systems
• Installing and Upgrading Oracle applications
• Applying numerous Patches to resolve issues and to enable fast and efficient transactions
• Cloning development and test systems from production on a scheduled and ad-hoc basis
• System Administration
• Creating new responsibilities.
• Modifying existing responsibilities
• Creating new users and assigning appropriate responsibilities to them
• Modifying Menus
• Registering executables, programs and reports and assigning them to request groups enabling access to user groups.
• Modifying profile settings at site and user levels.
• Configuring Printers
• Administer database
• Modify init.ora and config.ora parameter files
• Create tablespaces, datafiles, control files, redo logs and rollbacksegments
• Create users and roles
• Assign proper privileges to users and roles.
• Create database objects like tables, views, sequences, synonyms, database links, triggers, stored procedures, stored functions and packages
• Plan and implement the backup and recovery methods
• Monitor and tune the performance using tools Enterprise manager management pack for applications, Enterprise manager tuning pack, utilestat/utilbstat, explain plan, SQL Trace and TKPROF, SQL Analyze, expert and more.
• Refresh the Development and test server with production server data

Sr. Oracle DBA

Confidential, Lexington, MA

Hardware: Sun servers, NT servers

OS: Sun Solaris, Windows NT

Software: ORACLE 8i, Oracle Enterprise Manager with tuning pack and change management pack, Server Manager, PL/SQL, NET8 and

Responsibilities:

• Installation of Oracle software and creating databases
• Administer database
• Plan and implement the backup and recovery methods
• Monitor and tune the performance using tools Enterprise manager tuning pack,, utilestat/utilbstat, explain plan, SQL Trace and TKPROF, SQL Analyze, expert and more.