Oracle Data
Resume:
SANDEEP
*******@************.***
SANDEEP
Professional Summary:
Oracle DBA with over 6+ years experience maintaining Oracle Database
running on UNIX/LINUX ( Sun Solaris, HP-UX, AIX,RedHat Linux) and Windows.
. Experience as On-Call 24x7 production DBA support,
application/development DBA.
. Extensive knowledge on database administration for Oracle 8i, 9i, 10g
and 11g, with experience in very large scale database environment and
mission critical large OLTP and OLAP systems.
. Involved with installation and maintenance of ORACLE 10g RAC/oracle
11gRAC and standby database for High Availability and Disaster
Recovery purpose.
. Experience in managing Oracle databases running on MS-Windows, NT
Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
. Hands on experience in Oracle 10g/11g RAC implementation &
administration (Oracle Clusterware setup and configuration, RAC
installation using ASM, Grid Installation).
. Good experience RAC Clusterware administration, Configuration and
Patching.
. Extensive experience in Dataguard configuration, implementing and
maintaining standby databases.
. Hands on experience in Grid control, Streams, GoldenGate Replication.
. Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF,
STATSPACK, AWR and ADDM.
. Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) for
database monitoring/performance/diagnostics.
. Extensive experience in Database Backups RMAN (Full/Incremental
backups) and in traditional hot/cold backups.
. Experience in LOGICAL BACKUPS and Database migration tools with DATA
PUMP, Export/Import and Transportable Tablespaces.
. Good experience in writing/editing UNIX Shell Scripts.
. Good experience in PATCHING AND UPGRADATION. Expertise in upgrading
Oracle Development and Production databases from 8i to 9i, 9i to 10g &
11g, 10g to 11g.
. Extensive knowledge and experience on managing very large Data
Warehouse databases.
. Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and
Triggers.
. Extensive experience in configuring and implementing ASM and
proficiency in using ASMCMD and ASMLIB.
. Experience in Flash-Back Technology.
. Experience in Database Refresh and patch management and in Database
cloning with RMAN and manual methods.
. Experience in Capacity Planning and Bench Marking.
. Developed database monitoring/health check alert scripts for database
uptime/downtime status, and sizing issues using grid control (OEM).
. Proficient in raising TAR with Oracle Support and using Metalink to
resolve the bottlenecks in the database environments.
. Excellent Communication skills, co-ordination and communication with
system administrators, business data analysts and development teams.
TECHINICAL SKILLS:
RDBMS Oracle 11g RAC, Oracle 10g RAC, oracle 9i, oracle
8i, Oracle 7.3, SQL Server, MySQL.
Operating Systems Solaris 9/10, Linux RHAT 4/5,6, HP-UX 10.x/11.x,
AIX 5.2/5.3, Microsoft Windows NT,2000/2003/2005.
High Availability, Oracle 10g RAC, Oracle 11g RAC,
Tuning
& Monitoring Products
Tools & Utilities ASM, Data Guard, Grid Control (OEM), Tkprof,
Statspack, AWR,
ADDM, ASSM, Oracle SQL Developer, TOAD, RMAN,
Export/Import, DataPump (expdp/impdp), SQL Loader.
ETL & Reporting Tools Informatica, Power Center 8.5/8.0,Data
Stage6.0,1.0,
Business Objects Xi R26.1, Oracle Data Integrator,
SAS
Backup Tools Veritas NetBackup, NetApp, HP OmniBack, TSM,EMC
Programming Languages C,C++,Asp.Net, XML, HTML, DHTML, CSS, Java
Education: Bachelor of Technology
Professional Experience
Biogen Idec Inc., Boston, MA
Aug 09 - Present
Sr. Oracle DBA
Responsibilities:
. 24x7 Production database and applications support.
. Installed, configured, and maintained Oracle 10g and 11gR2.
. Upgraded databases from Oracle 9i, 10g to 11g.
. Involved with installation and maintenance of ORACLE 10g RAC/ORACLE
11g RAC and Standby Databases (Oracle DataGuard) for High Availability
and Disaster Recovery purpose.
. Restoration and Recovery of databases at the times of occurrence of
critical failures.
. Responsible for installing, upgrading and configuring the Oracle
environment by creating databases, storage structures and objects,
database backup and recovery, monitoring and optimizing database
performance.
. Applied CPU patches.
. Implemented Oracle database backup & recovery solutions using RMAN and
manual methods.
. Performed block recovery using RMAN.
. Moving data between databases using Data Pump.
. Performed large batch jobs, and tuning of SQL queries and database
systems.
. Created User accounts, Roles and granting required access permissions
and privileges to the database based on the applications they are
accessing.
. Partitioned large tables for better performance and manageability.
. Installed and configured GoldenGate for replication.
. Responsible in configuring and backing up database using RMAN, Hot
backups, Cold backups and Logical backups.
. Migrated databases from Sun Solaris, HP-UX to IBM AIX, and Windows to
Linux.
. Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
. Worked with Data Pump to take the logical backups of databases.
. Experienced in performing Point-in-Time Recovery.
. Performed Capacity Planning and Bench Marking
. Load and Transform data using SQL*Loader and External Tables
. Logical and Physical Database Design
. Clear documentation was prepared on all the processes like program
specification, bugs fixing logs & change requests for future
reference.
. Performed capacity planning, Extracting, Transforming and Loading
(ETL) data using SQL*Loader and External Tables.
Environment: Oracle 11g RAC/10g RAC, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM
AIX, ASM,OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump,
SQL*Loader, GoldenGate
Walgreens, Lincolnshire, IL
May 08 - Aug 09
Oracle DBA
Responsibilities:
. Installed, configured, and maintained Oracle 10g and 11gR2.
. Upgraded databases from Oracle 9i, 10g to 11g.
. Involved with installation and maintenance of ORACLE 10g RAC/oracle
11gRAC and Standby databases (Oracle DataGuard) for High Availability
and Disaster Recovery purpose.
. Responsible for installing, upgrading, patching and configuring the
Oracle environment.
. Implemented Oracle database backup & recovery solutions using RMAN.
. Extensive uses of Oracle Data pump Exports/Imports utility for moving
data among the servers.
. Performed large batch jobs, and tuning of SQL queries and database
systems.
. Created User accounts, Roles and granting required access permissions
and privileges to the users.
. Partitioning and re-organization of table and indexes.
. Configured and implemented Oracle Streams.
. Implemented downstream capture at the destination database using
Oracle Streams.
. Responsible in configuring and backing up database using RMAN, Hot
backups, Cold backups and Logical backups.
. Written scripts for the automation of backups and clonings
. Migrated databases from HP-UX to IBM AIX.
. Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
. used Data pump to take the logical backups of databases.
. Involved in designing logical and physical data models using Erwin.
. Migrated databases from HP-UX to Sun Solaris, and Windows to Linux.
Environment: Oracle 11g RAC/10g RAC, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM
AIX, ASM,OEM (Grid Control), RMAN, Explain Plan, Data Pump, SQL*Loader,
AWR, ADDM
Huntington Bank, Columbus, OH
Nov 07 - May 08
Oracle DBA
Responsibilities
Provided 24X7 support for all the production and development databases.
Installed and configured Oracle 10g.
Performed upgrades from Oracle 9i to 10g.
Administration of Oracle Applications versions 11i.
Other duties include applying oracle database patches, design and creation
of databases as per user requirement, creation of database users,
monitoring, tuning, troubleshooting, backup and recoveries.
Applied Oracle Applications and database patches.
Cloned/Refreshed Oracle Databases and Oracle Applications.
Responsible for optimizing the queries and application tuning.
Perform SQL tuning and assist developers with coding PL/SQL.
Provided support to Application Database Administrators in designing the
database.
Installed and Implemented Backup & Recovery procedures.
Implement Hot, Cold and Logical backup plans.
Implement "Stored Procedures and Triggers" based on business plans using
PL/SQL.
Automation of data load using Korn shell scripting and SQL*Loader.
Responsible for setting and managing user accounts, Granting required
privileges to users.
Defining and Implementation of backup and recovery strategies.
Perform other regular DBA activities including space management and
performance monitoring.
Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
Continuous monitoring of database performance during peak and non-peak
loads using STATSPACK.
Involved in process improvement, Oracle Server
Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup
& Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning,
Application Tuning, Security Administration, Data Warehousing, Data Guard,
Oracle Advanced Replication, Real Application Clusters, Oracle Standby
Servers.
Environment: oracle 11g/Oracle 10g RAC/9i/8i, REDHAT LINUX, ASM,OEM (Grid
Control), IBM AIX, RMAN, Explain Plan, Data Pump, EXP/IMP, SQL*Loader, AWR,
ADDM
Bharti AirTel Ltd, Hyderabad, India
Jul 06 - Oct 07
Oracle DBA
Responsibilities:
. Maintenance of Oracle Production, Development, Testing and QA
databases.
. Installation and configuration of Oracle 9i, 10g databases.
. End-user requests in terms of assisting them in effectively create
tables, views, packages, sequences, schema refreshes.
. Worked with developers to provide queries and tuning the queries for
better performance.
. Issues related to Space Management, Locks, Database Hit Ratios, Backup
failures and UNIX related On-Call alerts.
. Resource Management (Create and manage Indexes, Clusters, Tables),
allocate and manage physical storage structures like Data files, Redo
logs, Control files. Allocate and Manage logical storage structures
like Table spaces.
. Database backup & Recovery.
. Load data using SQL*Loader.
. Alert monitoring and Ticketing.
. Developed SQL, PL/SQL Programs such as procedures, functions, packages
and triggers
. Coordinated with developers and users connecting to different
databases, setting policy and procedures as they relate to database
maintenance, security, backup & recovery, SQL coding guide lines.
. Coordinating Backup and Recovery operations over all databases.
. Creation of users and Granting them privileges and roles.
. Export and Import Data according to the users request.
Environment: Oracle 10g RAC/9i/8i, SUN SOLARIS, REDHAT LINUX, OEM (Grid
Control), RMAN, Explain Plan, Data Pump, EXP/IMP, SQL*Loader, STATSPACK,
AWR, ADDM
State Bank of Hyderabad, Hyderabad, India
Feb 05 - Jun 06
Oracle DBA/Developer
. Involved in 24x7 production database maintenance and on-call support.
. Responsible for administering and supporting production and
development Oracle 8i databases. Migrated production and development
environments from Oracle 8i to Oracle 9i environment.
. Responsible for installing, upgrade and configuring the Oracle server,
creating databases, storage structures and objects; database backup
and recovery, monitoring and optimizing database performance.
. Designed backup and recovery procedures for OLTP system. Conducted
periodic cold and hot backups.
. Instance cloning done to create test and training environments.
. Developed SQL, PL/SQL Programs such as procedures, functions, packages
and triggers
. Partitioned large tables to increase the performance.
. Configured scripts to monitor activity with database.
. Generated scripts for daily maintenance activity like analyzing the
tables/indexes, and monitoring their growth rate.
Environment: Oracle 10g RAC/9i/8i, SUN SOLARIS, WINDOWS, OEM (Grid
Control), RMAN, Explain Plan, Data Pump, EXP/IMP
Contact this candidate