www.tarams.com Software Technologies Pvt Ltd Bangalore : Data Warehousing, Software Engineer

[muthukalee]

Tarams Software Technologies Bangalore : Software Engineer

Company Name : Tarams Software Technologies
Company Location : Bangalore
Designation (of vacancy) : Software Engineer
Company E-mail ID : jobs@tarams.com
Company Website : www.tarams.com

Job Description, Candidate Profile, Company Profile, Company Address :
Software Engineer

Job Code : DWIJT001
Description : Data Warehousing Professional
Location : Bangalore

Job Summary :
Design and develop data warehousing system for large business

Responsibilities :
Be responsible for release cycles and quality of the code
Interact with client to gather requirements and feed-back

Job Requirement :
Education : B.E/ B. Tech /MCA/ B.Sc (CS)/ M.Sc (CS)/ Grad+GNIIT

Experience :
2-4 Years of experience
Understanding of Dimensional Data Model
Through Knowledge of ETL and ELT frameworks
Knowledge of at least 1 ETL Tools (Talend or Kettle preferred)
Should have very good database design experience
Good knowledge of DB Concepts , SQL , Advanced SQL , Stored Procedures , Triggers etc
Understanding of DB Performance improvements and Query Optimization
Working knowledge of Java / C++
Working knowledge of shell scripts
Working knowledge of any reporting tool (Jasper Preferred)
Should have worked with an Application Server / Web Server (Nice to have)
Should have excellent written and oral communication skills
Should be a go-getter, able to think out of the box & take up responsibilities

To Apply to this job please go to this link :http://tarams.catchthebest.com/apply/1f84/6705

or send an email to jobs@tarams.com with the job code DWIJT001 in the subjectline

Contact us :
Tarams Software Technologies Pvt. Ltd.
#163/C, 1st Floor, 3rd Cross, 3rd Main,
J.P. Nagar 3rd Phase,
Bangalore - 560 078

[Guest-IJT]

Name : Mangu Singh
Email : mangusingh.mca AT gmail.com
Designation / Skillset : DBA


Resume :
Mangu Singh
To sharpen my skills through continuous learning, being on a challenging job and to work
OBJECTIVE :
Towards achieving the objective of the Organization.

ACTIVITIES :
- Installation and administration of Oracle Database and its Tools on various Operating Systems, such as Windows NT, Linux Red Hat Monitoring production and development environment
- Assistance in restoration exercises & recovery of database.
- Configuration of databases in RMAN
- Configured scripts to automate database changes and maintenance.
- Supporting 24x7 production databases.
- Physical design and implementing the database, including memory and disk space allocation.
- Logical database design including creation and sizing of logical storage structures such as tablespaces, tables and indexes.
- Taking and deciding the suitable kind of backup (Rman, Export, Cold and Hot backup).
- Written scripts for taking the both kind of backups (Online & Offline backup).
- SQL tuning through use of optimizer hints within SQL statements.
- AWR Report Analysis and Proactive tuning.
- Resolving Locking Issues.
- Configuring the Database Archiving Mode.
- User- Managed Complete Recovery.
- User- Managed Incomplete Recovery.
- Managing Users.
PROFESSIONAL QUALIFICATION :
1. Completed Master in Computer Applications (M.C.A) with 77.45% (Hons) in the year 2011 from ABES Eng College Ghaziabad affiliated to UPTU.
ACADEMIC QUALIFICATIONS :
1. Passed Graduation with Maths from IGNOU, New Delhi in the year 2008
2. Passed Intermediate in science from U.P Board in the year 1997
3. Passed High School from U.P Board in the year 1995

ACHIEVEMENTS :
1. I was topper in MCA 5th Sem with 83 % marks.
2. Completed Three ORACLE CERTIFICATION in 10 days with 92%, 88%, 90% marks..
1. OCA : Oracle certified associate
ORACLE CERTIFICATION :

2. OCP : Oracle certified professional
1 : Completed DBA 10g Training from PATH INFOTECH Ltd E-1,Sec 63 Noida
TRAINING & EXPERIENCE
2 : 3 year Teaching experience on the Part time basis
3 : 6 months oracle dba experience
Operating System : Windows & Linux
TECHNICAL SKILLS :
Database : Oracle10g.
Language Known : Core Java, SQL,HTML,PL/SQL.
Software/Hardware : Installing OS and Computer devices
Oracle10g Operations : Installing, DB Creation, Storage Tablespaces,
Oracle 10g Operations : Backups & Recovery, Performance, ASM.
AREA OF INTEREST:
Database Administration(DBA)
PROJECT DETAILS:
PROJECT 1:
Project Title : ATM Software
Description : This project provides the facility to Cash transfer from customer’s accounts.There
Is proper authentication and verification of each customer.Individual’s accounts
Get updated at the time of any transaction.This software basically mimics all major
Functionality of ATM
Role : System Design & Database Design.
Responsibilities : Analysis the SDLC phase use the waterfall model.Prepare the E R diagram, Design
The database.I completely done all work related database making all Tables as per
Need of Project.Database has full functionality of valdation.Apply all constraints of
Relational database management system (RDBMS).Use the primary key, reference
Key,unique key and check cnstraints ,NOT NULL constraints.This database is optimal
Performane.Remove the redundancy as possible according to system.This database
Accessing very fast due to use index concept.
Team Size : 3
Duration : August 2010 to October 2010
PROJECT 2 :
Project Title : News Network
Description : News Network is a web based functionality which can be used to provide updated
News on various categories for the viewers of the news channel. News Network
Provides a plateform for Reporters to submit the news to the channel and then
Editor can review the news content and assign it category
Role : System Design & database Design.
Responsibilities : Analysis the SDLC phase use the waterfall model.Prepare the E R diagram, Design
The database.I completely done all work related database making all Tables as per
Need of the Project. Database has full functionality of valdation. Apply all constrai-
Nts of Relational database management system (RDBMS). Use the primary key,
Reference key,unique key and check cnstraints ,NOT NULL constraints.This
Database is optimal performane. Remove the redundancy as possible according to
The system. This database accessing very fast due to use index concept.
Team Size : 3
Duration : January 2011 to April 2011
EXTRA CARICULLAR ACTIVITY:
1.Participated in various cultural activities in High School and Intermediate.
2.Participated as a Volunteer in Tech Fest ‘Genereo-10’, ABES Engineering College.
3.Participated in various social activities in a college environmental issues and blood donation
STRENGTH:
1. Positive Thinking
2. Quick Learner
3. Love to take challenges
4. Work in any environment
5. Highly Disciplined

DECLARATION:
I hereby declare that all the details given above are true to the best of my knowledge and belief.
Place: Ghaziabad
Date: (Mangu Singh)
-------------------------------------------------------
More Information about this submission and submitter:-
___________________________________________________
Submission ID : 4351713
Date & Time : 9th Jul 2011 6:16 PM (UTC)
IP Address : 14.98.190.41
Browser Info : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Predicted Country : --