SUMMARY

• Over 7 years of IT experience with 5 years of experience as a Database Administrator in Oracle/UNIX/AIX/NT/Client Server environment both in production and development environments.
• Oracle Database Administrator & Developer for a very large multi user Production Environments with Database Implementation on UNIX and Windows.
• Installed Oracle 8i/9i on Sun Solaris, created customized database and Installed Oracle 10g (10.1.0.4) on SunOS and applied various patches to it.
• DBA Experience: Database Planning, Sizing table space, Create database, scripts, Monitor databases, Oracle Install, Upgrade, 24x7 DBA support, Backup/recovery, Disaster recovery, Automate jobs, Schema managing, SQL loader, Export/import Database, Tune database, Tune SQL.
• Proficient in all DBA responsibilities such as user management (synonyms/privileges, roles, quotas, table partitioning, index, sequence), space management (tablespaces, rollback segment), monitoring (alert log, memory, disk I/O, CPU, network activity).
• Performed Oracle database upgrades from 8i, 9i to 11g for development and production environments.
• Adept in OEM, OEM grid control 10g, SQL*plus, Export, Import and SQL*Loader and UNIX cpio. Excel at loading data from FLAT files and other databases, Responsible for Data loading using SQL*Loader for clients.
• Implementation of Oracle Backup and Recovery strategies using RMAN (recovery manager) and creating RMAN scripts. Cloning of Databases using RMAN.
• Worked on databases sizing from 400GB to 5TB in OLTP.
• Tuned the database at every level namely design, application, shared pool, SGA, I/O, Sort, Undo, locks, shared server, SQL, Operating System.
• Extensive experience of Performance tuning of various aspects of the database using utilities like TKPROF, Explain Plan, Stats pack.
• Experienced user of Oracle PL/SQL in stored procedures functions and triggers. Extensive knowledge in creating and tuning SQL queries and PL/SQL procedures and functions for optimum performance.
• Experience in Sun Solaris Administration.
• Developed automation tools using UNIX Shell Scripting and job scheduler (Cron tab)
• Proficient at using TOAD, SQL Developer.
• Strong working experience and knowledge on all phases of Software development life cycle.
• Versatile team player with excellent analytical, communication and inter personal skills.
• Lead teams both at onshore and offshore.
• Knowledge of configuration control and CMMI level 5software quality procedures.

SOFTWARE SKILLS

Databases: Oracle (11,10g, 9i and 8i)
Oracle Products: SQL*Plus, PL/SQL, Oracle Enterprise Manager, Forms 9i / Reports 9i, SQL Loader
Tools: OEM, RMAN, Export, Import, Datapump, Tkprof, STATSPACK, AWR, ADDM, TOAD, SQL Developer, Grid Control (10g)
Operating Sys: SUN Solaris, Win NT, Win 2000, Win 98,AIX
Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripts
Applications Pl/Sql, Oracle Enterprise Manager (OEM), Oracle Utilities (Import / Export, SQL*Loader, 10g Data Pump), Toad,CVS
EDUCATION

• Bachelors in Electrical and Electronics

CERTIFICATIONS

• Oracle Certified Associate in Oracle 10g Database Administration.
• Oracle Certified Associate in Pl/SQL Programming.

RECOGNITION & AWARDS:

• Various awards and recognitions awarded at Accenture - ASE Achiever, Yellow Topper award for Individual excellence and Team player, Rising Star

PROFESSIONAL EXPERIENCE

Company - Confidential
Client - Confidential, Chellomedia, Switzerland
Role - Offshore Lead Oracle Database Administrator

Feb 2009 to May 2011

Scope:
Liberty Global is a leading cable operator providing triple play services in around 14 European countries. Lead database administration team in supporting almost 100 test, development and production databases. Project required a major technical upgrade of all applications and its related db's, support all the db's, catering user requests, perform as-is analysis of Development database, provide recommendations for hardware sizing and develop mechanisms to streamline database administration activities.

Responsibilities:

• 24 X 7 admin support to Production 9i and 10g databases. Performed various administration tasks on Production environment.
• Performed database upgrade from 8i/9i to 10g using Oracle utilities like export, import, catupgrd.
• Perform as-is analysis of non-production environments and provide recommendations on Capacity planning, load sharing and hardware sizing on SUN Solaris systems.
• Performed various admin tasks like -database character set conversion to UTF8 on Oracle 10g, database creation and cloning of non-production environments from production environment, database purging by tablespace re-organisation, DB monitoring for long running sessions/queries using AWR reports, alertlog files, dynamic views and statspack reports and suggest improvements.
• Developed and implemented automation scripts using UNIX Shell scripting minimizing manual efforts involved during database cloning.
• Extensively involved in SQL tuning using various oracle provided tools like Explain Plan, SQL Trace, TKPROF and STATSPACK, Tablespace space management and database file system management.
• Regular administration activities include - removing deadlocks created by various user processes, monitoring and management of logical and physical database components like table spaces, segments (tables, index, and rollback).
• Worked extensively with RMAN backup, restore and recovery. Backup of Database like making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.
• Worked with OEM Grid Control to monitor and manage Oracle software to provide enhanced agility, better service quality and lower operational costs.
• Running SQL Tuning scripts for gathering information on database performance like sorts, gets, misses, cache hits, disk I/O activity, disk reads.
• Worked with FTP, Winscp in transferring of files and on Export/Import and scheduling jobs using crontab.
• Performed AMDOCS CRM upgrade from 10.1 version to CRM 13
• Performed regular maintenance of CRM environments on Unix Sun Solaris
• Work with the configuration & set up of Data Guard.
• Executed Admin activities from onshore client location.

Environment: Oracle DBA (Oracle 8i/9i/10g/RMAN/ASM/24*7 support), AWR, Sun Solaris 10, Import/Export, OEM, and TKPROF, Data Guard, 10g Data Pump, AMDOCS CRM 13.1

Scope:

Confidential, is the second largest cable operator in the Netherlands, providing cable television (digital and analog), broadband Internet, and telephone services to both residential and commercial customers. Worked as a senior database administrator providing support for 70-80 prod/non-prod databases and implemented numerous off-the-shelf applications. This project involved in work related to new releases and ongoing support work like environment refreshes, fault resolution and general Oracle consulting.
Responsibilities:

• 24x7 support to Oracle 10g Production Database Administration.
• Performed performance tuning through the use of AWR and ADDM through OEM, analyzing trace files, achieved Optimal Space utilization in tablespace by avoiding fragmentation, usage of partitions to improve the query performance and manageability and provide recommendations for optimum performance.
• Maintain standby databases using replication utility named Data Guard.
• Implemented backup strategies using RMAN, Cold Backups, Export/Import utilities, and shell scripts for non-production environments.
• Provided space estimations for non-production environments.
• Define and create table spaces, users, roles and security.
• Provided database-related design recommendations to application developers as required.
• Developed Unix Shell Scripts for managing day-to-day activities like analyzing tables every night and automation of backup.
• Performed recovery of non-production databases (recovering from Media Failure, tables dropped accidentally, data files and from Block Corruption).
• Maintenance of CRM environments like user creation, schema changes and upgrades.

Environment: Oracle DBA (Oracle 8i/9i/10g/RMAN/Space Estimation/24*7 support), Sun Solaris, Import/Export, OEM, AMDOCS CRM 10.1

Scope:
UTI-Technology Upgrade project was distributed database system for 44 branches. Work involved implement Oracle environment setup, database creation and regular monitoring and provide suggestions for process improvement, develop Oracle PL/SQL objects like triggers, stored procedures and packages.

Role & Responsibilities:

• Developed new functionality using Oracle objects like Database triggers, PL/SQL Procedures, PL/SQL packages and functions.
• Created tables and indexes by analyzing and rebuilding of indexes for better performance.
• Rewrote many ORACLE stored procedures to improve performance.
• Data Loading from Flat files using SQL*Loader.

Environment: Windows NT, SQL, PL/SQL, TKPROF and Oracle 8.x

Client - Confidential, India
Role - PL/SQL developer

July 2004 to June 2005

Scope:

The Plant monitoring system consists of various modules that deal with the daily
operations of the power plant such as monitoring the power and heat levels of the gas turbines present in the plant, evaluate performance and maximize the productivity of the plant by providing relevant data necessary for understanding the operations of the power plant. Worked as PL/SQL developer in to calculate the most economic mode of plant operation by using the various formulae that are used for calculating the heat and power levels currently used in the operations of the plant.

Responsibilities:

• Involved in the requirement analysis for understanding the various formulae to be used for evaluating the performance and the most economic modes of plant operation
• Developed Indexes, Triggers, Stored Procedures, Functions and Packages using PL/SQL.
• Complete project documentation as per standards.
• Test case preparation, Unit Testing, Integration testing, System Testing and product deployment

Environment: SQL, PL/SQL and Oracle 8.x

REFERENCE: AVAILABLE UPON REQUEST