Bhanu M. Gandikota

Mobile: 415-***-****

adci0k@r.postjobfree.com

Who am I:

Database Architect/Administrator/Developer SME with expertise in both SQL and No-SQL databases in both on-premise and cloud environments. Worked in various IT sectors including Rakuten.com, VMware, Walmart.com, Wells Fargo Bank, ADP, Axiom, and Asurion. Worked in various areas of SDLC including DevOps, ITOPS, Engineering, QA, Infrastructure/Architecture teams.

Excellent communicator, Great team player, Great mentor, Quick learner, Highly motivated, Dependable, Technically sound Subject Matter Expert (SME).

Current coordinates: 3700 Waples Crest Court, Oakton, VA 22124

Opportunities looking for: Database Specialty Architect, Database Solutions Architect (on-premise and Cloud), Lead Database Architect, Lead Database Administrator in or around Oakton, VA

DB Architecture/Administration/Development/Operation experience:

RDBMS/DBMS/Cloud

# of years of experience

Oracle

15 years

PostgreSQL

8 years

MySQL

8 years

Microsoft SQL Server

8 years

Apache Cassandra

5 years

MongoDB

4 years

Redis

2 years

Hadoop

1 year

AWS

3 years

Google Cloud Platform (GCP)

1 year

Microsoft Azure

1 year

IT/SDLC Experience (sorted from oldest to latest)

#1

Axiom (Formerly Digital Impact Inc), Santa Clara, CA

From: 01/2001

To: 03/2004

Role: Oracle DBA Lead

Responsibilities:

Installation, Patching/Upgrade of MS SQL Server and Oracle RDBMS, Database Character set conversion, DB partitioning, Release management, Data modelling, DB upgrades/patches, RDBMS Access control, Performance tuning of SQLs and databases. HA and DR activities, Read and write scaling of database queries, mentoring junior DB developers/Administrators, Design/implement ETL processes and DataMart/DW.

#2

ADP Insurance division, San Ramon, CA

From: 04/2003

To: 03/2005

Role: Sr. Database Administrator

Responsibilities:

Oracle and SQL Server RDBMS Installation. Patching, Release management, Data modelling Logical/Physical, DB upgrades, Data sharding via Tiered storage architecture, DB Access control, Performance tuning of SQLs and databases. Design/Implement HA and DR activities

#3

Walmart.com, Brisbane, CA

From: 03/2005

To:08/2006

Role: Sr. Database Administrator

Responsibilities:

Worked on Design/Architecture/Maintenance of Walmart.com Oracle databases, both OLTP and DW. Worked on migrating from legacy DW data-mart into Netezza/Informatica based OLAP solution. Lead design and implementation of PCI standards across Oracle databases. Worked closely with engineering/platform teams to prepare DB systems for Q4 growth including DB patching, SQL tuning, OS tuning,

#4

Wells Fargo Bank NA, San Francisco, CA

From: 09/2006

To: 01/2011

Role: DBA lead, DBA Architect, Technology Manager

Responsibilities:

Administered/managed mission critical Oracle 10/11g databases in stand-alone as well in Real Application Clusters (RAC) to support various products including www.wellsfargo.com, BillPay, Fraud detection and prevention. Designed and implemented Highly available multi-master Oracle production databases across geo locations using Streaming Replication (SR). Designed and implemented read scalability using Oracle standby databases and Data Guard technologies. Built, managed and mentored a team of skilled DBAs across the globe to provide reliable uptime and 24x7 production support for large pool of mission critical Oracle and PostgreSQL databases.

PCI Audit implementation.

#5

VMware/EMC, Palo Alto, CA

From: 01/2011

To: 09/2012

Role: Cloud Solutions Architect (VPC)

Responsibilities:

Worked on vPostgres (aurora), MySQL, Micro Soft SQL Server, and Oracle cloud DBA operations automation projects including backup/recovery, routine DBA maintenance tasks, High Availability, Disaster Recovery, Access control, read scaling, and replication. Designed and built database dash boards to provide in-depth view of various DB metrics, and resource utilizations. Enabled read and write scaling using MySQL multi-master shared-nothing architecture.

#6

Asurion Inc, San Mateo, CA

From: 10/2012

To: 11/2013

Role: Database Architect

Responsibilities:

Designed, implemented, supported high volume OLTP databases for various mobile carriers as part of device and content protection plan offerings. Designed and implemented data encryption for both at rest and in motion data. Worked closely with engineering/development teams in fine tuning DDL/DML queries. Identified tuning/scaling opportunities and migrated some features from traditional OLTP database into no-SQL Cassandra cluster.

#7

Rakuten Rewards (formerly Ebates Inc), San Francisco, CA

From: 01/2014

To: Currently Employed here

Role: Principal Database Architect

Responsibilities:

Worked on design/implementation/support of various RDBMS/DBMS solutions using PostgreSQL, MySQL, Microsoft SQL Server, Cassandra, MongoDB, Redis clusters. Implemented PgBouncer connection pooling and converted application connections from session to transaction pooling, designed and implemented read scaling using Physical and Logical replication technologies such as Streaming Replication and Native Logical replication. Designed and implemented migration strategies to migrate on-premise MySQL and PostgreSQL based applications into AWS VPC with minimum/zero downtime. Designed and implemented extensive monitoring in AWS using Cloud watch, and custom monitoring tools. Designed, implemented, optimized RDS/Aurora databases in AWS. Built, mentored, monitored, and lead a global team of skilled DBAs. Migrated PostgreSQL and MySQL database platforms into AWS cloud and Cassandra clusters into Google Cloud Platform (GCP). Expert in migrating on-prem databases into AWS, GCP using such tools as Data Migration Service (DMS) as well as native logical/physical replication tools. Designed and implemented ETL/ELT processes to create Data Warehouse databases. Implemented automated processes to scale RDS/Aurora instances and storage to cater to dynamic patterns in application/database usage. Designed and implemented High Availability (HA) and Disaster Recovery (DR) plans for RDS/Aurora instances.

**References provided upon request.

Contact this candidate