SUMMARY

• Around 10 years of experience as Oracle Data Base Administrator also providing support for both development and production 11g/10g/9i databases on Various Platforms.
• Proficiency in Oracle database installations 9i, 10g, 11g on UNIX/LINUX, HP - UX, IBM AIX, SUN Solaris, Windows environment with hands-on experience in upgrading the Oracle databases. (10gR1 to 10gR2,9i to 10gR1,10gR2 to 11g).
• Experience on high volume databases with sizes varying from 100GB to 5 TBs of data.
• Experience in installation and configuration of Oracle 10g with RAC using ASM, configured user log on load balancing and failover on RAC database for high availability.
• Installed and Administered Oracle 11g ASM & 10g RAC with ASM & Oracle Clusterware File system (OCFS2).
• Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM).
• Monitored performance and availability of the VIS application a high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN.
• Planned and implemented DR & high availability solutions using OEL 10g Standby Database using Oracle Data Guard, 11g and 10g RAC.
• Having good knowledge on 11g Grid control and 12C Cloud control and intensively used for Diagnostic & tuning activities.
• Experience in applying oracle database patches using opatch utility.
• Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• Configured and Maintained Physical Data Guard for High Availability and offline reporting.
• Experienced in using 11g features Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid monitoring, and Recycle Bin.
• Hands on experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering Terabyte of Oracle Databases on Oracle 10g/9i/8i.
• Performed data replication, transformation and delivery of database transactions using Goldengate replication tool. Supported a large number of Development Databases
• Proficiency with Installation and maintenance of replication tool GoldenGate by creating extract process, extract pump, and replicate.
• Installed, configured, and resolved issues with the Oracle Streams utility, and with the Oracle Change Data Capture (CDC) utility.
• Engineering of the existing databases and provide both a Physical and Logical/Physical data model to maintain an existing Database.
• Proficient in administration activities like Installation, Configuration, Upgrades, Patches, TAR support, Cloning, Capacity Planning, script development and documentation.
• Experience in Migration of Database from 9i to 10g, 10g to 11g.
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using load testing tools.
• Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.
• Performed backups and crash recoveries using conventional hot/cold backups and RMAN.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).
• Experience in SQL, PL/SQL, Database procedures, Triggers, Packages
• Performing tuning of application with AWR Reports, tkprof, explain plan, Autotrace, Statspack and Oracle Enterprise Manager.
• Experience with designing and data modeling using ERWIN data modeler, converting the logical model to physical model.
• Experienced with installing, configuring and administering SQL server 2000/2005/2008 databases including migration from MS SQL server to oracle
• Experience with Repository Manager to import Metadata for sources and targets and the mapping designer to map source to the target.
• Experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using Load testing tools.
• Designing and Building Relational Databases architecture in OLTP, OLAP, client/server.
• Strong learning abilities with keen interest in learning new technologies and best practices with passion to take on challenges to deliver and add value to the clients, good communication and inter-personal skills, accustomed to work in a team environment with tight schedules, and capable of working efficiently under pressure and managing multiple projects.
• Extensive experience on OEM,TOAD (Tools for Oracle Application Developers), SQL*Plus and SQL*Loader as well as traditional UNIX command that requires for Oracle DBA
• Excellent working experience on EMC, NetApp and ASM Storage technologies.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, UNIX Shell scripting.

Database: Oracle 11g/10g/9i, SQL Server 2008/2005, MS-Access, NO SQL.

Application Tools: Oracle Grid control/Oracle Enterprise Manager, TOAD,DBCA, TKPROF, RMAN, ASM, RAC, Import/Export, SQL loader,SQLNET, Tuning packs, Load runner, VERITAS NetBackup, TSM,Commvalut, EXPLAIN PLAN, ERWIN, SQL-Navigator, DBArtisian, Data Guard, Data-Pump.

Development Tools: SQL*LOADER, PL/SQL, SQL*PLUS, T-SQL.

ETL Tool: Informatica 8.6, SQL Server Integration Services (SSIS)

Operating Systems: UNIX (Solaris 9, 10, AIX 5.3, HP-UX11), Windows 2000/2003 Windows 2000/XP, Linux Redhat 2.1, 3.x, 4.x, 5.x (32bit, 64bit)

Others: MS Office Suite, SSH, FileZilla

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Oracle DBA

Responsibilities:

• Installation of OLTP oracle database 12c and upgraded from 10g database to oracle 12c.
• Oracle 10g,11g grid control (OGC), RMAN, Data Pump
• Maintenance and monitoring of table spaces, data file, control files etc.
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Install, upgrade, and maintain Oracle software products/versions for on Windows 2012
• Database upgrade from oracle 10g to oracle 12c.
• Coordinating with different functional teams about down time.
• Installed weblogic 11g, Created data source, windows service for auto start and stop the managed servers.
• Installed oracle application express, Oracle Virtual Directory with web logic server.
• Compiled forms and reports and trouble shoot the problems occurred while compilation.
• Proficient in Golden Gate(GGSCI) basic processes validation.
• Proficient in new Install/implementation of GG; Initial load, direct load, exp/imp with SCN.
• Proficient in troubleshooting repcat/extract abend scenarios, post ETrollover, data issues(handling with dev/app teams as necessary), check source from repcat, missing arch files and so on.
• Good knowledge to setup or switchover GG process on DR(when switched over from Primary site).
• Good knowledge in GG performance tuning like split repcats, use batch sql, server load & underlying object partitions.
• Adequate knowledge upgrade of GG, HA of GG (like configuring VIP), configuring GG on CRS.
• Good knowledge (& hands on exp) in advanced GG concepts like conflict detection & resolution; multimaster sync.
• Having experience on SQL Server 2012, 2008/R2 and replication of data from prod to test and development environment.
• Install and configure Oracle Fail safe 11g on windows server.
• Creating roles and granting to the user for administration.
• Providing administration service for Oracle Failsafe 11g through change management process.
• Having hand on experience with Oracle Failsafe 11g integration with oracle databases.
• Database Space allocation, manage user privileges and resources for Oracle Failsafe 11g.
• Having experience in oracle fail safe manger to monitor the cluster status and adding another node to cluster tree for monitoring and administration.
• Having experience in active/passive, active/active configuration experience for fail over configuration.

Environment: Oracle 12c/11g/10g, Oracle Enterprise Manager, ASM, Oracle Enterprise Manager (OEM), TOAD, Windows 2012, Weblogic 11g,Oracle Application express 4.2.6.

Confidential, OKC

Oracle DBA

Responsibilities:

• Provided Oracle database administrative support for OLTP,OLAP 10g,11g databases.
• Oracle 9i,10g,11g grid control (OGC), Putty, sql*plus, RMAN, Data Pump
• Maintenance and monitoring of table spaces, data file, control files etc.
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Install, upgrade, and maintain Oracle software products/versions for on Linux, Sun Solaris
• Database migration from netapp storage to emc storage.
• Database migrations from oracle database 10g to oracle database 11g ASM.
• Database upgrade from oracle 10g to oracle 11g.
• Coordinating with different functional teams about down time.
• Developed Kron Shell scripts to automate sox audit scripts.
• Having experience in HP storage, HPOV services monitor.
• Providing administration service for Oracle Failsafe 11g through change management process.
• Having hand on experience with Oracle Failsafe 11g integration with oracle databases.
• Database Space allocation, manage user privileges and resources for Oracle Failsafe 11g.
• Having experience in developing oracle sql queries.
• Having experience in Informatica Power center.
• Installed weblogic 11g, Created data source, windows service for auto start and stop the managed servers.
• Installed oracle application express, Oracle Virtual Directory with web logic server.
• Expertise in usingGolden Gateto support data replication in the Oracle database environment.
• Installation and configuration of GOLDENGATECrossPlatforms.
• Proficient in Golden Gate(GGSCI) basic processes validation.
• Proficient in new Install/implementation of GG; Initial load, direct load, exp/imp with SCN.
• Proficient in troubleshooting repcat/extract abend scenarios, post ETrollover, data issues(handling with dev/app teams as necessary), check source from repcat, missing arch files and so on.
• Good knowledge to use of macros; exception handlers like handecollissions; ignore; skiptrans.
• Good knowledge to setup or switchover GG process on DR(when switched over from Primary site).
• Good knowledge in GG performance tuning like split repcats, use batch sql, server load & underlying object partitions.
• Adequate knowledge upgrade of GG, HA of GG (like configuring VIP), configuring GG on CRS.
• Good knowledge (& hands on exp) in advanced GG concepts like conflict detection & resolution; multimaster sync.
• Install and configure Oracle Failsafe 11g on windows server.
• Creating roles and granting to the user for administration.
• Having experience on Oracle Exadata operational support.
• Having experience in monitoring user (schema) privileges for audit purpose.

Environment: Oracle 11g/10g, Oracle Enterprise Manager, ASM, Real Application Cluster Loader, Oracle Enterprise Manager (OEM), TOAD, Red Hat Enterprise Linux (RHEL),HP-UX and Oracle Enterprise Linux (OEL).

Confidential, Troy, MI

Oracle DBA

Responsibilities:

• Install, upgrade, and maintain Oracle software products/versions for on Linux, Sun Solaris, and HP-UX
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
• Trouble shooting of various database performances by proper diagnosis at all levels including SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Configured Oracle Replication and Dataguard.
• Performed incremental migration from Oracle 8i multi-master to Oracle 9i multi-master replication environment.
• Installed OLTP RAC on Oracle 10g and worked on ASM feature of Oracle.
• Migrated database Oracle 8i from Windows NT to Red Hat Linux with minimal downtime.
• Provided Oracle database administrative support.
• Oracle 9i,10g,11g grid control (OGC), Putty, sql*plus, RMAN, Data Pump
• Maintenance and monitoring of table spaces, data file, control files etc.
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Install, upgrade, and maintain Oracle software products/versions for on Linux, Sun Solaris, and HP-UX
• Database migration from netapp storage to emc storage.
• Database migrations from oracle database 10g to oracle database 11g ASM.
• Database upgrade from oracle 10g to oracle 11g.
• Coordinating with different functional teams about down time.
• Developed Kron Shell scripts to automate daily jobs.
• Expertise in usingGolden Gateto support data replication in the Oracle database environment.
• Installation and configuration of GOLDENGATECrossPlatforms.
• Proficient in Golden Gate(GGSCI) basic processes validation.
• Proficient in new Install/implementation of GG; Initial load, direct load, exp/imp with SCN.
• Proficient in troubleshooting repcat/extract abend scenarios, post ETrollover, data issues(handling with dev/app teams as necessary), check source from repcat, missing arch files and so on.
• Good knowledge to use of macros; exception handlers like handecollissions; ignore; skiptrans.
• Good knowledge to setup or switchover GG process on DR(when switched over from Primary site).
• Good knowledge in GG performance tuning like split repcats, use batch sql, server load & underlying object partitions.
• Adequate knowledge upgrade of GG, HA of GG (like configuring VIP), configuring GG on CRS.
• Good knowledge (& hands on exp) in advanced GG concepts like conflict detection & resolution; multimaster sync.
• Install and configure Oracle Failsafe 11g on windows server.
• Creating roles and granting to the user for administration.
• Providing administration service for Oracle Failsafe 11g through change management process.
• Having hand on experience with Oracle Failsafe 11g integration with oracle databases.
• Database Space allocation, manage user privileges and resources for Oracle Failsafe 11g.

Environment: Oracle 9i/10g/11g databases, Data pump, Export/Import, Physical Backups, RAC, Solaris 10.0, AIX,HP-UX, Windows 2000/XP, Linux, Erwin,RMAN, Golden Gate, Oracle Enterprise Manager, TOAD.

Confidential, New York

Lead Oracle DBA

Responsibilities:

• Installed, Configured and Maintained Oracle 9i/10g/11g databases on Linux, Solaris and Windows Platforms.
• Installation, configuration, maintenance and troubleshooting Oracle 10g/11g Real Application Cluster (RAC), ASM and grid infrastructure on various platforms.
• Performed OLTP Oracle database upgrades from 9i to 10g and 10g to 11g and also applied patches.
• Configured Dataguard to ensure high availability, data protection and disaster recovery for enterprise data.
• Experience working with Oracle Active Data Guard 11g/12c
• Experienced in installation and configuration of Golden Gate and trouble shooting in different environments
• Designed, configured and maintained backup and recovery policies
• Automated the nightly RMAN backups for the production and test databases and also performed cloning, duplicating databases and point in time recovery using RMAN
• Performed the database migrations from AIX/Solaris/HP-UX to Linux platforms
• Installation, Configuration &Administration of 10G/11G/12c Oracle Enterprise Manager
• Worked with Oracle database gateway (10g/11g and 12c) for SQL Server
• Continuous performance monitoring and tuning of the databases and applications using OEM, tuning pack and diagnostics pack
• Experience in performance tuning using EXPLAIN PLAN, TKPROF, STATSPACK, DBMS STATS, Automatic Workload Repository (AWR), Active Session History (ASH), Automatic Database Diagnostic Monitor (ADDM) and SQL Tuning Advisor
• Working knowledge of Exadata
• Worked with SQL server 2000,2005,2008 and 2012
• Worked closely with the SQL server admins in creating gateway servers between the Oracle and the SQL server databases for thedata transfer
• Experience with EMC,NAS or IBM snaps, SRDF, BCVs, etc
• Experience with Database Vault
• Having experience in Informatica Power center.
• Schema backup and refresh on a regular basis from prod to dev and test.
• Applied quarterly patches supplied by Oracle on all production and non-production databases.
• Good experience in PL/SQL and Shell Scripting.
• Handled all standard database administrative tasks
• Knowledge and experience in administrating PeopleSoft Server components like PeopleSoft Application Servers, Process Scheduler Servers, Tuxedo, Web logic Servers, PIA (PeopleSoft Internet Architecture), Application Messaging, Integration Broker etc.
• Handful of experience in using the PeopleSoft related tools Application designer, Data mover, sqrw tool etc.
• Excellent knowledge of Oracle PeopleSoft ERP PIA architecture
• Proficiency in migration activities in PeopleSoft, Tax updates, Patches, Maintenance packs, Service packs
• Created databases in SQL server and also SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions
• Worked closely with the SQL server admins in creating gateway servers between the Oracle and the SQL server databases for the data transfer
• Monitored and performed maintenance of activities which included checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Written shell scripts for backup and recovery, import and export procedures and also to monitor the alerts for ORA- errors
• Experience in the area of PeopleSoft Administration and SAP
• Developed backend Procedures, Functions, Packages and Triggers using PL/SQL
• Assisted application development team in query tuning &optimization, partitioning etc
• Worked with architects and application teams in detecting the bottle necks.
• Expertise in usingGolden Gateto support data replication in the Oracle database environment.
• Installation and configuration of GOLDENGATECrossPlatforms.
• Worked with system administrators for various OS level administrative tasks
• Setup ODBC Connections for interaction with Sql-Server and other non-Oracle Databases
• Responsible for creating scripts to load data into production databases using sscheduled jobs
• Test and monitor the logical backups using Oracle Data Pump utility
• Good knowledge on relational and dimensional data modeling for creating Logical and Physical design of Database using multiple data modeling tools like ERWIN etc
• Setup meetings and involved in decisions on future database growth and sizing
• Worked as a member of production DBA team in perfect coordination with other team members
• Provided 24x7on call support for all the production databases on rotation basis
• Environment: Oracle 9i/10g/11g databases, Data pump, Export/Import, Physical Backups, RAC, Solaris 10.0, AIX,HP-UX, Windows 2000/XP, Linux, Erwin,RMAN, Golden Gate, Oracle Enterprise Manager, TOAD.
• Developed Kron Shell scripts to automate daily jobs.
• Installed weblogic 11g, Created data source, windows service for auto start and stop the managed servers.
• Installed oracle application express with web logic server.

Environment: Oracle 11g/10g, Oracle Enterprise Manager, ASM, Real Application Cluster Loader, Oracle Enterprise Manager (OEM), TOAD, Red Hat Enterprise Linux (RHEL),HP-UX and Oracle Enterprise Linux (OEL).

Confidential, Ashburn, VA

Senior Oracle DBA

Responsibilities:

• Installed, Configured, Upgraded and Applied patches and bug fixes for Prod, Test and Dev Servers.
• Involved in 24*7 support for production RAC database with on-call pager
• Installed and configured OEM Grid Control.
• Install and configure Oracle Golden Gate.
• Installation and creation of OLTP 11g and 10g databases for Testing, Development and Production
• Data Refresh from Production to Test and Development environments using RMAN Duplication
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK
• Monitor CPU usage, I/O contention, memory parsing on UNIX server
• Involved in Upgrade/Migration of the oracle databases from Oracle 10g to Oracle 11g and Sun Solaris to OEL (Oracle Enterprise Linux).
• Experience in SQL scripts for session and lock monitoring
• Monitored/managed 2 node RAC environments, databases using OEM Grid control, and RMAN database backup and recovery.
• Monitored batch performance
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Golden Gate.
• Experience in DBA skills of Teradata DBMS Administration, initial Teradata DBMS environment setup, development and production DBA support, use of Teradata Manager, FASTLOAD
• Automated the procedures and interface programs using Oracle Advanced Queuing, Oracle Enterprise Manager.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import&move procedures
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM
• Optimal Space utilization in tablespace by avoiding fragmentation.
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
• Having experience in HP storage, HPOV service monitor.
• Having experience in developing oracle sql queries.
• Having experience in Microsoft Biz Talk.
• Responsible for continuous database monitoring and reorganization for ensuring performance
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contentions
• Taking periodic Backup of the Database and the software using RMAN and VERITAS NETBACKUP.
• Migration of Database from RHEL 4 to Sun Solaris and applying patches whenever required.
• Experience in oracle features Flashback version query, Rollback Monitoring, Tablespace Management, Oracle Datapump, Flashback Table, RMAN and Auditing
• Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
• Scheduling jobs using Oracle Job Scheduler
• Oracle OLTP database Upgradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Installation and configuration of Oracle Client software and Tools
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK
• Monitoring and Optimizing database performance
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Created scripts to query performance views to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration
• SQL scripts to monitor Table spaces and extent growth.
• Developed Kron Shell scripts to automate day to day jobs.

Environment: Oracle 10g RAC, 11g, UNIX, Solaris 10, Informatica, TOAD, VERITAS, OEM, ERWIN 7.2, SQL, PL/SQL, TKPROF, Weblogic, EXPLAIN PLAN, Business Objects XI, DataGuard.

Confidential, Jacksonville, FL

Oracle DBA

Responsibilities:

• Installed Oracle 9i and 10g, RAC database on HP-UX 11.0, Redhat4
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
• Created development, testing, staging, production for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Involved in different scenarios of OLTP as well as DSS (DATA WAREHOUSE) Databases.
• Managed DSS (Decision Support System) and OLTP (On Line Transaction Processing system) full life cycle projects with about 10 databases at one time, biggest database around 800 GB supporting both production developments on Unix and Windows NT/Windows 2000.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Administration, optimization, and maintenance of the Data Warehouse and Data Marts databases.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Managed the migration of SQL Server 2005 databases to Oracle 10g.
• Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency check, and index defragmentation.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Performed Bi-Directional Schema Level Streams for Oracle 10g.
• Created scripts and documented the Operational guide for Streams.
• Created and Managed Jobs using AutoSys Job Scheduler.
• Performed Uni-Directional, Bi- Directional Streams from HP-UX Boxes to Suse Linux Boxes.
• Performed Table level Streams.
• Extensive UNIX Shell scripting in csh, Pro*C.
• Migrated database from 8i to 9i and 10g supporting various incremental releases.
• Configured RAC 9R2 and 10g from HP-UX boxes to Win 2003 Boxes.
• Configured, migrated and tuned of Oracle 9R2 RAC and 10g RAC.
• Involved in Data Modeling, Database Design and Creation.
• Involved in the Dimensional Data Modeling and populating the business rules using mappings into The Repository for Data management.
• Oracle Grid Control Management Server Installation.
• Provided 24X7 support for production Databases.
• Database backup and Database tuning for real time and batch systems
• Assisting customer setup, tune and maintain Oracle database.
• Proven expertise in object-oriented design and client/server application systems development.
• Performed Performance tuning by using STATSPACK, TKPROF, AWR and ADDM and SQL Trace and TKPROF and Explain plan and Analyze and estimate on object level and schema level.
• Data extraction from various sources, transformation and loading into the target Oracle database using Informatica Power Mart.
• Involved in Data Modeling concepts including Data Vault, and also in Advance security including DB Auditing, Labeling.
• Configured Physical Standby Database for Disaster Recovery using Datagaurd.
• Documented the steps of installing and configuring the Crystal Enterprise for the networking department built the servers when we have releases.
• 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, TKPROF, TOAD, Foglight and Oracle Enterprise Manager.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Install and configure Oracle Failsafe 11g on windows server.
• Creating roles and granting to the user for administration.
• Providing service for Oracle Failsafe 11g through change management incidents, change requests process.
• Having hands on experience with Oracle Failsafe 11g installation,integration with oracle databases, Oracle fail safe service manager for cluster services .
• Database Space allocation, manage user privileges and resources for Oracle Failsafe 11g.
• Having experience in fail over setup and ensuring all installed components are up and running.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Perform Oracle replication (advanced Queues, materialized views etc)
• Devised and Implemented backup strategies using hot, cold, and exports based on the business requirements.
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Trouble shooting of various database performances by proper diagnosis at all levels including SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Developed UNIX shell scripts to perform the above tasks efficiently.
• Worked as a member of production DBA team in perfect coordination with seniors and team members.
• Having experience in HP storage, HPOV service monitor.
• Having experience in developing oracle sql queries.

Environment: Windows NT/2003/2008, HP-UX, AIX, Solaris and Linux, Oracle 9i and 10g, SQL Server 2000/2005, Toad, RMAN, PL/SQL,SQL*Loader, SQL*Plus, Informatica Power Centre 7.2, Erwin, Clearcase, Foglight, Autosys, SQL Backtrack, BMC Patrol, Aqua Data Studio 3.7,Query Analyzer, Oracle Fail Safe, Linux on NFS, blade system from HP.

Confidential, Green bay, WI

Oracle DBA

Responsibilites:

• Install, upgrade, and maintain Oracle software products/versions for on Linux, Sun Solaris, and HP-UX
• OLTP Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
• Trouble shooting of various database performances by proper diagnosis at all levels including SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Configured Oracle Replication and Dataguard.
• Performed incremental migration from Oracle 8i multi-master to Oracle 9i multi-master replication environment.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
• Migrated database Oracle 8i from Windows NT to Red Hat Linux with minimal downtime.
• 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
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
• Implementing Database Security, Management of role-based security.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Used Oracle Advanced Queues feature to set up multi-master replication, dealt with conflict resolution and performance issues
• Database Restore using RMAN, Cold Backup and Export.
• Data Modeling, Database Design and Creation using Erwin.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Performing day-to-day database administration tasks including Table space 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.
• Used Triggers for database activities, including delete, update, and insert triggers for multi-master Replication.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Problem analysis involving interactions/dependencies between UNIX and Oracle.
• Production support for Oracle running on UNIX.
• On-Call 24x7 DBA support for production databases.
• OLAP on Oracle platform using Oracle Express (OLAP server), Relational Access Administrator (RAM),
• Data Migration as part of enterprise data warehouse project.
• 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.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Having experience in HP storage, HPOV service monitor.
• Having experience in developing oracle sql queries.
• Having experience in Microsoft Biz Talk.
• Developed UNIX shell scripts to perform the above tasks efficiently.

Environment: Solaris 8.0/9.0/10.0 , OAS 10g, Linux Red Hat, Windows 2000/2003/NT Oracle 8i (8.1.6/8.1.7 ), Oracle 9i/10gR1, RACF, Oracle Enterprise Manager, Oracle Partitioning, Informatica Power Center 7.1, Oracle Replication, Hot Standby, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2000, Toad, Erwin 7.2.

Confidential

Junior Oracle Database Administrator

Responsibilities:

• Installed and configured OLTP Oracle RDBMS on UNIX and Windows environments.
• Performed Database upgrade of Oracle 9i from existing Oracle 8i system.
• Involved in analysis of market risk and claims data.
• Developed new PL/SQL programs - Triggers, Functions, Procedures and Packages to manage various business functionalities
• Performing backups and recoveries using RMAN/conventional hot backups.
• Other duties include applying Oracle database patches, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries, monitoring and optimizing database performance. Worked with DML SQL statements which were used to modify the client information in the current database tables.
• Worked closely with senior DBA to understand the business and technical requirements.
• Developed entity relationship, data flow and functional diagrams.
• Designed database tables, implementing referential integrity.
• Developed triggers which internally called procedures and functions.
• Performed complex SQL query tuning, index reorganization, and Rollback.
• Developed oracle forms and reports using oracle designer 2000.
• Involved in all phases of the software development life cycle.
• Designed and developed various UNIX Shell, PL/SQL and SQL scripts to monitor the database.
• Designed appropriate backup and recovery procedures to meet the business requirements.
• Involved in documenting the entire system architecture and data flow.
• Developed UNIX shell scripts to perform the above tasks efficiently.

Environment: Windows 98/NT/ 2000, UNIX, HP-UX, RedHat Linux 4.x, IBM AIX, MIGRATION

Confidential

Junior Oracle DBA / Developer

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Provided support for all the databases as an operational database administrator. Installation, configuration and upgrading of Oracle server software and related products.
• Implemented Standby Database and Database Replication to realize database high availability. Created partitions for large table to improve performance Installed and configured Oracle 8i databases.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries.
• Responsible for optimizing the queries and application tuning.
• Created roles, profiles and privileges and assigned roles to users.
• Execute physical database changes required by applications
• Strong Knowledge of Creating Public Synonyms, DBlinks, Ref Cursors, Raise Application Error, Parameterized Cursors.
• Installed and Implemented Backup & Recovery procedures.
• Cloning the databases for different environments.
• Maintained archived data on tape.
• Implement Hot, Cold and Logical backup plans.
• Analyze, design and implementation of the Database for e-commerce system.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Developed UNIX shell scripts to perform the above tasks efficiently.
• Involved in documenting the entire system architecture and data flow.

Environment: Windows 98/NT/ 2000, Oracle Server 8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting