Leonid Kurtser

*** ******* ****,

Thornhill, ON L4J 8S8 ac4dy9@r.postjobfree.com

CANADA 647-***-****

OBJECTIVE

A position as DBA/Developer/Integrator BigData (Hadoop/GreenPlum) for complex Production and Non-Production environments.

SUMMARY OF QUALIFICATIONS

●Over 17 years of experience working for international companies in variety of industries including financial, telecommunications, insurance, health.

●Oracle DBA/Developer/Data Integrator - responsibilities on physical/logical databases/DataMart for Data Warehouse (VLDB) and OLTP environments.

●Experienced in relational DB supporting, implementation, installation, upgrading, performance/tuning, audit/security, backup/restore - RMAN, RAC, migrations, Data Guard, GoldenGate, ASM, advising developers for database topics.

●Manage Databases on the Cloud KVM- OpenNebula.

●Integration/Management/Architecture BigData – Hadoop (Hive, PIG, SQOOP, OOZIE).

●Experienced work with UNIX, Linux (RedHat, CentOS, Ubuntu) Window same on VMware or Hyper-V, Cloud.

●Integration between RDBMS (Oracle (Oracle DB and Exadata), MariaDB, Postgres, GreenPlum) and NoSQL(Hadoop)).

●Outstanding logical & problem resolve skills.

Databases: Oracle – 7.3.4, 8.0, 8i, 9i, 10g, 11g, MSSQL Server 2000/2005/2008, GreenPlum, Postgres, MariaDB, Hadoop (Hive).

Tool Sets: Snaplogic ETL (management, development), Quest - (Spootlite, TOAD, Navigator); Oracle - RMAN, Fail Safe, OEM, Grid Control, SQL Developer, Jdeveloper, Statpack, Precise -Tools set; SQL Server-EM/DTS, PLSQL Developer.

Languages: Hadoop (Hive, Pig), Unix Shell (KSH, CSH, TCSH), C, Pro*C, SQL, PL/SQL (include ETL process programming), Python, AWK, SED, HTML, JSP.

O/S: UNIX - (Sun Solaris, AIX, HP), Linux, Windows - XP/7/2000/2003/2008.

ERP: Oracle 11.5.9 – 11.5.10

EDUCATION

2006 MSM (Degree Master of Science) - Information Management, University Polytechnic, USA.

2006 Oracle 9i/10g Performance and Tuning Course, John Bryce, Israel

1999 B.Sc., Statistics and Computer Science, Bar Ilan University, Israel

2002 Administration SQL Server 2000 Database, John Bryce, Israel

2001 Oracle 8i Performance and Tuning Course, Oracle, USA

1999 Oracle 8.x Database Administration Course, John Bryce, Israel

EXPERIENCE

Feb-2012 –Dec 2017 BLACKBERRY (CANADA) DBA/Developer/Big Data Integrator

Role included:

Support VLDB/OLDB Databases from 1Tb to 50 Tb.

Space estimation and calculation, application installation, performance/memory tuning, server/database monitoring, configuration, and troubleshooting. Provided design input and interacted with the design team on the best database practices. Evaluated server/instance architecture, hardware, system specifications, and capacity planning. Managed, trained, and mentored staff.

Resolve performance related issues for reports and SQL queries.

Provide on-call support for enterprise databases.

●Work with Oracle ASM/DataGuard/RMAN/GoldenGate on Production and Reporting servers.

●Application support 100Tb data on Oracle Exadata.

●Integration BigData – Oracle/Postgres/MariaDB and Hadoop (SQOOP/PIG/HIVE).

●Support BigData - GreenPlum Appliance - Administrator/Developer/Integration – 2Tb daily load, 35TB data on each of 3 appliance AP/NA/EU.

●Support/Administration ETL – Snaplogic environment on Local Cloud.

●Implementation new patches and remediation of database/system vulnerabilities.

●Have experience in the market latest systems virtualization and cloud technologies (KVM, OpenNebula, VMware).

Aug-2010 – Feb-2012 ZYLOG SYSTEMS (CANADA) LTD Oracle DBA and Developer

Role included:

●Supporting Oracle DB 10G (include RAC on Linux (RedHat)) environment of company (Production, UAT, Development, QA, DR

●Performing backup/restore strategies (RMAN)

●Creating utilities for monitoring Oracle DB.

●Development new stored procedures, triggers, reports for Client/product needs.

●Create Report using Microsoft SSRS 2008 (Report Services).

●Creation/Supporting DR - Data Guard 10G

●Support Oracle RAC (10G) on Production/UAT/QA environments.

2007 – 2010 HP/EDS (Israel) Oracle Database Administrator

Client – Tnuva (largest dairy products manufacturer in Israel)

Role included:

●Supporting production Oracle DB servers (Over 60 Instances), supporting and managing Corporate Data Warehouse (more 2 Terabytes size) with VERITAS Cluster and compress data for minimize storage capacity.

●Support 60 environments - MSSQL Server 2000/2005/2008.

●Performing backup/restore strategies (RMAN) and upgrades to new Oracle versions.

●Implementation and integration of new solutions including: Standby DB (8i), Data Guard(9i,10g,11g) used for redundancy and DRP solution, backup strategy, creating test environment, reporting and monitoring data with range time windows for data access.

●Installation and administration Grid Control, creating utilities for monitoring Oracle DB (performance/logging) and Hardware.

●Auditing of sensitive data bases (HR, finance, and billing.), day by day monitoring procedures and creating alert scripts. Managing DB privileges and user access policies.

●Supporting RAC on Linux (RedHat) for Oracle ERP environment (Oracle 10g) for High availability and load balancing.

2006 - 2007 US-Cellular (Chicago, USA)

Oracle Database Consultant for Amdocs billing system

●Provided Automation work via scripting and other programming languages for Flat Environment and Full Environment creation related to Oracle within AMDOCS Ensemble.

●Developed a knowledge base of all design, implementation solutions, and processes.

●Defined the architectural and environmental standards around configurations, directory structure and application integration points (environmental variables, PATHS, etc). Administration and troubleshooting tips and process/steps for the oracle database components of AMDOCS Ensemble.

2003 – 2006 Advantech Inc.(Israel) Oracle DBA/Oracle Application DBA (ERP)

●Clients (Cellcom – Cellular Telco Company, Pelephone – Cellular Telco Company, ECTEL, Motorola, E4x, Government, First international Bank

●Implementation and integration of new solutions: DataGuard, reconfiguration exists Oracle DB, Oracle database – VLDB (data warehouse 20Tb RAC environment) Systems and Data Architecture, logical DB modeling, physical DB modeling, reporting tool architecture design.

●For ERP (11.5.9 – 11.5.10), was responsible for the upgrade, installation, support, configuration and implementation.

1998 - 2003 Amdocs Inc (Israel-USA) Oracle DBA/Application DBA

●Clients Western Wireless - Cellular Telco Company (Relocation).

●Creating, Designed, implementation, and maintained complex custom databases that held client data, billing data, and project information.

●Managing stored procedures, performance analysis using Statspack, SQL tracing and tuning SQL code. Proactively monitoring use tools and SQL scripts for statistics, analyzing and resolving problems within the database and O/S.

●Supporting development, testing (UAT), training and production environments.

●Troubleshooting related to DB & Application & handling the user problem.

●Providing 24x7 technical support (via hotline) Providing capacity management solutions.

Contact this candidate