SUMMARY

• Solid expertise in Oracle 8i, 9i, 10g, 11g with RAC, ASM, Data Guard Database Administration including Development, BAU/Production Support, Performance Tuning, Capacity Planning, Migration, Upgrades, Backups, Recovery and high availability and disaster recovery design incorporating clustering and load balancing.
• Demonstrated experience working in client-facing roles to contribute towards the end-to-end delivery lifecycle of complex and large-scale technology solutions.
• Strong analytical skills to diagnose and resolve technical production issues, proven scripting and PL/SQL programing skills, good understanding of OS platforms UNIX, LINUX or WINDOWS
• Experience in Oracle e-Business Suite 11i/R12 ERP/CRM Applications DBA tasks including upgrade, migration, customization, performance tuning BAU support.
• Seasoned Configuration Management experience excellent requirements analysis, business process management, stakeholder management, interpersonal and communication skills.

CAREER HISTORY AND ACHIEVEMENTS

Senior Oracle DBA Technical Consultant

Confidential

Reporting to Project Managers my role involved analysing, designing and managing the transitioning of Oracle Databases from NAB legacy data centre to IBM Cloud IOD - Infrastructure on Demand .

Achievements included:

• Achieved set target to get the sign-off by gathering Business Requirement from SOW brainstorming sessions with SMEs preparing elaborate Database Migration Strategy Document for upgrading and migrating eleven different NAB Wholesale Banking Databases.
• Received client recognition for on-time provisioning of Oracle 11gR2 databases in IBM-NAB Cloud by co-ordinating and working effectively with NAB users, Infosys team and IBM Infra team.
• Successfully provided Oracle Technical consultation and hands on production implementation support to various NAB Retail, Wealth and Wholesale Banking specific applications.

Senior Oracle DBA / System Analyst

Confidential

• SKILLED Group ASX:SKE is a market leader in Flexible Labour Solutions in Australia. Reporting to General Manager my role involved:
• Assuming complete ownership for technical support and development of Oracle Databases and associated business applications and their integration through BizTalk and legacy links.
• Managing and maintaining dozens of Oracle 8i/10g/11i databases on Sun Spark Solaris and Linux platforms having large ERP/CRM Application called AGRESSO along with five other business applications, one Business Intelligence and one Reporting Application all integrated through various systems including Biz Talk Integration Server, ETL Build and ETL Routines.
• Developing, optimizing and modifying PL/SQL code stored procedures, functions, packages, triggers, schema objects etc. and Unix Shell Scrips using Agile Development methodology.
• Administering and performing daily RMAN Backup/Recovery tasks, Disaster Recovery / Business Continuity Planning across Oracle, SQL Database, Middleware Applications, and Storage.
• Managing changes to the Applications and database using Agile methodology and within client's ITIL Change Management Framework and Performing impact analysis of changes
• Performing requirements analysis, business process mapping and analysis, functional and software specification documentation and stakeholder management as and when needed.

Achievements included:

• Significantly improved overall system performance by modifying and optimizing Oracle 8i/10g/11i PL/SQL Stored Procedures and Functions of integration software of three Oracle Databases and two Microsoft SQL Servers through BizTalk Orchestration using SOA Architecture.
• Improved database stability and uptime by developing implementing several automated system monitoring, data integration, data migration, data archiving and cleansing scripts.
• Strengthened management confidence in IT Disaster Recovery and BCP capabilities by developing and implementing test environment clones from DR using EMC DDBoost RMAN.
• Reduced IT licensing cost by planning and moving databases from high CPU servers to low CPU count servers still managing and keeping the system performance at user acceptable levels.
• General Manager IT Application Database Development Support

Confidential

• EagleBurgmann India Ltd is a subsidiary of Burgmann Industries of Germany and Eagle Industry of Japan manufacturing high precision mechanical seals for oil refineries and other industries. Reported jointly to the Managing Director in India and the Global IT Manager in Germany my role involved
• Managing a team of 20 IT professionals including DBAs, Developers, Systems and Network Admins, Business Analysts for support and development of ERP/CRM and Manufacturing Apps.
• Planning, designing and implanting upgrade, migration and performance enhancement projects of Oracle, MS SQL Sybase databases along with respective business applications
• Liaising with all levels of stakeholders to understand enterprise architecture, business strategies, policies, rules and operations of the organization, and to elicit, analyse, recommend, design, develop, implement, test and manage IT Business Applications.
• Participating in the design and development of new Consolidated Global Master Database to integrate, consolidate and create a single global master data of all subsidiaries.
• Achievements included:
• Achieved 20 cost reduction target by mentoring and training IT staff, implementing auto-monitoring tools and providing self-service systems to business users.
• Improved profit margin by improving BOM accuracy from 85 to 99.9 by analysing and enhancing MRP-II application and effectively collaborating with business units.
• Generated revenue for IT Department by managing Global Master Databases of Germany along with several other Oracle, Sybase and MS-SQL databases remotely from India.

Senior Techno Functional Consultant Oracle Apps DBA

Confidential

• Sierra Atlantic is an ERP/CRM consulting firm. Reported to Project Manager I was responsible to:
• Designing, Executing Oracle E-Business Suite upgrade, migration projects performing database level Change Management tasks. Performing hands-on Oracle DBA and Apps DBA tasks executing onsite go-live/cut-over implementations in US, Canada and Asia pacific region.
• Perform Technical Business Analysis and Change Management tasks for ERP/CRM Upgrade, Migration, Integration projects and co-ordinate with client team, onsite/offshore teams

Achievements included:

• Achieved set target of minimum post go-live defects by detail documenting and executing DBA steps formulating comprehensive test scenarios and developing elaborate test scripts.
• Reduced upgrade cut-over time by 30 from projected hours while performing onsite Oracle Apps DBA tasks to upgrade 9i Database with RAC and 11i eBusiness Suite.
• Senior Techno Functional Consultant Oracle Apps DBA

Confidential

• The Office of the Clerk is responsible for providing administrative and IT support to The United States House of Representatives Reporting to the Project Manager I was responsible to review and prepare SOP, SOW and Solution Design for the upgrade of Oracle Application FAIMS to the latest version of Oracle eBusiness Suite Release 11i and mentor, train in-house Oracle Apps DBAs. Achievements include:
• Successfully reviewed the customization and the complex interface requirements with treasury and other government agency IT systems and prepared the SOW, upgrade strategy and plan presentations along with several other required artefacts by evaluating and negotiating for various upgrade path options, customization impact analysis and related solution options.
• Received recognition for the Standard Operating Procedure SOP documents prepared for Oracle Financials Application, Oracle Database and Middleware Technology stack components.

Senior Oracle Techno Functional Consultant Oracle Apps DBA

Confidential

Confidential is a US federal corporation protecting retirement incomes of Americans. Reporting to the Project Manager I was responsible to participate as lead technical consultant in the customization and implementation of Premium and Practitioner System using Oracle eBusiness Suite 11i.

Achievements include:

• Improved project benefits by performing Oracle Apps DBA tasks and inventively implementing Single-Sign-On 10G for Oracle Apps 11i through Oracle's Early Adaptor Program.
• Previous Experience: Starting from May-1995
• I started my career as Business Analyst and progressed to Systems Analysts, Developer, Oracle DBA, Oracle Apps DBA and Oracle Financials ERP/CRM Techno Functional Consultant performing various tasks including:
• Perform Oracle DBA, Oracle Apps DBA, System Analyst and Development tasks as a consultant.
• Planning, Designing, Testing and Executing Oracle E-Business Suite upgrade, patching and migration projects and performing database level Change Management tasks.
• Participating in all stages of the development lifecycle from requirements gathering, process mapping, analysing, software specification design to preparing user and training documentation.
• Supporting and managing project progress, time and cost facilitate project teams to achieve their assigned tasks, conducting regular project reviews and guiding the team towards success.
• Performing hands on Oracle e-Business Suite Application configuration, System Administration and Apps DBA, Oracle DBA and Developer tasks at client sites
• Performing Oracle Financials ERP Functional and Technical Consultant Team Lead tasks including working closely with development teams explaining designs and helping with software implementations and building rapport with clients and key stakeholders
• Performing hands on client-server software development using variety of tools and technologies.