Summary

20+ year record of innovation in diverse business environments developing newapplications, maintaining and enhancing existing systems, managing teams of software engineers, and mentoringfellow employees. Expert in enterprise infrastructure and architecture, migrating legacy operations to Oracle and unix. Expertise in Oracle database design and administration. Adept at creation, configuration, administration, and tuning of multiple databases up to 10 TB in size within mission-critical, 24x7 production environments. Implemented high availability architecture to fit within business requirements. Professional communication and collaborative abilities. Core competencies include:

• Database Development & Administration
• Database Evaluation, Tuning & Maintenance
• Security, Backup & Recovery
• Troubleshooting & Problem Resolution
• Data Modeling
• Standards Development
• Installation & Upgrades
• User Training & Support

Platforms:

UNIX [HP-UX 10.x & 11.x, AIX, Windows 2000 Advanced Server/NT 4.x/9x/3.11, Linux

Language

SQL, PL/SQL, C, Pro *C, Java; UNIX Shell scripting, Cobol, Visual Basic

Hardware:

RISC Servers [HP C360, J5000 & L2000]; NetAPP Network Attached Storage (NAS) F740; Compaq DL380 servers, RAC, ASM.

RDBMS:

Oracle 11g, Oracle 10g, Oracle 9i, 8i, 8.0.x & Oracle 7.x, MSAccess.

Tools & Applications:

Oracle Enterprise Manager (OEM), Recovery Manager (RMAN), LOGMINER, Designer 9i, SQL*Loader, Datapump, PL/SQL developer, Developer 10g (Oracle Forms, Reports and Graphics), SQL*Plus, UNICENTER SQL-Station Version 7.0, SQR, Checkmate, ClearCase, CoSort, Autosys.

Middle Tier:

Oracle 10g Application Server (IAS), Oracle 9i Application Server (IAS)

EXPERIENCE HIGHLIGHTS:

• Experienced in Oracle database administration, backup and recovery, schema maintenance, performance tuning, performance monitoring, space management, production support 24x7 and in PL/SQL. Possess excellent interpersonal, communication and technical skills.
• Experienced in Oracle Database 11g,10g / 9i / 8i / 8 / 7.3/6/5, installation, configuration and administration on Sun Solaris, Windows, HP UNIX, IBM AIX and Linux Redhat 3/4 ES/AS.
• Experienced in installation, configuration and administration of Oracle 11g/10g/9i Real Application Cluster (RAC).
• Experienced in Installation and Configuration of Physical Dataguard databases,
• Experienced in Oracle databases cross-platform migration, upgrading and Maintenance of the Oracle Databases.
• Experienced in developing and implementing standards, procedures for operation, access, control, backup and recovery policies of database and application servers.
• Experienced with UNIX System Administration, which includes creating and managing users groups and profiles, installation of software, system securities, creating and managing file systems etc.
• Implemented OEM in grid environment to monitor all the databases and to send email alerts of database status.
• Experienced in backup, recovery using RMAN, from both Hot Backup/Cold Backup.
• Experienced in database performance tuning and optimization, using STATSPACK, using TKPROF, generating EXPLAIN_PLAN, studying trace files etc. Used ADDM and AWR for performance tuning from oracle 10g onwards.
• Experienced in implementing data warehouse using PL/SQL, SQL*Loader, DATA PUMP, ETL etc.

Confidential,Santa Clara, CA
SR Database Administrator/Solution Architect 12/2011 - Present
Performed critical roles in design, development, implementation, enhancement, and maintenance of client applications.

• Physical and logical designing of database with the distribution of data-files on different disks.
• Architectural evaluated between the Sun Solaris and Linux servers to replace the existing servers which are running slow and is not able to handle the current volume of data and applications.
• Designed and implemented Disaster Recovery strategies on NAS storage, and used Dataguard to create the Physical Standby databases.
• Installed Oracle 11g database in Unix environment and migrated the data from Oracle 9i to 11g. Created Installation scripts to create schema objects (Users, Tablespaces, Tables, Constraints, Synonym, sequences, roles and privileges, Triggers) .
• Implemented NetApp, for backup and restoring the database.

Environment: UNIX (Sun Solaris), Linux, Oracle 11g/10g/9i, ER*Win, RAC, Developer 10g (Oracle Forms, Reports), Oracle 10g Application Server (IAS), PL/SQL, SQL, Shell Scripting (Ksh), Perl, OEM, NetApp, AWR reports and performance tuning.

Confidential,Milpitas, CA
SR Database Administrator/Solution Architect 04/2011 – 11/2011
Performed critical roles in design, development, implementation, enhancement, and maintenance of client applications.

• Physical and logical designing of database with the distribution of data-files on different disks.
• Architectural evaluated between the Sun Solaris and Linux servers to replace the existing servers which are running slow and is not able to handle the current volume of data and applications.
• Designed and implemented Disaster Recovery strategies on NAS storage, and used Dataguard to create the Physical Standby databases.
• Installed Oracle 11g database on Unix server in RAC environment and migrated the data from Oracle 10g to 11g. Created Installation scripts to create schema objects (Users, Tablespaces, Tables, Constraints, Synonym, sequences, roles and privileges, Triggers) .
• Created batch scripts to upgrade ORACLE forms 9i to 10g and solved all the issues corresponding to the upgradation.
• Implemented RMAN, for backup and restoring the database.

Environment: UNIX (Sun Solaris), Linux, Oracle 11g/10g/9i, ER*Win, RAC, ASM, Developer 10g (Oracle Forms, Reports), Oracle 10g Application Server (IAS), PL/SQL, SQL, Shell Scripting (Ksh), Perl, OEM, RMAN, AWR reports and performance tuning.

Confidential,Parsippany, NJ
SR Database Administrator/Solution Architect 11/2007 – 03/2011
Performed critical roles in design, development, implementation, enhancement, and maintenance of client applications.

Confidential,NJ
Caller usage metering application:
Wireless Communications has a usage metering application that keeps track of duration of each cellular call and services used. For example, if a caller makes a regular call, a base rate applied for the duration of the call, if a caller uses special features like roaming, extra charges applied.

The usage metering application efficiently monitors concurrent calls, gather usage data on each call, and write those details into a binary flat file. The files generated are sorted and converted into ascii format and loaded the data in a central database for use by other applications that generate bills, reports, audits, and so on. I have worked on the part of loading the data into central database.

Confidential,Ohio

• Evaluated each organization’s needs and unique requirements, and determined hardware and software solutions best suited to improve the current systems.
• Physical and logical designing of database with the distribution of data-files on different disks.
• Architectural evaluated between the Sun Solaris and Linux servers to replace the existing servers which are running slow and is not able to handle the current volume of data and applications.
• Designed and implemented Disaster Recovery strategies EMC Symmetric and ASM, and used Dataguard to create the Physical Standby databases.
• Installed Oracle 11g database on Unix server in RAC environment and migrated the data from Oracle 7 to 11g. Created Installation scripts to create schema objects (Users, Tablespaces, Tables, Constraints, Synonym, sequences, roles and privileges, Triggers) .
• Created batch scripts to upgrade ORACLE forms 9i to 10g and solved all the issues corresponding to the upgradation.
• Planned and scheduled production jobs, and supervised and assisted team of developers building applications for UNIX/Linux interfaces through Autosys.

Environment: UNIX (Sun Solaris, AIX, HP), Linux, Oracle 11g/10g/9i/8i/7, ER*Win, RAC, ASM, Developer 10g (Oracle Forms, Reports), Oracle 10g Application Server (IAS), PL/SQL, SQL, Autosys, Shell Scripting (Ksh), Perl, OEM, RMAN, AWR reports and performance tuning.

M.C.A. (Masters Degree in Computer Science)