GOPAL SHANKAR

PROFESSIONAL SUMMARY

About 21 years of experience in Database product development. More than 13 years with MySQL Server product development. Eight year with Bell Labs working on DataBlitz Main Memory Database Engine (MMDB).

• Involved with Oracle MDS Service control plane and data plane feature development.

• Involved with MySQL/Oracle development team involved in design of Transnational Data Dictionary, and improved INFORMATION_SCHEMA subsystem design.

• Involved in managing other modules like Lock subsystem, ACL, Stored Routines, Triggers in MySQL/Oracle.

• Experience in development of ‘DataBlitz’ SQL Engine, a main memory database kernel by Lucent.

• Individual contributor for design and implementation of database kernel modules like, JDBC and ODBC drivers, SQL kernel sub query modules from scratch.

• Experienced in analysing complex problem solving like High CPU usage, performance degradation, database corruption and throughput Scalability. database corruption and throughput Scalability.

TECHNICAL SKILLS

Domain:  Database Internal's specifically MySQL, PostgreSQL and DataBlitz.

Database Technologies: ODBC, JDBC, SQL 92, Stored procedures, Triggers, Replication & DB Clustering, Load Balancing.

Databases used: MySQL, DataBlitz, PostgreSQL, Oracle and more.

Languages and Scripting: C, C++, Java, Shell Scripting, Perl, CGI, LAMP and compiler design tools like Lex & Yacc.

Debugging Tools: GDB, Dtrace, DBX, strace, ltrace, nm, ASAN, rational purify & quantify.

OS: Ubuntu, RHEL, MontaVista Linux, Sun Solaris, HP-UX.

OS Concepts: Memory Management, Multi-threading, IPC.

Processors: x86, PPC, x86_64, Sparc, Itanium, SMP processors.

Version control: Git, Bazaar, SVN, CVS, Sablime.

Code browsers: vim, cscope, ctags, VS Code.

Map Reduce framework: Hadoop/HDFS

OPEN SOURCE CONTRIBUTION

Design and Implementation of various features and bug fixes in MySQL Database Engine.

MySQL Server Commits

MySQL server blogs

Design and implementation of ODBC driver and SELECT query feature in JDBC. 

https://sourceforge.net/projects/csql/

PUBLICATIONS

Publication: US 20130268503 A1  "Database navigation of changes at commit time"

http://www.google.com/patents/US20130268503

EDUCATIONAL QUALIFICATION

2013 - Master in Computer Science (Databases)

Illinois Institute of Technology, Chicago, IL, USA.

Research experience:

Worked on Native Database Provenance research project conducted by research group at IIT, Illinios with Prof. Dr. Boris Glavic. In this project we study how to integrate support for tracking provenance, information about the origin of data, into the core (optimizer and execution engine) of a database system with the goal to improve performance and storage requirements of provenance. Most provenance-aware relational systems are implemented as middle-ware solutions using query rewrite techniques to compute provenance. These approaches suffer from poor performance that is caused by limitations in the query language (SQL), execution engines, and optimizers of standard database engines.

I did contribute toward implementation a new type of aggregation operator in Perm (an extension of PostgreSQL with provenance functionality developed by the research group) that allows us to propagate provenance information through the operator without changing aggregation results. Implemented several physical versions of this operator, integrated it with the optimizer and cost-model, and did performed initial performance experiments to evaluate the operator.

2003 - Bachelor of Engineering (Computer Science & Engineering) 

Visveswaraiah Technological University, Belgaum, India

WORK EXPERIENCE

Company: ORACLE INDIA PVT LTD.

Duration: 10 Year ( Jan 2012  till date )

Software environment : C++, Clang, Ubuntu, RHEL,

Team size: 14

Work Location: Bangalore, India

Designation: Principal Member Technical Staff

Assignments:

Improvement to MDS Service:

• Developing MDS maintenance scheduler to automate maintenance and generate notification to customers.

• Enable SELinux auditing in MDS instance in Permissive Mode.

• Improve performance on IMPORT feature on MDS, by tuning configurations of MySQL Shell and Server.

• Refactoring and improve code around MDS service internal state management.

• Porting MDS Dataplane agent to use python3 from python2.7.

• Enable support to configure the system variable 'lower_case_table_names' for MDS database system.
  
  

Major feature additions to MySQL 8.0:

• Design and Implementation of INFORMATION_SCHEMA tables for MySQL ROLES.

• Design and implementation of new INFORMATION_SCHEMA module for MySQL 8.0 Server.

• Design and implementation of Data Dictionary module for MySQL 8.0 Server to store table meta-data into relational tables instead of file system files .FRM.

• Design and implementation making CREATE TABLE ... SELECT as a atomic and crash-safe DDL.

• Design and implementation of feature to enable user to control (enforce and disable) table encryption.

Have worked on various bug fixes related to deadlocks, locking, stored routines and ACL subsystem areas in MySQL server.

Company: Mascon Global Limited

Duration: 2 Year ( Jan 2010  to Jan 2012 )

Software environment : C++, Java, Solaris , RedHat Linux and Montavista Linux, HPUX

Team size: 10

Work Location: Alcatel-Lucent, Naperville, IL

Designation: Senior Technical Lead/ Developer

Assignments:

• Enhance JDBC Driver to support OpenJDK 1.6.

• Porting DataBlitz to HP-UX 11i.

• Individual contributor for design and implementation of SQL Client Discovery Protocol feature,

• involving changes to SQL Kernel, JDBC and ODBC Driver, ISQL command line tool.

• Optional durable commit mode, for all clients. (non disk flush mode).

• Design of better UMASK handling mechanism for DataBlitz Main memory system.

• Design RPM package module for DataBlitz Product deployment.

• Code reviews for fixes on Klocwork Static Code analyzer issues.

• Planning and execution of DataBlitz 8.0 major release features.

• Proposal for new “Distributed Horizontal Partitioned Tables” feature for DataBlitz.

• Interface Alcatel-Lucent Customer for product support.

Company: Huawei Technologies

Duration: 3 Months (Oct 2009 to Jan 2010)

Software environment : VC++, Java, Eclipse, Suse Linux.

Team size: 30

Location: Bangalore, India

Designation: Techincal Project Lead/Developer

Assignments:

• Individual contributor for design and implementation of OUT bound parameter support for JDBC Driver for PostgreSQL.

• Propose Improvement for Native JNI Type II JDBC Driver for PostgreSQL.

• Re-organize entire product documentation with new set of examples for every feature in PostgreSQL Engine.

• Performance analysis on Call Ring Back Tone Application.

Company: Mascon Global Limited

Duration: 29 Months ( April 2007 to Sep 2009 )

Software environment : C++, Java, Solaris, RedHat Linux and Montavista Linux.

Team size: 20

Work Location: Alcatel-Lucent, Naperville, IL & MGL, Bangalore, India

Designation: Technical Lead/ Developer

Assignments:

• Individual contributor for design and implementation of JDBC and ODBC driver for DataBlitz SQL engine.

• Individual contributor for design and implementation of SubQuery Feature in SQL Kernel.

• Individual contributor for design and Implementation of IP-Filtering feature.

• Individual contributor for development of prototype of MySQL custom storage engine using DataBlitz storage manager.

• Porting DataBlitz system 32bit source to support 64bit x86 machine architecture.

• Performance analysis and comparison of DataBlitz product with Timesten and development of datasheet.

• Supporting Business Development team.

• Conduct training on C++ for global MGL team and other associate companies.

• Develop demo for customer and provide presentation at customer location.

• Interface Alcatel-Lucent Customer for product support.

Company: Mascon Global Limited

Duration: 43 Months ( Sep 2003 to April 2007 )

Software environment : C++, Java, Solaris , RedHat Linux and Montavista Linux.

Team size: 20

Work Location: Alcatel-Lucent, Naperville, IL & MGL, Bangalore, India

Designation: Senior Software Engineer

Assignments:

• Porting Dharma SQL kernel to work on 64bit x86 machine.

• Individual contributor for development of High Performance ODBC Driver model.

• Individual contributor for development of Relational DML command line interface tool using

• C++ (non-sql) interface, including development of parser (lex and yacc).

• Release Engineering, Configuration Management, Testing

AWARDS

1) Recipient of Alcatel-Lucent Recognition for Individual Contribution for "Excellence in promoting DataBlitz product quality"

    from Third Party Product Realisation Group of Lucent Lisle, IL – USA.

2) Recipient of Spot Award for "Developing high performance ODBC driver model"

    for DataBlitz MMDB from Mascon Global Limited, Bangalore, India

REFERENCES

Dr. Boris Glavic

Assistant Professor, Head of IIT Database Group,

Department of Computer Science,

Illinois Institute of Technology, Chicago, USA

http://www.cs.iit.edu/~dbgroup/people.html

https://www.linkedin.com/in/boris-glavic-89059019/

Mr. Mallikarjuna Rao

Netskope - Engineering team, Santa Clara, USA

https://www.linkedin.com/in/mallikarjunanamburi/