We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

Lincolnshire, IL

SUMMARY

  • 8+ years of experience in IT industry as an Oracle Database administrator, having exclusive experience in production support, installation, configuration, upgrades, cloning, space management and database security with Oracle Software 11g/10g/9i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.
  • Possess high competency in advanced DBA skills such as backup, recovery & performance tuning.
  • Successfully resolving problems which involve in-depth knowledge of oracle architecture, connectivity, backup/restore, database corruption, security etc.
  • Problem determination and Trouble shooting in Development, Test and Production Environments.
  • Providing 24x7 Production Support for Oracle databases.
  • Performing periodic maintenance tasks like Index rebuilds, Table Analysis and data purge to ensure efficiency and reliability of the applications and databases.
  • Preparation of High Level document, Detail Level Design document and other relevant documents for development process.
  • Knowledge Transition by preparing plans, work schedule, understanding documents, managing transition calls and tracking transition status.
  • Installation/Maintenance/Upgrade of Oracle RDBMS Server 9i, 10g and 11g.
  • Refreshing, migrating and upgrading databases.
  • Experience in implementing RAC Database in Aix platform.
  • Conceptually strong knowledge on clustering.
  • Conceptually having Knowledge on GoldenGate.
  • Coordinating Oracle SR engineers for resolving the Issues

TECHNICAL SKILLS

Core Strengths: Oracle Database (RAC and Standalone) Administration, SQL, UNIX.

RDBMS: Oracle 9i, 10g, 11g Administration

Operating Systems: LINUX, AIX, HP-UX, Sun Solaris, Windows 2000, 2003, 2007

Programming Languages: SQL, Shell Scripting.

Tools: Enterprise Manager, Oracle Grid Control (10g, 11g and 12c), TOAD, SQL Developer.

PROFESSIONAL EXPERIENCE

Senior Oracle DBA

Confidential, Lincolnshire, IL

Responsibilities:

  • Deploy database changes on production needed for new requirements, to fix application defects or performance issues on Sun OS, Linux and AIX.
  • Knowledge Transition for database activities from the existing teams.
  • Perform activities of data maintenance, table maintenance, database re-organizations, data archival and other efforts typically undertaken to improve the efficiency and reliability of the applications and databases.
  • Perform database activities like schema backup/restore, import/export, required for the health of the application and release processes.
  • Analyze database activity, perform application database performance and tuning activities and maintain development, test and production databases.
  • Perform analysis and reporting of results from processing and database monitoring.
  • Maintain Database Alerts.
  • Proactively maintain stability of production databases.
  • Hands-on experience in High-availability CRS, ASM and Data Guard
  • Periodic data purge to follow retention policies and space constraints.
  • Work with application team and production support team to debug production issues.
  • Good Exposure in disaster recovery, routine maintenance for Oracle databases.
  • Good Exposure in Oracle cluster ware and HACMP cluster ware concepts.
  • Good Exposure in Oracle Recovery Manager (RMAN).
  • Having expert knowledge in Configuring Recovery Catalog Database and maintaining RMAN.

Environment: Oracle 9i, 10g, 11g, RAC, Dataguard, Toad for Oracle, AIX, SUN Solaris.

Oracle DBA

Confidential

Responsibilities:

  • Installation and Troubleshoot of Real Application Cluster (RAC) Database and Cluster ware.
  • To troubleshoot and resolve all the Database Issues, Network Issues and the Application Issues.
  • Worked in Production, Development, Testing and Implementation environment on Linux and AIX
  • Involve in various Implementations like (DB Creation, Patching, Cloning and Up gradation) on Database Tier.
  • Database Administration and Maintenance.
  • Setting up BACKUP strategy and disaster recovery procedures to ensureminimal downtime and data loss.
  • Good Exposure in disaster recovery, routine maintenance for Oracle databases.
  • Involved in Implementation of RMAN backup strategies.
  • Involved in configuring of ASM Databases and Migration of Non-ASM Databases To ASM databases Using RMAN
  • Handling alone in validating the Developed scripts for Hot and Cold Backup and Database Refresh
  • Implemented Symantec net backup.
  • Monitor physical and logical backup for Integrity and checking the Data files consistency using DBverify.
  • Check the log alert files if any problems occurred and necessary action to rectify them.
  • Having expert knowledge in Configuring Recovery Catalog Database and maintaining RMAN
  • Analysis and Documentation of the existing database architecture.
  • Applying the Critical Patch Update (CPU) based on the requirement
  • Preparation of High Level document, Detail Level Design document and other relevant documents for development process.
  • Providing support as required and mentoring team members while solving technical problems and providing technical guidance on solutions.

Environment: Oracle 11g RAC database, AIX.

Oracle DBA

Confidential

Responsibilities:

  • Migration Oracle Server databases.
  • Database Administration And Maintenance
  • Managing Tablespace and Datafiles.
  • Managing Security (Creating users, logins and roles, granting permissions)
  • Performance Monitoring and tuning.
  • Checking database locks and clearing the blocking sessions.
  • Worked on user managed backup strategies like online and offline.
  • Implemented Backup and Recovery strategies using RMAN(migrated from user managed backup to RMAN)
  • Performed Cloning of database.
  • Integration of Patches, Creation and Modification of tables in the database, Execution of Jobs, Bug fixing etc.
  • Resolving user requests for the technical issues as well as various other tasks for the development environments.

Environment: Oracle 9i, 10g, 11g, Toad for Oracle, AIX, SUN Solaris.

Oracle DBA

Confidential

Responsibilities:

  • Installing and Configuring Oracle 10g, including service pack deployments
  • Automatic Storage Management installation, configuration and management
  • Migration of oracle databases.
  • Database Administration and Maintenance.
  • Implementing disaster recovery plans.
  • Working on Stored procedure and Triggers
  • Working Imports and Exports utilities.
  • Managing Security (Creating users, logins and roles, granting permissions)
  • Performance tuning of databases using AWR, ADDM and OEM
  • Working on backup & Recovery
  • Creating Index & managing other objects of Database.

Environment: Oracle 10g, 11g, Toad for Oracle, AIX, SUN Solaris

Hire Now