Oracle Plsql Developer

VIGNESH KUMAR R

Email – ************@*****.*** 20 CAS colony 1’st street,

Mobile +91-962******* Old vilangudi road,Post,

Madurai (Dist) 625018

OBJECTIVE

Seeking a position to utilize my skills and abilities in the software industry that offers professional

growth while being resourceful and innovative.

SUMMARY

•MCA(Computer Application) with 1.5 year of IT experience in designing, developing and maintaining

DataBase applications.

•A good communicator with leadership, analytical, relationship management and co ordination skills.

PROFESSIONAL EXPERIENCE

Medmeme Informatics Pvt Ltd: Nov 2012-Present

Database Administrator

Responsible for Oracle 10g logical and physical database design, implementation, and maintenance on Windows 7

Created new databases and users: set up backups, export, and other monitoring scripts

Implemented database refresh using full export for table level and full database defragmentation, resulting in

improved performance and effective space management.

Managing database security. Design, develop, and implement automated data backup and restoration procedures.

Provide technical support for database maintenance and disaster recovery

Identify, recommend, and implement all new database technologies and Oracle license management.

PROJECT DETAILS

(1). DashBoard

Team Size: 6

Client – Medmeme

Role: PL Sql Developer/DBA Administrator

Environment : – PHP,ORACLE 10g,11g

Description

Global Database Dashboard project contains Organizations and Meetings worldwide medical domain.it has

relationship among organizations world wide.it has complete tree

stucture among the organizations relationship.

Global Database Meetings module continuously tracks more than 14,000 medical meetings and 5,100 peer reviewed

journals worldwide to amass approximately 800,000 medical meeting

abstracts annually. With data collected daily and extending back 10 years, this platform holds a growing body of

information on 6.5 million presentations,

making it the largest database of medical meeting abstracts in the world.

Responsibilities:

1) Design Database Schema for implement Complex business logic.

2) Create Entity Relationship (ER) Diagrams to the proposed database.

3) Extensively used Joins and sub queries for complex queries involving multiple tables from different users.

4) Create database objects such as tables, Stored Procedures, User Defined Functions, Views, Sequences,

Triggers for complex business logic.

5) Create All necessary constraint regarding to business logic when schema design.

6) Export and import data from CSV files, Text files and Excel Spreadsheets using Oracle Sql Developer.

7) Tuning a Procedure, view, complex business logic Query for Increase the performance.

8) Create Database Link to connect remote oracle servers.

9) Create tablespaces in database level.

10) Create Users and maintain each user in separate tablespaces.

11) Create dba roles to assign each users in Oracle Database Server.

12) Make Database Backup and Restore for security purpose using EXP, IMP, EXPDP, IMPDB utilities.

13) Bug fixing for existing procedure,views,functions etc.

14) Data Loading from one server to another using PL SQL scripts.

(2). Trialmeme

Team Size: 6

Client – Medmeme

Environment : JAVA, JSP, SQL Server 2008

Role: Sql Server Developer/DBA Administrator

Description

Global Database Trialmeme project offers detailed information on a growing body of more than 184,000

clinical trials globally, including historical data. Trials are continuously updated and searchable by disease, compound,

brand, mechanism of action, trial and recruitment status, location,

investigators, institution, and more. The platform also includes comprehensive information on where trial findings have

been presented or published.

Responsibilities:

1) Design Database Schema for implement business logic.

2) Create Entity Relationship (ER) Diagrams to the proposed database.

3) Extensively used Joins and sub queries for complex queries involving multiple tables from different

databases.

4) Create database objects such as tables, Stored Procedures, User Defined Functions, Views, TSQL

Scripting for complex business logic.

5) Export and import data from CSV files, Text files and Excel Spreadsheets using Sql server Management

Studio.

6) Tuning a Procedure, view, complex business logic Query for Increase the performance.

5) Create Linked Server to Move data from one server to another.

6) Tuning a Procedure, view, complex business logic Query for Increase the performance.

7) Create database objects such as tables, views, stored procedures, functions,Triggers etc.

8) Create All necessary constraint regarding to business logic when schema design.

9) Make Database Backup and Restore for security purpose.

10) Bug fixing for existing procedure, views, functions etc.

11) Data Loading from one server to another using TSQL scripts.

(3). Profilememe

Team Size: 6

Client – Medmeme

Role: Sql Server Developer/DBA Administrator

Environment : – JAVA, JSP, SQL Server 2008

Description

In Depth Profiles of 1.5 Million Thought Leaders

Global Database Profilememe project uses client specified criteria to identify, profile, rank, and map the most

influential experts in any disease or drug category. This database platform offers in depth and timely intelligence on 1.5

million medical and scientific experts worldwide, going back 10 years. By charting the professional pathways through

which medical knowledge travels, Profilememe lets clients identify and enlist experts whose opinions shape their

markets.

Responsibilities:

1) Design Database Schema for implement business logic.

2) Create Entity Relationship (ER) Diagrams to the proposed database.

3) Extensively used Joins and sub queries for complex queries involving multiple tables from different

databases.

4) Create database objects such as tables, Stored Procedures, User Defined Functions, Views, TSQL

Scripting for complex business logic.

5) Export and import data from CSV files, Text files and Excel Spreadsheets using Sql server Management

Studio.

6) Tuning a Procedure, view, complex business logic Query for Increase the performance.

7) Create Linked Server to Move data from one server to another.

8) Tuning a Procedure, view, complex business logic Query for Increase the performance.

9) Create database objects such as tables, views, stored procedures, functions, Triggers etc.

10) Create All necessary constraint regarding to business logic when schema design.

11) Make Database Backup and Restore using Sql server Management Studio.

12) Bug fixing for existing procedure, views, functions etc.

13) Data Loading from one server to another using TSQL scripts.

TECHNICAL SKILLS

Operating System: Windows 2000/XP/7/8,Ubundu 6.0

DataBase:

Oracle 10g,11g,Sql Server 2008

Language: C

Tools: Oracle Sql Developer, Sql Server Management Studio

SUMMARY OF QUALIFICATIONS

•MCA – Gandhigram Rural Institute Deemed University with 71% (2012)

•Bsc.(Mathametics) – Madurai Kamaraj University with 70% (2009)

•H.S.C – Tamil Nadu State Board with 74% (2006)

•S.S.L.C Tamil Nadu State Board with 90% (2004)

EXTRA CURRICULAR ACTIVITIES

•Had successfully completed 2 years of active NSS Campaign in the college and had participated in the

concurrent programs.

•Participated in State level Technical Symposium QUTRIX 2K11 conducted by PG & Research Department Of

Computer Science at Gobi Arts & Science College, Gobichettipalayam.

PERSONAL DETAILS

Fathers Name : Mr.K.Rajendran.

Date of Birth : 01 Nov 1988

Languages Known : Tamil and English.

Hobbies : Solving Puzzle, Working with Debugging in C

I hereby declare that all information furnished above is true to the best of my knowledge.

Place :

(R.Vignesh Kumar)

Date :

Contact this candidate