SUMMARY

• Over 3 year experience as a Database Administrator primarily in designing implementing and support for Oracle database
• Experience as Oracle Database Administrator in very large production Environment with Database implementation on Linux, Unix and Sun Solaris AIX, and windows 2003/2008 server
• Established and wrote the Database Administrator procedures document for the IT department. This document outline all standards for DBA group including installing/upgrading Oracle, Creating database, DBA tools, administration and monitoring, naming standards, policies, practices and procedures.
• Implementation of oracle backup and recovery strategies using RMAN (recovery manager) and creating RMAN script. Cloning of database using RMAN.
• Experience primary Administrator over window 2000 and 2003 cluster server including SQL server 2000/2005/2008 .
• Developed UNIX cell scripting with SQL server 2000/2005/2008 to provide automated auditing of enterprise environment.
• Experience in SQL Tuning and Database Tuning for every large Database( VLDBs) and OLAP and OLTP
• Experience working with Data Guard, Flashback(table/ version query), Data pump, RAC Data guard and Oracle enterprises manager (OEM 10g), including the grid and monitoring controls
• Tuning Experience using SQL LOADER, EXPLAIN PLAN, AUTOTRACE, TKPROF and STATSPACK utility
• RDBMS PATCH apply on TEST, Development and production instant to the requirement.
• Technical Database design and management of database activities and Resource Capacity Management.
• Database design. Creation of various database object like Table, Object types, Views, procedures, Functions, Triggers, Package, Sequences, synonyms, Snapshots.
• Coordinating with Developers and user connecting to different database, setting policy and procedures as they relate to database maintenance, security backup & recovery, SQLs coding guide lines etc.
• Experience working with data guard, flashback(table/version query), Data Pump, ASM, RAC and Oracle Enterprise Manager (OEM 10g), including the grid and monitoring control.
• Successfully resolving SQL Server problems which involves in - depth knowledge of SQL Server architecture, connectivity, replication, DTS, backup/restore database corruption security, programming etc.
• Practical solution to problem solving with creative ideas identify pattern linkages and underlying situation, documentation, consider customer need in evaluation of solution
• True team player, maintain client/customer relationship by providing timely, superior quality products and services: understanding of client/customer needs, opportunities and satisfaction criteria.
• Experience in managing and working throw the ORACLE's TAR escalation process using metal ink.
• Maintaining data integrity and tune database for optimum performance and availability and excellent in troubleshooting Oracle Database issues.
• Change Requirements Servicing, Bug Fixes, Testing and Integration and Releases of the enhanced programs.

TECHNICAL SKILLS

Databases: Oracle (11g, 10g, and 9i/8i), OEM, MS SQL Server and MS

Oracle Production: SQL*Plus, PL/SQL, ORACLE Enterprise Manager, Form 6i, Reports 6i SQL Loader

Tools: OEM, RMAN, Export, import, data pump, Tkprof, Statspack ASM, AWR, ADDM, TOAD 7.6, visual studio, Relational Rose, ERWIN, Toad, Grid control(10g), Symantec 13, MicromueNetcool/ BMCpatrol, SAM, SAN, NAS, VPN client FTP, FSTP etc.

Operating System: Red Hat Linux UNIX, SUN Solaris, MS-DOS WIN NT, Win 2000

Languages: SQL, PL/SQL, C AND C++

Applications: Oracle Applications R 11i 5.9, 11i5.10.2, Patching, cloning DB refresh Oracle enterprise manager(OEM), Oracle utilities (Import/export) SQL *loader and 10g data pump.

PROFESSIONAL EXPERIENCE

Confidential, VA

Oracle Database Administrator

Responsibilities:

• Installation of production and test oracle database server 9i/10g/11g
• Monitoring and troubleshooting of the database backup and recovery
• Up gradation of oracle database, Configuration of listeners, tnsnames and Unix Environment for oracle work group server database on production sites
• Demonstrate strong working experience of database administration, backup and recovery, modeling, tuning, monitoring.
• Monitoring and management of various database component (logical & physical) like table space, segments (table, index, rollback).
• User creation and enforcing security using privileges of roles.
• Experience in manage escalation and coordinate with interfacing teams
• Optimization and fine tuning and database by planning storage requirement, building index and altering storage clauses for tables and index.
• Maintenance of the production Server (up to 30 GB in size) and carrying out future enhancement as per client requirements.
• Monitoring and database by space management and ORA error and resolving according to that requirement.
• Taking the backup of database regularly, management Redo log files, control files, and monitoring data file.
• Conversion of database from file system to Oracle RDBMS using tools like SQL Loader and Unix Shell and perl scripting to automate the process.
• Experience in SQL Tuning for Very Large Databases (VLDP) and VLTP systems.
• Experience in RAC, Data Guard and oracle enterprise manager Grid control
• Experience in Flashback recovery by deleting the same database object in database.

ENVIRONMENT: Red Hat Unix, Oracle 9i/10g/11g, form 3.0/4.5/6, SQL server 8/7/6, pl/SQL, SQL.FSTP, putty

Confidential, VA

Oracle Database Administrator

Responsibilities:

• Provide Database Administration on Production, Testing and Development Database Servers.
• Create Database, Table space and Monitored table space & their growth and took proper actions.
• Taking backup of the database regularly (Hot and cold backup using logical backup physical and using Recovery manager)
• Clone/Refresh of production database to testing and training environments.
• Performance Tuning & Monitoring of the database using Stats Pack, TK proof, Explain plain
• Tracing the alert, Log file "ORA" messages, Monitoring Database to ensure smooth functioning of database.
• Coming up with custom-tailored backup/restore and disaster recovery plans for production servers.
• Managed Disk space allocation for table space and user object at physical level on servers.
• Providing consultation on SQL Server to our development teams.
• Change Requirement Servicing, Bug fixes Testing and integration and releases of the enhanced programs.
• Automated data loading scripts using Shell scripts, cron job and dbms job.

Environment: Oracle 9i/10g/11g, SQL Server 2000/2005/2008 , Oracle Enterprise Manager (OEM) 6.5, Toad, Unix, Aix, Sun Solaris, Windows NT, MS Access