Resume

Sign in

Project Oracle

Location:
Hyderabad, AP, 500072, India
Salary:
Negotiable
Posted:
August 22, 2012

Contact this candidate

Resume:

Name: K TARUN KUMAR

Organization: CMC Limited (A TATA ENTERPRISE)

Email : bfne14@r.postjobfree.com

Mobile: +91-916*******

________________________________________

Career Plan:

My career plan is to pursue a career with an aggressively growing and professionally managed company, where my technical skills, my ability to innovate and my determination to succeed would dovetail with the organizational goals and aspirations.

Experience Summary:

Worked with A.C Nielsen Italia Spa (Milan, Onsite) as a Team Leader / Technical Leader.

Managing a Team of 15 and Managing Projects

Conduct the status meetings and team meetings and report the management.

Provide clear status report on all the projects and Escalations and issues in the Tower Review call, Management Calls, Problem management Review calls.

Good Knowledge on Oracle Application Server 9i, 10g.Installing and Configuring Mid-Tier, SSO, OID & INFRA, Fusion Middleware 11g, Web logic.

Installation of FMW, configuration, troubleshooting, patching, monitoring.

Installation of SOA, configuration, troubleshooting, patching, monitoring.

Manage the onsite team and Spoc for Client / 3rd party Vendor.

Problem Management,Incident Management,CMDB

Installing and Configuration of OEM

Build & Release Management tasks

Having 10+ years of IT Experience.

Having 7+years of Experience as an Oracle DBA

Configuration of Oracle 10g RAC on windows 2003 EE 64 Bit on HP BL685 Blade server.

Experience as Oracle 9i & Oracle 10g Database Administrator in managing large-scale production and development, Integration& Transition environment databases.

Experience in SOA 10g

Database upgrade / migration from Oracle 9i to 10g, 10g to 11g.

Installed and Configured Oracle 9i & Oracle 10g database

Performed tasks like RMAN configuration for Hot backup of Database, Managing primary database structures (table spaces), Performance tuning. (Using AWR report and by checking the execution Plan of the query).

Expertise in installing different versions of Oracle. Configuring Data Guard (9.2.0) - Physical standby database

Configured & Maintained Oracle RMAN Backups.

Database Patching and Troubleshooting.

An active member of a team of Implementation handling of migrations.

Expertise and Assist in developing, documenting, implementing, and sustaining Standard Operation Procedures.

Coordinated with Oracle Online Support for Trouble shooting (HRMS RAC Issues)

Operating System level monitoring and Administration.

Cloning databases using normal and RMAN methods.

Knowledge on Standby setups.

Skill Set:

Primary Skills Oracle DBA, Oracle Application server (10g), Fusion Middleware, Weblogic, OEM, Performance, Trouble shoot, Problem & Incident management, Data Pump and Capacity planning & Storage, IBM AIX.

Technology Worked On:

Hardware Software Tools

Windows-XP, Windows-2003 Server, Unix AIX(P5,P7),Linux Oracle 9i & 10g &11g,TDPO,$U,CFT OEM,TOAD,SQL LOADER,PUTTY,TELNET,$U,CFT,TSM

Training / Continuing Education Summary:

Program or Course Coverage Dates

DWH (Data warehousing) Informatica,Erwin,Cognos March 2007 to August 2007

Oracle DBA Creation of database,backups,monitoring Database, Restoring June 2004 to December 2004

Achievements:

From App.Dev to implement a project which was the first of its kind implementation from Infrastructure prospective with ZERO rework. The same was appreciated by Nielsen Infrastructure Leaders and TCS App. Hosting Leaders.

Awarded the “STAR OF THE MONTH” award for month August 2009 by TCS

Awarded the “BEST RESOURCE FOR INFRASTRUCTURE” by NIELSEN

Appreciated in the TOWN HALL Meeting by TCS Infrastructure Leaders & Global App. Hosting Manager

Highly appreciated by the L’OREAL App.Dev and NIELSEN Infrastructure for managing the utmost critical platform databases for the Nielsen Business with minimum downtime and very efficiently.

Appreciated by TCS Infra for re-structuring the entire OAS environment and documenting all functionalities which was very useful & helpful for the whole team to implement new installations.

Highly Appreciated by NIELSEN & TCS Infrastructure Leaders for creating a new OAS environment for FUSION MIDDLEWARE (11gr1, 11gR2) which was of its first kind in NIELSEN Environment. I was able to install and secure the new environment in 3 weeks which the MANAGED SERVICES could not achieve. I have provided training to IBM France team for this installation, as IBM is part of the Nielsen contract for some platforms.

Awarded the “STAR OF THE MONTH” award again for month June2010 by TCS.

Appreciated for managing the BAU without escalations and Finished Projects in given timelines with again ZERO re-work.

Appreciated for securing the entire NF environment by configuring the Centralized GRID control for monitoring.

Published in the CMC Ultimatix Interface of year 2009, 2010, 2011.

Awarded in BEST PROCESS IMPROVEMENT category.

Details of Various Assignments in CMC (In reverse chronological order)

Project TCS BA SI ONSITE SEZ

Customer A.C Nielsen

Period from 01/03/2008 to till date

Description NF - Operations Management & Database Administrator &Capacity planning & Storage

Ensuring proper procedures and process are followed and streamlining the activities

Role To lead onsite Level 1 HS team in Milan

Solution Environment Unix AIX & Windows & Red hat Linux

Highlights 1. Administer all the Databases (200 Db Instances which includes production, transition, integration, pre-production) in Europe (Milan Data center & IBM data centre, Montpellier).

2. Ensuring proper procedures and process are followed and streamlining the activities.

3. Addressing the requirement of the team and clients.

4. Addressing issues in Production governance call.

5. Submitting the new tasks and projects in time with zero rework.

6. Installation and Configuration of OAS.

7. Resolve the issue slogged on Query Logging System (QLS), owned by Global Nielsen

8.Work on new project implementation and give training to the Offshore team.

9. To handle the escalations and reduce the escalations.

10. To take pro-active measures to reduce the incidents.

11. To follow-up on the changes and project implementations in NF infrastructure.

12. Co-ordination with IBM for issues and implementation in NF infrastructure.

13. Assigning new tasks to the team. Enforcing to do documentation of their activities.

14. Help the team with any technical issues.

15. Address day to day operational activities, issues of the team.

16. Conduct the status meetings and team meetings.

17. Addressing the requirement of the team and clients.

18. SPOC for IBM from TCS.

19. Successful in achieving client appreciation in all the tasks taken up.

20. Successfull implementation of the migration / Installation of FMW,Administration,Troubleshooting,Monitoring (11g)

21. Installation of SOA,Configuration,Administration,Patching,Troubleshoot,monitoring (11g)

Project HRMS

Customer Government of Karnataka [E-Governance]

Period 6 months

Description Designed and implemented, the system will help the Government get a accurate picture of the sanctioned posts, filled up posts and vacant posts; it will save time in making the estimates for preparation of Appendix B estimates for the annual Budget. Computerized Database helps in drawing up pay bills, supplementary bills and all salary-related exercises in quick-time.It also helps assessment for promotion, deputation for training, deployment for Special and time-bound tasks/projects.It will be a handy tool for decision-making authorities in resolving personnel matters with ease and precision

Role Database Administrator

Solution Environment Windows 2003 server 64 bit,Oracle 9i & 10g

Tools OEM,TOAD

Highlights 1. Database Migration from Oracle 9i(9.2.0.1.0) to 10g (10.2.0.1.0)

2. Performance tuning. (Using AWR report And by Checking the execution Plan of the query)

3. RAC Configuration (4 Node RAC configuration in Windows Environment)

4. Monitoring the RAC Database (Production)

5. Generate and analysis of AWR report.

6. Monitoring and optimizing the performance of the database and performing tuning.

7. RMAN configuration for Hot backup of Database

8. Database monitoring using Oracle Enterprise Manager

9. Taking Database Hot Backup (Using RMAN) and logical backup using Export utility

10. Managing primary database structures (table spaces)

11. Managing primary objects (table,views,indexes)

12. Database Patching and Troubleshooting.

13. Creating cloning databases as same as to the production site for testing environment, UAT environment and other application related activities.

Major Projects before Joining CMC

Project 1:

Company A.M Technologies

Project Title Bank Reconciliation System

Description The collections of Property tax by different sources like through e-Seva, bill junction, at circle offices etc were first verified by MCH officers. Then they send to SBH, for collection. The main idea of this project is of verification of data at SBH office by not entering it again, and Generate the required format for sending them for clearance soon as they got the status of information from the clearance again they should be uploaded to the MCH database

Role Database Administrator

Duration 5 Months

Responsibility The collection process of data and updating, loading process was manually done in MCH and the DBA team made automated jobs by replicating data with materialized views with different options based upon the necessity. Planned for the automated scheduled backup strategy. Applied retention periods for the backups. Knowledge shared with our Senior Team Members.

Project 2:

Company A.M Technologies

Project Title Bio-Chemical Project

Description This Project deals with the chemicals, which are involving in the Biological Activities and their target effects. This project contains different modules like Biological indicators Reactants & various chemicals and their maintenance with their respective concentrations. This Project also maintains the detailed information about Biological Indicators & Endocrine Glands

Role Database Administrator

Duration 16 Months

Responsibility 1. Configured Physical Standby database for the production databases and tested for switchover, failover, activating the standby to primary and no data loss.

2. Implementing partitioning on huge tables to improve the performance and reduce the maintenance of storing & retrieving the data.

3. Used Query Rewrite on some tables to improve the performance of reports.

4.Generating stats pack reports regularly to monitor the system

5.Performed the different file recoveries in the database if necessary

Project 3:

Company A.M Technologies

Project Title Medical Information Systems (MIS)

Description This Project has many modules like Education, Marketing, Entertainment, Finance, Transport, Medical & Health etc. This project deals with the different sites of the marketing products in south India with their corresponding hyper Links to view different other related sites. So that by using these site customers can order their needs at one place. This Project shows the complete information of different web sites like School Info, Entertainment Info, Medical & Health Info, Top Specialists Info and their Corresponding Web Sites.

Role Database Administrator

Duration 9 Months

Responsibility 1. Installation of Oracle Database according to the client requirement

2.Creation of Users and Roles & Profiles

3.Database link creation for fast accessing remote server

4.Analyze database objects at regular interval.

5.Taking Backups includes Logical as well as Physical backups

6.Configuring Database Into Archive log mode

7.Generating Stats pack for SQL Tuning Process

8.Granting Roles and Privileges for user controlling activity

9.Involved in the Full Table Scan when efficiency went down

Career Profile (Summary of Assignments/Projects in CMC)

Date From Date To Customer Role

03/09/2007 29/02/2008 Government of Karnataka [E-Governance] Database Administrator

01/03/2008 31/01/2012 A.C Nielsen Italian Spa (TCS Project),Onsite Database Administrator & Oracle Applications (Team Leader & Tech Lead)

31/01/2012 Till Date A.C Nielsen Italian Spa (TCS Project),Offshore Database Administrator & Oracle Applications (Team Leader & Tech Lead)

Personal Details

Date of Birth 21/11/1977

Nationality INDIAN

Sex Male

Marital Status Married

Mobile No. +91-916*******

Date of Joining 03/09/2007

Designation Sr IT Engineer

EMail ID bfne14@r.postjobfree.com

CMC Location Bangalore

Passport Details

Name as on Passport Passport No. Date of Issue Expiry Date Place of Issue

Tarunkumar kudikala E2208356 21/05/2002 20/05/2012 (Renewal in Progress) Hyderabad Regional Passport Office

Visa Details

Country Date of Issue Expiry Date Visa Type Place of Issue

Italy 17/05/2008 13/08/2012 WP / Stay Permit MUMBAI

Driving License Details

Issuing Authority Date of Issue Expiry Date License No. and Type Place of Issue

Indian Union Driving licence,Andhra Pradesh 30/12/2006 29/12/2026 DLFAP029451532006,LMV,MCWG TRA Rangareddy East,hyderabad



Contact this candidate