We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

OBJECTIVE:

To obtain a challenging position that will enable me to utilize, develop and enhance my skills.

SUMMARY:

  • Dedicated professional with extensive experience supporting production and development environments as an Oracle Database Administrator.
  • Effective team player with excellent communication, analysis and problem solving skills.
  • Outstanding project and team leader; able to coordinate and direct all phases of project - based efforts while managing, motivating, and guiding teams.
  • Exceptional corporate citizen; actively helping the department and the company to go from good to great.
  • 7 years of experience managing and supporting 24x7 production and development environments as an Oracle Database Administrator
  • Experience in Oracle software installation, configuration and patch application
  • Experience in upgrading Oracle software to higher versions > 10g -> 11g
  • Good knowledge of Oracle Architecture
  • Experience with database tools like OEM, TOAD, SQL*Plus, Explain Plan, TKPROF, STATSPACK, ADDM, SQL*Loader, Export/Import, Data Pump
  • Implementation of 10g OEM Control for database monitoring and alert notification
  • Experience with Data Guard setup and configuration with RAC
  • Experience with database backup, cloning and schema refresh
  • Expertize in database Migration and Consolidation
  • Remote database connectivity management using tnsnames, OID LDAP and Names Server
  • Good understanding of UNIX Kernel parameters
  • Good working knowledge of VI editor
  • Generate and analyze Oracle STATSPACK Reports
  • Ability to work on multiple projects and with multiple development teams simultaneously
  • Automation of day-to-day DBA tasks using SHELL scripts and CRON jobs
  • Expertise in troubleshooting the problems related to databases and applications
  • Manage onsite and offshore co-ordination and communication
  • Good working knowledge of RMAN

TECHNICAL SKILLS:

Platform/OS: Sun Solaris, HP-UX 11.0, LINUX, Tru-64, Windows

Databases/RDBMS: Oracle 11g, 10g,

Tools/Utilities: TOAD, 10g OEM Console, SQL*Plus, Explain Plan, TKPROF, STATSPACK, ADDM, RMAN,SQL* Loader, Export/Import, Data Pump

Programming/Languages: UNIX Shell Programming

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

Responsibilities:

  • Install Oracle 11g, 10g, and upgrading databases to higher version
  • Install and configure Oracle 10g DataGuard with RAC, OEM
  • Maintenance/Support
  • Provided 24X7 on-call support to maintain all databases in production and development environments
  • Database maintenance, upgrades, and patches releases
  • Manage database users and security
  • Implemented ORACLE TDE
  • Support job processing, scheduling, real-time management, troubleshooting and storage configuration
  • Capacity Management for existing databases
  • Day to day database administration tasks
  • Good Knowlege of Oracle Gateways for connectivity to DB2 and SQL server
  • Handled client escalations related to database activities
  • Cloning Database from production to development
  • Physical and Logical backups using RMAN
  • Standby database setup and maintenance
  • Utilized Oracle Metalink for technical support
  • Write extensive SQL/PL-SQL code for business needs
  • Implement Triggers,sequences,functions.
  • Proactive database monitoring using custom built sql/PL-SQL and unix scripts
  • Identify, trace and tune SQL queries for better performance
  • Generate AWR, ADDM and ASH reports
  • Database and application developer ’ s problems troubleshooting
  • Application and SQL query tuning to help development team
  • Helped application development team in tuning and testing queries
  • Parallel query execution
  • Proper setting of Kernel parameters
  • Tablespace fragmentation checks and reorganization of tables
  • Communication/Documentation
  • Design, Document, implement Database Maintenance Plan
  • Document processes and procedures for reuse
  • Improved standards and guidelines for database changes and application development
  • Adhered to predefined deliverables and SLA ’ s
  • Managed onsite and offshore co-ordination and communication
  • Design, Developed, Document, Implement and Monitor Backup and Recovery Operations (Using RMAN )
  • Responsible for Disaster Recovery plan

Hire Now