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

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship