Responsible for all aspects of database (PostgreSQL, AWS) component of the new generation of Cloud Mobile Device Management System:

• Architecture

• Schema Design

• SQL and PL/pgSQL Development, Unit Testing

• Performance Tuning, Query Optimization

• Administration

• Java dev. community education/mentoring/support

Responsible for all aspects of DB Administration, Developers DB support/mentoring:

1. Postgres DB Administration

2. Postgres Londiste Replication

3. Postgres Streaming Replication

4. Performance Optimization, Query Tuning

5. Vertica ETL Optimization

• Responsible for back-end design and implementation of RTB(Real Time Bidding) system (MySQL, Oracle, Postgres):

• Schema design and implementation (MySQL, PostgreSQL)

• Triggers for data propagation (PL/SQL, PL/pgSQL).

• Lead major project of porting existing system from [PostgreSQL, Python] to [Oracle, PL/SQL, Python]:

• Schema and data porting.

• Business logic reimplementation with Unit Tests.

• Use stateless HTTP/Json technology to communicate between front-end modules (Java, Python) to the back-end DB.

• Responsible for performance/correctness of the EF Reporting System. Improved average report execution time from 2.5 hours to 5 minutes by analyzing auto-generated report queries and optimizing them.

• Lead the effort of switching DB access implementation from Python/Protobuff to PL-pgSQL/JDBC. Personally re-implemented several Python modules using PL-pgSQL adding Unit Test for each back-end API.

• Re-implemented DB Unit Test Framework in pure Python adding support for PostgreSQL. Wrote several dozen of PostgreSQL API Unit Tests.

• Responsible for overall Architecture, Design and Implementation of the PSS Systems DB – logical and physical schemas, PL/SQL and T-SQL: packages, procedures, functions, triggers, views, etc.

• Lead global porting project of PSS Systems to support SQL Server (back-end and Java layer).

• Design and develop DB Unit Test Framework (Python).

• Write hundreds of DB Unit Tests.

• Provide support and resolve all Customers' DB issues.

• Mentor Java development community (local and 2 off-shore teams)