Career Summary

• Senior-level Oracle Database Administrator with over 15 years of experience in the administration of relational databases (Oracle, Ingres) which includes analysis, design, development, database administration and tuning.
• DBA skills include the Backup and Recovery management (RMAN), Business Continuity Plan (BCP) using Standby databases (DATAGUARD), SHAREPLEX Replication tool, monitoring of database instances 24x7 using UNIX shell scripts, data modeling tools like ERWIN, third party tool (TOAD) and GRID CONTROL.
• Performed installations and upgrades of Oracle software, Real Application Clusters (RAC 10g & 11g) implementation in Linux, Sun & TRU64 environment, database tuning, transaction management and tuning of memory structures. Managed VLDBs in a critical OLTP production systems & replication environments.

Skills Recap

RDBMS: Oracle (11g,10g,9x, 8x), Ingres 2.5/6.4
Oracle Tools: RAC, Grid Control, RMAN, DATAGUARD, SQL*Plus
Languages: PL/SQL (Triggers, Procedures, Functions, Packages), Scripting 
Modeling: Erwin 4.1.4
OS: SUN Solaris 5.10, Linux 5.2,5.4,AIX 5L, True64 UNIX v 5.1, Open VMS 7.2,
Windows 98/Windows NT workstation
Packages: Quest Tools – TOAD,Shareplex, Spotlight, SQLABXPERT, Space Manager MSOffice 2000, Project 2000
Hardware: Compaq Alpha/GS160Alpha 2100, Turbolaser 8400/GS140, HP 9000 series

Professional Experience

Confidential (01/11-Till Date) Sr. Oracle DBA Phoenix, AZ

Responsibilities

• Upgrade Oracle Databases to 11g
• Test and Implement new oracle 11g features like duplicate database, dataguard
• RAC proof of concept using 11gr2.
• Documentation of upgrade procedures and issues while upgrading to 11g.

System Architect/Oracle DBA (Consultant)

Responsibilities

• Implementation of Grid Control for monitoring, maintenance and troubleshooting the Oracle databases.
• Work on plan to rollout oracle 11G and RAC on Linux based on reference architecture.
• Work with Performance engineering group to troubleshoot production issues.
• Worked with different database groups to streamline the implementation of oracle RBAC based on company’s defined roles and responsibilities procedure.
• Work with various database groups on capacity planning, propose and implement new database environments based on the customer requirements providing HA solutions.
• Mentor other DBAs to provide technical knowhow to troubleshoot and maintain oracle database environments.
• Test and Document migration plans for new acquisitions/mergers from the database perspective.
• Create standard process document for the end-to-end delivery of database environments.
• Test & Implement various oracle application tools like SOA, BI publisher, AIA, workbench.

Sr. DBA
Responsibilities

• Worked on POC for upgrade from 9i to 10G
• Rolled out 10g upgrade as per the approved plan on different databases
• Support Application development in design, tuning and implementation of new code
• Worked on the POC for various tools for Reporting servers
• Troubleshooting issues with slowness, database access, tuning.
• Worked closely with different groups including application, operations, Sys Adm., network as per the requirements

Environment: UNIX, Windows, Oracle (8i, 9i, 10g)

Oracle Consultant (Contract)
Responsibilities

• Responsible for implementation of Logical standby database using Oracle 9i.
• Installation of Oracle Client/Server software on various machines
• Implementation of Grid Control 10g in various production environments.

Environment: Sun Solaris, Oracle 9i, 10g

Confidential (03/06-07/06) Phoenix, AZ

Oracle Consultant (Contract)
Responsibilities

• Proof of Concept for upgrade of Oracle database from 8i to 10g and documented the procedure.
• Proof of Concept of Oracle Streams 10g and documented the results.
• Worked on the Oracle PL/SQL package to implement database uptime report.

Environment: UNIX, Oracle 9i, 10g

Confidential (10/98-03/06) Scottsdale, AZ

Sr. Database Administrator
Responsibilities

Role: Oracle Database Administration

• Managing large databases using New Oracle features like partitioned Tables, spifle, and dynamic memory structures.
• Install and Upgrade Oracle on all the hosts as required and prepare documentation to follow standardized procedures.
• Develop procedures to automate database administration functions like startup and shutdown of Oracle databases, backup procedures, tablespace management.
• Implementation of databases inside and outside the firewall.
• Write shell scripts in Unix and VMS to effectively monitor the critical areas of databases like monitoring tablespaces, archive destination, replication, performance stats, mount points, checking and trimming alert.log.
• Develop and Implement Business Continuity Plan (BCP) using Standby Database (8i) and DataGuard(9i).
• Use OEM and TOAD for various database functions
• Test and Implement Backup and Recovery Plans based on the user requirements using RMAN incremental backups and OEM, Cold & Hot backups, and export backups.
• Write data pipelines for movement of data across the databases and platforms
• Use Oracle utilities like SQL*LDR to load external data
• Establish ODBC connectivity between heterogeneous platforms
• Define and enforce data standards by having standard naming convention
• Use data modeling tools like ERWIN in the physical design of database
• Implement Triggers and PL/SQL Procedures to support the production processes
• Enforce business rules through Integrity constraints
• Implement security procedures.
• Setup of Data Migration Process from Ingres to Oracle Platform
• Use of Basic Oracle Replication
• Test and promote Quest SHAREPLEX replication tool between different instances for High Availability.
• Standardize listeners (Net8) across the different platforms and hosts
• Define standards and procedures for database creation, naming of mount points, object and entity naming, use of datatypes, storage of dba scripts, promotion from development to test to production
• Manage Users, Roles, Resources
• Monitor and recompile invalid objects
• Backup of control file
• Maintain trace file locations, trimming listener. log files

Performance Tuning

• Test and Implement new Features of 9i
• Disk load balancing
• Monitor CPU utilization
• Monitor and optimize various Oracle memory structures like shared pool, data buffers, redo-buffers, sort areas
• Monitor and manage the rollback/undo segments
• Use of estats/bstats to resolve any SQL Tuning issues
• Maintenance of indexes and tables, load balancing by striping data by using partitioning, analyzing tables
• Troubleshoot the user queries using Explain Plan.
• Manage temporary segments

Assistant Manager (Systems)
Responsibilities

• Database Design, database performance Tuning, database maintenance and security procedures.
• Planning, analyzing, designing, testing and implementing new developed applications based on the changing needs of the company and an on-going need to update the software being used in its operations.
• Software developed increased productivity and operational efficiency by 400%, for this company as a result of total integration of all the application software running in different functional areas of the company.
• Recognized with ‘Award of Excellence’ by the Management for my contributions in the development and automation of application software.

Environment: UNIX, Windows, Oracle

Customer Support Specialist
Responsibilities

• Involved the study of Business models, Development and design of the relational databases
• Implement and troubleshoot the local area networks

Environment: Unix, Windows, Oracle

Education

M.S. (Computer Applications) 
B.S. (Math)