Dimitry Ioffe Email & Phone Number

New York, Us

Cloud DB and data engineer tasked with developing and implementing global strategy for cloud and on premise database products, their full life-cycle support, and data management and archival practices for the firm. Guidance, optimization and performance tuning of the existing data engineering processes.• Complete redesign, refactoring and reimplementation of a terraform based workflows to deploy and manage various AWS SQL/NoSQL DB products and DB solutions in the cloud• Optimization and refactoring of the existing code/ddl to more cloud friendly and scalable• Global archival strategy design and development of the python based and open source cloud native archival framework• Performance tuning and optimization of deployed database solutions• Port of the existing ClickOps based solutions to terraform

Stamford, Ct, Us

Global manager responsible for R&D and the full life cycle implementation of the business critical data pipelines, data products and their infrastructure.DBOps and SRE for complete portfolio of DB productsDevelopment, monitoring and full stack integration into ELK for all data and messaging platforms in use by the firm.In depth code optimization, automation, and performance analytics for Apache messaging stack and multiple open source as well as proprietary db products in relational and NoSQL spaces.Vertical stack optimization and storage utilization forecasting per product and platform.Vendor negotiation and streamlining.Responsible for providing directional outlook and road maps to CTO and senior management for both structured and unstructured data along with the migration and support paths to address changing data needs of the firm. Responsible for the monitoring automation and growth projection for the vertical infrastructure of the data and messaging products in use by the firm.

New York, Ny, Us

Enterprise Data Architect/Divisional Head of Data Architecture for PWM/DBA SME

Design, modeling, and blueprints for global enterprise automation and resource modeling via splunk and complex event processing. Lead efforts in Americas in development, reengineering, and uplift of Informatica and BusinessObjects platforms to more cost and resource charge back effective model tightly coupled with vendor licensing.• SQL performance tuning and optimization for DB2 9.*• Development of java tools to support account management for BusinessObjects and their integration with corporate LDAP• Lead for the for re-engineering, virtualization, and self-services in Americas for Informatica and SAP BusinessObjects product lines• Design and documentation of DR solution for middleware tools in Americas

New York, New York, Us

• Compliance DBA team lead / Manager• PostgreSQL platform lead• Implementation and support of various databases, audit reports and surveillance systems to support SEC regulatory audit requirements for the firm• Design and support of the audit controls to maintain and support enterprise-wide implementation of SOX• Core member of the technical standards committee for the implementation and payment processing system for domestic and international currencies marketplaces• Support, maintenance and minor design improvement of the existing commodities payment and trading systems globally• Installation, configuration, optimization and support of Sybase IQ 15.x, ASE10-15.x, Rep. Server 11.5-15.x, DB2 UDB 7 - 9, MS SQL 7.0 and MS SQL 2000 for divisional Projects• C/C++ udf development to further DB2 UDB functionality• SQL debugging and tuning for stability and performance• Extensive shell and Perl scripting

• Implementation of physical and logical security guidelines and procedures for the enterprise• Team lead for the development of the Fixed Income Trade and Settlement automated system• Project manager for enterprise wide DBMS Euro compliance transformation initiative • Y2K enterprise compliance project manager• Enterprise-wide budgeting and effort assessments for hardware/software, support upgrades and maintenance• Installation, support and troubleshooting (hardware & software) of HP-UX 9.5-11.0, Solaris 5-7• Installation, administration and troubleshooting of enterprise-wide multi-domain DNS and NIS/NIS+• Installation, administration and support of mission critical 24x7 distributed Sybase cluster on heterogeneous operating systems (Solaris & HP-UX)• Hardware and software support and administration of HP3000 and MPE/iX 5.5 and 6.0• Provided enterprise wide migration path from Sybase 11.5.0 to 11.9.2

• Project lead for enterprise standards on MS SQL server and multi-directional replication• Installation, administration and support of mission critical 24x7 MS SQL 6 servers, Sybase 11 and Sybase Adaptive Servers 11.5• Tuning and optimization of DSS and OLTP systems• Optimization of system specific transact SQL for MS SQL and Sybase• DNS support and troubleshooting • Support and troubleshooting of DIGITAL Unix• Implementation of backup strategy using Perl 5 and advanced replication techniques• Replication of data for non-homogeneous databases

• Extensive programming experience in Sybase 11 and MS SQL 6• Migrating databases and scripts from MS SQL 6 to Sybase 11• Extensive use of case and modeling tools• Configuration and installation of Windows 95 and NT• Structural data analysis, linear and non-linear modeling • Extensive programming in SPSS 7 and SAS 6

• Extensive programming in Paradox and MS Access• Development and support of OLAP• Statistical analysis for publications (logistic regression, survival analysis, complex correlations and hidden relations) • Administration and support for departmental servers• Data mining with CHAID • Extensive programming in SQL, SAS, SPSS, PAL, Object Vision, C++, Visual Basic

• Modeling of RDB for DSS • Assistance in choosing proper statistical methodology and analysis • General statistical consulting in SPSS and SAS for graduate students

Mba/Gm, Global Management, Technology, Finance

Ba, Statistical Research Design, Applied Economics And Econometrics, Computer Science, Mathematics

Education record