OBJECTIVE

• Seeking a job for challenging position of a Lead Database Administrator

SUMMARY

• Around 8 yrs of experience in IT industry, as an Oracle Application DBA and core DBA supporting multi Terabyte databases on multiple environments.
• Experience with working on Cloud environments
• Led onsite and offshore DBA resources.
• Proven ability to integrate technical expertise and business knowledge in developing and executing new processes.
• Expertise in hiring, training, motivating new employees.
• Expertise in building customer relationships.
• Experience in implementing HA Data guard with zero data loss and standby databases.
• Configuring and setting up disaster recovery site.
• Database and application upgrade of OLTP from 9i to 10g in RAC 3 - node and application from 11.5.10 to 11.5.10.2 (4 node).
• Experience in Oracle E- Business Suite R12.
• Experience with working on databases running on Oracle EXADATA.
• Experience in implementation and upgrade.
• Experience in building Disaster Recovery solutions for Oracle Application, Hyperion, IPM and SOA.
• Experience in backup and recovery using RMAN.
• Experience in Oracle RAC databases on ASM, RAW file system for Multi Terabyte databases.
• Experience in maintaining and quick problem solving ability for 24x7 Oracle Application databases and core databases for multiple customers.
• Worked on Capacity Planning, Space Management, Security Management, Auditing, Shell scripting, Memory and Performance Tuning.
• Experience in maintaining and monitoring Oracle Application databases in HP-UX, Linux, Solaris, AIX and Windows platforms.
• Experience in supporting Oracle Application and databases running on SAN, NAS storage and NFS file systems.
• Experience in Weblogic Server Administration.
• Experience in Patching (using adpatch, Kintana), Cloning (Rapid Clone and Manual Clone) and using AD utilities.
• Experience in Workflow Administration in Oracle Application.
• Experience in managing Concurrent Managers, planning for concurrent manager workers as per requirement.
• Exposure to Oracle Hyperion.
• Experience in enabling security in Oracle databases to meet AUDIT compliance.
• Troubleshooting problems related to user errors.
• Experience in troubleshooting Apache issues.
• Experience in installation of Oracle application (11.5.10), R12 and oracle databases
• Experience in shell scripting required for database maintenance and support activity
• Proven ability to interact with end users, good team player and quick learner
• Experience in training new members
• Experience in preparing Technical Presentations and Demos for clients

TECHNICAL SKILLS

Operating Systems: Windows 2000/ XP/ Professional/ 2003, Red Hat Linux AS/ ESHP-UX (11.11/11.23 ), Solaris, AIX

Languages: SQL, PL/SQL

Tools: Oracle Forms 6i, Reports 6i, Toad, OEM, Kintana, Remedy, sqlloader, RMAN

Database: Oracle 11g, 10g, 9i and Oracle 8

Applications: Oracle Application (11.5.9, 11.5.10, 11.5.10.2 and R12), Fusion Middleware applications, Hyperion

PROFESSIONAL EXPERIENCE

Confidential, Belmont, CA

Responsibilities:

• Provide support for Oracle Outsourced customers.
• Lead dr solution team
• Disaster Recovery planning, build and test for customers
• Providing solution for customers within an SLA of 1 hour for Oracle Application, Oracle FMW applications and Oracle core database issues.
• Maintaining Standby databases
• Support Exadata Databases
• Work on Severity 1 SR for issues with Oracle Applications which includes issue with Apache, oacore, concurrent manager, concurrent requests, issue related to application tech stack etc.
• Recovering databases(Block recovery, point-in-time recovery, complete recovery) in case of issues
• Troubleshoot and fix issue with Weblogic Server
• Implement and maintain database backup using RMAN for ASM and non-ASM environments
• Tracking application and database changes applied by change management process
• Providing support for newly implemented Oracle Fusion Middleware customers
• Work closely with System admin, Storage in case of outages by initiating conference call
• Applying new changes to environment
• Provide instant solution in case of database problems like tablespace issue, locks in database, segment issue etc
• Write shell script to automate database monitoring, backup jobs
• Troubleshoot Application and database performance issues
• Troubleshoot and fix Hyperion issues
• Provide solution for Oracle Workflow related issues
• Work closely with Product Support team with SR’s
• Prepare technical document and presentations for clients
• Representing DBA team in meetings

Confidential, Pittsburgh, PA

Responsibilities:

• Performed Oracle Application upgrade for OLTP environment (11.5.10 to 11.5.10.2)
• Managing and leading project for Confidential South America DBA team
• Implemented audit policies into all databases across North America, South America, Australia and Hungary databases to meet audit compliance
• Implemented new monitoring standards and processes
• Assisted developers and project managers with database architecture to ensure projects were delivered on-time, while utilizing the functionality of Oracle database to its fullest.
• Cloning Oracle Application Instances to build Development and QA instances
• Oracle Workflow Administration (Notification Mailer issues, workflow migration)
• Applying Oracle Application and database patches (patch analysis and application using adpatch and KINTANA)
• Fix up gradation issues in coordination with Oracle Support
• Regular database backup activity
• Managing Standby databases
• Oracle Application System Administration (managing concurrent managers, user creation, creating responsibility, menu and functions, register new applications, managing profiles)
• Failover primary database to standby database
• Table space and data file management
• Unix file system management
• Analyzing apache and JVM parameters for application performance
• Performed AUDIT task
• Password management for application and database security
• Planning database and application outages for maintenance window
• Analyzing AWR reports for performance and tuning
• Remedy Ticket solution for Oracle Application and database users
• Key player in preparing upgrade plan
• Implement new changes to monitoring scripts as per new requirements.
• Lead workflow administration and tech support team
• Maintain Oracle application using AD utilities.
• Provide 24/7 support for multiple production instances for NA and Europe
• Patch analysis and schedule downtime for applying of patch
• Provided training and support to new resources in team
• Build new oracle application instances for test environment and training
• Understand future requirement of customer and provide plan for work
• Worked closely with different teams to consolidate work
• Creating and monitoring SR’s

Confidential

Responsibilities:

• Create clone of production environments using rapid clone
• Conduct daily status meeting with client and gather new requirements
• Apply application and databases patches on multiple Oracle Application instances
• Provide DBA support for EBS and Non-EBS instances
• Worked closely with development team to solve implementation issues
• Taking backups (Hot/Cold and Export/Import)
• Registering custom forms and reports which are developed as a part of custom development
• Creating custom application and database users, custom table spaces and assigning required roles and privileges
• Worked closely with UNIX team to implement monitoring scripts.
• Trouble shooting problems related to Apache and Jserv
• Monitoring Concurrent managers and requests

Confidential

Responsibilities:

• Monitoring and maintaining Oracle Application using AD utilities
• Troubleshooting problems related to database
• Manually creating databases
• Installing Oracle application on Windows
• Oracle Application system administration
• Proactive monitoring of database and taking required actions
• Undergone training on oracle application and oracle core database activities