Data Sql

Sergey Prytkov, Ph.D.

**** ********* **.

Reston, VA 20190

Home: 703-***-****

Mobile: 571-***-****

e-mail: ******.*******.**@*****.***

Education:

**** **.*., ********* ******** University of America, Washington, DC

1994 M.S., Chemistry Catholic University of America, Washington, DC

Professional Summary:

An experienced IT professional with specialization in databases. Have 18 years of experience in database development and administration for various databases: Oracle, DB2, Greenplum (PostgreSQL), Netezza and others. Extensive use of SQL for development, ad-hoc queries, object creation, data management. Programming with PL/SQL. Use of Oracle SQL*Loader, Export/Import utilities for loading and offloading data. Development with programming and scripting languages: C/C++, Unix Shell Scripts, Python.

Certifications:

Oracle Advanced PL/SQL Developer Certified Professional

Oracle 9i Certified Professional DBA

Oracle Certified Associate, Java SE 7 Programmer

Sun Certified System Administrator (Solaris 9)

IBM Certified Database Administrator (DB2 V8.1)

Microsoft Certified Professional (2003)

Computer skills:

Databases: Greenplum, Netezza, Oracle (10g, 11g), DB2 (8.2, 9.1),

SQL Server 2000/2005, Teradata (13.0, 14.0)

Programming languages: SQL, PL/SQL, Unix Shell Scripts, C/C++, Python, Java

Operating Systems: Windows, Unix (Solaris, AIX, HP-UX), Linux

Data Modeling Software: PLATINUM ERwin 3.5.2

Database Application Development Tools: TOAD (Tool for Oracle Application Developers), Oracle SQL Developer, PL/SQL Developer by Allround Automations

ETL Tools: Informatica PowerCenter

Cloud Technologies: Hive, HQL

Software Development Tools: Microsoft Visual C++

Version Control Software: Subversion, Perforce

Experience:

Mar 2010 – Jul 2016, FINRA Inc., Rockville, MD

Working for the largest independent regulator for securities firms, supported the functioning of a multi-terabyte data warehouse, having multiple roles in a fast paced environment:

Jun 2015 – Jul 2016 ETL Developer

ETL Development.

oParticipated in the company’s movement from Greenplum and Netezza to cloud-based data storage. Developed transformation procedures for ETL of market data into AWS Cloud environment using Hive and HQL. Analyzed source and target data formats and source to target mapping. Used Hive queries and Hive DDL to transform data and combine data from several sources into one data file.

Data management.

oContinued data management support of Greenplum and Netezza databases. Managed the removal of expired data from Greenplum and Netezza databases according to retention policies and users’ requests. Created SQL scripts that generated the data removal scripts for date partitioned tables (Greenplum).

oCreated and executed SQL scripts that corrected data errors in Greenplum and Netezza databases. Used shell scripts to automate the generation of such scripts for multiple partitions (Greenplum).

oDeveloped a shell script that was run on a daily basis comparing the row counts between different sources and reporting inconsistencies.

Jun 2012 – May 2015 Application DBA (Greenplum, Netezza)

Database object management.

oCreated tables for the new business objects. Created partitions for these tables (Greenplum). Loaded data into the newly created tables. Created and modified views based on these tables. Dropped tables, views, partitions that were no longer necessary.

Data movement and data archival.

oGenerated and ran scripts to remove the outdated data from the disaster recovery database. Offloaded data into compressed flat files for archival. Moved data between the databases.

oUsed ad-hoc SQL queries and PL/SQL procedures for an Oracle-based metadata repository to create reports on archival status of Greenplum and Netezza tables.

Data access management.

oManaged the creation of user accounts and groups, and granting them necessary privileges to provide proper access to the database objects.

Data quality control.

oCreated and ran scripts to correct data errors in Greenplum and Netezza databases.

oCompared database object definitions between production and disaster recovery databases and reported inconsistencies.

oCompared row counts between production and disaster recovery databases and reported inconsistencies.

Mar 2010 – May 2012 QA Engineer

QA Testing.

oDeveloped and executed test cases for ETL procedures using proprietary Java based tool. The ETL procedures loaded data from various data sources (Oracle, SQL Server 2008, flat files) into a Netezza data warehouse. Wrote SQL statements necessary for such tests.

oCreated Requirements and Test Sets, published test results in HP Quality Center. Submitted bug reports using Borland’s StarTeam. Verified fixes for the bugs. Tested proprietary Python based tools: a software build tool and a Netezza to Oracle data transfer utility.

oChecked the compliance with requirements of SQL scripts for table and view creation. Participated in writing and editing requirements and technical documentation. For this purpose, interacted with business analysts and developers to point to incorrect specifications that may lead to errors.

Nov 2011 – Feb 2014 Software Engineer, Dulles Research LLC., Reston, VA (part-time)

As a part-time employee participated in the project to transform Oracle PL/SQL into Teradata SPL (Stored Procedural Language). Participation involved the following tasks:

Database feature reviews.

oServed as an expert source on Oracle SQL and PL/SQL, and Teradata SQL and SPL. Created detailed reports on various features and language elements of SQL, PL/SQL, and SPL, compared matching features, identified differences that can create potential problems during transformation, and suggested ways of resolving these problems.

oSuggested replacement mechanisms for Oracle features that do not have matching features in Teradata. Estimated the feasibility of such replacement. The features and language elements included triggers, cursors, cursor attributes and cursor loops, dynamic SQL, hierarchical queries, sequences, exceptions, multi-table inserts and some others.

Transformation algorithm development.

oDeveloped algorithms for transformation of Oracle features to Teradata. Developed algorithms for replacement of some PL/SQL procedural elements with advanced SQL statements. Example – use of windowing functions instead of loops with induction variables. The algorithms contained detailed description, flowcharts, and examples.

Jan 1998 – Mar 2010 Sr. Software engineer, Experian Inc./MarketSwitch Corporation

In 1998 started working for a startup Marketswitch Corp., which was acquired in April 2004 by Experian Inc. During the employment with these companies performed the following duties.

Database Administration.

oWas responsible for the functioning of all the databases (Oracle, DB2, SQL Server, Teradata) on multiple OS platforms (Windows, Unix, Linux) for the local team of developers. Performed routine DBA tasks: software installation, instance and database creation, startup, and shutdown, patch installation, administration of database objects (tablespaces, datafiles, tables), user administration, database networking services configuration and troubleshooting, backup of important data.

oProvided scripts for creation of database objects (tablespaces, bufferpools, partition groups) necessary for installation of company’s products.

oAddressed performance issues: used Explain Plan, Oracle Trace, and TKPROF to identify poorly performing SQL statements, and improve their performance.

oContributed to company’s technical documentation by providing database related instructions (Oracle, DB2, and SQL Server) for installation and use of company’s products.

Database development and data modeling.

oDesigned and maintained the database component of the company’s product: created data models for MarketSwitch’s line of products metadata and generated SQL scripts for their implementation on Oracle and DB2 databases by using ERwin 3.5.2.

oWrote PL/SQL procedures and SQL statements for retrieving/saving these metadata from/into the database.

Data Management.

oPerformed data loads, data offloads, and data transformations at the request of customers, customer support team, and other developers. For these tasks used Oracle SQL*Loader, Oracle Export/Import utility, Informatica PowerCenter, Teradata FastLoad utility, SQL queries.

oAssisted customer support team by developing select statements for creating views necessary to work with the customers’ data.

Unix/Linux system administration.

oAdministered a local network of Unix/Linux servers and workstations (Solaris 7, 8 and 9, AIX 5.3, HP-UX 11i PA-RISC and Itanium, Red Hat). Installed software at the request of developers.

oSupported NIS and NFS.

C++ programming.

oDeveloped C++ classes and methods for interfacing GUI, Calculation Engine, and Database layers of company’s line of products multi-tier architecture and provided internal testing utilities for these classes and methods. Fixed bugs in C++ code.

Testing. Participated in compatibility and performance testing of company’s software for various versions of Unix, Linux, and Windows operating systems:

oFor the latest versions of AIX and HP-UX (AIX 6.1, HP-UX 11i v3) arranged remote access via SSH and VPN to IBM and HP servers through these companies’ partnership programs, configured resources on these servers, installed and/or configured databases, installed, configured, and launched the company’s products, performed smoke testing.

oFor Windows operating system used dual boot configuration for smoke testing of installation procedures and functioning of company's products in a reproducible operating system environment.

Languages:

English (fluently), Russian (native speaker).

Contact this candidate