Solutions Architect
eIntegrate
Skills
Oracle DBA, RAC experience, SRE practitioner, PL/SQL developer, programmer, database optimization and scripting/programming experience, Perl, Ruby, JS, Microsoft SQL Server, DB2, MySQL, MongoDB, PostgreSQL, Database, Backup, RMAN, codebase, python, Oracle, database security, SQL, PL/SQL scripts, monitoring systems, Cloud, Python Scripting, task automation and reporting automation, Data Guard, Delphix project implementation, Oracle Database administration, DB, SQL PL/SQL Performance tuning, Partitioning and indexing tables, AWR, ADDM, ASH, Oracle RAC, Shell scripting, Perl scripting, PL/SQL programming, SQL programming/scripting, Oracle Exadata, Advanced replication, Streams, Golden Gate, MarkLogic, NoSQL database, LDAP server, file processing, GUI, data modeling, DDL, Network administration, CISCO ASA, AP's, Load Balancers, installation, SQL server, PL/SQL, Oracle RAC Databases, shell scripts, OEM, DDL/packages, programming, database monitoring, voice recognition, Windows, Windows 64x, RHEL, PCI compliance, Oracle Database, RAC administration, 24x7 support, Backup and recovery via RMAN, PCI certification, Log mining, Performance tuning, performance monitoring, Hardware support, SAN, NAS, databases, dbVista, dbVista administration, MySQL administration, Sybase, Oracle SQL, Sybase programming, JAVA, EJB programming, DTS, C++ programming, Oracle 8, Oracle 8i, MS SQL, VBA, Shell programming
Project history
01/2013
-
11/2014
Responsibilities:
Supporting infrastructure (network, virtual VM's). Working with the MarkLogic NoSQL database.
Running local LDAP server, mail and calendar services for few organizations. Created DataProcessor
for 834 file processing, editing, and information gathering. Manage offshore team (Ukraine and part
of India team) with DB and GUI development for integration framework. Works with the offshore team
(India) for application support and architecture. MySQL administration, backup, recovery, and
synchronization. Mentoring juniors and middle-level programmers. Software and hardware price
negotiation.
Oracle installation, performance tuning, and updates. Problem troubleshooting. 24x7 support.
Managing backup and recovery. Logical and physical data modeling. Data loading and transformation
for the healthcare industry. Managing database security, user, roles and access administration.
Support for tables, AWR and ASH report analysis. Data objects change monitoring via developed
package. Daily import of critical DDLs, packages, and functions. SQL plan management. Audit triggers
for DDL and dictionary tables. Creating SQL, PL/SQL scripts and programs to support ongoing
activities.
Supporting infrastructure (network, virtual VM's). Working with the MarkLogic NoSQL database.
Running local LDAP server, mail and calendar services for few organizations. Created DataProcessor
for 834 file processing, editing, and information gathering. Manage offshore team (Ukraine and part
of India team) with DB and GUI development for integration framework. Works with the offshore team
(India) for application support and architecture. MySQL administration, backup, recovery, and
synchronization. Mentoring juniors and middle-level programmers. Software and hardware price
negotiation.
Oracle installation, performance tuning, and updates. Problem troubleshooting. 24x7 support.
Managing backup and recovery. Logical and physical data modeling. Data loading and transformation
for the healthcare industry. Managing database security, user, roles and access administration.
Support for tables, AWR and ASH report analysis. Data objects change monitoring via developed
package. Daily import of critical DDLs, packages, and functions. SQL plan management. Audit triggers
for DDL and dictionary tables. Creating SQL, PL/SQL scripts and programs to support ongoing
activities.
03/2006
-
01/2013
Sr. Database Administrator, PL/SQL Developer
Ignite Media Solutions
Responsibilities:
Oracle RAC installation, migration, backup, DR. Performance tuning and monitoring for Oracle RAC
Databases. Application performance tuning, support, and monitoring. 24x7 support. Managing backup
and recovery. Managing database security, user, roles and access administration. Table partitioning
and data cleanup according to internal policies. Daily monitoring for batch performance via PL/SQL,
shell scripts and OEM. AWR and ASH report analysis. Data objects change monitoring via developed
package. Daily import of critical DDL/packages/functions. SQL plan management. Audit triggers for
DDL and dictionary tables. Mentoring juniors and middle-level programming. Creating SQL, PL/SQL
scripts and complicated packages to support developers' work programs and reports. Supporting
ongoing activities, mentoring juniors and middle-level programming. Creating additional framework
and plugins for database monitoring (PERL). Creating in-house APEX based application to monitor,
reporting and tracking any stage of orders, voice recognition framework and warehousing application.
Support NAS and SAN hardware. Migration from Windows to Windows 64x and then to RHEL with minimal or
no downtime. Playing the main role in database logical and physical modeling, partitioning. Created
database for 250M US-based households and provide all needed functionality with fast search and
database response. Create a process for updated all of these data(quarterly). Passing PCI compliance
for database and DB hardware.
Oracle RAC installation, migration, backup, DR. Performance tuning and monitoring for Oracle RAC
Databases. Application performance tuning, support, and monitoring. 24x7 support. Managing backup
and recovery. Managing database security, user, roles and access administration. Table partitioning
and data cleanup according to internal policies. Daily monitoring for batch performance via PL/SQL,
shell scripts and OEM. AWR and ASH report analysis. Data objects change monitoring via developed
package. Daily import of critical DDL/packages/functions. SQL plan management. Audit triggers for
DDL and dictionary tables. Mentoring juniors and middle-level programming. Creating SQL, PL/SQL
scripts and complicated packages to support developers' work programs and reports. Supporting
ongoing activities, mentoring juniors and middle-level programming. Creating additional framework
and plugins for database monitoring (PERL). Creating in-house APEX based application to monitor,
reporting and tracking any stage of orders, voice recognition framework and warehousing application.
Support NAS and SAN hardware. Migration from Windows to Windows 64x and then to RHEL with minimal or
no downtime. Playing the main role in database logical and physical modeling, partitioning. Created
database for 250M US-based households and provide all needed functionality with fast search and
database response. Create a process for updated all of these data(quarterly). Passing PCI compliance
for database and DB hardware.
12/2003
-
03/2006
Oracle DBA
SoftComputer Consultants
Responsibilities: Install, support and deploy databases (dbVista, Oracle). Create and support
in-house packages for reporting and testing.
in-house packages for reporting and testing.
01/2002
-
12/2003
OTF (Oracle task force member)
ISD(Information Systems Development)
Responsibilities: Install, support and deploy databases (dbVista, Oracle). Create and support
in-house packages for reporting and testing.
in-house packages for reporting and testing.
07/2000
-
01/2002
Developer
PrivateBank
Responsibilities: Development of "Privat-24" server and database part of online billing and banking
system. Created synchronization between Sybase and Oracle database.
system. Created synchronization between Sybase and Oracle database.
07/1998
-
07/2000
Developer
DTS
Responsibilities: Create in-house billing and logistic application
01/1997
-
07/1998
Developer
State Fiscal Service of Ukraine (IRS like)
Responsibilities: developing of DataExchange for State Fiscal Service of Ukraine.
Local Availability
Only available in these countries:
USA
I'm currently in US.
