PROFESSIONAL SUMMARY:

• IT professional with 8 years of experience as an Oracle Database Administrator. Experienced in administration, installations, all phases of SDLC, migrations, up gradations, patches, performance tuning, backup and recovery, space management, database security.
• Extensive experience in installing, configuring, monitoring and maintaining Oracle Software 11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.
• Strong background knowledge installing and configuring Oracle 10g R2 RAC (Real Applications Clusters) with ASM and maintaining other Oracle database products on Sun Solaris, Red Hat Linux, IBM-AIX, Windows environments.
• Experience in fulfilling DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• Migrated single instance databases to multimode 10g RAC environment for high availability and load balancing.
• Solid experience on Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN.
• Installed, Configured and maintained 2 Node 11gR2 RAC with ASM production databases. Installed and Configured Oracle 10g RAC (3 node cluster), CRS using ASM.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Upgrading databases to higher versions, applying patches and patchsets.
• Experienced in applying patches including Patchsets and CPU patches on Standalone, RAC and Standby Database.
• Experience in Installing and configuring Golden Gate on RAC clusters
• Close to 2 years of experience working with Oracle Golden gate for performing database upgrades, Cross platform migrations and Replications.
• Replicated databases using Oracle Golden Gate for reporting purposes in OLTP environment with minimum lag.
• Administration experience in Very Large Multi Terabyte Databases (VLDB) environments.
• Extensive experience in Configuration of RMAN, Planning and scheduling Backups using RMAN, Hot Backups and Logical Backups, Oracle utilities and tools like OEM, Import-Export, Data Pump, and DBCA Installation, maintenance and tuning of RAC applications.
• Experience in implementing, configuring and managing Data Guard with Physical Standby Databases for High availability configuration.
• Experience in Real Application Cluster (RAC) environment with Auto Storage Management (ASM) on Oracle 10g and 11gR1.
• Hands On experience working with Oracle Streams & has successfully completed projects with complete end-to-end support for Oracle Streams.
• Delivering SQL and Database performance tuning services via V$/GV$ views, Explain Plan, AWR (statspack) reports, ADDM, SQL Tuning Advisor, Oracle Enterprise Manager (OEM), Grid control.
• Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Experienced in Oracle Support (raising SR) processes for technical requests through Metalink.
• Experience in Managing oracle databases, dimensional modeling, data warehousing.
• Extensive experience in solving database related design issues and also experienced in re-designing existing databases to the required needs.
• Excellent verbal and written communication skills. Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.
• Strong ability to handle multiple projects simultaneously through completion and ability to work independently or in a team environment and ability to function successfully in a highly stressful environment.
• Participation in on-call (off hours) schedule in providing technical support.

TECHNICAL SKILLS:

Operating Systems: HP-UX 11.x, Sun Solaris 9/10, IBM-AIX, RHEL 3.x/4.x/5.x, Windows 200x/Vista/XP/Prof.

RDBMS: Oracle 11g/10g/9i/8i.

Languages: SQL, PL/SQL, C, C++, JAVA, UNIX Shell Scripting.

Tools: RMAN, Oracle Enterprise Manager (OEM), Grid Control, SQL*Loader, Export/Import, Data pump export/import, TOAD, iSQL*PLUS.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK.

WORK EXPERIENCE:

Confidential

Oracle DBA.

Platform: RHEL, IBM-AIX, Oracle 11g/10g, RAC, ASM, RMAN, PL/SQL, UNIX scripting.

Responsibilities:

• Responsible for administration and supporting Oracle 11g, 10g RAC databases in DEV, QA, UAT and Prod Environments
• Installed and created 11g databases on both standalone servers and Real Application cluster (RAC) servers.
• Involved in administration of over 150 Oracle 11g R1/10g R2 instances.
• Installation and Maintenance of Oracle 10g, 11gR2 RAC on IBM-AIX, LINUX, Solaris.
• Maintained Production databases upto 7TB
• Replicated databases using Data Guard for reporting purposes in OLTP environment with minimum lag.
• Installed, Configured and maintained 2 Node 11g RAC with ASM production databases. Installed and Configured Oracle 10g RAC (3 node cluster), CRS using ASM.
• Installed and configured Golden Gate on RAC clusters.
• Created Unix Shell Scripts for validating database parameters and tracking the build process.
• 24X7 production support.
• Setup of Disaster Recovery databases (Data Guard).
• Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Installing and Configuring Recovery Manager (RMAN)
• Worked on oracle application patches upto 4-5-00
• Created & Managed Jobs using AutoSys Job Scheduler, CronJobs
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas
• Monitored OEM tickets and resolving them based on the priority.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Extensive experience in capacity planning and participated in capacity planning meetings for Project requirement stages.
• Applied PSU patches to Oracle Databases and Oracle Applications.
• Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, SQL Trace, TOAD and Oracle Enterprise Manager
• Export and Import of database objects to copy from one database to another database between different environments
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities)
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc

Confidential, Bellevue, WA

Oracle Database Administrator.

Platform: RHEL, IBM-AIX, Oracle 11g/10g, RAC, ASM, RMAN, PL/SQL, UNIX scripting.

Responsibilities:

• Installation, Configuration, Designing and Maintaining of Oracle 11g/10g on RHEL and AIX platforms.
• Administering Oracle 11g/10g production, test, development environment on RHEL, IBM-AIX.
• 24X7 production support.
• RAC troubleshooting.
• Maintaining schemas and partitioning tables.
• Implemented the security using ORACLE Database Vault.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instance.
• Involved in BMC Patrol installation and configuration.
• Performance maintenance such as Rebuild Indexes, tables etc
• Involved in conducting DR (Disaster Recovery) environments.
• Documented the various migration methodoligies.
• Involved in the Installation activities of SQL-Server 2005/2008
• Experienced with cross site (active-active) data replication using Golden gate.
• Replicated databases using Oracle Golden Gate for reporting purposes in OLTP environment with minimum lag.
• Involved in the process of tuning and refining queries of various applications.
• Implementing 10g Data guard with one physical database
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Creating table spaces, tables and users for custom applications.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Hands On Experience in installing, configuring and managing Oracle 11g RAC with ASM.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experience in regular Database Administration activities such as Upgrades, Migration, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, capacity planning, script development, and documentation.
• Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring.
• Skilled in setting up/Installation and configuration of release 10g RAC R2 with ASM and Raw Devices and 10g CRS.
• Upgraded Production, Development databases from 10.2.0.2 to 11.1.0.2.
• Applied patches, patch sets and Critical Patch Update using OPatch and OUI.
• Excellent experience with OEM Grid control, TOAD which acts as a great platform where Database Quality, Performance and Availability functions for administration and development are considered.
• Worked on SQL, PL/SQL coding including creation of stored procedures, functions, packages, triggers.
• Performance monitoring, Database tuning and Application tuning, Cluster Interconnect tuning using Dictionary views, OEM Tuning Pack, Diagnostic Pack, AWR (Statspack) reports.
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR (statspack) reports, ASH, ADDM and OEM (Oracle Enterprise Manager) and Grid Control.
• Export/Import, Datapump to migrate database objects from one database to another.
• Daily DBA activities: managing datafiles, redo log files, control files, alert log files, trace files, tablespaces, segments, extents, data blocks & physical storage, database network connectivity, database security, database links, database users, granting/revokingsystem/object privileges, roles & resources, querying data dictionary tables for metadata, setting init.ora parameters.
• Experience with data modeling, physical and logical database design.
• Experience with materialized views which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
• Partitioning of large tables, indexes & rebuilding Indexes to improve the performance.
• Experience in monitoring and tuning system resources associated with the database performance hit ratios, I/O, lock and latch contention.
• Assisting developers with tuning of SQL, PL/SQL scripts to enhance the database performance.
• Find solution and resolve critical issues with Oracle Support.

Confidential

Oracle Database Administrator.

Platform:RHEL, Sun Solaris, Oracle 10g, 9i, ASM, RMAN, SQL, PL/SQL, UNIX scripting.

Responsibilities:

• Worked as a team member to provided 24x7support for Production and Development databases.
• Installation of Oracle software, administration of oracle 9i/10g production, test and development environments on RHEL, Sun Solaris platform.
• Involved in designing Data model for various reporting based Data marts, enhancement of OLTP data model. Starr schema, snowflake, ER diagrams using Erwin.
• Extensively worked on tuning of SQL query, batch jobs, optimizing batch process as well tuning various ETL jobs.
• Upgraded databases in production and development environments from 9.2.0.6 to 10.2.0.2 (Oracle 10gR2).
• Applying high priority, security patches, patchsets to oracle using OPatch Utility, runInstaller.
• Review of Database logical and Physical design.
• Install, upgrade and maintain Oracle software products/versions for on Linux and HP-UX.
• Installed RAC on Oracle 10gR1and worked on ASM feature with EMC Storage of Oracle.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Involved in designing Data model for various reporting based Data marts, enhancement of OLTP data model. Starr schema, snowflake, ER diagrams using Erwin.
• Extensively worked on tuning of SQL query, batch jobs, optimizing batch process as well tuning various ETL jobs.
• Adopted agile project management, played role of SCRUM master. Sprint based development and enhancement of new features and functionality on existing platform.
• Part of group responsible for implementing new technologies in firm by keeping business growth and demands requirement in mind, Migration of data centers, coordinated various IT imitative to support management and business initiative.
• Worked closely with capacity planning group on various performance-based SLA.
• Worked closely with business and product group to enhance functionality of pre paid platform to implement various clients requirement.
• Worked closely with Issue management group to escalate any client facing issues, performance of applications, SLA related issues etc.,
• Security User Management, Privileges, Role, Fine Grained Auditing, Risk Management, Profiling, Authentication.
• Data Migration as part of enterprise data warehouse project.
• Performed migration using transportable table space (TTS) to transport tablespaces across platforms.
• Extensive Performance Tuning, Memory (SGA) Tuning, RAC tuning, net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data Guard.
• Involved in Business Analysis and Requirements collection.
• Monitoring and management of various database components (logical & physical) like tablespaces, segments (tables, extents, rollback), Users (granting /revoking privileges, roles, synonyms), creating and rebuilding the indexes, database linksSecurity User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Find solution and resolve critical issues with Oracle Support.

Confidential, Charlotte, NC

Oracle Database Administrator.

Platform:IBM-AIX, Sun Solaris, Oracle 10g, 9i, RMAN, ASM, SQL, PL/SQL, UNIX Shell scripting.

Responsibilities:

• Worked as a team member for 24x7 support inboth production and development environments.
• Installation and creation of 9i and 10g databases for Testing, Development and Production on IBM-AIX and Sun Solaris environment.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes.
• Implemented the standard naming conventions for the fact and dimension entities and attributes of logical and physical model.
• Participated in JAD session with business users and sponsors to understand and document the business requirements in alignment to the financial goals of the company.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
• Used Bulk Collect feature to improve performance
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security
• Database Restore using RMAN, Cold Backup and Export.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle
• Corporation and installation of patches.
• Experience with SQL, PL/SQL coding, stored procedures, functions, packages, triggers.
• Created UNIX Shell scripts for different database tasks and export/import for data transfer.
• Creating primary database storage structures (tablespaces) once developers have designed an application.
• Perform other regular DBA activities including schema management, space management and performance monitoring.

Confidential

Associate Oracle Database Administrator

Platform:HP-UX, IBM-AIX, Oracle 9i/8i, RMAN, SQL, PL/SQL, UNIX Shell scripting.

Responsibilities:

• Installed and configured Oracle 8i, 9i on LINUX and IBM-AIX environments.
• Administering and supporting production and development Oracle 8i, 9i databases.
• Developed Transact-SQL scripts for reuse in normalizing incoming files along with creating SQL queries, ad hoc queries to produce custom data extracts.
• Worked on creating Database Objects - Schemas, Tables, Indexes (clustered and non clustered), Views, User defined functions (UDFs), Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Worked withT-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
• Efficient in building recursive queries using CTEs (Common Table Expressions).
• Worked on ETL (Extraction, Transformation and Loading) using Data transfer services (DTS), Service Broker and SQL Server Integrated Services (SSIS) from various Data sources.
• Upgraded databases in production and development environments from 8i to Oracle 9i.
• Setting and maintaining user accounts, granting required privileges and roles to users.
• Implement periodic Hot, Cold and Logical backup plans, RMAN backups.
• Handling day to day activities along with schema and space management.
• Creating primary database storage structures (tablespaces, datafiles, tables, indexes etc).
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Partitioned large tables to increase the performance.
• Performing all daily maintenance tasks. Interacting with oracle customer service as and when required.
• Implementing automated backups with RMAN using crontabs.
• Providing support to end users and developers.

Confidential

Oracle PL/SQL Developer

Platform:RHEL, Windows, Oracle 8i, SQL, PL/SQL, UNIX Shell scripting.

Responsibilities:

• Involved in the analysis, design, build, and testing phase of the life cycle for the project.
• Developed PL/SQL packages to capture end of day transactions.
• Implemented UTL HTTP oracle built in package to acquire data from external websites.
• Involved in designing the database, identification of the objects and creating tables.
• Latest features of Merge/Multiple Table Insert/Loading and logging error in a single statement/Grouping sets, Cube, Rollup have been used to improve the performance and reduce IO.
• Preparation of design specifications document.
• Designed and created database objects such as Tables, Views and Indexes.
• Designed and wrote Stored Procedures, Functions and Triggers.
• Created and modified data models using Designer 2000.
• Coordinated with Senior Developers and DBAs during design phase.
• Wrote scripts for Loading Data using SQL * Loader and Import/ExportAssisting the developers in tuning the SQL for optimized performance.
• Making changes for the existing shell scripts as per the needs.
• Extensively used Explicit Cursors in stored procedures.
• Developed PL/SQL scripts for exception handling.