Dhinakaran R S(oracle Dba)

DHINAKARAN.R .S. Contact: 91-9841651594 (Mobile) 91-44-27162010 / 27163296 (Res.) 91-44-22203110 / 22203234 (Off.) Email: [email protected] OBJECTIVE To obtain role where I can exploit my excellent productivity and experience as an Oracle Database Administrator. SUMMARY OF PROFESSIONAL · ·

Information Technology professional with 3+ years of experience in application development and data management on several different platforms. A Oracle Certified Professional with 2+ years of experience as an Oracle Database Administrator in Oracle 9i on Sun Solaris, RedHat Linux, Unix and Windows NT/2000 platforms.

SUMMARY OF EXPERTISE · · · · · · · · · · · · · · · · ·

Oracle Architecture / Server Knowledge, Database Design and maintenance of Database. Installation in various platforms Planning and Creation of Databases. Exporting and Importing databases Creating tablespaces, sizing the system tablespace, allocating default tablespace for users, rollback segment tablespace, temporary tablespace, data tablespace, index tablespace and so on. Creating tables and indexes, sizing their extend, partitioning and so on Creating users with restricted access, with default and temporary tablespaces. Creating roles and granting to users based on their group requirements. Creating profiles and attaching them with users Performing hot and cold backups Physical Backup with / without RMAN Restoration and recovery from backup Sizing the SGA. Sizing the db buffers, shared SQL area, log buffer based on the requirements. SQL issues and Tuning Considerations for Different Applications Monitoring the table growth, database growth, current users, system resource usage and so on. Experience in SQL*Loader, loading data from text files. Knowledge in writing shell scripts for automating backups and restoration.

PROFESSIONAL SUMMARY · · · ·

Database Administrator, Ramanujan Computing Centre, Anna University, Chennai, India, August 2003 to Till Date. System Programmer, Ramanujan Computing Centre, Anna University, Chennai, India, November 2001 to August 2003. Faculty , TCIL-IT Computer Education and Training Center, (Govt. of India Enterprise), Sriperumbudur, India, June 1998 to October 2001. Supervisor, DATA SYNERGIES, Chennai, India, June 1996 to May 1998.

SOFTWARE WORKED Operating Systems

:

RDBMS DBMS Oracle Tools Language GUI

: : : : :

Novell Netware 4.1, SCO UNIX R 5.0.4, Sun Solaris 9, Linux 8, Windows 95/98/NT/2000 Oracle 9i. FoxPro, Dbase. OEM, SQL *Loader Export/Import, Oracle Installer C, C++, SQL. Visual Basic 5.0/6.0, Developer 5.0

- 1/3 -

Scripting Language

:

Unix Shell Scripting

- 2/3 -

PREFESSIONAL CERTIFICATION ·

Oracle Certified Professional in Oracle 9i Database Administration.

·

Post Graduate Diploma in Computer Applications at LIBA (Loyola Institute of Business Administration), Chennai. Diploma in Computer Applications at LIBA (Loyola Institute of Business Administration), Chennai.

·

ACADEMICS · ·

Master of Science in Mathematics (pursuing) at University of Madras, Chennai, India. Bachelor of Science in Mathematics, University of Madras, Chennai, India.

Personal Details Date of Birth Marital Status

: :

23rd April, 1974. Married.

Passport No.

:

F636202

Address

:

# 14A, Reddy Street, Sriperumbudur, India – 602 105.

PROFESSIONAL EXPERIENCE Database Administrator, Ramanujan Computing Centre, Anna University, Chennai, India, August 2003 to Till Date 1. Academic Information Management System Client Role Environment Team Size Description

: : : : :

Anna University Oracle DBA Oracle 9i, Developer 2000, IBM Netfinity 5100, Win NT 4.0. Five Academic Information Management System (AIMS) is a software package developed for recording the academic activities of each individual students and their respective academic performance to the database. Academic performance of each student progress can be generated using AIMS software in the form of reports. Information related to Degree programme offered by College of Engineering, and other constituent colleges of Anna University are maintained, based on that students are evaluated according to their respective degree.

Responsibilities: · Installed Oracle 9i Database software in Windows NT, created database according to the requirement of Application Software, monitored and configured databases. · Oracle Database Administration (logical & Physical database backup, database tuning) Daily database backup, tablespace administration, SQL net configurations and basic database tuning as part of maintenance activities. · Maintenance of existing system and provide advanced level support. 2. TNEA – 2004 and 2005 (Tamilnadu Engineering Admissions System) Client Role Environment Team Size Description

: : : : :

Anna University Oracle DBA Sun Solaris 8, Oracle 9i, Windows 2000, SQL *Loader, Export and Import. Four Distributed Engineering Admission processing for all over Tamilnadu engineering colleges done by Anna University. It’s around 235 engineering colleges are situated, and around 50,000 seats are filled by this processing. Maintaining 1,40,000 records to fill for the 50,000 engineering seats. Oracle 9i was the database on the Sun Solaris operating system and Developer 2k was the front end software on the Windows 2000 operating system.

- 3/3 -

Responsibilities: · DBA Activities -Development and Implementation Installation of Oracle database on Sun Solaris Installing Developer 2000 on client nodes (Windows 2000). · Created links between the four database servers. · Installation of Oracle server, OEM and associated tools. · Configured SQL *Net on client nodes. Creating Table spaces, Users. User role creation. · Security and Disk space Management. Loading data from ASCII files into Oracle database. · Writing control scripts for loading data and validation of data. Taking everyday backup. · Since it was a distributed processing, I took care for one of the admission centre System Programmer, Ramanujan Computing Centre, Anna University, Chennai, India. November 2001 to August 2003. 1. Rate Contract System Client

:

Role Environment

: :

Team Size Description

: :

Association of State Road Transport Undertakings (Govt. of India Undertakings) 7/6 Siri Fort Institutional Area, Khel Gaon Marg, New Delhi-110049, India. Team Member Oracle 9i, Windows NT 4.0, SQL, Developer 2K 5.0, SQL* Loader, Export and Import Eight This system is developed to computerize the activities of the Association of State Road Transport Undertakings towards the acquisition of varies components of spare used in buses owned by State Transport. Rate Contract Module processes the information provided through price master based on various parameter such as volume of supply, reliability of supply over a long term and quality. This module consists of various user input screens. The processed information generated in the form of reports. The other reports towards statistical studied of Per Kilo Meter cost of operating fleets of buses owned by State Transport was integrated in the final phase of project for providing Statistical information to Ministry of Surface Transport, Government of India.

Responsibilities: · · ·

Involved in System study, Analysis, Design and Developed screens using forms. Developed back-end Stored Procedures, triggers, functions. Worked on import/export and Sql- loader. 2. Post Graduation Admission System

Client Role Environment Team Size Description

: : : : :

Anna University Designing and Coding Visual Basic 5.0 Three The admission processing system has been developed and implemented successfully. Different courses like M.E., M.Sc. and M. Tech have different admission procedures. The system developed is menu driven and the user initially has to select the course name from the pull down menu. Overall merit list and community wise merit lists are generated.

Faculty, TCIL-IT Computer Education and Training Center, Sriperumbudur, India. June 1998 to October 2001. Supervisor, DATA SYNERGIES, Chennai, India. June 1996 to May 1998. Creation of data formats using Foxpro, Data analysis for Consumer Research, Industrial Research, Television Panels, Bank and Financial companies etc. Also involved in overall management.

- 4/3 -