PROFESSIONAL SUMMARY

Over Eight years of IT experience as an Oracle DBA on a variety of UNIX (Solaris, Linux, AIX, HP-UX), Windows platforms having in-depth expertise with all facets of Database design, Administration, Production Support, Installation, Configuration, Patches, Upgrades, Migration, Performance Tuning, Backups and Recovery, Cloning, Space Management, database security, Disk Space, File System Management and Monitoring

• Oracle Certified Professional (OCP) and Achieved High Performer Award with EDS an HP Company
• Experience in Installation and configuration of Oracle 11g, 10g, 9i, 8i in Solaris, AIX, LINUX, HP-UX and Windows environment
• Experience in Oracle Real Application Clusters (RAC) 11g, 10g, 9i – Installation, administration, troubleshooting, patching
• Configuring Standby DataGuard Server in Distributed/High Availability Database Environments
• Experience in Setting up, managing, and administering the Oracle Clusterware and ASM.
• Troubleshooting Database performance using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM)
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, TKPROF, STATSPACK, TRCSESS, Auto Trace, AWR and ADDM utilities to fine tune SQL execution plans. Modify init parameters to improve instance/database performance
• Very good experience in Oracle patches, upgrades and Migration
• Well experience in Backup & Recovery (RMAN, Import / Export, Data Pump, Online, Offline) of mission critical databases with VERITAS Net Backup & IBM TSM
• Capable of maintaining multiple databases independently
• Worked in production, development, testing and very large databases (VLDB) in sizes of terabytes and excellent customer handling skills
• Complete range of Oracle DBA activities including day-to-day production database monitoring, Backup & Recovery using RMAN, Shell Scripting, Partitioning, Trouble shooting production issues, Performance Tuning, Logical & Physical Database design, Extensive SQL & PL/SQL skills
• Extensive experience on 24/7 production environment for large volume of databases with on-call pager support
• Expertise include Design and Data Modeling (Erwin) and software development using Oracle on multi platforms (HP-UX, Solaris, Linux, AIX, Windows)
• Expertise include oracle Materialized Views, Partitioning (Tables and Index)
• Provided extensive support for Application development Team for resolving the issues concerning to databases
• Solid experience in SQL, PL/SQL, SQL*Loader, Shell Scripts and JDBC programming
• Solid experience in DB Links for data transfer
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures
• Domain knowledge of Airlines, Data Storage, Manufacturing, Financial
• Having good technical and communication skills and very much adaptable to new environments

TECHNICAL EXPERIENCE

Operating System : Solaris, HP-UX, Linux, AIX, Dos, Windows
RDBMS : Oracle 8i, 9i, 10g, 11g with RAC, SQL Server, IBM DB2, MySQL
Languages : SQL, PL/SQL, Shell Scripting and Core Java
Tools : SQL*Plus, iSQL*Plus, SQL*Net / Net Manager, SQL*Loader, Oracle Enterprise Manager (OEM), Server Manager, RMAN, Oracle Export/Import, StatsPack, AWR, ADDM, Explain Plan, TKPROF, TOAD, Oracle Database Configuration Assitant
Design Tools : ERWin3.4 & 3.5, VISIO
Hardware : IBM eServer, Pentium Servers

EDUCATION

Master of Computer Application
Bachelor of Science – Physics

CERTIFICATION

Oracle Corporation
Oracle Certified Professional (OCP) - DBA

Brain Bench
Oracle PL/SQL
RDBMS Concepts
SQL (ANSI)

Sun Micro Systems
Sun Certified Java Professional (SCJP)

PROFESSIONAL EXPERIENCE

Database Administrator 04/07 – Present
Confidential, Fort Worth, TX

This project involves small to large volume of Oracle 7,8,9,10 and 11g databases on multiple UNIX platforms (HP-UX, Solaris, Linux, AIX) and windows NT with high availability environment of RAC and Standby servers with ASM to their premier Airline clients. Its 15 members of DBA team supporting around 601 oracle instances on all platforms.

Responsibilities

• The environment is 234 servers and around 601 database instances on UNIX and Windows platforms
• Managing 53 instances on Oracle 8i,9i and 10g with ASM/RAC environment databases on Sun Solaris, HP-UX and Linux
• Managing database sizes lower as 50gb to higher as approx 600gb
• Installation and Configuration of Oracle 10g Real Application Clusters (RAC) on 2 & 4 nodes with Automatic Storage Management
• Providing 7x24 support and on-call support with pager
• Managing Oracle9i and 10g server with Real Application Cluster environment with Standby DataGuard on HP-UX and Solaris
• Handling day-to-day activities on 8i, 9i and 10g servers
• Database patches and upgrades of Oracle 8i, 9i and single instance to RAC instances on Solaris, HP-UX, Linux and Windows environments
• Migration from Oracle 8i to Oracle 9i and 10g on UNIX
• Refreshing Pre-Prod, Development and Test Environment using Production data
• Involved in refreshing lower environment schemas with production data periodically using EXP/IMP and Data Pump
• Monitoring databases with own scripts for (Tablespace, Rollback Segment, Table and Index fragmentation and Audit User Access, Oracle Home cleaning)
• SQL and PL/SQL tuning using various diagnostic tools like Explain Plan, Trace, TKPROF, Statspack, AWR, ADDM
• Server managed backup & recovery using 9i and 10g RMAN, logical Export/Import & Data Pump as the backup & recovery tool, developed SQL Scripts for cold and hot backups
• Creating Users, Schemas, Tablespaces, Tables, Partitioned Tables and Index, Indexes, Sequences, Synonyms on 8i, 9i and 10g
• Creating roles and enabling, disabling roles on all databases(8i, 9i, 10g)

Environment: Oracle 8i, 9i, 10g, & 11g Sun Solaris, AIX, HP-UX, Linux, Windows, SQL*Plus, PL/SQL, SQL*Loader, RMAN, Putty, Citrix, Erwin, TOAD,

Database Administrator 12/06 – 03/07
Confidential, Ann Arbor, MI

This project involves production support, Monitoring and maintenance of all Oracle database servers. The database support operation includes schema design, DB change promotion, space management, performance tuning, routine statistics gathering, object maintenance and loading of data from mainframe systems. Backup and Recovery with use RMAN, Export & Import and database patching for all the servers. It’s a very huge environment.

Responsibilities

• Managed Oracle9i and 10g server with Real Application Cluster environment on HP-UX and Solaris
• The environment is 586 servers and around 1300 database instances on UNIX and Windows platforms
• Installed and Configured of Oracle 9i & 10g servers on UNIX (HP-UX, Solaris)
• Handled day-to-day activities on 9i and 10g servers
• Database patches and configuration of Oracle 9.2.0.3 to Oracle 9.2.0.7 Server on HP-UX, Solaris and Windows environments
• Monitoring 8i, 9i and 10g databases with own scripts for (Tablespace, Rollback Segment, Table and Index fragmentation and Audit User Access)
• Peak time monitoring 9i and 10g databases with use of 9i and 10g Statspack
• SQL and PL/SQL tuning using various diagnostic tools like Explain Plan, Trace, TKPROF, Statspack
• Server managed backup & recovery using 9i and 10g RMAN, logical Export/Import as the backup & recovery tool, developed SQL Scripts for cold and hot backups
• Physical and Logical design / model with Erwin Data Modeler
• Customize and Implement SQL * Loader utility for loading the data
• Creating Users, Schemas, Tablespaces, Tables, Partitioned Tables and Index, Indexes, Sequences, Synonyms on 8i, 9i and 10g
• Created roles and enabling, disabling roles on all databases(8i, 9i, 10g)
• Provided 7x24 & on-call supports

Environment: Oracle8i, 9i & 10g, HP-UX, Solaris, Windows, SQL*Plus, PL/SQL, Erwin, TOAD, RMAN, Putty, Citrix

Database Administrator 06/06 – 11/06
Confidential, Augusta, ME

The state of Maine Central Voter Registration System (CVR) project is to eliminate the copies of voter databases at Town/City level and replace the Town/City systems with a statewide voter registration system and a centralized voter database.

Responsibilities

• Installed and configured Oracle10g Server and database instances on HP-UX and Windows XP environments
• Maintenance of the 10g database, handling day-to-day activities, supporting developers with their problems
• SQL and PL/SQL tuning using various diagnostic tools like Explain Plan, Trace, TKPROF, Stats Pack
• Monitoring 10g databases with own scripts for (Free space in Tablespace, Rollback Segment, Table and Index fragmentation and Audit User Access)
• Performance & Tuning for database instances and physical memory
• Managed and monitored Oracle 10g Data Guard – physical standby database for high availability
• Server managed backup & recovery using 10g RMAN, logical Export/Import as the backup & recovery tool, developed SQL and scripts for cold and hot backups
• Establish and maintain sound backup and recovery policies and procedures
• Physical and Logical design / model with Erwin Data Modeler 7.1
• Reverse Engineering of the database, generated database objects through Designer
• Customize and Implement SQL * Loader utility for loading the data
• Managing object and system privileges, granting, revoking privileges
• Creating roles and enabling, disabling roles
• Developing PL/SQL Objects Triggers, Packages, Stored Procedures and Functions to enable the client call from the front end and load data from one schema to another
• Providing 7x24 supports

Environment: Oracle10g, HP-UX 10x, Windows XP, SQL*Plus, PL/SQL, SQL*Loader, Erwin, TOAD, RMAN, Putty, JBOSS, Tomcat, J2EE

DBA 05/03 – 05/06
Confidential, Trichy, India

Confidential is a software product which can provide the Supervisors in an automotive shop floor with tools to optimize operators’ deployment and manage skills & training needs.

Responsibilities

• Installed and configured Oracle Server and database instances in multiple OS environments, including patch installations
• Physical and Logical design / model using Erwin 3.5
• Providing production support to maintain data integrity, performance, security and availability of the production environment database
• Create standby database for production database on Oracle to manage switchover and failover capabilities
• SQL and PL/SQL tuning using various diagnostic tools like SQL TRACE, TKPROF, STATSPACK
• Server managed backup & recovery using RMAN, logical Export/Import as the backup & recovery tool, developed SQL and scripts for cold and hot backups
• Establish and maintain sound backup and recovery policies and procedures
• Provide technical consultation to application developer and end users
• Customize and Implement SQL * Loader utility for loading the data
• Managed Real Application Clusters Oracle9i
• Managing object and system privileges, granting, revoking privileges
• Developed Database Triggers, Packages, Stored Procedures and Functions to enable the client call from the front end
• Provided 7x24 supports with use of Remedy

Environment : Oracle 8i & 9i, Windows NT, HP-UX, SQL*Plus, PL/SQL, SQL*Loader, ERWin3.5, TOAD, RMAN, IBM Web Sphere

Database Developer 02/02 – 04/03
Confidential, Trichy, India

Confidential is a software product. It is a complete Accounting and Financial Management System and also it offers unmatched flexibility to further take care of client specific needs. It manages the business Accounting, Inventory and Order Processing.

Responsibilities

• Created database objects like Tables, Indexes, Sequences, Synonyms, etc
• Wrote PL/SQL stored procedure, functions, triggers and packages
• Used TOAD to run SQL and PL/SQL code to manipulate the databases in all environments
• Migrated the data from Excel sheets, text files into the respective Oracle Database tables using SQL *Loader scripts
• Developed Java Programming
• Network Administration, System and troubleshooting

Environment: Oracle 8i, TOAD, PLSQL, SQL plus, SQL Loader, ERWIN, J2SDK, Windows, UNIX