R.Srinivasan

Summary

• Around * years of experience as Oracle DBA (10g/9i/8i) on UNIX, Sun Solaris, Windows 2000/NT, Red Hat Linux.

• Experienced in full life cycle of database administration in Oracle. Worked both as a Production Support DBA and Development DBA in Oracle.

• Highly experienced in Oracle 10g/9i/8i/7.x Administration, Export/Import. Performance Tuning, Oracle SQL / PL-SQL tuning, Monitoring, Backup and Recovery, Oracle Management Server, RAC, Capacity Planning.

• Created Oracle partition tables and applied patches as per the requirements of the partitioning module and upgrade Oracle and DBMS software.

• Experience in Upgrade and Migration of oracle database to higher version (from Oracle 8i to Oracle 9i to Oracle 10g) and other platforms using Oracle Data Migration Assistant.

• Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM).

• Extensively worked on Oracle Cluster ware.

• Working Experience with Crystal Reports.

• Maintained and monitored 6TB databases using Oracle Enterprise Manager Grid Control, Toad and Embarcadero DBArtisan 8.1.5 in my project.

• Implement Oracle Streams for schema and table level replication.

• Experienced with Performance Tuning MS SQL and Sybase RDBMS (query enhancements, index optimization and segment placement).

• Working knowledge of SQL Server.

• Perform Tuning, coding and Monitoring for Oracle database via database monitoring tools like Embarcadero DBArtisan 8.1.5 and OEM and TOAD.

• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring databases.

• Efficient in SQL query optimization using explain plan, Utlbstat/Utlestat, TKPROF reports, gathering statistics, pinning the objects, Running scripts.

• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application. And Involved in performance monitoring and tuning of the database by fine tuning the database implementation.

• Configured securities and access to production databases.

• Working experience on Websphere application server.

• Extensive experience with designing and implementing Oracle databases, including systems architect, project management, data warehouse design, implementation and tuning.

• Develop data models and perform planning of architecture, functions, modules, recovery, standards and implementation.

• Understanding of OLTP database architectures.

• Managing, optimizing and tuning Oracle and SQL Server databases through such tools as Oracle’s Enterprise Manager (OEM), snapshots and AWR Reports.

• Designed and Implemented database security using Oracle roles and privileges. And securities for users and applications…

• Experienced in Database design including creation, modification, and deletion of table spaces, data-files, rollback segments and schema's, creating schemas (Tables, Indexes, views, sequences, synonyms, roles, and users).

• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Excellent communication, interpersonal and business interaction skills

• Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.

• Working experience on Flashback databases.

• Perl Scripting for backup and disk management purpose

• Great working knowledge of ERP R12 upgrades from 11i and supports

• Specialist in creating automated scripts and with Unix & Korn Shell Scripts along with PERL.

• Responsible for using PERL in scripting for backups and space saver policy

• Designed and implemented backup and recovery strategies. Extensively used conventional and RMAN for backup and Disaster recovery. Experience in advanced recovery methods like PITR and TSPITR. Logical backup using and full/ partial export/import and Data Pump.

• Production support given to the system 24x7. Ability to work beyond regular hours. Carried primary and secondary support roles with pager rotation to support during weekends, Holidays and beyond regular hours.

• Provided database related services to their development, Production and QA environments.

• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.

• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.

• Extensively used PL/SQL (Stored procedures, triggers, packages), SQL* PLUS, SQL* LOADER, Explain Plan, and SQL tuning of Oracle database.

• Designed logical and physical Data Models using ERWIN forward-engineered into DDL and executed on large scale to create database.

• Excellent communication and interpersonal skills.

Technical Skills

Operating Systems HP-UX HP-UX (11.11, 11.23 & 11.31), Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.2, 5.3, Linux Ubuntu 9.0

Red Hat Linux RHEL 2.1, 3.x, 4.x,5.x and Windows 95/98/NT/2000/XP

RDBMS Oracle /11g/10g/10gRAC/9i/8i, RDBMS, MS-SQL Server 2000, 2005 and Sybase

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

DB Management TOAD 9.5, Enterprise Manager grid

Tools/Utilities RMAN, OEM, Sql Navigator, Oracle Management Service(OMS), SQL*Loader, ASM, Export/Import, TOAD, Patch Management, ODBC, Data pump, Data guard, VERITAS Net Backup, MS Access, IBM InfoSphere DataStage

Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Hardware Platforms Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 6500 / 450, HP XP256 / XP512, IBM C server p5 model 590, and various PC desktop and servers.

Professional Experience

L&T Infotech, Hartford, CT Jan/ 2009 – Present

Oracle Database Administrator

Role and Responsibilities:

• Creation and configuration of database on Red Hat Linux, UNIX and SUN Solaris

• Upgrading database from Oracle version 9i to 10g and migration of data.

• Good experience in working with Oracle and SQL server 2005. And Good experience with SQL migration.

• Created Oracle partition tables and applied patches as per the requirements of the partitioning Module and upgrade Oracle and DBMS software.

• Worked with Oracle partition tables and applied patches as per the requirements of the module. Used Oracle replication as databases for read only snapshots to maintain local copy of master tables in OLTP systems. Also done Patches for upgrading Oracle and DBMS software.

• Implemented a large-scale Enterprise Data Warehouse system using NCR Teradata database size of 4 Terabyte on EMC disk array

• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring databases.

• Performance tuning of application by identifying the SQL, which are not written well; providing inputs to the application programmer; correcting and implementing the right components.

• Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL, PL/SQL.

• Using informatica as an oracle reporting tool.

• Maintained & monitoring the Real Application Cluster (RAC) set up and stand alone Database using OEM Grid Control and TOAD.

• Worked in advanced recovery methods like PITR and TSPITR. Logical backup using and full/ partial export/import and Data Pump.

• UNIX shell scripting for backup and monitoring of database.

• Designed and Implemented database security using Oracle roles and privileges. And securities for users and applications.

• Designed and implemented backup and Disaster recovery strategies with RMAN

• Setting up of RMAN on the database to perform necessary back-up.

• Designed and implemented backup and recovery strategies. Extensively used conventional and RMAN for backup and Disaster recovery. Experience in advanced recovery methods like PITR and TSPITR. Logical backup using and full/ partial export/import and Data Pump.

• Managing, optimizing and tuning Oracle and SQL Server databases through such tools as Oracle’s Enterprise Manager (OEM), snapshots and AWR Reports.

• Configured securities and access to product databases in SQL Server 2000/2005, Windows 2003 Server

• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.

• Understanding of OLTP database architectures.

• Working on mentioning and implementing new database on UNIX Platforms.

• Physical standby database for High Availability.

• Perl Scripting for backup and disk management purpose…

• Perl Scripting and AWK scripting for backup and disk management purpose…

• Performance tuning for Oracle Day-to-day maintenance and management of the several different databases in development, test, regression and production environments; proactively monitoring production environment for any exceptions/ issues./

• Identifying issues/ bottlenecks that could potentially cause issues, involving the right teams (such as server admins or application developers) and take a corrective action to rectify the issues.

• Written extensively UNIX Shell Scripts, PL/SQL, Stored Procedures and Triggers.

• Excellent communication and interpersonal skills.

Environment: ORACLE 10g/9I, AIX UNIX, OLTP, OEM Grid Control, TAR, RAC, RMAN, Export/Import, UNIX Shell Scripts.

J.P Morgan Chase, Wilmington, DE June/2008 – Nov/ 2008

Senior Oracle Database Administrator

Roles and Responsibilities:

• Worked as an Oracle Production DBA (9i/10g/11g) on HP-UX (11.11, 11.23 & 11.31), AIX 5.2, Solaris 10 & SUSE Linux 9.3 servers.

• Extensively involved in Real Application Cluster (RAC) nodes 10g database migration from EMC drives to HITACHI drives with Automatic Storage Management (ASM).

• Installed the Oracle 11g data base on Window 2003 server.

• Extensively involved in the migration of Production Real Application Cluster (RAC) and Stand alone Date base to different geographical location i.e from Lewiston (USA) to Toronto (Canada).

• Production support given to the system 24x7. Ability to work beyond regular hours. Carried primary and secondary support roles with pager rotation to support during weekends, Holidays and beyond regular hours.

• Migrated multiple Clients from AIX, Solaris, Windows, HP-UX, Linux to different platforms with Oracle 11i

• Performed extensively on Migrating BO (6.5, Xi)

• Perform the Pre-migration task for RAC & Standalone Database.

• Designed and implemented data warehouse including Dimensional Modeling.

• Worked with Oracle partition tables and applied patches as per the requirements of the module. Used Oracle replication as databases for read only snapshots to maintain local copy of master tables in OLTP/OLAP systems.

• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.

• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.

• Designed and implemented backup and recovery strategies. Extensively used conventional and RMAN for backup and Disaster recovery. Experience in advanced recovery methods like PITR and TSPITR. Logical backup using and full/ partial export/import and Data Pump.

• Perform the Tivoli Storage Manager (TSM) backup before migrating the RAC & Standalone servers to Canada.

• Involved the Post-migration task (Unit-testing) for every RAC & Standalone servers migrated to Canada.

• Creating tablespaces and database files based on the OFA model. Implemented physical database design after sizing tables and indexes and creating tablespaces taking into account I/O load distribution.

• Managing, optimizing and tuning Oracle and SQL Server databases through such tools as Oracle’s Enterprise Manager (OEM), snapshots and AWR Reports.

• Responsible for maintenance, integration and monitoring of a SQL Anywhere (Sybase product) server and consultant to MS SQL Server issues.

• Perform Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad & Grid Control.

• Configured securities and access to product databases in SQL Server 2000/2005, Windows 2003 Server.

• Installation of Oracle Application server Infrastructure 10.2.0.1 (OID/LDAP, OC4J, HTTP server, SSO, Meta data repository) on SUSE Linux 9.3.

• Configuration of Middle Tier 10.2.2.1 (Portal, Discoverer, Apache) on HP-UX 11.23 box.

• Applied Patch to upgrade Oracle Application server from 10.2.0.2 to 10.2.2.0.

• Perform Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Embarcadero DBArtisan 8.1.5 and OEM.

• Extensively worked on UDB DB2 Database.

• Working on application up-gradation on DB2 database.

• Designed and implemented backup and Disaster recovery strategies with RMAN.

• Perform Logical backup using and full/partial export/import and Data Pump.

• Configured securities and access to production databases.

• Designed and Implemented database security using Oracle roles and privileges. And securities for users and applications.

• 24x7 production support DBA working on a primary/ secondary pager rotation and supported on holidays, weekends and beyond regular hours.

• Proactively managed the databases; set up notifications/ alarms using shell scripts for managing any exceptions in day to day management of the databases.

• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation

• Installed, maintained and optimized GoldenGate TDM and GoldenGate Veridata.

• Implemented database refresh with the data pump utility.

• Working experience on Websphere application server.

• Experience with catalog management.

• Installing and Configuring from Oracle 9.2.0.1.0 (9i) database to Oracle 10g.

• Involved in Oracle partition tables and applied patches as per the requirements of the client and upgrade Oracle and DBMS software.

• Upgrade the data’s from Existing Oracle 9i to Oracle 10g and Migration of database (from 9.2.0.5 to 10.2.0.1).

• Performed on tuning of Oracle SQL / PL-SQL.

• Working experience on Websphere application server.

• Understanding of OLTP database architectures.

• Working on mentioning and implementing new database on UNIX Platforms.

• Extensively Experience worked on Cognos and informatica as an oracle reporting tool.

• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn shell,perl, Unix shell Scripting.

• Specialist in creating automated scripts and with Unix & Korn Shell Scripts along with PERL.

• Responsible for using PERL in scripting for backups and space saver policy.

• Perl Scripting for backup and disk management purpose…

• Implemented stand-alone database using Oracle Data Guard feature for High availability configuration.

Environment: Oracle 11i/11g/10g/9i, Sybase 11.x, MS SQL 2000/2005, HP-UX 11i v3, SUSE Linux, Solaris, OEM Grid Control, AIX, RAC, RMAN, OEM, DBArtisan 8.1.5, Oracle Streams, Unix Shell Programming, Functions and Triggers, SQL Tuning, PL-SQL, Stored Procedures, TOAD, PERL, Windows 2003 Servers.

Priceline, Stamford, CT Aug/2007–May/2008 Oracle Database Administrator

Role and Responsibilities:

• Team member in a 9 members DBA team, which provided 24x7 supports to 3 productions.

• Installation and Upgradation of Oracle 8.1.6 /9i and other Oracle tools. Participated in testing the compatibility and portability of Application on Oracle.05 by migrating whole application and database from 8I TO 8.1.6 /9i.

• Good experience with SQL migration and Data Warehouse.

• Good experience in working with Oracle and SQL server 2005.

• Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM).

• Performance tuning of application by identifying the SQL, which are not written well; providing inputs to the application programmer; correcting and implementing the right components.

• Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL, PL/SQL.

• Archiving of the necessary data using Fast Unloads (4.5) of Computer Associates.

• Worked in advanced recovery methods like PITR and TSPITR. Logical backup using and full/ partial export/import.

• Locally managed tablespaces were used which track all extent information in the tablespace itself. This results in improved performance as it eliminates recursive operations and reliance on data dictionary.

• Designed and implemented backup and Disaster recovery strategies with RMAN

• Setting up of RMAN on the database to perform necessary back-up.

• Team member of Backup and Recovery Group (consist of 3 DBAs) responsible for Disaster recovery and Standby Database.

• Actively worked on SQL and Physical database tuning resolving fragmentation and disk contention. Use Partitioning feature of Oracle 8 to improve performance.

• Database sizing for various deployments to clients.

• Efficient in SQL query optimization using explain plan, Utlbstat/Utlestat, TKPROF reports, gathering statistics, pinning the objects, Running scripts.

• Actively participated in Application Tuning, which includes SQL Tuning, Database design tuning and tuning at Instance level.

• Have written shell scripts for automation of various database-monitoring activities.

Environment: ORACLE 8.1.6 /9i, running under HP-UX, SQL*Loader, Performance tuning, export/import, Tkprof.

General Electric Healthcare, Princeton, NJ Oct/2006 – Jul/2007

Senior Oracle DBA

The CMS system is relied upon by GE Healthcare’s ERP system for receiving timely and valid contract pricing from CMS. The system infrastructure relies heavily on data feeds and interfaces that were built into the CMS system that support enterprise and external data vendors, such as wholesalers, pharmacies, and buying groups. CMS receives a number of customer profile feeds from SAP (Systems Applications and Products), DDD (Drug Distribution Data) and Slimline.

Hardware/Software:

Java, Web Logic Application Server, XML, Oracle 9.2.0.7, TOAD, Sun Solaris 5.9,Oracle 9i RAC.

Responsibilities:

• Space Management, User Management, Roles & Privileges.

• Allocating and re-organization of tablespaces.

• Developed a full set of standard procedures for installation, backup, restoration, and tuning, primarily from the application perspective.

• Provided leadership on issues such as standard SQL*Net configurations, archive strategies, security management, and monitoring strategies.

• Applied strong technical expertise in application tuning, complex view creation, tuning of troublesome SQL statements, stored procedure and snapshot strategy.

• Infrequently document management creation and Maintain DB objects and code in source controls / GE libraries.

• Job scheduling using crontab.

• Monitoring the health of the database by generating AWR reports.

• Resolved tickets raised by the Business users and tuning ad-hoc queries requested from business.

• Performed Standby configurations for our various Primary servers.

• Security Auditing for users.

• Implemented database backup strategies using RMAN utility.

Client: -NIIT Ltd, Bangalore, INDIA Dec/2004 – Aug/2006

Junior Oracle DBA

Role and Responsibilities:

• Responsible for Oracle 8i logical and physical databases design, implementation and maintenance on UNIX.

• Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration, third party backup software Legato troubleshoot and backup testing.

• Managed and resolved design issues during development.

• Moved database Schema changes to stage or production.

• Migrated and upgraded databases from version 7 to 8i.

• Developed some UNIX Shell scripts to automate database operation and database monitoring.

• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery

• Installation and configuration of Stats pack and analysis of Stats pack performance report and subsequent tuning of production databases.

• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation

• Performed database tuning using Explain Plan, hints, utlbstat/utlestat, Toad, Power Explain, and Enterprise Manager.

• Provided primary database support for application database systems such as Siebel CMS, Documenting, and MapInfo MapXtreme Spatial Application.

• Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.

Environment: ORACLE 8i, HP-UX, UNIX Shell scripts, RMAN, ODBC, JDBC.

Educational Qualification: Hemchandracharya North Gujarat University, Patan, India

ICICI Bank, India. Oct/2002Aug/2004

Pl/SQL Developer/Oracle Database Administrator

Role and Responsibilities:

• Upgrading and migrating database from oracle 8i to 9i version.

• Design and support complex distributed and replicated database architecture.

• Design and creation of client database instances per requirements including primary and test environments.

• Moved database Schema changes to stage or production.

• Refreshing and manipulating data in tables using PL/ SQL procedures

• Creating tablespaces and database files based on the OFA model. Implemented physical database design after sizing tables and indexes and creating tablespaces taking into account I/O load distribution.

• Locally managed tablespaces were used which track all extent information in the tablespace itself. This results in improved performance as it eliminates recursive operations and reliance on data dictionary.

• Understanding of OLTP database architectures.

• Performed SQL tuning by using Explain Plan.

• Extensively used PL/SQL (Stored procedures, triggers, packages), SQL* PLUS, SQL* LOADER, Explain Plan, and SQL tuning of Oracle database.

• Making structural changes to the databases when database design changes are to be implemented.

• Setting up of RMAN environment

• Implementation and maintenance of read only snapshots and snapshot logs

• Create and maintain staging database environment as well as standby database.

• Performance tuning for Oracle Real Application Clusters (RAC).

• Refreshing development/test database from production using Export/Import. This is done so that the latest data is available in the development/test database.

• Identifying integrity constraints for tables.

• Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.

• Analysis and Designing of Database

Environment: Oracle 8.1.6 /9i, PL/SQL, SQL* PLUS, SQL* LOADER, RMAN, RAC.

Contact this candidate