SUMMARY

• Over 5+ 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 9i 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
• Install, Configure, and Create RAC CRS and Database Instances by using Response files (silent installation) and SRVCTL commands
• 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 9i,10g and 11g )
• Vibrant team player with belief in taking positive approach towards issue resolution

TECHNICAL SKILLS

Operating System: UNIX, Linux, Win NT/2k, DOS & SINIX

Hardware: Sun SPARC E10k, HP T500,HP T600.

RDBMS: Oracle 9x 10G and 11G

Languages: Exposure to PL/SQL, VI Editor, UNIX Shell scripting

Tools & Utilities: Embarcadero Tools like DBArtisan, Change Manager, OEM, Dataguard, SQL Loader. Tuning pack like Oracle export, SQL analyze RMAN, EXP, IMP, EXPDP, IMPDP, DBASSIST

Application Tuning: AWR, SQL Trace, TKPROF, Explain plan, Waitevents and Statspack.

Miscellaneous: Conversant with MS-Office suite

PROFESSIONAL EXPERIENCE

Confidential, MD

Oracle Database Admin

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 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 the entire 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, 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 than 1500 databases across 500 servers.

Environment: 4 node Rac, Oracle 9i to 11gR2, BMC Remedy, RMAN, Dataguard,, OEM, ASM

Confidential, MO

Oracle Database Admin

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 Perl scripting.
• 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 5.x, OEM, PL/SQL, Oracle 10g RAC, TOAD, Erwin, STATSPACK, EXPLAINPLAN, SQL Server 2005.

Confidential, NY

Oracle Database Admin

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.
• 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 using conventional OS utilities as well as RMAN
• 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, binary control 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, EXPLA
• Security Administration including the management of profiles, roles, users and their privileges PLAN, AWR/Stats Pack Reports