Oracle Sql Server

Nikolay Yevtushenko

*** ***** ****** ******* *****, Wildwood, MO, 63021

Cell: 636-***-****

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

PROFESSIONAL SUMMARY

** ***** ***** ********** ** IT.

•

9+ years’ experience working with Oracle, UNIX, and Windows Server.

•

9 years experience in IT for the administration, maintenance, and monitoring of high availability at Amdocs with

•

products for leading cellular companies around the world.

TECHNICAL SKILLS

Hardware HP, SUN, AIX, Linux, Windows Workstation, VMware

•

Operating Systems Windows 95/98/2000/ME/XP/Vista/NT/Windows 7/8, UNIX, Linux

•

Programming Languages C, C++, SQL, PL/SQL, Turbo Pascal, VB6, SAX Basic, LISP.

•

Databases Oracle 9i,10g,11g with SQL*PLUS, iSQL*PLUS, MS ODBC, SQL Server

•

7/2000-2012

Development Tools MS Visual Studio, BPEL, Oracle 9i Designer, AutoCAD, Visio, TOAD

•

(SQL Tool), PL/SQL Developer.

DB Management Tools Embarcadero DB Monitor, Oracle Enterprise Manager (OEM).

•

General Software TOAD (SQL Tool), PL/SQL Developer, SQL Developer, MS Office

•

Communications: FTP, SCP

•

EDUCATION

2004-2005 Graduated MASTER DBA in Oracle 9i, at John Bryce

2005 Correspondence course “Oracle 9i DS”

1998 Database Management course at Odessa State Academy, Ukraine

1993-1998 Master Degree in Computerized Control Systems from Odessa State Academy

LIST OF COURSES TAKEN AT AMDOCS

Oracle 9i SQL Tuning

UNIX ksh scripts & software tools

Linux Programming

Oracle 9i Designer

Oracle 11g at RedHat 6

Oracle 11g RAC

Oracle 11g Golden Gate

WORK EXPERIENCE

08/2010-Present Amdocs Inc., USA, Saint Louis

10/2006-08/2010 Amdocs Inc., Israel, Raanana

Production Sr.DBA Oracle

ADBA and PDBA support for the following products: Ordering (OMS), Billing (Enabler), CRM, RPL,

•

Cramer, Ensemble, AMSS, ACS, TLG, ELLA etc.

Support for clients such as ATT, Rogers, Telstra, Mobilcom, ClearWire, Vonage etc.

•

Working with Amdocs tools: TIGER, Scout, Genesis, DB Extract, CIA, Validation Tool

•

Database Security - Created administrator accounts with required roles. Maintained all necessary

•

security paperwork for these operational accounts.

Documentation - Provided documentation on new and existing procedures for Oracle operational

•

environments.

High Availability - Responsible for the continued availability of all supported Oracle products.

•

ERD creation for all Amdocs products.

•

Monitor space alerts, warnings/critical errors.

•

Release Management – Coordination of changes between business team and DBA, application of scripts,

•

upgrading applications, review logs for errors, work with developers to clean up errors.

Ensure database availability, reliability, security, and connectivity

•

Monitor health (table space size, error logs, queue logs, etc) of single node and RAC Systems

•

Track/Analyze database performance against the metrics using AWR/STATSPACK

•

Rebuild indexes, tables, purge procedures.

•

Restore/Backup - Recover individual tables exp/imp and expdp/impdp or entire database as necessary

•

(COLD/HOT Backup)

Build test environments from correct baseline applying software releases and supporting testers with

•

problems found during SIT testing using scripts, exp/imp, expdp/impdp.

Performance issues – work with application teams to identify and fix culprit.

•

Reporting - Generated reports related to replication queues, replication connections, processes and

•

database free space. Received daily reports regarding overall system health and latency.

Scripting - Responsible for the creation and maintenance of new internal tools. Tools primarily consisted

•

of Shell scripts that interacted with the UNIX OS and Oracle databases. These scripts utilized multiple

tools that included grep, sed, perl and awk. The level 2 operational DBAs use these tools as the primary

means of monitoring roughly 200+ DBs worldwide.

SQL Programming - Created database objects (tables, views and stored procedures) to increase the

•

productivity of the operational DBAs. Procedures ranged from those that check user accounts to those

that run SQL across multiple servers. Generated PL/SQL queries that provide important information to

the administrator.

Support - Provided phone support for customer, after hours to support long running processes. Traveled

•

to the site when necessary to assist the on shift administrator.

Training - Responsible for the training of all new employees using SOP up-to-date.

•

ETL and data mapping/customization with special request.

•

Customized environments creation with specific product’ structure and data in RAC and single DBs.

•

Created and maintained additional testing environments as requested and needed by applications

•

development

Created and maintained a “data copy” utility that was used to copy data from production to test for

•

problem replication and testing.

Provide on-call support for 24 X 7 operations

•

Utilized BMC Remedy ticketing program to track work on various issues.

•

Utilized various logs to document work completed at our level.

•

Shared responsibility of shift work with other DBAs. Personnel were staffed 24x7x365.

•

Participated in the migration of servers to new hardware that included the upgrade of our applications.

•

Disaster recovery training

•

Participated in projects and tasks for transfer Oracle DB to SQL Server.

•

LANGUAGES: SQL, PL/SQL, UNIX Shells

ENVIRONMENT: HP-UNIX, AIX-UNIX, SUN/SOLARIS, Linux, Windows NT 4.0, ORACLE

2005-2006 Veracity, Israel

DBA Oracle and SQL

DBA Oracle & SQL Server and DBA advisor at “Veracity”

•

Application projects on PL/SQL for cellular companies.

•

Creation and support for RAC DBs (Oracle 9i/10g)

•

Responsible for maintaining backups of the databases Oracle 10g (RMAN, hot and cold backups).

•

VBA programmer.

•

Oracle installation on Windows and UNIX platforms (Linux – RedHat, CentOS)

•

VMware installation and preparation for training classes for Oracle products on VM Linux machines

•

Acronis backups/images for training classes

•

2004-2005 Freelancer

DB Support

Have completed projects involving creating, supporting and administering Databases.

•

Data Base and SQL Statement Tuning, Backup and Data Recovery.

•

Installation of all MS Windows versions, MS office, backup programs

•

Projects on MS Access.

•

LANGUAGES: Visual Basic 6

ENVIRONMENT: Windows XP, Oracle, SQL Server, MS Access.

2003-2005 CodeCode Technologies, Israel

Technician

Help Desk and Technical support at CodeCode Technologies.

•

Thermal Transfer Printer Technician.

•

1997-2000 Internal Revenue

Programmer

Programmer at Internal Revenue, Ukraine.

•

Languages FoxPro, Clipper and C++.

•

Environment: MS Access, Excel, Word with Windows 98.

•

Languages: English, Hebrew, Russian, Ukrainian.

Italian, French and German on basic level.

Contact this candidate