Member Of Technical Staff
Austin, Texas, Us
• Designed and created a multi-tier model for pooling of Oracle Connections for multi-threaded scenarios based on session and database settings. (C++, Oracle 12C)• Implemented Multilevel Tagging of database connections based on session settings and user defined tags. Wrote PL/SQL to provide callback support for scenarios when requested tagged connections are busy. (C++)• Synchronized session state between server processes residing on Database Resident Connection pools and connections maintained on client side pools of Data Provider. (C++, SQL)• Analyzed the Two Task Common protocol and upgraded it for efficient communication for synchronizing session state between the Database and Data Provider. Migrated the code to Oracle Cloud. (C, Oracle Call Interface)• Programmed to reduce latency involved with fulfilling connection requests by switching pooled connections across Pluggable Databases (PDB) and their services in Oracle Multitenant Architecture. (C++, OCI, Oracle12C)• Synchronized session states and NLS settings post migration across PDBs in a Container Database. (C++, XML)• Handled data requests initiated for a connection after a planned or unplanned Failover happens from a failing instance to a working instance of a database. (C++, OCI, PL/SQL)