SUMMARY:

• Nine years and nine months of work experience in the software industry.
• Nine plus years of experience as Oracle Core DBA with experience in Basic Administration, Performance Tuning, Instance Tuning, Installation, Capacity Planning, Migration and Upgrade, Backup and Recovery, data guard, RAC and other administration activities.
• 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.

AREAS OF EXPERIENCE:

Industries: Banking & Insurance IT Applications Management

Applications/Products: 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

Source Safe Tools: SERENA (HP-PPM)

Others: SQL, PL/SQL, Unix Shell scripting, C, MF COBOL SQL*Loader, expdp, impdp, Statspack, AWR, AD Utilities, SQL Developer, TOAD Four years of Solution architect experience specializing in various applications, database and technology stack upgrades and migrations.

EXPERIENCE SUMMARY:

Solutions Architect

Confidential

Responsibilities:

• 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/certification 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.

Oracle Database Administrator

Confidential

Responsibilities:

• 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.

Informatica & Data warehouse Administrator

Confidential

Responsibilities:

• 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.

Oracle Applications Administrator

Confidential

Responsibilities:

• 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.

Oracle Hyperion Product Suite Administrator

Confidential

Responsibilities:

• 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.

Confidential, Memphis, Tennessee

Oracle DBA

Environment: Oracle 11gR1,R2, RHEL6

Tools: 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 certification 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 training 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 certification 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.