Project Manager

Cell:-738-***-****

CHINA RAMA KRISHNA JADA E-

mail:***********.****@*****.***

Summary

. 6 years of Oracle database administration experiences for various kinds

of applications in Windows and Linux environments. Proven background of

technical problem solving. Very good extensive Experience in Writing

Complex SQL Quireis for generating various kinds of reports .A self-

motivated, responsible, and reliable team player with a set of very

strong technical skills .

Professional Experience

Oct 2007 -Till date

Sr. Oracle DBA

. Installed, configured and managed oracle database servers sized up to one

terabyte .

. Monitored Database growth and provide Database capacity planning for

applications expansion.

. Identified, resolved, or provided recommendations to other different

kinds of the performance problems ranging from Database performance

problems to I/O hardware performance problems.

. Designed and implemented backup methods and disaster recovery strategies.

. Designed/modeled Database structures to support a variety of software

applications

. Created new databases and users, setup RMAN backups, Export, and other

monitoring scripts

. Migrated Database between software versions, platforms and Database

products.

. Communicated requirement and changes to the development team as required

and monitored all development and testing process during application

migration and database upgrades.

. Extensive experience in Configurations and maintenance of database

software, able to create physical databases/schemas from logical designs

. Experience in creating database tables, setting up indexes, data

constraints and DB views Analyze, predict through trend analysis and

resolve database system, storage and application issues Monitor SQL jobs

in production.

. Provided 24x7 on call production support

Academics

. B.Tech from Jnt University with 70%, 2003-2007

. Intermediate from Intermediate Board of Education with 90.2%, 2001-2003

. SSC from State Board of Education with 82%, 2000-2001

Employment History

4G Identity Solutions Pvt Ltd Database Administrator, 2007-2011

Programmer

Tata Consultncy services Database Administrator, 2011-Till date

Programmer

Projects

Project #1

Title : British Telecom(BT)

Client : Brithish Telecom United Kingdom

Description :

British Telecom is an UK client which spans it's business support across

india in various Multinational companies.It has own multilple LOB(Lines of

business) in whole sale,retails and open reach.We support all database

support in the testing envionment.

Responsibilities:

. Installed, upgraded and patched Oracle software. Setup brand new

machines including Oracle software installation

. Managed and resolved design,connectivity issues during development

. Needs to work on services requests raised by end user.

. Needs to work on major incidents raided by application team

. Applying patches,bug fix patches and upgrade database in both

Standalone and RAC enviroments.

. Needs to resolve various Performance Tunning issues.

Project #2

Title : Targeted Public Distribution System(TPDS)

Client : United Nations World Food Programme(UNWFP)

Description :

The UNWFP has undertaken this project on behalf of the Government of Orissa

to reissue ration cards, based on biometric system to better manage and

monitor the distribution of food grains in Rayagada District. This project

is being carried out to strengthen the distribution system of the

Department of Food & Civil Supplies, Government of Orissa by leveraging

Biometric technology based solutions. The project includes capturing of

beneficiaries biographic and multi biometric (face, finger and iris) data,

creating a unique database by eliminating duplicate entries using

biometrics algorithms, printing and distributing the ration cards to the

citizens.

Responsibilities:

. Requirements Gathering

. Installed, upgraded and patched Oracle software. Setup brand new

machines including Oracle software installation

. Managed and resolved design issues during development

. Moved database Schema changes to stage or production.

. Used EXPORT to do table level and full database backup

. Provided on-call production database support.

. Importing the .dmp files into database and Manage the data by removing

duplicates and Junk data.

. Generating difference kinds of reports using Complex Sql

quiries(e.g:-Village wise % age enroled reports,Dailystatus reports) .

Project #3

Title : Integrated Survey of Ration Cards, Pensions, Indiramma

Houses

Client : Andhra Pradesh Govt.

Description :

AP Ration Cards De-Duplication is a project which deals with the biometric

de-duplication of citizens. The biometrics includes IRIS and Photo. It is

a batch processing application which is having multi threading to do the

task in efficient and faster manner. De-duplication will be done by SIRIS

server, an IRIS server for which we can write a web service. The project

includes online MIS of reports for the field verification results. The

project is an initial move towards the UNIQUE Identity project of Indian

government.

Responsibilities:

. Aggregation of all districts data (5.5 Million iris blobs with

Demographic data)

. Database Design

. Defined Methodology for aggregation of Oracle Dumps for siris

processing.

. Query Optimization and Performance Tuning

. Generated reports from the database using PL/SQL and SQL(Developed MS

Excel Macros for different type of reports)

. Creating tablespaces and database files based on the OFA model.

Implemented physical database design after sizing tables and indexes

and creating tablespaces taking into account I/O load distribution

. Performed SQL tuning by using Explain Plan and Tkprof.

. Refreshing development/test database from production using

Export/Import

. UserManagement.

. Performance tunning with OEM.

. Maintenance

Project #4

Title :Biometric Registration Identification and Blacklisting System

(BRIBS)

Client :Reliance Industries Limited(RIL) Jamnagar-Gujarat.

Description :

Biometric Registration Identification and Blacklisting System (BRIBS) is a

web-based application developed for Reliance. It is a system primarily

intended to the creation of Unique Identity and management of Blacklisted

Employees/Non-Employees. It also acts as a fool-proof biometric

identification system (based on Iris Recognition).It is being accessed

across five sites (five different locations). BRIBS uses SIRIS to implement

IRIS recognition technology.DataBase Replication place an vital role in

this project.

Responsibilities :

. Database design and implementation.

. Database creation, implementation and maintaining database design.

. Database tuning and performance monitoring.

. Create Job Schedule for daily as well as periodic backup processes.

Environment : MS SQLSERVER 2002,Struts, JSP,Apache Tomcat

Project #5

Title:Unique Identification Audhority of India (UIDAI) (Currently Running

in India Wide)

Client :Govt Of India.

Description :

Unique identification project was initially conceived by the Planning

Commission as an initiative that would provide identification for each

resident across the country and would be used primarily as the basis for

efficient delivery of welfare services. It would also act as a tool for

effective monitoring of various programs and schemes of the Government

.The UIDAI's mandate is to issue every resident a unique identification

number linked to the resident's demographic and biometric information,

which they can use to identify themselves anywhere in India, and to

access a host of benefits and services. The number (referred to until now

as the 'UID') has been named Aadhaar, which translates into 'foundation',

or 'support'

Responsibilities :

. Database design and implementation for internal MIS.

. Database creation, implementation and maintaining database design for

Operators/Suepervisors Activation.

. Be on-call, attend to problems on a daily basis and resolve various

database-related issues and customer requests.

. Creating tablespaces and planning the location of data, index and

rollback tablespaces redo log files and control files in adherence to

the Optimal Flexible Architecture

. Managing database security. Creating and assigning appropriate roles

and privileges to users depending on the user activity

. Database server tuning. Proactively monitored hit ratios on different

components of the SGA. This included tuning of the shared pool,

databases buffers and redo buffers.

. Database backup and recovery. Used hot and cold backups.

. Data loading using SQL*Loader

Environment : Oracle 11g.

Technical Skills

Security Administration(Roles, Recovery Manager (RMAN)

privileges, authentication, encryption) Incremental backup&Recovery

Oracle Enterprise Manager (OEM)

DataPumping PL/SQL

Database Design Log shipping

Sql Loader System Design

Experience on tools like TOAD,Sql TK Proff

Developer Explain Plan

Complex Sql quires.PlSql (Procedures, Cloning Of Database

Functions, Triggers, Packages) Patching Database

Sql Reporting. ASM administration

Performance Tuning

Personal Details

. Name : China Rama Krishna Jada

. Father's Name : Narasimha Rao

. Date of Birth : 25th May, 1986

. Address : Flat No:301, Shridi Sai Nilayam, 6th Phase,

KPHB,

Hyderabad - 500

072.

Contact this candidate