SUMMARY:

• Three years of experience as Informatica Power Center and Data Warehouse Administrator with experience in Installation, Upgrade & migrations and day - to-day administration activities.
• One year and six months of experience as Oracle Apps DBA with experience in supporting R12 Upgrade.
• Two years of experience as Oracle Hyperion Products administrator.
• One and half years of application development/enhancement experience using MF-Cobol, Oracle PL/SQL and Unix Shell scripting.
• 1 year of Client facing experience at Onsite.
• Over 3 years of team management experience.
• Application stack and Technology stack deep dive and analysis - Identify component dependencies, perform interface and infrastructure analysis, portfolio and document review.
• Capacity planning and tech stack compatibility/ review.
• Analyze and identify areas of improvement and consolidation and design optimum architecture to minimize Operating cost and increase ROI. Document existing and proposed architecture and update portfolio
• Prepare road map for the migration path with less downtime, define milestones, checkpoints keeping in mind the criticality and availability of business and derive execution tasks through work breakdown structure.
• Identify risks and plan for mitigations - Fallback plan.
• Prepare Project plan, execution checklist, arrange kick-off meetings and schedule checkpoint calls and work calls with stakeholders.
• Work allocation and delegation to team, tracking and monitoring.
• Weekly Status reporting with progress against the schedules and identify, report deviations.
• Work with application teams (ranging from Data warehouses and online applications) and Datacenter teams ranging from Storage, Network, OS and Database, acting as a bridge.
• Design and Implementation of high availability, backup & recovery strategy, DR, SSO and SSL.
• Knowledge of various technology stack components, such as Storage, Network, Backup Tools, Firewalls, AD, Operating systems, relational and linear databases and middleware components such as Oracle Fusion middleware.
• Knowledge of MongoDB, basics of Bigdata and Hadoop.
• Provide L3 support in performing RCA for critical issues, and identify proactive ways to avoid recurrence
• Validation/verification of the migration/upgrade.
• Decommission of old environments.
• Capacity Planning, Design and Preparation of environments and Tech Stack Upgrade.
• Installation, patching, Migration and Upgrade of Oracle DBs of version ranging from 9i to 11g.
• Research new features in new releases and implement them. Knowledge of Oracle 12c, Goldengate.
• High availability implementation using OFS, RAC and Data guard.
• Design and Implement Backup and recovery strategies using native backup methods and Oracle RMAN.
• Performance tuning activities - Instance and Code Tuning.
• Develop scripts using SQL, PL/SQL and UNIX shell scripting and Windows Batch scripting to automate daily tasks.
• Installation, Configuration and patching of Informatica Power center
• Upgrade / Migration of existing Power center installation from 8.6.1 to 9.0.1, 9.0.1 to 9.1 & 9.5.1
• Configuration of Informatica High Availability and DR.
• Backup and restore.
• Day-to-Day administration activities such as creating/modifying users, groups, folders, privileges, adding/removing nodes, repositories.Upgrade of Oracle ERP from 11i to R12.
• Experienced in using AD utilities (adpatch, adrelink, adautocfg, admrgpch, adadmin, adctrl etc.)
• DR exercise.
• Maintenance of Oracle Application Server 10g (Portal) and handling user access issues.
• Installation, Configuration and patching of Oracle Enterprise performance Management system, which includes suite of Hyperion components like Financial management, Financial Reporting, Reporting and Analysis, WebLogic and Fusion Middleware.
• Upgrade and migration of EPM Products and refresh of environments.
• Implementation of SSO, SSL and DR strategy.
• Day-to-Day administration activities.

TECHNICAL SKILLS:

Technology and Tools: ERP 11i, R12 Informatica Powercenter 8.6.1, 9.0.1, 9.5.1, DVO BOXIR2, R3 Oracle Hyperion Products Oracle Fusion middleware Applimation Oracle Portal RDBMS Oracle 9i, 10g, 11g (OCP - 10g) SQL Server 2005, 2008 Operating Systems Windows 2000, 2003, 2008, 2008R2 IBM AIX RHEL5 Testing Management Tool/Defect Tracking Tools Rational ClearQuest. Remedy6, ITSM 7.1, 7.6 SERENA (HP-PPM) SQL, PL/SQL, Unix Shell scripting, C, MF COBOL SQL*Loader, expdp, impdp, Statspack, AWR, AD Utilities, SQL Developer, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, Tennessee

Oracle DBA

Environment: Oracle 11gR1,R2, RHEL6 Used: TeamTrack,OEM

Responsibilities:

• Providing 24*7 Support to the client environments:
• Response and Resolution SLA Management
• Troubleshooting problems reported with technology stack components.
• Data Archival, Performance Tuning, day-to-day administration of RAC databases.
• Upgrade and Patching.
• Backup and Restore policy planning and implementation.
• Automate Monitoring using OEM and in-house tools.
• Refresh of non-production instances from production.
• Problem management, Change Management, Incident Management, RCA and metrics.
• Weekly status report to client and continuous improvement.
• Identify new areas of improvement and handshake projects and kickoff.

Confidential, Bluebell

Solution Architect

Environment: Windows 2008R2, VM, Oracle 11gR2, Oracle EPM 11.1.1.3, 11.1.2.3, Oracle WebLogic 11gR1, Oracle Fusion Middleware.

Responsibilities:

• Review of existing architecture by document review and application components study.
• Review licensing, compatibility and of new version, identify areas of improvement, and design new optimal architecture.
• Capacity Planning.
• Prepare Project plan, identify deliverables and key milestones, execution checklist.
• Task allocation, co-ordination with offshore team, tracking status through daily status calls. Weekly status reporting to client.
• Work with various teams to prepare environment - Platform support team (SAN & Windows) to prepare servers and storage, Database team to setup OFS, and database, Network team to setup Load balancer and DNS entries.
• Installation, Configuration and Patching of EPM 11.1.2.3.500 in a distributed environment with High availability, for multiple environments - Production, QA and DR.
• Data migration from existing environment to upgraded environment and refresh from Production to Non-Production environment.
• Implement recommended configurations in OHS, WebLogic and tuning.
• Implementation of Single Sign-on, SSL and DR strategy.
• Setup monitoring and alerts using Custom monitoring tool and WLST scripting - Application, Server and DB availability alerts, system resources utilization monitoring etc.
• Work with various teams to setup backup for various components - application configuration files, VM servers, database, and file shares.
• Setup Start and Stop scripts, one-stop service check script and automate backup and DR using scripts.
• Resolve issues and provide L3 support to Functional team, Testing team and users during application testing and performance testing.
• Preparation of Architecture diagram, Installation and Configuration document, Support Document and Password change document. Portfolio Management.
• Provide to Operations Support team.
• Plan for decommission of old environment.

Confidential

Solutions Architect and Technical Lead

Environment: Windows 2008R2, Oracle 11g, Informatica Power center 9.5.1, BO XI R3.

Responsibilities:

• Review of existing architecture by document review and application components study.
• Review licensing, compatibility and of new version, identify areas of improvement, and design new optimal architecture. Capacity Planning.
• Prepare Project plan, identify deliverables and key milestones, execution checklist.
• Work allocation, project monitoring and tracking, status reporting to client. Managing a team of 5 Infrastructure DBAs.
• Work with application team to list down the test plan and strategy.
• Work with Platform support team (SAN & Windows) to prepare servers and storage.
• Work with Database team to setup OFS, and database software and plan, implement upgrades.
• Work with Network team to setup Firewalls, Load balancer and DNS entries,
• Work with backup team to setup backup/restore strategy.
• Coordinate the migration and upgrade of POC, Dev, Test, QA, Performance, Dry run and Production environments. Upgrade of Informatica installation and migration of data.
• Change Management, Incident Management and Problem management
• Decommission of old environments.
• Implementation of DR strategy.
• Setup monitoring and alerts using Custom monitoring tool and batch scripting - Application, Server and DB availability alerts, system resources utilization monitoring etc.
• Analyze and resolve various issues arising in migration and provide support to application and functional team, Testing team and users during application testing and performance testing.
• Document Issue and Resolutions, RCA and ways to avoid recurrence, Lessons learnt and best practices. Portfolio Management.

Confidential

Delivery Manager for DBA Track and Informatica administrator

Environment: Oracle 9i, 10g, 11g Informatica Power center 8.6.1, 9.0.1, 9.1, 9.5.1, BO XI R2,R3, SQL 2005/2008

Responsibilities:

• Managing the Oracle DBA Support Project comprising a team of 20 resources.
• Providing 24*5 Support to the client environments:
• Response and Resolution SLA Management
• Troubleshooting problems reported with technology stack components.
• Backup and Restore policy planning and implementation.
• Automate Monitoring using OEM and in-house tools.
• Refresh of non-production instances from production.
• Problem management, Change Management, Incident Management, RCA and metrics.
• Weekly status report to client and continuous improvement.
• Identify new areas of improvement and handshake projects and kickoff.
• Maintain Informatica and DW environment.

Confidential

Tech Lead for Oracle DBA

Environment: Oracle Applications R12 (12.1.1),11i, Oracle 9i,11gR2,Oracle Portal

Responsibilities:

• Preparation of environments for Upgrade - Dev/Test/QA/Performance Testing, Production, Practice and Vision Environment.
• Upgrade DBs from 9i to 11gR2.
• Monitor DB health during Apps Upgrade and improve performance.
• Troubleshooting problems reported with technology stack components.
• Backup and Restore policy planning and implementation.
• Automate Monitoring using OEM and in-house tools.
• Refresh of non-production instances from production.
• Gathering Schema Statistics, Index Rebuild and GSS Import.
• Preparation of execution checklist and status monitoring.
• Problem management, Change Management, Incident Management, RCA and metrics.

Confidential

Application enhancement and Tech Lead - Oracle DBA

Environment: Oracle 9i, 10g, 11g and IBM AIX

Responsibilities:

• Design and implement DB environment, Capacity Planning, Disaster Recovery.
• Installation and configuration of Oracle DBs.
• Configure Backup and recovery for DBs
• Performance Tuning - Instance and Code
• Data guard setup and configuration
• Daily Administration activities and support.
• Tablespace Maintenance. Gathering Schema Statistics, Index Rebuild and GSS Import.
• Problem management, Change Management, Incident Management, RCA
• Unix Shell scripting and automation.Understanding TDS and ASBA modules.
• Design of new enhancements, development using MF COBOL, Oracle PL/SQL, UNIX shell scripting and testing.
• Documentation.

Confidential

Team Member

Environment: UNIX, Pro*c, SQL, PL/SQL, Oracle 9i

Responsibilities:

• Resolve issues based on tickets.
• Regular DB health checkup.
• Space maintenance and other administration activities.