Summary

• Over 6+ years of IT experience in Oracle Database Administration on various operating systems such as Linux, UNIX (HP UNIX and Solaris), Windows NT, Windows 2000/2003
• Experience on OLTP and DSS Systems and supported on 24X7 operations
• Expertise in security, monitoring activity, installation, backup and restores, recovery, tuning and SQL & PL/SQL
• · In depth knowledge and extensive working experience in Oracle database administration such as data modeling, database design, performance tuning, system set up and upgrade, backup and recovery.
• Excellent understanding of Oracle architecture and Oracle tunable parameters
• Excellent understanding of Oracle RDBMS 8i through 10g and Oracle data dictionary (On Sun Solaris 2.x, HP UX 10.x/11 and Win NT/ 2000 environment)
• Successfully implemented Oracle10g(R2) RAC: ASM storage devices, RHEL4/3
• Install, Configure, and Create RAC CRS and Database Instances by using Response files (silent installation) and SRVCTL commands
• Tuning Linux system level parameters for Oracle RAC such as HugeTLBs(vm.nr_hugepages), NFS tcp_slot_table_entries, net.core.rmem_max, and net.core.wmem_max
• Setup Data Guard for production RAC Database in Physical Standby Architect.
• Hands on experience in Oracle advanced technologies such as 10g RAC, OEM, Grid Control, Data Guard (both logical and physical), partitioning, RMAN.
• Implemented a standby database operation using Oracle9i, 10g Data Guard for data loss and also provides graceful switchover and switchback between sites for a planned OS and hardware maintenance.
• High-volume production database support, Oracle Fail Safe implementation (Data Guard), backup plans and implementation, Performance monitoring and tuning (Statspack)
• Exprience in implementing and using of Oracle 10g new features like Data Pump, ASM, Flash Back Technology, Transportable Tablespaces and Automatic Workload Repository
• Planning and scheduling Physical Backups using RMAN and Manual methods and Logical Backups (Full, User, Table)
• · Oracle Installation, upgrade and migration (Oracle 8.1.x, 9i and 10g )
• Shell scripting for automating, monitoring and performing routine database jobs.
• Vibrant team player with belief in taking positive approach towards issue resolution

Skill sets

Hardware: Sun SPARC E10k,HP T500,HP T600.
RDBMS: Oracle 7x, 8x, 9x & 10G
Languages: Exposure to PL/SQL, VI Editor, UNIX Shell scripting,
Tools & Utilities: Oracle's OEM, Dataguard, SQL Loader. Tuning pack like Oracle expert, SQL analyze RMAN, EXP, IMP, EXPDP, IMPDP, DBASSIST, SVRMGRL
Application Tuning: AWR, SQL Trace, TKPROF, Explain plan, Waitevents and Statspack.
Miscellaneous: Conversant with MS-Office suite

Confidential, CT
Jan 09 - Current
Database Admin

This project is basically for Production Support for six line of business for client. This project includes providing 24/7 support for production, Dev and QA environment also to the survival critical production databases, All activities are SLA driven and bound to be accomplished in timely manner. Project involve working with complex onsite and offshore model where onsite is primary responsible for support and also for weekend support, This environment includes working with variety of oracle versions like 8i to 11gr2. Providing support for all the mission critical and HA databases with rac and exadata environment,

Responsibilities:

• Monitoring and Handling the Scheduled Production support Jobs, Handled the production Abort jobs and respond as per SLA with doing investigation and Creating Tickets & deciding the priority.
• Involved in Analysis of Production Issues and Providing root cause analysis and summary reports for Supply Management with Data Fix and Job Fix.
• Widely used Autosys for automation and as job scheduler where thousands of jobs running pretty much everything is scripted.
• Involved in Migration of Jobs from Dev/Stage to Production Environment.
• Involved in creating, upgrading, patching, decommissioning of the databases.
• Responsible for planning and conducting DR testing activities for the DR servers.
• Responsible for creating and documenting all the database related issues for the team.
• Interact with the clients in order to understand the requirement and suggest solutions.
• Close communication with other supporting groups like UNIX SA, Storage, Autosys Group, Netbackup team, all the task performed through constant communication with groups and clients involved.
• Support includes lots of communication and documentation. Communicating to the groups and customers across the globe.
• Responsible and accountable for managing more then 1500 databases across 500 servers.

Environment: 3node Rac, 6node Exadata, Oracle 8i to 11gR2, BMC Remedy, Autosys, RMAN, BCV Sync and Split, BCV cutover, Dataguard, Veritas cluster, OEM,ASM,

Confidential, MO
Role: Oracle DBA
May 2008-Mar 2009

Responsibilities:

• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Installed and setup 10g Oracle Enterprise Manager Grid Control (10.2.0.3) and Mass Agent Deployment on several hosts.
• Installed Oracle Dataguard for Oracle Disaster recovery, High Availability and data protection.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL and UNIX Shell Scripts for backups.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL, PL/SQL statements, reorganize database objects and design indexes to improve response of queries.
• Involved in designing data warehousing boundaries and parameters, Data Transformation, PL/SQL.
• Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
• Working Experience with Latest TOAD 9.6 having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents,Logminer, Segment Advisor, Database Monitor, Server Stat's, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance
• Performed administrative maintenance, monitoring both Oracle and MS SQL Server database systems in a global 24x7 operational environment.
• Implemented Oracle database backup & recovery solutions using RMAN and Exports/Imports.
• Used ASH reports to tune the performance of database.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created user accounts, roles and granting access permissions to the database.
• Monitored data transfer between the Database servers using DataStage, Oracle Streams/CDC, SQL*Loader, MS SQL Log shipping and DTS packages.
• Extensive Responsible in configuring and backing up database using RMAN for hot backups, cold backups and logical backups
• Installed and Configured Oracle 10g databases on Linux.
• Performed automated backups and scheduling using Perlscripting.
• Upgraded Oracle databases from 9i to 10g.
• Migrated data from MS SQL Servers to Oracle, and vice versa.
• Involved in designing logical & and physical data models using power designer.
• Implemented Oracle Database 10g two node Real Application Cluster (RAC) on a Linux system
• Installed and configured Oracle Enterprise Manager 10g Grid Control.

Environment: Oracle 11g/10g/9i, Red Hat Enterprise Linux 4.x, AIX 5.2, OEM, PL/SQL, Oracle 9i/10g RAC, TOAD, Erwin, STATSPACK, EXPLAINPLAN, IBM DataStage,C++, Weblogic, SQL Server 2005.

Confidential, NY Sep 2005 - Mar 2008

Database Administrator

Confidential, is the most experienced Application Service Provider (ASP). They use a highly automated, efficient, systematic approach to deliver managed hosting, application management, remote management, professional services, and eBusiness development. They have different clients like UniVision, Technocolor, Ny Govt. Agency,State Firm Insurance etc.

Project Scope & Responsibilities

• Creation of ORACLE databases.
• Standardization of ORACLE database environments.
• Install, Configure, and Create RAC CRS and Database Instances by using response files (silent installation) and SRVCTL commands.
• Upgraded few 8i and 9i databases to 10G RAC on RHEL4 U4.
• Tuning NIC Cards by setting Full Duplex mode and speed to 1000MB/s to improve the performance.
• Successfully implemented Adding/Deleting RAC nodes, TAF, Load Balance.
• Setup and documented Data Guard Fail-Over/Switch-Over/Read-Only scenarios in RAC.
• Installation and configuration of Stats Pack, snapshots and analysis of Stats pack performance report and subsequent tuning of production databases.
• Database planning and design of logical storage structures and capacity planning for future growth.
• Converting dictionary-based tablespaces to locally managed tablespaces to eliminate fragmentation, better performance and reduced maintenance.
• Develop and administer processes for capacity planning.
• Configuration and setup of OEM monitor production databases.
• Design, deployment, monitoring and troubleshooting of rollback segments
• Installed and upgraded the oracle server 8i, 9i, 10g
• Configuring database with suitable block size, multiple pools and storage parameters for best performance.
• Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, Data Pump tools.
• Rich experience in planning and implementation of backup/recovery strategies usingconventional OS utilities as well as RMA
• Documented policies and procedures for each project including recovery in case of disaster using procedures, such as daily script creation of control files and copying, binarycontrol files to backup directories, database copying, and renaming a database on different servers
• Migration of data from the Production to Test/Dev databases as per the requirement of the Development team and restoring the data if it is corrupted.
• Optimizing the SQL's for optimum performance by using TKPROF, EXPLAIN Security Administration including the management of profiles, roles, users and their privileges PLAN, AWR/Stats Pack Reports

Education

B.S. in Electronics