SUMMARY

• Around Six years as Oracle Database Administrator (Proficient in Oracle Database Administration Activities) like developing customized business applications, database design, database administration and experience on UNIX (Solaris, HP - UX, AIX), Linux, Windows 2008/2005 with Oracle(9i,10g,11g),Developer 6i/9i,Sql net, SQL Plus etc.
• Experience in Database Design, Administration and troubleshooting skills for Oracle 11g/10g/9i/8i on UNIX & Windows platforms.
• Experience in usage Oracle OEM, ASH tools to resolve the performance issues.
• Experience with database backup, restore, and disaster recovery procedures. Hands on experience of database backups and Recovery strategies using RMAN (9i/10g), Export, shell scripts for hot/cold backups.
• Hands on experience in configuring Oracle Data guard (9i/10g) physical Standby
• Experience in 10g RAC implementation, maintenance and support.
• Expertise in 10g Grid Control.
• Used Oracle 10g streams for Data replication, Data warehouse loading, Event notification as well as business event management.
• Used 10g Data pump (expdp, impdp) and 9i Export Import (exp, imp)
• Experience as On-Call 24x7 production DBA support, development DBA.
• Managing team, achieve team and individual targets, addressing any issues of concern.
• Extensive experience with Oracle Database Migration/Upgrade.
• Used Automatic Memory Management & Automatic SQL Tuning features Oracle 11g.
• AWR Baseline Enhancements, Case Sensitive Passwords, Data Recovery Advisor, Database Replay features of Oracle 11g.
• Strong Knowledge on 11g & 10g Release and New Features
• Strong in data (system) analysis, DBA support of phases of Software Life Cycle (design & development, implementation) in large-scale multi-user (systems) environments.
• Strong experience in tuning database performance from system as well as query tuning perspective.
• Expertise in Creating/troubleshooting/monitoring script, creation of log files, packages & development of scripts for SQL*Loader, Export, Import, PL/SQL.
• Involved in optimizing SQL queries.
• Monitoring and optimizing the Performance of the database, tuning Management, Change Management, capacity planning, and SQL tuning.
• Expertise in Entity/Relation Data Modeling using ER-Win and Designer.
• Working experience with Very-Large databases (VLDB) up to 4 terabytes, data migration, against Oracle & other databases such as MS Access, SQL Server.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, Oracle RAC, MS SQL Server 2008/2005/2000

Operating Systems: HP-UNIX, Sun Solaris 10, Linux, IBM AIX, Windows 2008

Languages: SQL and PL/SQL, Perl

Application Servers: WebLogic, Oracle Application Server (9i&10g), Apache

ERP: Oracle Applications, Windchill Servers, SunGard

Data Protection Tools: LogMiner, Flash BackQuery, DataGuard

DB Tools: SQL*Plus, i*SQL Plus, SQL*Loader, DBA Studio, Export & Import utility, OEM, ASMCMD, Net8, Oradebug, Database Configuration Assistant, Explain plan, SQL Trace, Tkprof, RMAN, QUEST Performance Analysis, Spotlight, TOAD

Data Modeling: Erwin 3

Data Replication Tools: Oracle Advance Replication

Programming Languages: C, SQL, PL/SQL and UNIX Shell Scripts

Web Based Tech: HTML, HTMLDB, APEX, DHTML and VB Script

Security: Auditing, Network Security, SOX

Change Management: Bug DB, HP Service Desk/Centre/Manager, DISCO, SRS

PROFESSIONAL EXPERIENCE:

Confidential, DE

Oracle DBA

Responsibilities:

• Involved in Oracle 11g/10g installation, migration of OLTP and Data warehousing databases adhering to the standards.
• Created Documents and laid standards to DBA team in installations, upgrades and other daily DBA activities.
• Maintained strong partnerships with Data Architecture, Infrastructure Services and Application Development Teams and participated in discussions relating to business process issues and how to leverage technology solutions.
• Designed and implemented 4 node 10GR2 RAC with ASM storage
• Manage all primary on-call DBA activities such as checking on table space problems, checking for fragmentation, checking on nightly/weekly backup problems, responding to any Oracle errors, and deadlock conditions
• Set up, configure and maintain the physical standby databases with Data Guard for switch and failover scenarios
• Proactively Tune badly running SQL’s using explain plan, TKPROF, Dynamic performance view, AWR.
• Implemented new features of Oracle 11g like Automatic Memory Management, Automatic SQL Tuning, AWR Baseline Enhancements, Case Sensitive Passwords, Data Recovery Advisor, Query Result Cache, Read-Only Tables, SQL Performance Analyzer, and SQL Plan Management.
• Upgraded Oracle 9i/10g db’s to 11g using DBUA.
• Automated the site switchover/failover operations using Oracle DG Broker.
• Installing / implementing OEM 10g Grid Control Management Server and Agent with 10g R1/R3 Repository to manage 700+ targets( Database include primary and stand-by databases, Grid Control Agents, Server, 9i/10g application server components on more then 100+ server )
• Produce detailed game plans for monthly or quarterly database partition maintenance tasks
• Set up, configure and maintain the data replication tools such as Oracle streams.
• Design, and implement database backup/restore infrastructure using Oracle RMAN, and Netbackup tools.
• Build, installed, upgrade and administration of Oracle 9i/10g instances of different dimension. Experienced in managing with features like Oracle Managed Files, Auto Space / Undo Management.
• Monitor and manage Oracle database Security by implementing SOX Policies through OEM GC.Setup Policies/Rules for Checking Oracle Security discrepancy and Alert System in OEM GC.
• Oracle Security Management and resolving of user conflicts by controlling access to data and database objects.
• Database Refreshing / Replicating from production site to testing site using hot backup and recreating control file from its trace backup.
• Regular build deployment in non-prod and Prod.
• Oracle Enterprise Manager Grid Control (OEM GC) for monitoring production Oracle databases.
• Recovering the database from Block corruption, Objects-drop and using TSPITR.
• Used Oracle streams for Data replication, Data warehouse loading, Event notification as well as business event mgt.
• Used Materialized Views (snapshots) for replication of data.
• Monitoring logs, alerts, managing Batch Jobs (Alteration, Automation, Tuning, Failure)
• Database refresh/replication from Production to Testing, Development, QA, & ITG Environments using RMAN / Data Guard / Hot Back-ups and Schema level Exports / Data Pumps.
• Provide Primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.
• Providing backup and recovery strategies, setting up and implementing the backup & recovery procedures for Oracle9i/10g databases.
• Downsizing, Defragmentation / Reorganization of VLDBs Using Export/ Import, Data Pump, cloning them using RMAN Duplicate features.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Oracle Enterprise Manager Grid Control (OEM GC) for monitoring production Oracle databases
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Developed shell scripts and PL/SQL procedures and scheduled Cron jobs and DBMS JOBS to monitor the database performance.
• Rendering 24*7 Oncall Production database support.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.

Environment: Server - Sun Solaris 10, AIX, RHEL 5, HP-UX 11.3 Database - Oracle 11g/10g, RMAN, SRVCTL, CRSCTL, Service Manager, OEM 10.2.0.5, STREAMS, RMAN, Trivoli DP, Unix KSH.

Confidential, NE

Oracle Database Administrator /Developer

Responsibilities:

• Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Performing all daily Maintenance tasks and analysis on database design and functionality.
• Creation &maintenance of Databases and Database objects.
• Involved in developing PL/SQL functions, Procedures, Packages and Triggers
• Installation of 9i databases on Linux & Solaris 10.
• Used RMAN for backup recovery.
• Performance monitoring and tuning up of the Database using STATSPACK, AWR, ADDM.
• Performance tuning of Oracle Database Objects by fixing row chaining.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Database Export/Import, Hot and Cold Backup and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.
• Supported MS SQL Server database and applications.
• Analyzing and monitoring the system performance and tune accordingly.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Installation and configuration of Oracle Client software and Tools.
• Automated the process of analyzing tables every night.
• Used scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache.
• Maintained all documents of Oracle database operations.
• Monitored the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents.

Environment: Oracle 9i/10g, SQL Server 2005, PL/SQL Developer, TOAD, RMAN, LINUX.

Confidential

Oracle Database Administrator

Responsibilities:

• Responsible for all production support DBA related activities which includes database backups, database restores, tablespace maintenance, database builds, database ids password management, Performance Tuning and troubleshooting with database versions Oracle 9i, 10g on UNIX & Windows XP/NT platforms.
• Extensive use of Oracle OEM, ASH, AWR, ADDM tools to resolve the performance issues.
• Implement Oracle Database Resource Manager on production database to optimize resource allocation and avoid Excessive overhead, inefficient scheduling, inappropriate allocation of resources, Inability to manage the database.
• Actively participate in Database Migration activities from Oracle 9i to Oracle 10g
• As a DBA, schedule different maintenance jobs using Autosys and DBMS Scheduler jobs.
• Responsible for setting up database and UNIX environments for any new releases in SDLC. This task involves lot more activities like participate in database design, create new database, Tablespace and UNIX space planning, capacity planning, database users and roles management.
• Extensive use of new Oracle 10g new features data pump EXPDP and IMPDP to export and import data.
• Experience in using Oracle RMAN tool for database backup and recovery.
• Experience in Oracle Data Guard setup, both physical and logical standby for failover (or) switchover to alternative hosts in the same or alternative location.
• As a production support DBA, responsible for 24/7 database support, carrying pager and respond back immediately whenever receives page for any database failures/issues.
• Write PL/SQL code for all DBA maintenance activities.
• Write PL/SQL blocks, Sql*Loader for DBMODS (data modification process) and execute the DBMODS in UAT and Production environments.
• Responsible for all DBA related documentation work. Create new documents if not available and modify the existing documents for any code/process change.
• Developed a suite of UNIX shell scripts for database builds, database restores, data replication activities.
• Monitoring the database and taking a proactive approach in trouble shootingwhich otherwise may be a potential bottlenecks for high availability of the database.
• Co-ordinate with performance team to analyze and resolve the performance related issues.
• Also worked extensively with Materialized views for replication of data between source and target database using fast refresh method.

Environment: RHEL 3, HP-UX, Windows 2005, RMAN, EXPDP, IMPDP, BMC Patrol, Oracle 10g/9i, OEM, RMAN, EMC.

Confidential

Oracle DBA/Developer

Responsibilities:

• Database Installation, silent Installation and embedding oracle base software into the product on multiple platforms.
• Developed RMAN scripts for backup and recovery of databases.
• Database Design, Schema Design, Performance Monitoring, Tuning.
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
• PL/SQL Programming in developing automatic partition management.
• Frontline customer support of Fortune 1000 customer's production.
• Created disaster recovery procedures and performed Backup/recovery.
• Installed, migrated, supported Customer Databases onsite and remotely.
• Database design Data modeling, Schema design using ERWIN, Schema design and scripting, dynamic schema generation.
• Migration of data from SQL Server 2005 using DTS and loaded into oracle Database.
• Automated database administration/data management since the product is a packaged product for a 24x7 production support of database with features like partitioning with PL/SQL calls to collect stats, Index maintenance
• Worked on performance tuning of SQL and Procedures and packages.
• Created Cron jobs in production to automate production tasks
• Administer, maintain, develop and implement policies and procedures for Managing DB Security and alert log entries.
• Resolve database performance issues, database capacity issues, and distributed data issues

Environment: Oracle 9i/ 8i, Sun Solaris 9, 10, UNIX Scripting, PL/SQL.