Suresh

(Sr.Oracle DBA)

s7mqzy@r.postjobfree.com

Ph: 940-***-****

PROFESSIONAL SUMMARY:

Over 3+ years of IT experience as Senior Oracle Database Administration and Developer Ver. 10G/9i/8i on a variety of UNIX (Solaris, HP-UX, AIX), Windows NT 4.0/2000/2003 with Oracle ( 8.0.5, 8i, 9i, 10g,11g), Stored Procedures, DB Triggers, Developer 2000, Sql*Plus etc.

Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 7.3.4,8 to 8i, 8i to 9i and 9i to 10g, 11g applied oracle patches.

Installed Oracle 10g RAC software with ASM & OCFS2 File systems.

Involved and Configured Oracle 11g database instance running across two oracle RAC nodes on Red Hat Linux AS 4 Server

Installation, maintenance and tuning of RAC Applications. Used rapid install and other Oracle Application maintenance utilities like OEM, EBS.

Created development, testing, staging, production, RAC and standby databases 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.

24*7 production database support with Support to developers & end-users.

Have implemented ORACLE STREAMS, and two type of standby databases supported by DATAGUARD, logical standby and physical standby databases

Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.

Implemented and delivered core edge technologies of Oracle 10g (Streams, EM Grid Control, and RAC).

Involved in Configuring and managing the listener files and setting up of multiple listeners using MTS.

Logical and physical modeling using Erwin.

Having good experience in using ACL AUDITEXCHANGE 2.0.

Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.

Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Having good experience on reporting tools like BOBJ.

Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day – to – Day activities.)

Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.

Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and manageability Working with Oracle 9i and 10g partitioned tables.

Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms

Installation and Configuration of Oracle Grid Control.

Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.

Extensive experience with designing and implementing Oracle databases, data warehouse design, implementation and tuning.

Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.

Database replication using snapshots, materialized views and advanced replication methods.

Worked on different types of storage structures (SAN/NAS).

Extensive knowledge in reporting tools like Business Objects and crystal reports

Good co-ordination and communication with system administrators, business data analysts and development teams.

EDUCATION

B. Tech (CSE), JNT University, Andhra Pradesh, India.

TECHNICAL ENVIRONMENT:

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

RDBMS: Oracle 11g/10g/9i/8.x/7.x, Oracle 10g Real Application Clusters (RAC), SQLServer2005.Oracle Streams

LANGUAGES: SQL, PL/SQL, Java, C, XML, UNIX Shell Scripting.

SOFTWARE APPLICATIONS/ TOOLS: ORACLE 8.x/9i/10i/10g, Recovery Manager (RMAN), Real Applications Cluster (RAC), EBS, STATSPACK, ERWIN 6.0/4.7, Teradata, Clusters, Veritas Backup, Developer 2000, SQL Loader, TOAD 7.6/7.5, Oracle Enterprise Manager

WEB TOOLS HTML, XML

PROFESSIONAL EXPERIENCE:

Title Sr. ORACLE DBA

Client KAISER PERMANENTE

Work Location Pasadena, CA

Duration sep 2010– Till Date

Environment Oracle 11g R1 &10gR2, HP-UX 11.31, Linux AS 5, AIX 5.3, SQL Server 2005 OEM (Grid Control), RMAN, Solaries, TOAD 9.7.2, RMAN, SQL*Plus, PL/SQL, SQL*Loader, DBArtisian 8.7, MS Visio 2010, ERWIN 6.0, AWR, EBS, Explain Plan

Resposibilities:

• Providing full life cycle on DBA/on call support for Production Databases, Administering, UAT, Development and QA databases.

• Translating technical and Business requirements into efficient Logical and Physical data models.

• Configured and Installed ORACLE 10g, 11g software on Red Hat Linux 4 Servers.

• Installed & configured Weblogic server on UNIX platform and deployed applications.

• Created and monitored Physical standby databases on maximum protection, performance mode using Dataguard for Disaster Recovery and performing production databases Maintenance.

• Configured Automatic Storage Management (ASM) for 10g RAC databases for reducing disk contention and providing centralized management for Disks.

• Supported installation and setup of ORACLE Cluster’s and RAC database.

• Monitoring and Administrating ORACLE RAC databases on ORACLE 11g Clusters.

• Used Weblogic server to integrated the OID enabled applications.

• Good experience with multi master replication setup & Administer with Golden Gate tool.

• Setup reporting server using ORACLE Streams from various data sources.

• Performed database Migration from Windows platform to Linux using RMAN (Convert) and Datapump.

• Analyzing the Automatic Database Diagnostic Monitor Reports from various Databases in various time intervals, creating BASELINE and monitoring performance metrics of Databases WORKLOAD.

• Having exposure to the Sybase database in day to day activities and also involved in migrating from Sybase to the Oracle 10g database.

• Upgraded few production databases from version ORACLE 10g to ORACLE 11g.

• Enhancing performance using various components like SQL TUNING ADVISOR, ACCESS TUNING ADVISOR, SEGMENT ADVISOR, UNDO ADVISOR and Automatic Shared Memory Management.

• Resolve database performance issues, database capacity issues and other distributed data issues (OLTP).

• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.

• Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.

• Identifying instance Top Waits root cause and bad queries, writing suggested solution reports about Instance tuning and Query tuning.

• Performed Table, Index Partitions for increased performance and for better storage management.

• Monitoring and performance enhancement using session Tracing, Statspack and CPU utilization.

• Identifying bottlenecks and wait based analysis using Oracle Wait Interface.

• Documented the Role Transition method from Primary to Standby and vice versa of Dataguard environment.

• Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager.

• Performed software cloning, tuning, patch management and deployment using Configuration and Provisioning, Diagnostic and Tuning Packs.

• Performing Backups (BLI, Full, Cumulative, Differential), Recoveries using RMAN-Netbackup.

• Used Flashback technologies-Flashback Table, Flashback Query & Flashback Database to recover from user errors and minimize the Full/Incomplete database recoveries.

• Performed database Audits/Fine Grained auditing, reports regarding the SOX-compliance activities against financial data, in regular basis on user operations involving sensitive database objects.

• Performing Database Refreshes using Exp/Imp, Datapump, Sql*Loader and RMAN.

• Writing Triggers and debugging Stored Procedures and Functions-PL/SQL.

• Wrote Shell and Perl scripts for monitoring and automating tasks of various Databases.

• Performed Backup and Refreshed SQL SERVER 2005 Databases using SSMS.

• Identified performance bottlenecks and performed performance tuning of SQL SERVER.

• Performed Export and Import utilities in SQL SERVER databases.

• Monitored Performance of databases and Administrated user security of MS SQL 2005.

• Monitored SQL SERVER Databases and assisted developers in debugging T-SQL Procedures etc.

Title ORACLE Developer/DBA

Client Satyam

Work Location India

Duration Jan 2008 – Feb 2010

Environment Windows 98/NT/2000, HP-UX, Oracle 8i/7,TOAD,Database Tools/Utilities

Project Scope: Project’s included building; maintaining and testing databases, involved in the entire development life cycle right from development to production, other tasks included were supporting and tuning oracle applications.

Responsibilities:

• Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT

• Analyzed the structures using Analyze command.

• Used Triggers for database activities, like delete, update triggers.

• Involvement in all phases of the project life cycle

• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system

• Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.

• Used SQL* Loader for data import from remote databases

• Worked closely with developers in Designing Schema / tuning PL*SQL/ SQL code

• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

• Performed day-to-day DBA jobs for managing Production/Development databases.

• Logical and Physical Modeling using ERWIN Data Modeler.

• Management of tablespaces for different users by granting quota on Default & Temporary tablespaces.

• Estimated Storage capacity for database objects.

• Monitored the growth of the database objects UNIX Shell scripting. Implemented for capacity planning.

• Created UNIX shell scripts to automate batch jobs through Cron.

• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication using materialized views.

• In-depth experience in Data Warehousing using Informatica and Oracle.

• Utilized SQL*loader and data pump import to load data into tables.

• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.

• Created and implemented Oracle database backup and recovery strategies using RMAN.

• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability

• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.

• Tuning test and production database by altering the parameters.

• Export and Import of database objects to copy from one database to another database.

• Investigating suspicious database activity using Auditing.

• 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.

• 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.

Contact this candidate