Konstantin G. Email & Phone Number

Irvine, Ca, Us

• Assume a broad range of responsibilities within the technology group focusing on Data Processing and System Administration.• Architected and further optimize a phased approach of software DTAP process (Development, Testing, Acceptance and Production) significantly reducing the risk of production application deployment and upgrades.• Responsible for logical/physical database design, data normalization/de-normalization• Develop ETL code for processing and analysis of financial markets data (Java/Python/SQL/PL-SQL).• Refactor existing SQL queries and PL/SQL procedures for optimum performance.• Mentor database developers on writing efficient SQL queries. • Engineer Oracle RAC and Exadata systems. Plan, procure and maintain Oracle Exadata and ZFS Storage Appliance systems. Design and implement procedures for Exadata DB backups, DB cloning via ZFS Storage Appliance, Data Guard and ZFS data replication.• Setup and maintain Oracle, MS SQL Server and MySQL databases for various vendor applications, including installations, upgrades, capacity planning, backup and recovery, monitoring and performance tuning.• Install, configure, upgrade and upgrade Oracle Enterprise Manager. Configure monitoring and database backups.• Deploy and administer High-Performance Computing Cluster (HPCC) environment, including hardware installation and troubleshooting, Linux OS deployments, upgrades, patching, software installation and maintenance.• Integrate and maintain Opswise Automation Center as main process workflow scheduler.• Write Perl/Python/PL-SQL scripts to facilitate System/Database Administration.• Install, upgrade and manage RSA Secure ID Stack.• Developed and continuously improve BCP (Business Continuity Planning) solutions for all in-house applications, databases and storage systems.

San Francisco, California, Us

Served as expert technical resource to internal clients and database administration groups. Engineered and maintained Oracle, Sybase and MS SQL Server DBMS, including installations, upgrades, capacity planning, performance tuning, backup, recovery. Acted as escalation point for all database related issues on 24/7 basis. Architected data replication solutions via Oracle Dataguard, Sybase and MS SQL Replication Server. Developed Perl scripts to facilitate database administration. Established database management standards, policies and procedures.

Boston, Massachusetts, Us

Responsible for managing Sybase and MS SQL Server databases. Performed data modeling, logical and physical database design, system monitoring, performance analysis and tuning, proactively identifying potential problems planed preemptive actions.

New York, Ny, Us

Programmed C++ ETL modules to transfer data from OLTP database into Reporting Data Warehouse. Developed, optimized and tuned SQL stored procedures for daily client portfolio reports generation.

San Francisco, California, Us

As a team lead managed a development team responsible for NCR Image Mark deployment. Drove business requirements gathering, design, build, testing, and production deployment. Managed and communicated change control to team members, operational users and upper management.

San Francisco, California, Us

Supported Oracle, Sybase and MS SQL Server DBMS, including installation, upgrades, capacity planning, performance tuning, backup and recovery, BCP and site failover exercises. Implemented data replication solutions via Oracle Dataguard, Sybase and MS SQL Replication Server.

New York, Ny, Us

Designed Prime Brokerage Portfolio Accounting Reporting Data Warehouse. Programmed C++ ETL modules to transfer data from OLTP database into Reporting Data Warehouse. Wrote, optimized and tuned SQL stored procedures for daily client portfolio reports generation.

New York, Ny, Us

Responsible for hardware and software installation, upgrade, maintenance and support of database and UNIX systems (Oracle, Sybase, Gemstone Object DBMS Servers, HP and Solaris workstations/servers). Engineered distributed computing system for Credit Derivatives Portfolio Management including database design, performance tuning, and programming Analytics Engine in C++.

Us

Responsibilities include database administration, developing backup and recovery strategies, data modeling, and performance tuning for multiple database platforms including Illustra, Informix, and Sybase. Tested and deployed new DBMS products to determine company-wide applicability.

Chicago, Il, Us

• Deliver DBMS and UNIX consulting services for assigned clients including American Express, Nomura Securities, Chase Manhattan Bank, Citibank, General American Investors, and Marine Midland Bank.• Provide DBA/SA support - installations, performance tuning, disk mirroring, data distribution, database design, data normalization/denormalization, referential integrity enforcement.• Design ETL modules to transfer data from mainframe to UNIX platform, upgrade hardware resources, and tune operating system kernel.• Develop recovery strategy and maintain database security.