Summary





Professional experience of over 3 years productive and successful experience in all aspects of Oracle database administration in a growing 24/7 environment .I have completed many projects with full life cycle. Team player attitude with the ability to work independently. Ability to communicate with peers and management. Ability to mentor other DBA s and associates


Employment

February, 2009 -  Present

Oracle DBA

Client : BFL Groups, Brazil.

Responsibilities : -

Created the Oracle objects with constraints, application users and table space allocation.

Monitored the daily, weekly and monthly activities of the application like sessions, locks, security policy and fragmentation using the tool Toad and UNIX utilities.
Hot or Cold backups, Full back and Incremental backup, Physical and Logical backup.
Backup and Disaster recovery with recovery manager RMAN and Recover user table with FLASHBACK.
Hot or Cold backups, Full back and Incremental backup, Physical and Logical backup.
Created and maintained users, Indexes, roles and privileges.

Environment : Oracle 9i, SQL, PL/SQL, RMAN, Import, Export, HP-UX, Java, Eclipse, Forms 6i, FTP, Data Tapes.

Nastek Solution Pvt Ltd Mumbai July 2007 to Jan2009
SAP/Oracle DBA

Client : UNITED PHOSPERES LTD, Gujarat.

Production and Inventory system is meant for an industry. It has more than 8 modules which consist of product, customer, order entry, supplier, inventory etc .I was responsible to modify the attributes in customer module and create a new instance, procedures for inventory. IFACS package was developed to build the information regarding financial status of a company. It has everything like accounting, statues, financial management etc

Responsibilities : -

Installed the application, configuring the Oracle database Server, windows, Solaris and maintaining the application software by applying patches.
Created the Oracle objects with constraints, application users and tablespace space allocation.

Provided the 24/7 production support and even on call support to other locations provided.

Monitored the daily, weekly and monthly activities of the application like sessions, locks, security policy and fragmentation using the tool Toad and UNIX utilities.
Transfer data between different databases with SQL * loader, Import or Export.
Implemented the backups using the scripts and verify success of backup. Tape backups.
Recovery plans on event of disaster with RMAN and maintain BDC.
Writing scripts, procedures, Packages and run standard packages to check invalid objects.
Export or Import of data with in the data centers.
Analyzing V$ views, explain plan and tune memory buffers, archiving.
Resolve the end users quires, network related problems and write documents on project.

Environment : Oracle 10g, SQL, PL/SQL, RMAN, HP-UX Import, Export, Sybase 11, Windows 2000, Toad, Linux, Solaris, Java, Eclipse, HP Proliant ML, Erwin, Forms 6i, FTP, Data Tapes.

June, 2007 -  June, 2008

IFACS

package was developed to build the information regarding financial status of a company. It has everything like accounting, statues, financial management etc.

Responsibilities : -

Part of a 3 member DBA team which was involved in the maintenance of the Oracle 9i/10g database for the Production and the development environments.
Implemented and configuration of RMAN Catalog and STATSPACK.
Hot or Cold backups, Full back and Incremental backup, Physical and Logical backup.
Backup and Disaster recovery with recovery manager RMAN and Recover user table with FLASHBACK.
Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
Tuned SQL queries using TKPROF, Analyzer Monitor USAGE and EXPLAIN Plan.
Managed and maintained data in all production and non-production databases, Database sizing, Capacity and Planning.
Review alert logs and dump files to check for any problems related to the database.
Created and maintained users, Indexes, roles and privileges.
Perform Space Management and Troubleshooting the database issues.
Maintained and developed SQL script, PL/SQL procedures, functions, packages
Objects and triggers for inserting, updating, retrieving and validating of data

Environment : Oracle 9i/10g Windows 2003, IBM Server, SQL PLUS, Toad
Remote Desktop Connection and FTP Server

June, 2004 -  June, 2006
Software Engineer/ DBA

June, 2006 -  June, 2007

Education

Skills


Applications Ms- Office XP/2000, Microsoft Project Central. Languages SQL, PL/SQL, Shell Scripting, T-SQL, Databases Oracle 8i/9i/10g on Windows and HP-UX platform, Sql Server 2005, MS-Access 2000, Sybase 12 .x Utilities RMAN, Export, Import, Data Pump, SQL*Loader Tools Crystal Report 7.0, Toad Hardware HP ML servers, Dell, Compaq, IBM and Sun servers, HP Tapes Operating Systems Solaris 5.9, Windows 2003/2000/XP/NT, UNIX Server/workstation, Linux RHAS 5, Hp-Ux. Technologies Visual Basic 6.0, ASP. NET, SAP Business 1, Forms 6i. The technology powers e-Learning, campus enterprise information portals and student commerce. The delivery of education services online for global commercial and academic Internet services, the client s are secondary schools, higher education, corporate and government markets deliver on the promise of the internet for online teaching and learning, campus communities, campus commerce services and the integration of Web-enabled student services and back office systems. Responsibilities : - Installed the application, configuring the Oracle database Server, windows, Solaris and maintaining the application software by applying patches. Created the Oracle objects with constraints, application users and tablespace space allocation. Provided the 24/7 production support and even on call support to other locations provided. Monitored the daily, weekly and monthly activities of the application like sessions, locks, security policy and fragmentation using the tool Toad and UNIX utilities. Transfer data between different databases with SQL * loader, Import or Export. Implemented the backups using the scripts and verify success of backup. Tape backups. Recovery plans on event of disaster with RMAN and maintain BDC. Writing scripts, procedures, Packages and run standard packages to check invalid objects. Export or Import of data with in the data centers. Analyzing V$ views, explain plan and tune memory buffers, archiving. Resolve the end users quires, network related problems and write documents on project. Environment : Oracle 8i/9i/10G, SQL, PL/SQL, Sybase 11, Windows 2000, HP-UX, Toad, Forms 6i, FTP, Data Tapes. Client : Spic Pharmaceuticals Limited Chennai Production and Inventory system is meant for an industry. It has more than 6 modules which consist of product, customer, order entry, supplier, inventory etc .I was responsible to modify the attributes in customer module and create a new instance, procedures for inventory. Responsibilities : - Studied all the PIS product modules. Involved in re-structuring of the entities using Erwin tool. Modified the parameter file for performance, table spaces space allocation and Database monitoring. Procedures and triggers for Inventory and BOM module. Used exports/imports to move data from production to development databases. Backup and recovery scripts were maintained and monitored the application data. Installation of SQL server, Oracle, Erwin tool software, documents on project activities. Environment : Windows NT 2000, Oracle 8i, Forms 6i, SQL, PL/SQL, Ms-office XP, HP servers. Date : Place : Chennai Kesavan .K 1