Database Administrator Resume Omaha, NE - Hire IT People

SUMMARY

Certified Oracle Professional wif 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 teh development environments
Strongunderstanding of RDBMS concepts, database best practices and work flow procedures
Thorough understanding of indexes, index management, and optimizer statistics
Well conversant wif 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 wif minimal supervision or guidance.

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Database Administrator

Responsibilities:

Provide support for teh development/production environments for both RAC and single instance.
Responsible for all backups and restoration. Clone database for developers.
Help teh 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 teh performance of databases and maintain metric for future use.
Capacity planning to accommodate teh growing amount of data.
Work closely wif project development team to understand their needs and deliver appropriate services wifin teh 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 teh size of teh database.
Responsible for troubleshooting and resolution of database issues.
Work wif security monitoring and encryption tools.

Confidential - Columbus, OH

Database Administrator

Responsibilities:

Performed migration/upgrade from 10g to 11g, and applied patches.
Tuned SQL for teh new and existing environment.
Installed OEM and Statspack and used these tools for performance and tuning.
Worked wif teh 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 wif 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 teh applications are operating efficiently.
Moving non ASM instance to ASM.
Involved in teh logical and physical design of Data warehouse and Operational data Store.
Resolved halp 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 teh 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 teh core application and developed test cases. Performed Integration, Functional, System, User Acceptance Testing and Regression tests.
Performed validation, ran test scripts and documented teh output.
Participated in all phases of teh SDLC.
Created Requirement Traceability Matrix and mapped test cases according to requirements.
Did parameterization to accurately emulate teh real user behavior.
Reported progress to management, report bugs and did regression testing.
Review Client requirements to perform end user testing and validation of teh application.
Involved in all phases of testing and post deployment maintenance.
Did parameterization and retesting to confirm teh functionality.
Report progress to Business Analyst on daily basis.