Oracle Database Administrator Resume
3.00/5 (Submit Your Rating)
Columbia, MD
SUMMARY:
- Possess 8 years of experience in Oracle database design, installation, performance tuning, security, backups, recovery, patches, upgrades, and migrations.
- Considerable talents in requirements analysis, data analysis, RAC installation & management, data modeling, user relations, team - building, mentoring, advising, and strategic thinking.
- Excel at collaborating and communicating with key stakeholders to propel continuous improvement.
- Able to coordinate and guide cross-functional teams in accomplishing objectives and meeting deadlines in a fast-paced environment .
- Well-versed in leveraging regular back-up procedures to protect and defend vital business information.
- Constantly focus on optimizing application performance, reliability, security, and usability.
- Solid ability to extract, manipulate, and analyze complex data to generate detailed reports
- Outstanding expertise in ensuring rigorous data integrity in machine-critical and high-volume Terabyte database environments.
PROFESSIONAL EXPERIENCE:
Confidential
Oracle Database Administrator
Responsibilities:- Manage Oracle PSU/CPU application for 50 RAC clusters from testing to production.
- Delegate tasks to developers in code deployment for five applications/databases according to SLAs.
- Install and uninstall Oracle products on multiple T5 machines to increase scope of infrastructure.
- Create, modify, and optimize database objects to enhance application performance.
- Plan, coordinate, and execute seamless database changes during monthly maintenance activities.
- Respond to and swiftly resolve client incidents and implement security fixes to ensure alignment with stringent client requirements.
- Devise and administer backup schedules to facilitate full recovery during unplanned downtime.
- Perform regular refreshes of multiple databases to streamline application development.
- Manage and maintain daily activities for 15 AWS servers to ensure efficient database performance
Confidential
Database Administrator
Responsibilities:- Directly supported three major projects requiring proficient administration of Oracle databases with sizes ranging from 20GB to 5TB.
- Systematically troubleshoot, performance-tuned, and managed 24 Oracle databases encompassing 10g & 11g single/RAC instances running on RHEL 5.0, Oracle Solaris 10, and Windows 7.
- Maintained EBS suite applications (e.g. Labor, Benefits, and HR) and oversaw code creation, testing, and deployment to higher environments for EBS suite applications.
- Installed and periodically upgraded and patched software servers such as OBIEE 11.1.1.7.1 to 11.1.1.9.0 and Informatica 9.5.0 to 9.6.1
- Ensured availability of refreshed databases for developers to test and improve code.
- Cloned databases using RMAN backups as well as Datapump to improve development tasks.
- Orchestrated full migration of database objects from Oracle Solaris 10 to RHEL 5.1.
- Helmed deployment of. WAR/.EAR/.JAR files to WebLogic server to achieve and sustain top levels of end user satisfaction.
Confidential
Oracle Database Administrator
Responsibilities:- Delivered comprehensive cluster support for 40 RedHat Linux and Windows servers running Oracle Enterprise Edition databases (versions 9.2.0.7.0 to 11g Release 2).
- Methodically created and configured Oracle 10g and 11g databases on Windows and Unix platforms.
- Supported and improved capacity planning by formulating database objects, tables, database schemas, indexes, profiles, and database links.
- Designed, tested, and implemented backup & recovery solutions including automated daily backups.
- Leveraged SQL and PL/SQL to program scripts and stored procedures for automation of frequently required batch jobs and alerts necessary for database administration.
- Strategically resized, partitioned, and striped storage disks, tables, indexes, and rollback/undo segments to increase performance output and bolster manageability.
- Proactively configured standby failover databases, vital to ensuring flawless business continuity.
Confidential,Columbia,MD
Oracle Database Administrator
Responsibilities:- Spearheaded administration and management of 100 databases on AIX and Sun Solaris platforms with sizes ranging from 40GB to 1.5 TB.
- Planned and performed ongoing installation, configuration, and disposition of Oracle software.
- Designed, created, and monitored cutting-edge databases using OEM database and grid control.
- Set up, configured, and effectively troubleshoot client-server connectivity using Net Manager and Net Configuration Assistant tools.
- Resourcefully cloned databases using RMAN, OEM, and DataPump to deliver best-in-class high-availability solutions in a Dataguard environment.
- Enforced IT security through diligent management of users, resources and objects, and appropriate granting of roles, profiles, and permissions.
- Prepared instructional workshops and associated materials to educate application end users.
