SUMMARY

• Top level knowledge of Databases including ORACLE RDBMS programming, application architecture, physical and logical database design with more TEMPthan 20 years in hand experience.
• In - depth knowledge of modern Information Technology issues including programming technologies, data processing and migration, structural and object-oriented analysis, UML and structure-oriented description techniques, CASE programming, client-server architecture programming, etc.
• Expert level knowledge of SQL (PL/SQL) programming. Advanced level knowledge of Java programming (15 years), C/C++ programming languages, Perl/Shell scripting and XML/XSL languages.
• Expertise in full-life cycle software projects planning using different methodologies, including Agile, Scrum, IBM BPML, LBMS System Engendering, in leading software development projects, and in information systems architecture.
• Expert development tools skills in ORACLE Developer(including Oracle Forms and Report), Platinum SQL*Station, ORACLE JDeveloper. Excellent Case Tools skills in ORACLE Designer 2000, Sybase PowerDesigner/PowerArchitect, Rational Rose. Additional DBA skills in Platinum Advantage and Artisan, TOAD.

TECHNICAL SKILLS

Database Servers: ORACLE 12c,11g,10g, 9i/8i.x/8.0.x/7.x/6.x; MySql 5.x, 4.x, 3.x

Application Servers: Apache HTTP; Tomcat 5,6,7,8; ORACLE/Weblogic Application Server, JBoss 4.x, 3.x; Oracle Application Express 5.0.

Languages: SQL, PL/SQL, Java, C/C++, XML/XSL, Perl, Shell script

Tools: ORACLE SQL Developer, ORACLE JDeveloper,; ORACLE Tools, Oracle Forms 12c, 6.0, 3.0, Oracle Report 12c, Oracle APEX;

Eclipse: Java extension, Eclipse C++ extension; Code Bloks Linux

XML: Spy 2009, 2007, 2009; ORACLE Designer 2000; Sybase Power Designer to 16.5; DBArtisan, TOAD; GNU C.

Shells: bash, ksh, sh, csh

OS: Linux Centos 7, Linux Red Hat Developer platform, Linux Red Hat Enterprise Server; Oracle/Sun Solaris; Windows 10/8/7/XP/NT/ 2000/4.0/3.5 ; HP-UX

Networking: TCP/IP; MS Win (TCP/IP).

PROFESSIONAL EXPERIENCE

Confidential, Somerset, NJ

Sr. Developer/Lead Architect

Environment: and tools: Oracle SQL developer, TOAD, Oracle 11G, 12G, JForex, Code::Bloks, Eclipse, Oracle Jdeveloper under Windows and Linux platforms

Responsibilities:

• Developing DB models(Oracle 12c), packages and SQL queries for the company back office data processing, processing inbound/outbound feeds data flows from different sources include: WEB Services, Forex and Crypto Currency log files, and / or direct WEB REST communications.
• Responsible for the design and develop Fast Forex trading application(Java), Architecture of multimarket/multicurrency applications with massive parallel processing.
• Responsible for the design and develop Stock Market trading application(Java), Architecture of multimarket applications with massive processing.
• Design architecture and data models for different trading systems in multiplication environments;
• Work with performance tuning using execution plan analyses, Oracle SQL Developer, Toad and others.
• Backup/restore DB and some other DBA maintenance activities, including standby database and parallel ETL processing

Confidential, Jersey City, NJ

Sr. Oracle Database Developer/Lead DB Architect

Environment: and tools: ORACLE 11g (RAC), Oracle EXADATA, TOAD, PL/SQL Developer, Sybase Power Designer, SQL Developer, ORACLE Data Modeler, PEGA PRPC

Responsibilities:

• Developing DB models, packages and SQL queries for the RDM Golden source repository, processing inbound/outbound feeds data flows from different sources include: Oracle WEB Services, Flat files, XML based files, and so on.
• Design and developing key elements of DW models and ETL data processing for Deutsche Bank Strategic MIS reporting system, DW use Oracle Database.
• Design architecture and data models Data Privacy implementation for multijurisdictional, multiplication environments;
• Work with performance tuning using execution plan analyses, Toad and others tools for Clients RDM database repository, PEGA PRPC Oracle database storage, Web Services for multiple databases communications.
• Design models and architecture for the data replication using Oracle Stream technologies from RDM application to consumer's systems;
• Writing PL/SQL, packages procedures, functions, for support business rule base data validation as a part of the generic database processing;
• Analyzing technical infrastructure and risks for different ways for design data models, data flow and database infrastructures design Oracle High Availability architecture.

Confidential, Pennington, NJ

Sr. Oracle Database Developer/Architect

Environment: and tools: ORACLE 10g (RAC), 10g, TOAD, PL/SQL Developer, Sybase Power Designer

Responsibilities:

• Developing DB models, packages and SQL queries for the Data Distributing Hub, processing inbound/outbound feeds data flows from different sources include: Oracle databases (using DB Links), DB2 Database, Flat files, XML based files, complicated code with Oracle Analytic functions such as Ranking, Lags, and so on.
• Design and developing DW models and ETL data processing for Core HR Enterprise reporting system, DW use Oracle EXADATA with multi terabytes storage.
• Design architecture for coordination Oracle database and Linux/Unix file servers security for fine grain access to tables and/or files;
• Work with performance tuning using execution plan analyses, TKPROF for processing trace files, AWR reports.
• Implementation Oracle RAC with main goal - improve performance of inbound/outbound feeds processing in fixed time (many parallel sessions of the feed processing with a couple millions records each with or without techniques of slicing source data flow).
• Writing shell scripts templates and PL/SQL code for automation and coordination Oracle and Unix/Linux security.
• Design models, architecture and developing code for the data replication using Oracle Stream technologies;
• Writing PL/SQL, packages procedures, functions, for support business rule base data validation as a part of the generic ETL processing;
• Analyzing technical infrastructure and risks for different ways for design data models, data flow and database infrastructures.
• Design architecture and planning procedures of the migrating current Oracle 10g database instances to Oracle 11g instances with minimization of risks for production systems;

Confidential, San Francisco, CA

Sr. Oracle Database Developer, Sr. Database Performance Specialist

Environment: and tools: ORACLE 10g (RAC), 9i, 10g, JBoss, TOAD, Sql Navigator, PL/SQL Developer, Sybase Data Base Designer;

Responsibilities:

• Planning data architecture for processing complicated data flows and large amount of data in OLTP environment (up to 1bln records per year);
• Developing complicated procedures, functions, queries on PL/SQL and SQL.
• Developing architecture and PL/SQL packages for downloading data from OLTP to DW database using Oracle Stream technologies;
• Developing architecture of Enterprise reporting system (Oracle DW and BO for regular reporting, OLTP for emergency reporting).
• Planning and implementation Oracle RAC architecture with main goal - scalability of the system (estimation for increasing volume of annual data 15-20%, system has to start working in 2-nodes RAC and has to have ability to keep the same performance during 4-5 years using simple adding new nodes);
• Writing PL/SQL, packages procedures, functions, for support ETL Data loading processes;
• Developing requirements for Level-0 to Level-2 Master data structures;
• Analyzing technical infrastructure and risks for different data models/data flow architecture.

Confidential, Whitehouse Station, NJ

Sr. Oracle Specialist/Developer

Environment: and tools: ORACLE 10g, 9i, Oracle JDeveloper v. 9i, 10g TOAD, Sql Navigator;

Responsibilities:

• Creation of dataflow processes and procedures for data validation/transformation during migrating architecture from Lotus to Web;
• Planning data Migration workflow into WEB Based Application and ORACLE Infrastructure;
• Analyzing technical risks.
• Writing PL/SQL, SQL Loader, packages procedures, functions, for support Migration process;
• Writing applications queries/SQL statements;
• Developing complicated procedures, functions, queries on PL/SQL and SQL.
• Tuning Oracle instances, physical DB structures, Oracle memory structures;

Confidential, NY

Sr. Oracle Specialist/Modeler/Architect

Environment: and tools: ORACLE 9i, 8i; Oracle JDeveloper v. 9i TOAD, Sql Navigator; XML Spy 5.0 (2003).

Responsibilities:

• Planning data Conversion from Finance Applications into ORACLE Infrastructure for Global TAX Department;
• Writing packages, procedures, functions, scripts for support Conversion, Migration and Mass Load processes;
• Analyzing technical and informational risks.
• Creation of backup/restore procedures and scripts;
• Installation of Oracle software and Oracle database;
• Tuning Oracle instances, physical DB structures, Oracle memory structures;
• Users’ and production schemas maintenance.

Confidential, NY

DBA/Programmer-Analyst

Environment: and tools: ORACLE 8i, 9i; Oracle Tools; MS SQL 7.0; Shell scripts, XML Spy 4.x, 5.0; MySql.

Responsibilities:

• Applications transfer from v.8.1.5 to v.8.1.7, and from MS SQL 7.0 to Oracle 8.1.6;
• Planning and tuning of Master-Master Replication Model (v.8.1.7);
• Planning and installation of Oracle Real Application Cluster consists:
• Two Sun Enterprise Servers with Solaris 8 OS, SUN Cluster 3.0, and common disk array;
• Two Red Hat Advanced server 2.1 nodes with common EMC disk array
• Main goal for RAC - failed over.
• Installation and tuning of Oracle database servers and applications (v. 8.1.5, 8.1.6, 8.1.7, 9i); pursuing high durability and HA (High Availability) of the system (24/7/365),;
• Tuning of physical DB structures, Oracle memory structures, and applications queries/SQL statements, including OPS and Oracle RAC environment, Oracle files on RAW devices