Database Architect

Krishna Tulluri

Database Architect

C*C Consultant 3rd Party Employee

469-***-**** *******.**@*****.***

Description: Kishore Tulluri is a seasoned technology professional with 15+ years of experience in Database administration, in Oracle, MySQL, and Mongo DB latest. He is an efficient resource for managing mission-critical databases and handled and administered large-scale DW environments both from database & ETL side. With his vast experience has got a 360-degree view of all the components of IT infrastructure of an Enterprise. Excellent troubleshooting and problem-solving capabilities complete control and knowledge of IT service management process include Change, problem, Incident Management, publishing RCA & RCCA.

As technology enthusiast has a vast knowledge of Cloud Services (AWS & Oracle), Business Intelligence Architecture in Data Ingestion, Cleansing, Analyzing and Reporting and technologies underlying.

KEY CUSTOMERS SERVED

PRA Health Sciences Inc. Nike Inc. Target Corporation Qualcomm Inc. Wells Fargo Bank NCB Bank, Jeddah GENPACT America Media Inc., (AMI)

PROFILE SUMMARY

ORACLE DATABASE ADMINISTRATOR EXPERIENCE

Experience in Installing and administering and managing large-scale databases on-Prem & Cloud

Detail & process Oriental Resource with Complete adherence to Service Management Processes

Proficiency in Oracle RAC Cluster setup & administration

Experience Recovering and restoring Cluster Database from complete Loss of ASM disks

Proficiency in Oracle Enterprise Manager 12c (OEM 12c)

Good Knowledge of Oracle Golden gate 11g and Quest Shareplex

Hands-on Migrations and Upgradations of Oracle databases

Expertise in Performance Tuning

Streamlined and very well experience in working with Oracle via SR, Escalating to Duty Managers and working with Oracle Analysts and Oracle product development teams

Installing, administering Oracle RAC ONE databases

Experience of carrying out Database/Application deployments in co-ordination with Application development team

Database Security and User Management implementation experience

Setup and administration of Database Flashback

Supporting customers by refresh UAT instances and set up new instances when required.

Database refresh using RMAN Active Database

CPU Patching on RAC, stand-alone and ASM homes

Good Troubleshooter. Co-ordinating with stakeholders and Technical Teams.

Excellent written, communication, interpersonal, liaison & Problem-Solving Skills with ability to work in multi-Cultural Environment

Driving Technical delivery end-to-end from offshore facilitating seam-less Delivery

MYSQL EXPERIENCE

Experience in Managing and administering Large Scale MySQL database environment

Installing, creating and Up gradating MySQL Databases

Implemented Backup and recovery of MySQL using MySQL dump and Canada for MySQL

Implement and maintain database security and best practices of MySQL

Database migration from MyISAM format to InnoDB storage engine to increase performance and betterment of integrity constraints.

Implementation of MySQL Replication

Implementation of Database Security

Monitoring and fixing alerts from MonYog and OEM

MongoDB

Evaluation of Product inline to meet business requirements

Installation and setup of On-prem & Cloud (AWS)

Implementation of best practices

Backups configuring and recovery Tests

Implementing of OPS Manager for Monitoring of Mongo Environments (DEV., TEST., VAL)

CRUD operations

INFORMATICA ADMIN EXPERIENCE

Provide support for shared platforms with 20+ projects per region (America, Asia Pacific and Europe)

ETL experience of using Informatica 9.6.1/9.5.1/8.6.1 PowerCenter Client tools - Mapping Designer, Repository manager,

Installation, setup of Informatica 9.5.1

Upgrading the Informatica environment to 10.1

Working experience with Informatica Global Support and Issues resolving and Closure.

Worked on Informatica Power Centre tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor

Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager.

Perform object deployments on versioned repositories from QA to Production

Setup and administer PowerCenter security and users, group’s creations

Manage PowerCenter security – User creation – (Native/LDAP) and group creation, revoke access etc.

Created Groups, roles, privileges and assigned them to each user group.

Informatica workflow/mapping/sessions migration using Repository Manager.

Informatica Administration activity (by using Admin console) like repository backup, monitoring integration services.

Outage Handling – Scheduled and Unscheduled outages.

Well versed in outages bringing down and bringing up services like integration services, repository and domain in UNIX.

Creation and maintenance of Informatica users and privileges.

Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.

Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.

Deployment of Informatica Mappings/Sessions/Workflows into a Production environment. Testing the Informatica Objects in QA before moving them into Production.

Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

Schedule daily backup of Informatica environment, restore Informatica environment when required

Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, work lets, Assignment, Timer and scheduling of the workflow.

Prepared migration document to move the mappings from development to testing and then to production repositories.

Modified existing mappings for enhancements of new business requirements.

Well-versed knowledge of Job Information Language (JIL) and capabilities to recommend suggestions that will comply with internal standards.

Perform daily Production Support recurring tasks and monitoring of the tickets queue, assign tickets, resolve tickets, update root cause and remediation.

Incident Management (Release Implementation, Change request Approvals, Processes Changes).

Worked on the incident, problem management in order to recognize, prioritize and fix the recurring and critical issues.

TECHNICAL PURVIEW

Operating Systems

Linux, Solaris, Windows

Databases

Oracle12c/11g/10g MySQL MongoDB Amazon Aurora

Cloud Services

AWS, Oracle

ETL

Informatica Power Center 9.x/10.1, TALEND

High Availability

Oracle Real Application Clusters (RAC), Data Guard, MySQL Replication, SharePlex

Monitoring Tools & Utilities

Oracle Enterprise Manager 12c, Nagios, MonYog for MYSQL, Zmanda for MySQL, MySQL Work Bench

Middleware & Visualization

WebLogic, OBIEE, BIP, Tableau

Business Intelligence

Data Collection, Data Consolidation, Aggregation, Analysis, Visualization, Data Governance

Replication Tools

Oracle Golden Gate, Shareplex, HVR

IT Service Management

BMC Remedy force, Kintana, ServiceNow, Clarify

CUSTOMERS & PROJECTS PURVIEW

S.no

Customer

Project

Responsibilities

Duration

1

PRA Health Sciences

IT-INFRA Managed Services

Managing 1000+ databases in 24x7x365 environment

22 Months

Driving Database initiatives, Environment optimizations

Database Deployments and Working with Oracle vendor on issues

Upgraded 12c Oracle enterprise manager to 12.1.0.5 from 12.1.0.1

Responsible for end to end delivery across IT Infrastructure Domain of Customer

Setup, Administering and Manage Talend TMM on Prem and MD on Cloud

Initiated and driven POC on Oracle Stored Procedure Conversion from ON-PREM to AWS -Redshift

Driving Exadata Retirement project

Initiated and driven Oracle Advanced features removal project across DB landscape as part of Cost consolidation

Driving Migration of Informatica Environment on Windows to Linux environment

Driving business meetings and ownership of Informatica Migration Project

2

Nike Inc.,

Production Database Support

24x7x365 database Environment Support with 800+ databases running on Linux, Solaris

12 Months

Few Applications Using 2-Node RAC having 11.2.0.3 version of database,

OEM12c, Nagios in place for Database Monitoring

Service Now in use for Work Requests, Change Requests, Incident Creation

Troubleshooting the performance issues in coordination with application team and Infra Teams

Administering 2-Node RAC databases

Experience in Re-building the RAC database from ASM disk corruption by re-configuring the cluster

Mentoring the Team of DBA’s

Performing Technology GAP analysis quarterly and identifying the gaps

Working closely on Key deliverable areas and adhering to agreed SLA’s with customer by timely reporting, Incident Management, timely tickets closure

3

Target Corporation

12c Oracle Enterprise Manager

Ownership, Administration and management of Oracle Enterprise Manager 12c

16 Months

Multi-system OMS upgradation

Designed Backup and recovery for OMS

Administering and managing 2-node Repository database

Agents Upgradation and troubleshooting

Targets discovery and setup

Targets administration by implementing groups, Compliance methods

Working with Oracle in bug fixing for OMS layer and applying patches at OMS and Repository layers to ensure seamless monitoring of all Targets

Agent Re-synchronization and troubleshooting agents

Pro-active working on OEM performance

Applying bundle patches

4

Qualcomm Inc.,

Corp-IT Applications

11g GI Installation & Deployment

32 Months

Supporting Critical Production Databases running on 10g RAC,11g GI Clusters and standalone environments

Optimizing environment by reducing the daily no. of alerts from databases

Handling end-to-end responsibility of project till closure

Conducting Root Cause Analysis and upgrading 11g GI from 11.2.0.1 to 11.2.0.2 & 11.2.0.3

Managing database migrations from 10g NON -ASM to 11g RAC ASM storage

Administering various functions viz., Upgrading GI & RDBMS from 10g to 11g, resolving technical issues, installation, deployment, up-gradation, knowledge Transitioning

Documentation of procedures and Best Practices

Monitoring Oracle Grid Control across databases

Setting up RAC. One database

Working Closely with application teams on performance issues

Looking after development, Test and Prod MySQL databases in Linux Environments

Responsible for the following:

Managing shared & dedicated MySQL Environments

Administering Third party backups for MySQL

Troubleshooting MySQL performance issues

Configuring and managing replication

Highlights:

o Holds the distinction of winning Qualstars as part of R & R programme

5

Wells Fargo

Whole Sale Banking Database Support

2-Node RAC databases running on 11.2.0., HPOO, Data guard, Quest Shareplex for HA replication

12 months

Supporting and administering Databases running on 11g on 2-Node RAC and Standalone servers

Refreshing the Non-Prod Environments from Prod using Data pump

Administering the 2-Node RAC databases

Performing and Testing BCP procedures periodically

Installation, setup and troubleshooting Shareplex Replication for Critical Databases High Availability

Implementing, managing and Monitoring Datagaurd for Databases

Working with HPOO Team to automate Database Switchover by developing the workflows

6

Qualcomm Inc.

BREW Integration

10.2.0.5 Databases on Linux, Erwin Database Design Tool, Oracle Enterprise Manager, BREW API, TOAD, Bugzilla

12 Months

Database Administrator for 35 Member Java development Team

Designing the database for a Product Engineering Interface Solution

Used ERWIN tool for Designing the database

Co-ordinating with Application Architect in development with respect to Database

Creation of database objects and Database Object Management

Documentation of database procedures

Implementation of Backup and recovery

Managing and administering Non-Prod Environments using Data pump refresh upon Application Team Request

Setup of Production database with backups and Monitoring

EDUCATION

B.E. (Electronics & Communication) from the University of Madras in the Year 2000

PROFESSIONAL ENHANCEMENTS

Training:

MySQL DBA Fundamentals

Oracle Performance Tuning- Oracle India Pvt. Ltd. New Delhi

Oracle 11g GI, Hyderabad

ITIL V3 Foundation, Hyderabad

Doing Business with China by Maya Hun-Chen

Contact this candidate