Resume

Manager Oracle

Location:

Arlington, MA

Posted:

December 27, 2018

Contact this candidate

Resume:

BORIS KATSNELSON

*** **** ******

Newton, MA ****9

Tel.: 617-***-**** – office

617-***-**** - cell

email: ac72cv@r.postjobfree.com

SUMMARY:

Over 20 years of database administration, systems and application development experience. Oracle Database Administration in production, QA and development environments. Development of financial systems and applications software using UNIX, networking, multiprocessing, Java, C++, ORACLE, SYBASE in SUN, AIX, HP, DEC, LINUX and Windows XP/2000 environments.

HARDWARE: SUN, DEC ALPHA, RS-6000, HP, SEQUENT, PC.

SOFTWARE: UNIX, SOLARIS, AIX, LINUX, RAC Installation and Administration, ORACLE Data Warehouses, ORACLE (9i, 10g, and 11g), Intermedia search engine, SQL, PL/SQL, Oracle WEB based applications (Designer 2000, Oracle Application Server, WebDB, JDeveloper); Oracle Applications 11i - General Ledger, Purchasing, Accounts Payable, Accounts Receivable, Assets, and Order Management; SYBASE, DBArtisan, Oracle Enterprise Manager and Oracle Server Manager; Oracle StatsPack; Quest Software products and tools – SharePlex, TOAD, SQL Navigator, Quest Central, Spotlight on Oracle, Space Manager, SQLab Xpert, I/Watch; Erwin and ER/Studio Database Modeling Tools; Java, XML, C++, VC++/MFC, VISUAL CAFÉ, WebSphere, Weblogic, Coldfusion, Windows XP/2000, PowerBuilder, ASSEMBLERS.

EXPERIENCE:

Global Systems Solutions, Inc., Newton, Massachusetts 05/2009 – Present

Senior Oracle DBA

Installed Oracle 11g and 10g database on UNIX, LINUX, and Windows platforms.

Upgraded existing Oracle 9.2i and 10g databases to Oracle 11g.

Created and maintained physical and logical Oracle objects: tables, views, indexes, synonyms, database links, sequences, stored procedures, triggers and packages; enrolled users, created roles, assigned privileges.

Designed backup and recovery strategy for development and production databases

Wrote shell scripts to implement backup and recovery process for both development and production.

Upromise, Inc., Newton, Massachusetts 12/2006 – 04/2009

Senior Oracle DBA

Installed Oracle 10g database on UNIX, LINUX, and Windows platforms.

Upgraded existing Oracle 9.2 databases to Oracle 10g and 11g.

Created and maintained Oracle RAC databases in data warehouse environment.

Designed backup and recovery strategy for development and production databases

Wrote shell scripts to implement backup and recovery process for both development and production.

Performed daily support of production databases.

Secretary of Commonwealth of Massachusetts, Boston, Massachusetts 06/2005 – 11/2006

Senior Oracle DBA

Installed Oracle 10g database on UNIX, LINUX, and Windows platforms.

Upgraded existing Oracle 8.1 and 9.2 databases to Oracle 10g.

Created and maintained Oracle RAC databases.

Performed application level tuning using Quest’s SQLab Xpert to identify offensive SQL statements that could be improved in SQLab Xpert’s Tuning Lab. Also used Oracle’s StatsPack for analyzing and tuning SQL queries.

Monitored and improved database performance using Quest’s Spotlight on Oracle.

Designed backup and recovery strategy for development and production databases

Wrote shell scripts to implement backup and recovery process for both development and production.

Developed shell and perl maintenance scripts for automatic database monitoring.

Performed diagnostics of space-related problems, object sizing, capacity planning, and fast reorganization of full tablespaces, individual objects, and direct repairs of chained rows using Quest’s Space Manager.

Performed daily support of development and production databases

Executive Office of Environmental Affairs, Boston, Massachusetts. 03/2005 – 06/2005

Senior Oracle DBA.

Installed Oracle 10g database on UNIX, LINUX, and Windows platforms.

Migrated existing Oracle 8.1 and 9.2 databases to Oracle 10g.

Created and maintained Oracle standby databases.

Implemented replication of data between databases.

Implemented database fail-over using Data Guard.

Implemented backup and recovery processes using RMAN.

Installed and configured Oracle Enterprise Manager 10g.

Installed and configured Oracle 10g Application Server and Infrastructure Database.

Millennium Pharmaceuticals, Cambridge, Massachusetts. 11/2004 – 02/2005

Senior Oracle DBA.

Provided standard administrative tasks for Oracle 8i and 9i on Solaris platform.

Implemented backup and recovery processes for both development and production environments using RMAN and Veritas Netbackup.

Administered Oracle databases running under VCS (Veritas Cluster Server).

Created and maintained Oracle standby databases.

Fidelity Investments, Merrimack, New Hampshire. 03/2004 – 11/2004

Senior Oracle DBA.

Supported production environment.

Wrote shell scripts to implement backup and recovery process for both development and production.

Developed shell maintenance scripts for automatic database monitoring.

Installed, configured and maintained Quest’s SharePlex for database replication. SharePlex allows synchronization between the source and remote target hosts within just seconds of latency. Log-based replication imposes virtually no overhead on the source database, source system, and network.

Provided day-to-day support for Oracle Financials release 11i applications. Installed and configured General Ledger, Accounts Payable, Accounts Receivable, Assets and Order Management Modules. Upgraded Oracle Applications from 11.5.5 to 11.5.9. Administered Concurrent Managers, used Oracle Application Utilities, such as AD Administration, AutoUpgrade, AutoPatch, AD Controller, AD Configuration.

Performed Oracle 8i to 9i migrations.

Worked with Unix System Administrators on machine configuration and capacity planning.

Massachusetts Department of Revenue, Chelsea, Massachusetts. 11/2003 – 03/2004

Senior Oracle DBA.

Supported production environment.

Wrote shell scripts to implement backup and recovery process for both development and production.

Developed shell maintenance scripts for automatic database monitoring.

John Hancock Financial Services/IBM, Boston, Massachusetts. 03/2003 – 10/2003

Senior Oracle DBA.

Supported 24x7 production environment.

Installed ORACLE 8.1.7 and 9.2 Servers and Clients on Solaris, AIX and Windows 2000.

Designed backup and recovery strategy for development and production databases.

Wrote shell scripts to implement backup and recovery process for both development and production.

Developed shell maintenance scripts for automatic database monitoring.

Managed data using Export/Import and SQL*Loader utilities.

Emplanet, Inc., Westborough, Massachusetts. 04/2002 – 12/2002

Senior Oracle DBA/ Database Developer.

Developed, enhanced and implemented:

packages, stored procedures, triggers, functions (with intense performance tuning)

database logical and physical structures

Unix shell scripts, cron jobs, and batch processes

for 401(k) plan Web based financial applications, using Oracle database.

Developed maintenance procedures, documentation, and provided 24/7 production support for the above applications. All applications were developed using PL/SQL, SQL*Loader in Sun/Solaris and Windows NT.

As an Oracle DBA, supported development, QA, and 24x7 production environments.

Installed ORACLE 8.1.7 and 9i Servers and Clients on Solaris and Windows 2000.

Performed physical and logical design for development and production databases using Erwin; analyzed and allocated tablespaces, managed datafiles and rollback segments.

Designed backup and recovery strategy for development and production databases.

Wrote shell scripts to implement backup and recovery process for both development and production.

Developed shell and perl maintenance scripts for automatic database monitoring.

Performed OS (Unix – Solaris 2.7,2.8) and database level tuning by monitoring database activity and identifying performance bottlenecks using Quest’s Spotlight on Oracle. Adjusted Unix OS parameters, Oracle initialization parameters, rollback segment structure, and optimizer parameters.

Partitioned ORACLE 8i Tables and Indexes to improve performance.

Worked with Unix System Administrators on machine configuration and capacity planning.

Managed data using Export/Import and SQL*Loader utilities.

Ardais, Inc., Lexington, Massachusetts. 08/2001 – 04/2002

Senior ORACLE DBA.

Supported development, QA, and 24x7 production environments.

Installed ORACLE 8.1.6, 8.1.7 and 9i Servers and Clients on Solaris and Windows 2000.

Installed and configured Intermedia search engine for managing text and images.

Performed physical and logical design for development and production databases using Embarcadero’s ER/Studio; analyzed and allocated tablespaces, managed datafiles and rollback segments.

Created and maintained stand-by databases using shell scripts.

Designed backup and recovery strategy for development and production databases.

Wrote shell scripts to implement backup and recovery process for both development and production.

Developed shell and perl maintenance scripts for automatic database monitoring.

Implemented database security audits to monitor database activity, using schema object auditing.

Managed data using Export/Import and SQL*Loader utilities.

Partitioned ORACLE 8i Tables and Indexes to improve performance.

Performed Oracle 8i upgrades.

Worked with Unix System Administrators on machine configuration and capacity planning.

Trained and mentored junior DBAs.

ActiveCyte, Inc., Newton, Massachusetts. 03/2001 – 08/2001

Senior ORACLE DBA.

Supported development, QA, and 24x7 production environments.

Installed ORACLE 8.1.7 Servers and Clients on Solaris and Windows 2000.

Installed and configured Intermedia search engine for managing text and images.

Performed physical and logical design for development and production databases using Embarcadero’s ER/Studio; analyzed and allocated tablespaces, managed datafiles and rollback segments.

Created and maintained stand-by databases using shell scripts.

Designed backup and recovery strategy for development and production databases.

Wrote shell scripts to implement backup and recovery process for both development and production.

Developed shell and perl maintenance scripts for automatic database monitoring.

Managed data using Export/Import and SQL*Loader utilities.

Partitioned ORACLE 8i Tables and Indexes to improve performance.

Worked with Unix System Administrators on machine configuration and capacity planning.

Trained and mentored junior DBAs.

Into Networks, Cambridge, Massachusetts. 03/1999 – 04/2001

Senior ORACLE DBA.

Supported development, QA, and 24x7 production environments.

Installed ORACLE 7.3.4, 8.0.5 and all 8i Servers and Clients on Solaris and Windows NT/2000

Installed, configured and maintained Oracle WEB based applications (Designer 2000, Oracle Application Server, WebDB, JDeveloper)

Performed physical and logical design for development and production databases using Embarcadero’s ER/Studio; analyzed and allocated tablespaces, managed datafiles, rollback segments.

Created and maintained physical and logical Oracle objects: tables, views, indexes, synonyms, database links, sequences, stored procedures, triggers and packages; enrolled users, created roles,

assigned privileges.

Designed backup and recovery strategy for development and production databases.

Wrote shell scripts to implement backup and recovery process for both development and production.

Developed shell and perl maintenance scripts for automatic database monitoring.

Developed and implemented processes, policies and procedures pertaining to the management, security, maintenance, and use of the database management system in a highly available production environment. Developed technical documentation.

Installed, configured and used Quest’s I/Watch to proactively monitor database, network, and operating system activity for abnormal performance characteristics – alerting DBAs of problems by setting numerous alarms, before end users are impacted.

Managed data using Export/Import and SQL*Loader utilities.

Partitioned ORACLE 8i Tables and Indexes to improve performance.

Provided day-to-day support for Oracle Financials release 11 applications. Installed and configured General Ledger, Purchasing, Accounts Payable, Accounts Receivable, Assets and Order Management Modules. Upgraded Oracle Applications to release 11i. Administered Concurrent Managers, used Oracle Application Utilities, such as AD Administration, AutoUpgrade, AutoPatch, AD Controller, AD Configuration.

Performed Oracle 7.3.4 to 8.0.5 and 8i migrations, and Oracle 8i upgrades.

Worked with Unix System Administrators on machine configuration and capacity planning.

Evaluated Oracle-based third-party applications of such companies as Quest Software, Embarcadero Technologies, Platinum Technologies (currently CA), BMC, Tivoli, Precise Software, OnWire Technologies.

Trained and mentored junior DBAs.

Fidelity Investments, Fund Accounting and Custody Services (FACS) Company,

Boston, Massachusetts. 10/1997 – 03/1999

Responsible for development and maintenance of various parts of client-server 3 tier system that collects and distributes pricing data in different currencies, including Euro, for various financial instruments.

Created UNIX-based server modules using embedded SQL in C/Pro-C code for accessing ORACLE database on SUN/Solaris and IBM platforms via TUXEDO interface. Created stored procedures.

Designed application database using ORACLE DBMS.

Developed scripts using C-shell and K-shell (UNIX) for automating file transfers using FTP and TCP/IP; created SQL scripts and generated statistics.

Developed graphical user interfaces for client-server mutual fund transaction systems using POWERBUILDER 5.0.4 for Windows NT 4.0, and Windows 95, interfacing with UNIX server, ORACLE database, and TUXEDO middleware.

Oracle DBA – Joined database administration group and was responsible for managing Oracle Databases

on SUN and IBM.

In addition to regular routine duties (analyzing and allocating tablespaces, managing data-files, enrolling users, creating roles, assigning privileges, creating and managing database objects, loading data and database backup’s), key responsibilities entailed:

Performance tuning, such as memory tuning, disk contention tuning and application tuning;

Working on maintenance scripts for automatic database monitoring.

Global Systems Solutions, Newton, Massachusetts. 06/1994 - 10/1997

Oracle DBA

Installed ORACLE 7.3 Servers on Solaris, created databases, analyzed and allocated tablespaces, managed datafiles, enrolled users, created roles and assigned privileges.

Implemented database security audits.

Created and managed database objects.

Used ORACLE utilities.

Performed database backup and recovery.

Performed application, database, memory and disk contention tuning.

Keystone Group, Inc., Boston, Massachusetts. 11/1993 - 06/1994

Design and implementation of Sales Information System and 12B1 System using Borland 4.0 C++, ORACLE, embedded SQL, stored procedures, POWERBUILDER on DEC ALPHA UNIX and Windows in distributed client-server environment.

Salomon Brothers, Inc., New York, New York. 10/1992 - 11/1993

Design and implementation of Financial Integrated Reporting Environment using C++ and Object-Oriented Design techniques, UNIX, X-Windows/Motif. (C++, embedded SQL, Stored Procedures, SUN/Solaris, SYBASE, TCP/IP, Sockets.)

Design and development of several Trading Systems using C++, X-Windows/Motif/UIMX. C++, Embedded SQL, Stored Procedures, SYBASE in HP/UNIX.

Salomon Brothers, Inc., East Rutherford, New Jersey. 01/1991- 10/1992

Development of general purpose C++ class libraries, graphical user interface using X-Windows/Motif for Fixed Income and Equity Trade Systems using C++, Embedded SQL, Stored Procedures, SYBASE.

AT&T Bell Laboratories, Holmdel, New Jersey. 01/1988 - 01/1991

Development of X-Window based graphical user interface to Factory System Test Software for communication project using C, Embedded SQL, Stored Procedures, and INFORMIX.

AT&T Bell Laboratories, North Andover, Massachusetts. 09/1981 - 12/1987

Operating system modification, diagnostics development. Integration of OS, diagnostics and application software. (C/UNIX).

EDUCATION

ORACLE EDUCATION. Oracle Database 10g Performance Tuning, December 2008.

ORACLE10g: RAC for Administrators Release 2, November 2007.

ORACLE8i: Performance Tuning Workshop, February 2000.

ORACLE8i: New features for Database Administrators, July 1999.

Planning for ORACLE8i: Advanced Components, July 1999.

Planning for ORACLE8i: Basic Components, July 1999. ORACLE8: Backup & Recovery Workshop, April 1999.

ORACLE8: Network Administration, April 1999.

ORACLE8: Database Administration, March 1999.

AT&T Bell Laboratories, North Andover, Massachusetts.

Advanced courses in UNIX Internals, Shell, BX.25, Data Link Protocols.

M.S. in Applied Mathematics, Minsk University, Minsk, Belarus.

M.S. in Electrical Engineering, Transportation Institute, Moscow, Russia.

Contact this candidate