*

Ihor Kalitynskyi

Address: **** ***** ** *, ************, FL, 32246 Tel: 904-***-**** Email: ac1tsi@r.postjobfree.com OBJECTIVE:

Seeking a career in Oracle Database Administration to leverage a company’s investment as well as provide an opportunity for advancement.

PROFESSIONAL SUMMARY:

Have eighteen years of Information Technology experience.

A self-motivated, responsible and reliable team player with a set of strong technical skills.

Have experience in solving problems of diverse scope where technical analysis and evaluation is required.

Oracle Database software installation / clone / patch / upgrade to development, test and production servers.

Expertise in the creation of databases, tablespaces, tables, indexes and other database objects.

Excellent in the use of the import and SQL Loader utilities to load data and performing exports as

supplemental to daily cold, hot RMAN backups to be used for database restore and recovery.

Modify database structures as required by developers due to business or application requirements, clone

development databases for testing and training.

Develop capacity and performance metrics as well as maintain, analyze, and report on a scheduled

periodic basis to management on development progress.

Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments.

Proficient in SQL Tuning in an Oracle Environment.

Knowledge and experience of Real Application Cluster (RAC), ASM, OCFS and Data Guard. TECHNICAL SKILLS:

SQL Plus, PL/SQL

Linux (Red Hat, OEL, SuSe), AIX, Solaris, Windows O/S skills (shell scripting, user management,

packages management, storage subsystem)

Oracle 7/8i/9i/10g/11g/12c, ASM, OCFS, RAC, Data Guard

Oracle Enterprise Manager 10g, Grid Control 11g, Cloud Control 12c, Cloud Control 13c

Oracle Transparent Gateway, Oracle LDAP, Oracle Certificate Authority

SQL Navigator, Toad, SQL Developer, RMAN, exp/imp, datapump, SQL Loader, tkprof, Log Miner

AWR, ASH, statspack, baselines, profiles

Administration of multiple instances of Oracle databases supported on the LINUX, UNIX and Windows environments.

Installation of Oracle patches, performing backup and recovery procedures.

Implementation and / maintenance of user security. ADDITIONAL SKILLS:

Strong work ethics, good attention to detail, excellent team player, great communication skills and ability to learn in a fast paced environment

2

PROFESSIONAL EXPERIENCE:

BNP Paribas Group – UkrSibbank, Kyiv, Ukraine, http://bnpparibas.ua 08/2010 to 07/2017 Senior Oracle DBA

Manage and support the 150+ Oracle Databases.

Install and patches Oracle software; create or clone the Oracle Instance/Databases on ASM.

Managing and reorganization tablespaces, data files, redo logs, tables, indexes and its segments.

Managing Users, Privileges and Roles.

Upgrading the Databases from lower version to higher version (10=>11, 11=>12).

Supporting very large Oracle databases (VLDB, > 30 Tb).

Implementing High Availability solution using RAC and Data Guard.

Configuring backup for databases and restoring databases using RMAN and IBM TSM.

Performance tuning database problems faced by application developers/users with utilities like AWR, ADDM and TKPROF.

Monitoring and optimizing databases using Grid Control 12c (Cloud Control 13c).

Upgrading Enterprise Manager from lower to higher version (10g=>11g=>12c=>13c).

Migrating Oracle databases from AIX to Linux environment using data pump.

Upgrading Oracle Grid Infrastructure from 11g to 12c.

Contacting Oracle support for technical questions and resolving problems. Brig-Retail, Kyiv, Ukraine, http://www.brigretail.com 11/2009 to 08/2010 Senior Oracle DBA Consultant

Support the 50+ Oracle production and development Databases on client side (UkrSibbank).

Installed and tested new version of Oracle Databases and patches.

Upgrading Oracle Databases from lower to higher version (9=>10, 10=>11).

Performed backups, restores, cloning or refreshing databases.

Installed Data Guard standby databases and performed disaster recovery testing.

Tuning heavy database loads.

Kviza-Trade, Kyiv, Ukraine, http://kishenya.ua 08/2006 to 11/2009 Senior Oracle DBA

Manage the 10+ Oracle Databases.

Supported Oracle RAC Databases and Data Guard.

Migrating Oracle Databases from Windows to AIX environment using export/import.

Upgrading Oracle Databases from lower to higher version (9=>10).

Performed backups and restores using RMAN and IBM TSM, cloning or refreshing databases.

Reorganized databases and sized database objects to meet standards and improve performance.

Tuning heavy database loads using Oracle Enterprise Manager 10g.

Installed and configured Oracle Gateway for connection to other databases. Institute of System Technology, Kyiv, Ukraine, 12/2002 to 08/2006 Senior Oracle DBA & Developer

Support the 27+ Oracle 9i Databases on Windows and Linux environment.

Backup and recovery; load / unload data; cloning databases.

Creating forms and reports (jsp, plsql, AsBase, Crystal Reports). State Tax Administration of Ukraine, Kyiv, Ukraine, http://sfs.gov.ua 07/2001 to 12/2002 Oracle DBA

3

Manage Oracle 7/8i/9i Databases and Oracle Express Server (OLAP).

Install, patch and upgrade Oracle Software and RDBMS.

Backup/recovery, export/import, load/unload data.

Developing forms and reports (asp, html, plsql). Academy of the State Tax Service of Ukraine, Irpin, Ukraine, http://asta.edu.ua 05/2000 to 07/2001 System/database Administrator

Support Oracle 8i Databases, Windows AD, mail, web, ftp, networks.

Backup/recovery, manage user account, install software. Forest Building ltd., Kyiv, Ukraine, 09/1999 to 05/2000 System Administrator

Manage Windows AD, user account and access, networks. EDUCATION:

Specialist’s (Master) Degree, Automated Control of Technological Processes National Technical University of Ukraine ‘Igor Sikorsky Kyiv Polytechnic Institute’. 07/2001

Bachelor’s Degree, Automation and Computer-Integrated Technologies National Technical University of Ukraine ‘Igor Sikorsky Kyiv Polytechnic Institute’. 03/2000

KEY TRAININGS AND CERTIFICATIONS:

Oracle Database 8i Administration - 2001

Administering a Microsoft SQL Server 2000 Database - 2004

AIX 5L Jumpstart for UNIX Professionals AW18/11070 IBM - 2007

IBM DB2 UDB Administration - 2008

IBM Information Server Administration - 2010

Introduction to the Teradata Database 25964 - 2011

Teradata Warehouse Administration 25970 - 2011

Oracle Database Security - 2012

Oracle Database 11g: Administration Workshop II - 2014

Oracle Database 11g: Performance Tuning DBA - 2014

Oracle Database 12c: New Features for Administrators - 2016

Oracle Database 11g Certified Implementation Specialist - 2014

Oracle General Product Support Specialist - 2015

Oracle Database 12c Certified Implementation Specialist - 2015

Contact this candidate