# Vadim Zingertal

> Principal Software Engineer, Database at Cubic

Location: Oakland, California, United States
Profile: https://flows.cv/vadimzingertal

Over 40 years of experience in:
• RDBMS architecture/design/programming/administration
• PostgreSQL, Oracle, SQL Server, MySQL
• SQL, PL/pgSQL, PL/SQL, T-SQL programming
• Performance Optimization, Query Tuning
• End-users/developers support, education, mentoring

## Work Experience
### Principal Software Engineer, Database @ Cubic Transportation Systems
Jan 2023 – Present

### Senior Database Architect, Cloud @ Ivanti
Jan 2012 – Jan 2023 | Mountain View, CA
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

### Senior Database Lead @ Yammer, Inc.
Jan 2012 – Jan 2012 | San Francisco, CA
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

### Senior Database Architect @ Efficient Frontier
Jan 2009 – Jan 2012
• 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.

### Senior Database Architect @ PSS Systems
Jan 2008 – Jan 2009
- 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)

### Senior Database Architect @ Rearden Commerce
Jan 2006 – Jan 2007
• Responsible for the overall Architecture and Design of the Rearden Commerce DB 
• Established, documented and enforced schema design patterns, naming conventions, PL/SQL coding standards, etc.
• Cleaned/rewrote and documented 75% of existing PL/SQL code.
• Wrote over 100 DB Unit Tests for packages, procedures, etc. using PL/SQL Unit Test FrameWork of my own.
• Implemented and deployed Automated DB Cleanup/Archival Framework allowing to move data from Transactional DB to Archiving DB based on configuration metadata. Implemented “Cascade Delete” functionality based of Referential Integrity Constraints metadata.
• Implemented a PL/SQL package (DDL_UTIL) allowing writing “Idem Potent” SQL scripts.
• Designed and prototyped Dynamic Data Model (DDM) Framework allowing users to create virtual tables on a fly – foundation for Building Applications On Demand (like Sales Force).
• Mentored and educated Java community (about 50 developers) with regards to Relational DB Technology usage.

### Senior Database Architect @ Questra Corporation
Jan 2004 – Jan 2006
•	Responsible for the Database Component (Oracle and SQL Server) .
•	New features implementation, schema maintenance, stored procedures (PL/SQL and Transact-SQL) developing/maintenance/tuning, SQL queries tuning, etc.
•	QSS System has most of the business logic written on the back-end, hence hundreds of stored procedures are implemented for both, Oracle and SQL Server databases.
•	Designed and implemented Unit Test Framework for PL/SQL and Transact-SQL procedures and packages. 
•	One of the latest projects: implementing Data Warehouse off-loading tool allowing data to be taken off line on table-by-table and date range bases.  The data can be brought back into the database by request.

### Staff Software Engineer @ Netflix
Jan 2003 – Jan 2004
• Responsible for data mining, data analysis (OLAP), business processes validation and optimization.
• Prepare series of presentations for company’s executive staff outlining the findings of data mining and suggesting improvements for critical business processes.
• Lead variety of small and medium size projects involving SQL, PL/SQL, ASP and VB programming.

### Senior Database Architect @ Model N
Jan 1999 – Jan 2002
• Played a key role in developing Model N Platform – 3 tier, J2EE conformed.
• Led and has always been a single point of contact for database side of Model N product development.
• Organized multi-user development environment (over 30 Java developers) facilitating seamless use of the DB.
• Led OLTP optimization effort aimed at increasing Model N schema population speed 5 times.  Utilized Data Partitioning, Direct Writes, Optimizer Hints, Redo Logs Writing Elimination, etc.
• Designed and implemented Model N database schema (94 tables).
• Designed and implemented unique Model N Community database subsystem, utilizing Oracle hierarchical queries.
• Led porting project to support IBM DB2 database.  Developed DB2 equivalent of Oracle hierarchical queries utilizing DB2 recursive queries.  Developed Database Invariance Layer (Java) to better support any other porting initiatives.
• Supported and educated Java development community re. Oracle RDBMS usage, efficient query writing, etc.

### Corporate Data Modeler @ Adobe Systems
Jan 1995 – Jan 2000
• Responsible for all Corporate Database Schemas and overall Corporate Database Design.
• Designed, actively participated in implementation and administered (24/7) Adobe Worldwide Customer Database, foundation for WEB based Adobe Store application.
• Designed Adobe Corporate Data Warehouse. 
• Designed and develop Time Tracking System using VB 5.0 and ORACLE 7.2.  RDO and Crystal Report 4.5 were used to implement data access and reporting.  Heavy PL/SQL development on a back-end involved (RPC - Remote Procedure Calls).
• Installed and administered Designer-2000 data repository.
• Using Designer-2000, created Entity Relational Diagrams (ERD) for some major corporate applications - AdobeBugTrackingSystem, AadobeSalesLeadTracking, AdobeHelpDesk etc.
• Led several major conversion projects redesigning/converting legacy applications (Sybase/Scopus, Informix/4GL) to ORACLE/Vantive client/server 3-tier system.


## Education
### MS in Computer Science
Southern Federal University (former Rostov State University)


## Contact & Social
- LinkedIn: https://linkedin.com/in/vadimzingertal

---
Source: https://flows.cv/vadimzingertal
JSON Resume: https://flows.cv/vadimzingertal/resume.json
Last updated: 2026-04-12