Data Project

Bhanu Prakash Chirathanagandla

Senior Oracle/Cassandra DB

Administrator

Phone: 408-***-****

Email: ***********@*****.***

Summary

●3 years as Nosql Cassandra site Reliability Engineer

●~9 years of experience in Designing, Developing, Deploying, implementing, maintaining and administering new platforms of Oracle/Cassandra Databases including systems architect, project management, implementation and tuning of mission critical enterprise applications.

NoSQL

●Supporting Big Data Applications on various NoSQL platforms like Cassandra DB (NoSQL).

●Automation of Cassandra Cluster builds using GitHub Version Control and Jenkins Integration

●Cassandra installations, troubleshooting performance issues.

●Experience in installing DSE v3/4 (Cassandra v 1/2.x) and OpsCenter v 4.x/5.x.

●Support Cassandra Clusters range up to 80 nodes across multiple Data Centers.

●Expland/Shrink C* cluster by adding, removing and replacing nodes.

●Configure backup, alerts, repairs and monitoring of Cassandra clusters, in conjunction with custom scripts.

●Troubleshoot the performance issue by closely working with DataStax support.

●Troubleshoot read/write latency and timeout issues using nodetool cfstats, tpstats, cfhistogram, and repair.

●Strong DevOps and continuous delivery methods experience with familiarity of tools including Jira, Confluence, Jenkins, Splunk and Git

●Exposure to Configuration Management tools such as github and Puppet

Education

●Masters of Engineering (M.E) in Instrumentation Engineering from Anna University, India.

●Bachelor of Technology (B. Tech) in Electrical and Electronics Engineering from Nagarjuna University, India.

work experience

working as full-time employee with designation Sr.Consultant in Infosys Technologies Ltd.

Technical Expertise

Languages

SQL, PL/SQL, Shell scripting, perl scripting

Application Servers

Apache Web Server

Development Tools

TOAD, SQL Developer, EditPlus.

Databases

Oracle (9i, 10g, 11g), Cassandra, Redis

Software/Tools

Golden Gate, RMAN, OEM, Exp / Imp, Expdp/Impdp, SQL, PLSQL Profiler, RAC, ASM, Data Guard, OEM, Splunk, Hubble

Operating Systems

Redhat Linux, HP, IBM AIX, Sun OS

Networking Protocols

TCP/IP, RIP, UDP, OSPF, BGP, BOOTP, DHCP, SMTP

DETAILS OF THE PROJECTS WORKED ON

01 Project Name

Client

Apple Computers

Description of the project

Apple Inc. (commonly known as Apple) is an American multinational technology company headquartered in Cupertino, California, that designs, develops, and sells consumer electronics, computer software, online services, and personal computers. Its best-known hardware products are the Mac line of computers, the iPod media player, the iPhone smartphone, the iPad tablet computer, and the Apple Watch smartwatch. Its online services include iCloud, the iTunes Store, and the App Store. Apple's consumer software includes the OS X and iOS operating systems, the iTunes media browser, the Safari web browser, and the iLife and iWork creativity and productivity suites.

Apple was founded by Steve Jobs, Steve Wozniak, and Ronald Wayne on April 1, 1976, to develop and sell personal computers.[5] It was incorporated as Apple Computer, Inc. on January 3, 1977, and was renamed as Apple Inc. on January 9, 2007, to reflect its shifted focus towards consumer electronics. Apple (NASDAQ:AAPL) joined the Dow Jones Industrial Average on March 19, 2015.[6]

The Internet Services Group (ISG) serves as the IS &T of Apple’s online business for iTunes, iCloud, Mobile Me, Face Time & Multi Player Game services. The group maintains databases and applications, various support utilities and takes care of most report generation requirements. DBA support for Internet Services Group for iTunes, Mobile Me and iCloud

.

Role

:

Cassandra site reliability Engineer

Responsibility

:

•Cassandra installations, troubleshooting performance issues.

•Experience in installing DSE v3/4 (Cassandra v 1/2.x) and OpsCenter v 4.x/5.x.

•Support Cassandra Clusters range up to 80 nodes across multiple Data Centers.

•Expland/Shrink C* cluster by adding, removing and replacing nodes in Solr and non-Solr Clusters.

•Configure backup, alerts, repairs and monitoring of Cassandra clusters, in conjunction with custom scripts.

•Responsible for designing a scalable, high throughput, realtime, highly concurrent, distributed, machine learning based decisioning platform for fraud detection with Cassandra as the backend Data Store.

•Built the functionality of Aggregates, Lookups and Projections to enhance the execution framework that handles the platform.

•Designed and evolved the data schema to support multiple lines of businesses.

•Designed a health monitoring dashboard for various components of the cluster.

•Responsible for forecasting and scaling infrastructure to meet the traffic demands from all the supported LOBs.

•Test-driven development, ensuring the entire test suite succeeds and target maximum code coverage.

•Perform Data Definition Language (DDL) Statements within Cassandra,

•Perform Data Manipulation Language (DML) Statements within Cassandra,

•Create and modify Users and User permission within Cassandra,

•Capture CQL output to a file, Import and export data with CQL,

•Execute CQL scripts from within CQL and from the command prompt.

Duration

:

Dec - 2010 to Till date

Software

:

Oracle 10g,11g, Cassandra, Redis

02 Project Name

TTSL-Database Administration (Prepaid Databases)

Client

Tata Teleservices, Hyderabad

Description of the project

Tata Teleservices Limited (TTSL) is part of the Tata Group, which had invested of over INR 9,000 Crore (US$ 2 billion) in Telecom, has a formidable presence across the telecom value chain. Tata Teleservices operates in 20 circles with the total revenue of INR 14,446 Crores (US$ 3.21 billion) till recently. Tata Teleservices has established a robust and reliable telecom infrastructure that ensures quality in its services. Tata Teleservices Limited serves more than 7 million customers in 1700 towns and is offering world-class technology and user-friendly services in 20 circles.

Role

:

Oracle DBA

Responsibility

:

•24*7 production Support for mission critical production systems

•Installation of Oracle 9i/10g/11g and database creation

•Installation of 10g Application servers and deployment of the applications

•Implementing Security features as specified by the Client’s Security policy.

•Monitoring space, wait events, locks and long operations running on the database

•Partitioning big tables and Indexes for optimal performance

•Archiving the data from the tables and backing up the archived data for the Business requirement

•Generating statspack reports on regular basis to identify the database performance at peak load

•Tuning the SQL statement by analyzing the explain plan

•Implemented scripts to monitor and get information on free space, alert log errors

•Reorganizing the database objects by archiving the data and moving the tables within the tablespace, rebuilding the indexes.

•Migrating the data from one database to the other using Export / Import Utility.

•Archiving the data from the tables and backing up the archived data for the Business requirement.

•Scripting the Backup of Development and End-To-End Environment using RMAN utility on to Disk / Tape.

•Duplicating the databases using RMAN utility.

•Trouble shooting 24*7 production environment issues.

Duration

:

Nov - 2006 to Sep 2010

Hardware

:

Sun Fire E10K / E15K / E25K

HP9000 Super Dome

Sun Enterprise 3500

Windows NT

Tools

:

SQL*PLUS,TOAD

03

Project Name

BT Ireland – Retail support

Client

British Telecom

Description of the project :

BT in Ireland is a wholly owned subsidiary of BT Group plc, and a fully integrated division of BT Global Services. With over 900 employees, the company is headquartered in Dublin with offices in Cork, Limerick, Galway and Waterford.

BT in Ireland helps organizations large and small, corporate and public, Irish and global to thrive through the provision of networked IT services.

BT in Ireland also operates in the residential and Internet portal markets, offering a full suite of innovative services to consumers, from home phone and internet access, to WiFi and high-speed broadband.

Role

:

Production Support Team Member.

Responsibility

:

As a Production Support Team Member and as a Developer (Onsite and Offshore) handled the following responsibilities:

•Requirements gathering for the new projects.

•Detail design and coding and testing.

•Configuration on Kenan Billing as per new requirements

•Preparing Root Cause Analysis Document for Comreg tickets.

•Investigating on critical issues for fixes & permanent solutions.

•Finding work around for high priority issues.

•Taking actions to reduce the inflow of tickets.

•Automating tasks which consume more time and effort.

•Supporting in debugging critical issues across modules.

•Helping in automation of tasks across modules.

•Sharing advanced concepts in PL/SQL with the team.

•Sharing useful commands in Unix with the team.

•Planning the work among team members.

Duration

:

Dec-2005 To Nov-2006

Solution Environment

:

Operating System : HP-UX B.11.11

Languages Used: PL/SQL, Shell, Perl,Awk

Tools: TOAD, Bridge Clarify 10.1 SR 1.8

Software

:

Kenan billing system version 11.5

04

Project Name

Mistral 1A-Maintenance, Enhancement on BIX, New order Management – Converter

Client

PROXIMUS, BELGACOM MOBILE

Description of the project

Proximus, also known as Belgacom Mobile, is the largest of Belgium's three mobile telecommunication Operators.

Mistral 1A-Maintenance:

In Belgacom Mobile, Mistral Project which replaced the rating & billing part of the existing PNI (Order Management) system by Arbor/BP which is a standard rating & billing solution has been live.

Role

:

Team member as Developer and tester

Responsibility

:

•Handling Problem Notifications, Change Requests (Gathering Requirements, Impact analysis, Design, Testing and Implementation).

•Doing Causal Analysis and providing permanent solutions to the problems identified

•Preparation of Software Requirement Specifications document for Change Requests.

•Preparation Test Plan and Test Cases. The software is tested as per the test plan and the results are documented.

•Supporting Quality and UAT activities

•Dynamic data migration

Duration

:

Dec-2003 To Nov-2005

Solution Environment

:

Solaris 5.8, Oracle 8.1.7 database, PL/SQL

Special software Used: Kenan BP 10.0

Languages/software

:

Unix, Shell scripting ad C

Contact this candidate