Senior Oracle DBA Level III Resume

SUMMARY:

Conducted exhausting testing of data pump and prepared work instructions to implement data pump expdp for daily exports in place of existing daily logical backups(exp).
Extensive experience of oracle tools Export/Import, Datapump, SQL*Loader, RMAN, OEM, SQL *PLUS, STATSPACK, TKProf, ADDM, AWR & TOAD.
Installation & configuration of oracle 8i/9i/10g/11g (Standalone & RAC) on UNIX, HP - UX, LINUX & Windows NT.
Installation & configuration of Data guard (Standby database).
Managing and Implementation of Backup and Recovery of database.
Develop Logical/Physical database models and generate the schema for building the Oracle database. And perform detail space estimation for the Oracle database.
Installed and tested grid agent software in HPUNIX and LINUX servers.
Planning and implementation of development, testing and production databases.
Enrolling users and maintaining system security.
Database Tuning - Tuning Applications, Tuning Memory and Tuning Disk Usage.
Controlling and monitoring user access to the database.
Allocating system storage and planning future storage requirements for the database.
Monitoring and optimizing the performance of the databases.
Maintaining Archived data on storage.
Investigate suspicious database activities.
Excellent skill in SQL to solve complicated query.
Experience of Client/Server environment.
Upgrade from 9i to 10g/11g and migrate databases.
Establishing and ensuring the connectivity using Net8.
Strong communication & management skills.

TECHNICAL EXPERTISE:

Operating Systems: Windows NT, Windows 2000/2003/20082 & HP-UX 11.0 & 11i, Linux

RDBMS: Oracle 8i/9i/10g/11g, MS Access.

Tools and Packages: SQL * Plus, SQL*Net, SQL * Loader, TOAD, RMAN,RAC,GRID,Import, Export, Datapump, Oracle Enterprise Manager.

GUI: Developer 2000.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA Level III

Responsibilities:

Upgraded oracle8i/9i to 10g/11g (Standalone & RAC) databases.
Execute CR/TR as requested by developer.
Responsible to apply patch on Dev and Prod databases.
Perform day-to-day PROD and Dev database activities
Maintain database objects like tables, Views and Procedures.
Involved in DR testing which includes restoring DB’s using RMAN, recovering helping application and other team for testing.
Refreshed data between Prod, QA and DEV environments as requested by the application teams.
Work with development teams in resolving database related issues.
Make selected changes to improve security, recoverability, and ease-of-use.
Backup and restoring of database using RMAN and maestro job.
Sizing the database for future growth.
Perform SQL Tuning and other DB monitoring (DB instance management only).
Extensively used the remedy tool for Change management process like Change request and incident ticket creation.
Provide day-to-day support to application developer.
Was part of Oracle DB engineering team and participated in extensive testing and documentation for installation/upgrade of new 11gR1&R2 software, DB creation,CPU patching, Oracle client software installation/Upgrade across different OS like HPUNIX,Windows 2003/2008R2,Linux.
Provided escalation support for software installations and DB upgrades.

Environment: Oracle 9i/10g/11g, TOAD, PL/SQL,SQL*Loader, Import, Export, Oracle Enterprise manager, HPUX,Linux, Windows NT/2003/2008R2

Confidential

Database Administrator

Responsibilities:

Installation of Oracle.
Creation of database
Schema management; user creation, profiles, roles
Applying latest oracle patches;
Providing 24x7 on-call database support in replicated environment
Database link creation and managing password expiration for DB links.
Monitoring the growth of the database and initiating appropriate actions
Performing data refreshes and Data re orgs
Scheduling Oracle jobs for various schema operations like Index rebuilding and materialized view refreshes.
Providing support for the application team for applying data model changes in Production environment. Also involved in reviewing scripts written by the application teams before implementing in Production.
Analyzing the SQL queries using explain plan and creating necessary indexes
Generating & interpreting Database statistics using STATSPACK

Directorate of Systems

Confidential

Responsibilities:

Installation of Oracle 8i & 9i
Creation of Oracle databases
Migration from 8i to 9i
User creation and maintenance including roles.
Applying the oracle patches time to time
Maintaining PLSQL codes for various functional requirements i.e budgetary changes
Importing data received from field formations for analysis