We provide IT Staff Augmentation Services!

Principal Database Administrator Resume

Belmont, CA

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

Principal Database Administrator

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

Principal Database Administrator

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

Hire Now