Design, Development & Support of a highly-scalable, high performance, multi-master, client-server based Data Management System across several geographical domains in on-premises cloud used by Systems engineering:
** Millions of daily transactions by thousands of concurrent users, interactive and noninteractive, supported by the design of relational database schema and performance-tuned SQL queries and updates.
** Thin C++ clients and multi-threaded, distributed JAVA based servers that provide real-time synchronization metadata and physical files across geographical domains.
** Horizontally scaling to handle new work demand and auto scaling to handle dynamic bursty loads.
** Provided users’ perspective to the development team for improving system features and performance.
** Designed, implemented, and deployed Infrastructure for production and testing.
** Defined and implemented software build environment and release packaging.
** Regression test case creation & maintenance: daily, random, and custom scenarios.
** Ported the software from SPARC/Solaris to x86/Solaris, x86/Linux, SPARC/Linux as well as performed new Oracle/Java release upgrades.
** Collaborated with project DBAs on data management methodology & processes, how to best utilize the system, new release beta testing, deployment, user environment related issues,, and other various custom tasks.
** Worked with Oracle DBA on new instance setup and cloning: production, clone, and play.
** Prepared training materials and conducted different usage classes to end-users, DBAs, and design flow developers.
** Worked with cloud infrastructure team in resolving on-premises system level issues.
** Technologies used: Java 7&8 (JDBC & JNI), C++, C, Oracle 12c/11g, UCP, Golden Gate real-time replication, DB-Link, perl, bash, Jenkins.