OBJECTIVE:

Senior Database Developer/Administrator Database Architect.

SUMMARY:

• Over 25 years of IT experience, most of them in data management/database application development areas.
• Expert knowledge of IBM DB2 for LUW (IBM DB2 UDB) v8.x, 9.x, 10.1, 10.5, 11.1.

SKILLS:

Information architect skills: Deep knowledge in the Relational Model. Large practice of working with structured and semi - structured data. Large practice of Data Modeling using various tools (including InfoSphere Data Architect and others). Logical/physical database design. R&D activity in Very Large Databases (VLDB) processing and data warehousing area. Deep knowledge and large practical experience in designing all types of Data Processing (including Transactional Processing, ETL processes, Data Cleaning, Enterprise Data Warehowsing). Act in the solution architect role. Using Data Marts technique as well as implementing universal warehouse solutions for ad-hock analytical requests using DB2 columnar storage capabilities (DB2 BLU Acceleration feature) and Cubes (IBM DB2 Multidimentional Clustering tables). Strong knowledge in parallel computing and its utilization for Data Processing and implementing high availability.

Advanced hands on experience on IBM DB2 for LUW v8.x/ 9.7/10.5/11.1 and dashdb: Installation, upgrade, administration; Logical/physical database design, tuning performance; Advanced knowledge and practical experience in DPF, pureScale and BLU Acceleration features; DB2 Compression, Multidimensional Clustering (Cubes), Range Table Partitioning; Using workload management for monitoring purposes and for workloads prioritization; DB2 pureXML technology; HADR planning/configuring; Backup policy planing/implementation; SQL/Q/CDC replication (configuring, maintenance, troubleshooting); SQL programming, SP development, SQL tuning; Data encryption; ETL tasks development.

Big Data: Deep understanding of the MapReduce and Google BigTable concepts; Practical experience in parallel computing and parallel computing algorithms; Familiarity with NoSQL BigData solutions stack.

Web Development: Large practical experience in Web solutions design and development using various programming languages and technologies. One of the major contributors to the Confidential Framework

PROGRAMMING LANGUAGES:

Expert knowledge of: C/C++, SQL, SQL PL, XML, XSLT, PHP, Rexx, shell scripting.

Extensive experience in: Java, XQuery, IBM Net.Data, JavaScript.

Familiar with: Scala, Python, Forth, Smalltalk, Scheme/Lisp, Perl, Pascal, Basic, x86 Assembly and many others.

Operation Systems: AIX, Linux, Windows Server, Solaris, HP-UX.

Change/problem management tools: SNOW, MAXIMO, BMC Remedy, JIRA, ...

Methodologies: relational data modeling, Entity-Relationship model, OO analysis and design, UML.

Various development methodologies: RUP, Agile, TDD, ...

EXPERIENCE:

Confidential

Senior IT Specialist (DB2 on Cloud), team lead, DB2 SME

Responsibilities:

• Leading DB2 administration/DB support team.
• Manage and support Cloud infrastructure DBs for several global environments.
• Work close with CMS Development team to identify and resolve performance and business logic issues. Organize support processes.
• Communicate with other team members, IBM and non-IBM stuff distributed over the world.

Confidential

Head of the DB2 Databases Management & Support Group, Database Architect

Responsibilities:

• Leading DB2 administration team; Design Data flows and processing while acting in a Database Architect role;
• Design and develop effective data management solutions; Organize core banking systems support (24x7 production, development and testing environments on AIX/Windows platforms); Design/approve database related architectural decisions for IT Development department;
• Participate change management process as one of the stakeholders, Change Advisory Board member; Backup/restore policy planning and implementation;
• Develop team communications (with other teams: virtualization, storage management (SAN based), OS (AIX/ Windows) management, ...);
• Communication with IBM on critical DB2 fixes
• Support other groups in all aspects of DB2 use.
• During my work in this role I also organized team education using special combination of IBM courses prepared especially for our group.

Confidential

Lead Specialist

Responsibilities:

• Core banking systems support (24x7 production, development and testing environment on AIX/Windows platforms);
• Review and approve database related production change requests; Review all database changes coming from IT development department for deployment to test systems;
• Database changes deployment; develop DB modifications which are considered to be executed only by DB2 administration team (due to the performance/risks reasons); Host systems (AS/400 based) connectivity troubleshooting; SQL replications monitoring, troubleshooting; Application profiling; Support other groups in all aspects of DB2 use.

Confidential

Consultant

Responsibilities:

• A member of worldwide distributed team, ZF core team member.

Technologies: PHP, C, CVS, SVN, GIT, JIRA, php unit, ...

Development methodology: Agile, Scrum.

Confidential, St.Petersburg

Chief Software Engineer

Responsibilities:

• Web based solutions, database solutions.

Technologies: Java, PHP, custom PHP extensions, XML/XSLT, MS-SQL Server 2000, Novell exteNd Application Server (ex-SilverStream application server).

Confidential, St. Petersburg

Analyst, Database Expert

Responsibilities:

• DB2 based solutions, analytical projects, web based solutions.
• IT audit and design architecture of new Intranet/Internet core IT solution to replace existing one (DB2 for OS/390 + DB2 for OS/2 + SmallTalk based ORM framework and application; the problem was in a complexity of supporting and extending existed system, based on a custom ORM framework which became out of support).

Confidential, St.Petersburg

Responsibilities:

• Design back-end architecture.
• Design and implementation of DB2 based transactional mechanism providing data and video processing workflow integrity across whole system; DB2 related programming.

Software: Sun SPARC Solaris, Sun HSM (storage manager), DB2 UDB EE V6.1.