Oracle Database Administrator Resume
|Desired Industry: Information Technology
|Desired Job Location: Columbia, Maryland
||Date Posted: 9/30/2010
|Type of Position: Full-Time Permanent
||U.S. Work Authorization: Yes
|Job Level: Experienced with over 2 years experience
||Willing to Travel: Yes, Less Than 25%
|Highest Degree Attained: Masters
||Willing to Relocate: Undecided
To be an outstanding Oracle Database Administrator
o Eight years of experience as an Oracle Database Administrator in a fortune 500 company administering and managing Oracle databases on different environments.
o Having excellent problem solving and decision making capabilities, good communication and interpersonal skills, capable of multi-tasking and understanding the priorities for client satisfaction.
o Exposure to almost all the functional areas of Oracle and use of extensive tools to aid in regular database administration
o Coordination with clients which includes understanding/ gathering requirements (storage /database/budget), supporting vendor installation, resolution of problems and providing database solutions in a timely manner.
o Well versed in UNIX Shell scripting, database documentation for explanation of various work flow database related processes, SQL and PL/SQL scripting.
o Experienced in databases and application related performance issues.
State of Maryland
Computer Information Services Specialist (2010-present)
o Responsible for creating and managing all Maryland State Police database user and dealer accounts.
o Responsible for providing training and instruction on database use and maintenance as required.
o Responsible for trouble shooting and managing application and database problems.
o Responsible for analyzing database data and provide monthly reports to commanders / directors.
o Set up of database Helpdesk to log calls relating to database /application issues.
o Tuned 11G Memory related parameters to optimize performance.
Senior IT Consultant (2000-2008) CT
Pfizer Inc is one of the largest Pharmaceutical Companies in the world with a market capitalization of over US$140 Billion. There are over 1000 oracle databases replicating data all over the world with a 24x7 support with the data centre based in Groton,CT.The number of Oracle databases has been on the increase considering the company over the recent years has been acquiring other Pharmaceutical companies.
My job responsibilities included:
o Installed 10G/9i/8i Oracle Server Software in Solaris /HP-UX machines
o Database Creation through DBCA and through the templates set up by DBCA. Wrote SQL scripts to create 10g databases.
o Performed Database upgrade (8i/9i 10g) using various tools like Export/Import, DBUA and through customized SQL Scripts on UNIX/Windows Machines.
o Migration/Consolidation of Oracle databases from Windows environment to UNIX environment (Part of cost saving measures initiated to retire servers)
o Installed third party vendor products needed by the pharmaceutical scientists for study of molecular properties of complex compounds.
o Performed Database or schema level refreshes using export/import or the backup utilities.
o Installation of security patches (initiated Security patch 68 installation on all database servers organization wide for which was given a certificate of appreciation by Pfizer)
o Creation and Management of materialized views /snapshots to support data warehouse applications and to support data replication at different sites around the world.
o Monitoring /Resolution of Service Center requests for wide range of database issues through the ticket system for users who log in to the Helpdesk Service Centre queue system .Some of the requests include:
o Database design which involves creation/modification of application objects and setting up of logical structures to support the application objects
o Review of code (PL/SQL Procedures /Packages /Triggers) provided by developers
o Implementation of code in development environment and propagating the changes subject to approval /testing from Quality Assurance to the test /staging/production environments performed through a gatekeeper process and the Peregrine Ticket system.
o Setting up of Application schema a/c's with the correct resource usage consumption /Password Management through the use of database Profiles/Resource Manager etc.
o Management of Application schemas through privileges /roles
o Responsible for Creation of database documentation for various database policies and for various work flow processes.
o Validated /Tested /Documented Backup /Recovery strategies under various scenarios using RMAN (Complete/ Incomplete/ Flashback recovery).
o Implementation of new 10G RMAN Features to speed up the Backup process.
o Measuring and analyzing the performance of application SQL statements using various tuning tools, providing recommendations to the application teams for usage of indexes/histograms/Outlines/Hints.
o Proactive Database tuning to keep hit ratios at a minimum standard guideline using Stats-pack and AWR reports.
o Implemented Partitioning in Data Warehouse databases to improve performance
o Monitoring of CPU usage /bottlenecks in the databases using SAR /VMSTAT or through customized SQL scripts
o SQL NAVIGATOR
o OEM DATABASE /GRID Control
o EXPORT /IMPORT
o DATA GUARD BROKER
o Masterís in Computer Management
o Masterís in Business Administration
Oracle Shell Scripting
UNIX (HP-UX,Sun Solaris)
Query Tuning /Optimization
Database Creation /Patching /Upgrade
Administering and Managing Oracle Databases in UNIX /Windows
I would like to introduce myself as a Professional Oracle Database Administrator and would like to be considered for the Post of Oracle Database Administrator in your esteemed organization.
I also have eight years of Professional working experience as a Database Administrator in one of Fortune 500 companies and am currently working as a Computer Database Service specialist for the State of Maryland.
To support my professional working experience I have a dual masterís degree in business management and administration and am also an Oracle Certified Database Administrator.
Apart from my professional experience I also have excellent communication and decision making capabilities and have handled customerís queries successfully in almost all the functional areas of the database. I have supported Oracle databases around the world with different time zones and have also been awarded a certificate of appreciation from my previous employer in planning and implementing a critical security patch application for 500 production Oracle databases in our data centre in Groton, CT.
I look forward to being provided an opportunity to work in your esteemed organization and if selected assure you that I would be an asset to your organization and would contribute my skills /effort /time for the success of the organization.
o Resume Enclosed
Candidate Contact Information:
|JobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response.