Document Sample
RAM+DBA Powered By Docstoc
					Venkat Ram
                                                                                Oracle Database Administrator
Professional Summary:
About 8 years of experience as an Oracle Database Administrator having hands on experience in database
administration, production support, installation, configuration, upgrades, patches, performance tuning, backup
and recovery, space management, database security, cloning, migration, shell scripting and documentation.

   Extensive knowledge on database administration for Oracle 8i, 9i, 10g & 11g with experience within very
    large scale database environment and mission critical large OLTP and OLAP systems.
   Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g and 11g in HP-UX, Sun
    Solaris, IBM AIX, Windows and UNIX/Linux environment.
   Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
   24*7 production database support with Support to developers & end-users.
   Installed Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems.
   Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded
    standalone databases to 10g RAC environment.
   Expert in implementing ORACLE STREAMS (unidirectional, bi-directional and downstream capture) and
    managed Operational, Historical and reporting databases.
   Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-
    building Standby Databases both Physical and Logical supported by DATAGUARD.
   Managed very large database (VLDB) of maximum size 5TB with 18 servers including 6 Productions, 6
    Testing, 6 Development and 3 Standby databases.
   Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data
    Warehousing using customized shell scripts and stepwise.
   Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with
    VERITAS Net Backup.
   Logical and physical modeling using Erwin. And Expertise using tools like Erwin, ER/Studio and Toad.
   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.
   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.
   Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
   Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data
    from flat files using external tables, SQL*LOADER.
   Good experience of creating PL/SQL packages, Stored Procedures, Functions, Triggers and Views to retrieve,
    manipulate and migrate complex data sets in Oracle Databases.
   Experienced in using Oracle's Transportable Tablespace (TTS) feature allows users to quickly move a user
    Tablespace across Oracle databases.
   Database replication using snapshots, materialized views and advanced replication methods.
   Experience in applying security patches to the databases.
   Effective troubleshooting of database and Performance problems.
   Good experience in Data Migration using export/import.
   Management of Objects, Schemas, Partitioning the tables and Indexes.
   Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
   Experience in implementation of enterprise databases on enterprise storage solution using SAN.
   Extensive knowledge in reporting tools like Business Objects and crystal reports.
   Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
   Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer
    service oriented attitude. A very good team player, self motivated, dedicated in any work environment.
       Oracle Certified Associate (OCA) in Oracle 10g Database Administration.
       MCTS: Microsoft SQL Server 2005- Implementation and Maintenance.

 Technical Skills:
RDBMS                  Oracle 11g/10g/9i/8i/7X, Oracle 10g (RAC, Data Guard & Streams), SQL Server 2005 and
                       My SQL.
OPERATING              HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1,
SYSTEMS                3.x, 4.x, 5.x and Windows NT/2000/2003/XP.

LANGUAGES              SQL, PL/SQL, T-SQL, C, C++, VB, UNIX Shell Scripting, Ksh, bash and Perl Scripting.

SOFTWARES,             DBCA, DBUA, Oracle 11i (EBS), Oracle Data Guard, OEM (GC), RMAN, ASM,
APPLICATIONS &         Clusterware, VCS, Shareplex, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp,
TOOLS                  impdp), TOAD, ERwin, TOAD Data Modeler, Rational (ClearCase and ClearQuest),
                       VERITAS Net Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF,
                       STATSPACK, AWR, and ADDM.

WEB TOOLS              HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metalink, MS Visio.

Professional Experience:

Sprint Nextel Communications Inc, Reston, VA                                                      April’08 – till date
Sr. Oracle DBA

Environment: Windows 2000/2003/XP, AIX 5.2/5.3 and Red Hat Linux 5.0, Oracle 10g and 11g, TOAD 9.0, Oracle
Enterprise Manager (GC), RMAN, RAC, DataGuard, ASM, SCP/SFTP, Shareplex, Erwin 4.0, ER/Studio 8.0.3, TKPROF,
Explain plan, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader, T-SQL, SQL Server 2005, Bugzilla, Visual Source Safe.

Description: Nextel Communications is a telecommunications company. This company owns and operates the third
largest wireless telecommunications network in the United States with millions of customers. This
telecommunications company provides Data Services, quality solutions, operations to the various departments.
Worked in Nextel’s data systems engineering group as Database Administrator for QA/QC engineering team on
multiple projects like Mobile Search, Content Search, My Account, RIM and store locator.

 Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0, IBM-AIX 5.3.
 Successfully upgraded Oracle 10g ( to Oracle 11g ( on IBM-AIX nodes.
 Involved in Installation and configuration of Oracle 10g RAC using Clusterware and ASM.
 Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.
 24x7 remote support and on call Database support for Database developers & end-users.
 Experienced in the installation of Oracle Grid Control in Server (OMS Oracle management Server) and installing
   the Agents in all the production, test and development databases and configuring them.
 Experienced in Design, implementation and generating documentation of Oracle 10g Data Guard on both
   physical/logical standby databases in high availability mode.
 Implemented Data guard, creating both Logical and Physical Standby databases in 10g RAC environment for the
   Production databases.
 Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle
 Installed Oracle Streams as an enhancement for the Client’s DW method and monitored Streams Issues using
   Grid Control.
   Developed SQL*PLUS & PL/SQL scripts for Extraction, Transporting & Transforming(ETL) data from Production
    databases to Data Warehouse Databases.
   SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF,
    STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
   Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with
    Export/Import Data pump utilities).
   Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments,
    Constraints, Database Access, Roles and Privileges.
   Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints,
    Stored outlines, Statistics for the same.
   Performance tuning and diagnosing DBMS and individual Production databases. Organized various migration
    review meetings with the application team to discuss the migration strategy based on their requirements.
   Performed policies on data confidentiality, integrity, availability, and auditability, Based on Access Controls
    for Access to Data at the database level.
   Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic
    workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
   Logical and Physical Database Modeling using CA Erwin 4.1.
   Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
   Creating and Scheduling Oracle Backend Process Jobs in Crontab.
   Cloning & Duplicating databases using scripts as well as RMAN.
   Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
   Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
   Implemented VERITAS Net Backup using RMAN (Recovery Manager) as a media management layer.
   Applying security patches both Server side and Client side and Performed testing.
   Worked closely with the Oracle developers for the better performance in Applications in writing the Packages,
    Triggers, Mat Views and Indexes on the tables.
   Used Secure SCP & FTP Extensively for the File transfers from machines to remote server.
   Experienced in documentation, Provided documentation for database design, analysis, modifications, creating
    schemas etc.
   Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance
   Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink) and managing
    database security.

Direct Energy, Pittsburgh, PA.                                                                    Jun’07 – Mar’08
Sr. Oracle DBA

Environment: HP-UX 11, Red Hat Linux4, Windows 2000/2003, Oracle, DB2, Enterprise
Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL*Plus, PL/SQL, ASM,
J2EE, ToadV9.7 & SQL, Navigator V6.1.

Description: Direct Energy is one of North America's largest energy and energy-related services provider with
over 5 million residential and commercial relationships. Direct Energy provides customers with choice and
support in managing their energy costs through a portfolio of innovative products and services.

 Responsible for administration and supporting Oracle 9i, 10g and 11i databases.
 24x7 Production database administration, support and monitoring to ensure a proactive problem
   recognition and resolution of database issues.
   Successfully migrated databases from windows2000/2003 running oracle 9i over to Linux boxes 10g.
   Installation, Upgrade and Configuration of Oracle 9i and 10g Databases.
   Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
   Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting
    privileges and user logins.
   Configuration, Administration and tuning of Oracle 10g and 9i RAC.
   Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
   Data Refresh in Test and Integration Databases using Transportable Table spaces.
   Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.
   Oracle Streams Bi-Directional replication implementation at Table, Schema and Database Level.
   Implemented backup strategies using hot/cold, exp/imp used on the business req.
   Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery (TSPITR)
    using RMAN.
   Implemented Streams replication between RAC and non RAC database environments.
   Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related
    problems and configured with Application servers on test databases.
   Assisted a team of DBA’s in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.
   Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetrix.
   Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL
    analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Statspack.
   Performed conversion single instance to Real Application Cluster (RAC) database instances.
   Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within
    managed databases.
   Provided database/application tuning including as reducing lock contention, analyzing objects.
   Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN
    duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
   Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data
   Experienced on Database Security by monitoring User Management, Privileges, Roles, Auditing, Profiling,
    Authentication and Risk management.
   Used Oracle Advanced Replication feature to set up multi-master replication, dealt with conflict resolution
    and performance issues.
   Unix Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export
    procedure of databases, getting system alerts.
   Experienced in documentation, Provided documentation for database design, analysis, modifications, creating
    schemas etc.
   Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink) and managing
    database security.

Wachovia Corp, Charlotte, NC                                                                      Feb’06 – Jun’07
Oracle DBA

Environment: Oracle database 10g ( to, 9i (, Redhat4, HP-UNIX 10.0, DB2, RAC, TOAD,
TTS, Erwin 7.2, J2EE, ASM, Oracle Enterprise Manager, Network setup and Management, ASM, RMAN, SQL*Plus,
PL/SQL, SQL*Loader.

Description: Wachovia is one of the America's largest financial institutions, serving individual consumers, small
and middle market businesses and large corporations with a full range of banking, investing, asset management
and other financial and risk-management products and services. This project is developed as a process of
automation for insurance policy management by using centralized data warehouse and Data Mart.

    Installed RAC on Oracle 10g release1 and worked on ASM feature of Oracle.
    24x7 Production database administration, support and monitoring to ensure a proactive problem
    recognition and resolution of database issues.
    Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical
     I/O and Memory Usage.
    Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments,
     buffer cache, redo mechanisms
    Oracle Grid Control Management Server Installation.
    Used transportable tablespaces (TTS) to move the data Oracle on a different platform and also much faster
     than performing either an export/import or unload/load of the same data.
    Implementation of 10g Data Guard and Bi-directional streams implementation.
    Handling large database environments 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.
    Made performance improvements to the database by building Partitioned tables, Index Organized Tables,
     Materialized Views and Bitmap Indexes.
    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
     and Oracle Enterprise Manager.
    Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints,
     Stored outlines, Statistics for the same.
    Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to
     appropriate groups.
    Implemented and followed data security standards and Security User Management, Privileges, Roles,
     Auditing, Profiling, Authentication and Risk management.
    Performed application migrations to non-cluster databases to cluster databases.
    Devised & Implemented backup strategies using hot, cold, and exports based on the business requirements.
    Implemented Veritas Net Backup-using RMAN (Recovery Manager) as a media management layer.
    Applying security patches both Server side and Client side and Performed testing.
    Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using
     Oracle data pump.
    Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
    Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL,
     database design, database tables, indexes, Instance, memory, operating system and java calls.
    Worked with production DBA team in perfect coordination with seniors and team members.

Emigrant Savings Bank, NY                                                                         Oct’04 – Dec’05
Oracle DBA

Environment: Oracle 10g/9i, SQL Server 2000, Sun Solaris 8.0, SUN SPARC, HP UNIX, Windows 98/NT/2000,
Oracle Enterprise Manager, SQL* Loader, T-SQL, STATSPACK, TKPROF, EXPLAIN PLAN.

Description: Emigrant is one of the leading retail financial institutions in the New York metropolitan area,
servicing the banking needs of our customers with 40 branches in NYC, Long Island, Westchester and Bronx. Our
DBA’s are responsible for maintenance of Database Servers behind our online banking website and all of the
internal bank applications.

 24x7 Database administration, support and monitoring to ensure a proactive problem recognition and
   resolution of database issues.
 Migration of Oracle databases from windows to Linux.
 Applied patches to Oracle Databases and Oracle Applications.
 Upgrading development and production databases to Oracle 10g.
 Proactive database monitoring using 10g grid monitoring tool.
 Database tuning using SQL-Trace, STATSPACK, EXPLAIN PLAN and TKPROF.
 Extensive Performance Tuning, Memory (SGA) Tuning, net backup, EMC (Time finder and SRDF), RAID,
   RAW Devices.
 Performed database cloning to setup test and development databases.
 Responsible for optimizing the queries and application tuning.
 Performed SQL tuning and assist developers with coding PL/SQL.
 Provided support to Application Database Administrators in designing the database.
 Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups. And performed backup
   validations using RMAN.
 Management of schemas, objects partitioning the tables & indexes.
 Automation of data load using Korn shell scripting and SQL*Loader.
 Responsible for setting and managing user accounts, and granting required privileges to users.
 Performed other DBA activities like including space management and performance monitoring.
 Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.

Bharti Airtel, Chennai, India                                                                      Apr’03 – Oct’04
Oracle DBA/Developer

Environment: ORACLE 9i, MS-SQL, SQL, PL/SQL, SQL* Loader, T-SQL, RMAN, Toad, Erwin, UNIX AIX
5.1,Windows NT/2000, UNIX Shell Scripting, export/import utilities.

Description: Bharti Airtel, is Asia’s leading integrated telecom services provider with operations in India and Sri
Lanka. This Project 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.

 Installed and configured Oracle RDBMS on UNIX and Windows environments.
 24x7 remote support and on call database support for developers & end-users.
 Responsible for administering, supporting production and development of Oracle 9i Databases.
 Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures
   and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
 Responsible for setting and managing user accounts, and granting required privileges to users.
 Loaded data from flat file to Oracle database using SQL*Loader. Created indexes on tables for performance
   tuning. Performance monitoring, tuning and space management in database with Grid control. Performed
   Troubleshooting and system maintenance.
 Involved in user creation and user access control. Involved in Schema creation and management. And
   Developed stored procedures, stand alone functions and PL/SQL packages to comply with the requirements.
 In depth knowledge of setting up RMAN backups and maintaining catalog schema. Proficient in creating
   auxiliary and duplicate database using RMAN.
   Develop, implement and test Backup and recovery strategies for development databases.
   Performed Database Reorganization regularly to remove row migrations and fragmentation using export and
    import utilities. Write UNIX Shell Scripts to schedule the code.
   Maintained the RMAN repository and customized recovery catalog and also Involved in Production Support
    and Operations teams to resolve production issues in a timely and efficient manner.

Lupin Laboratories, INDIA.                                                                         Aug’01 – Feb’03
Oracle Developer/ DBA

Environment: Oracle 8.1.7/9i, HP-UX, Windows NT/2000, PL/SQL, SQL Server 2000, T-SQL, Database
Tools/Utilities, OPS, Shell Scripting.

Description: Lupin Laboratories Limited is India’s one of the largest pharmaceutical Company, manufacturing
and marketing world class generics, branded generic pharmaceuticals and active pharmaceutical ingredients.
Despite our disparate beginnings, we are united by our shared passion for customer service and a commitment to
creating a better future in health care.

 Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer
 Created complex analytical reports using inline view, lexical parameters with Oracle Reports 9i.
 Modified Korn shell scripts as per technical specifications.
 Prepared Data Flow Diagrams for existing PL/SQL code.
 Involved in coding of data extraction scripts as per technical specifications.
 Analyzed the table structures using Analyze command.
 Involvement in all phases of the project life cycle.
 Designed database tables as per technical specifications.
 Translated business requirements into creation and alteration of database objects: tables, indexes, constraints,
   triggers and stored procedures.
 Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Shared By: