Database Administrator Resume Omaha, NE - Hire IT People

SUMMARY

Certified Oracle Professional with over 9 years of IT industry experience including7 years of solid hands on experience as Oracle Database Administration (Oracle DBA) performing vast variety of tasks
Highly dexterousin designing database architecture, database models evaluation, application schema layout, stored procedures and triggers, forms and reports
Well experienced in installing, patching and upgrading and administering Oracle Database on Windows & Unix/Linux platforms
Expert level skills in supporting production as well as the development environments
Strongunderstanding of RDBMS concepts, database best practices and work flow procedures
Thorough understanding of indexes, index management, and optimizer statistics
Well conversant with database backup and recovery using RMAN
Experienced in reviewing as well as developing stored procedures, packages and queries in PL/SQL
Skilled in performance tuning, trouble shooting and providing resolution.
Experience working in high availability technologies (RAC, Clustering, Data Guard) on 11G.
Full understanding of product release life cycle.
Able to work independently with minimal supervision or guidance.

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Database Administrator

Responsibilities:

Provide support for the development/production environments for both RAC and single instance.
Responsible for all backups and restoration. Clone database for developers.
Help the developers in SQL and application tuning.
Perform logical backup of data using Data pump.
Participate in on - call rotation.
Administer database access and security.
Apply oracle patches for stability reasons.
Check alert log for activities and ORA-errors.
Monitor the performance of databases and maintain metric for future use.
Capacity planning to accommodate the growing amount of data.
Work closely with project development team to understand their needs and deliver appropriate services within the required time frames.
Create and manage database structures, storage allocations, table/index segments, database access, roles, privileges and profiles.
Develop Report and forms.
Add or modify data files to change the size of the database.
Responsible for troubleshooting and resolution of database issues.
Work with security monitoring and encryption tools.

Confidential - Columbus, OH

Database Administrator

Responsibilities:

Performed migration/upgrade from 10g to 11g, and applied patches.
Tuned SQL for the new and existing environment.
Installed OEM and Statspack and used these tools for performance and tuning.
Worked with the development and application support team to identify and resolve performance issues using diagnostic tools such as AWR and ADDM..
Performed database backup using RMAN.
Part of a team responsible for data mapping.
Monitored and troubleshooted day-to-day database activity.
Worked with Goldengate replication technologies.
Migrated databases between servers.

Confidential, Chantilly, VA

Database Administrator

Responsibilities:

Responsible for solving problems dat users and developers encounter during day to day.
Performed and monitor database backups.
Provided 24x7 database support.
Managed over 100 gigabytes of data.
Worked independently and minimal supervision to ensure dat the applications are operating efficiently.
Moving non ASM instance to ASM.
Involved in the logical and physical design of Data warehouse and Operational data Store.
Resolved help desk tickets as assigned and provide 24-hour on call support.
Transport Data between database.
Monitored space issues, database locking, performance issues, and other key metrics.
Translated business and technical requirement into appropriate models.
Provided input to forecasts the future of database, performed monitoring, identified and correction of performance bottlenecks to ensure peak performance.

Confidential - Los Angeles,CA

Quality Assurance Analyst

Responsibilities:

Reviewed business requirements documents of the core application and developed test cases. Performed Integration, Functional, System, User Acceptance Testing and Regression tests.
Performed validation, ran test scripts and documented the output.
Participated in all phases of the SDLC.
Created Requirement Traceability Matrix and mapped test cases according to requirements.
Did parameterization to accurately emulate the real user behavior.
Reported progress to management, report bugs and did regression testing.
Review Client requirements to perform end user testing and validation of the application.
Involved in all phases of testing and post deployment maintenance.
Did parameterization and retesting to confirm the functionality.
Report progress to Business Analyst on daily basis.