Ness Technologies Israel, Billing and CRM Project ,
Senior Oracle DBA
Sr. Oracle DBA and Database Architecture expert in a
project dedicated to the design and implementation of a Highway Toll
Collection Billing system, on a 1˝ a terabyte of database on an EMC disk
array. Oracle 9i and 8.1.7. - SUN Solaris system.
Using ERWIN for Logical and Physical database Modeling,
and UML methodology and Use Case design approach using Rational Rose
Unified Process. Physical Database capacity planning and data-files
mapping. Database schemas creation based on the logical models. Oracle
Server software installation and configuration. Implementation of Oracle
Advanced replication environment and mechanism. Multiple Database
environment over multiple platforms. Design and implementation of
backup and recovery strategy using tools, such as Veritas Netbackup and
RMAN. Database and system monitoring tools. SIEBEL CRM package setup
and interface to the billing system. Other duties included: Technical
assistance and guidance to the development group. Performance testing
and tuning, capacity planning, and database monitoring. Strong
knowledge of PL/SQL code optimization, and assistiance to developers
with the writing and tuning of PL/SQL code. Very good experience with
different aspects of database tuning. Responsible for supporting and
managing database activity during the
development cycle. Creating and maintaining the data
model and physical integrity of
Bank Hapoalim, Israel, Data Warehouse Project
Senior TERADATA DBA and Data modeler
TERADATA DBA. For Israel’s largest Commercial Bank. In charge of DBA and
UNIX tasks. Implemented a large-scale Enterprise Data Warehouse system
using NCR Teradata database size of 1 Terabyte on EMC disk array.
Served as a technical expert in developing database designs for Data
Warehouse. Strong Data Modeling experience, . Experience using
modeling tools, logical and physical database design using ERWIN.
Maintaining and updating database models, generating or modifying the
database schemas Data Mapping and DWH loading. Configuration of COGNOS
and SAS metadata and query/data access utilities.
Database backup and recovery strategy, database performance and tuning
and SQL code optimization. Using marketing models to support the
bank’s marketing campaigns. Participated in the process of Installation
and implementation of Campaign Management and Contact management
Oracle Israel, Professional +Tech Support,
Senior Oracle DBA/ Consultant
Oracle DBA and consultant, performing design and support for Data
Warehousing and OLTP projects technical architecture and Database design
tasks utilizing Oracle EXPRESS OLAP technology and Oracle 7.1.4, 8i
of Star schema and multidimensional databases. System monitoring,
troubleshooting and PL/SQL code writing.
installation, and schema generation and development. SQL Loader scripts
and database load tasks. Benchmarks, Preparations and demonstrations
of Oracle technology and related tools, Technical topics coverage at
User-Group conventions. Experience in EXPRESS OLAP and Data Warehousing
database architecture and star schema design.
VISA Israel, Credit Card OLTP System,
For Israel VISA, Database designer and DBA developing a
Client/Server OLTP Credit Card system responding to over 800 concurrent
users and Batch jobs, in an Open VMS cluster.
Using Oracle 7.1.3 environment, from the design phase to
production, resulting in a fault tolerant system with over 1 Terabyte of
Duties included: Database logical Modeling and physical
design, server installation and multiple schema creation and maintenance
on multiple platforms. Support for the application development team.
Database maintenance tasks, backup and recovery.
Building and maintaining multiple databases, database and
system monitoring and capacity planning, analysis troubleshooting and
repair of database objects. Responsible for supporting and managing
database activity during the development cycle
Support for system Data Conversion effort from the Legacy
system. Planning and carrying-out system load and performance and
tuning and hotspot/bottleneck elimination.
Wall St. banks, Citibank, Credit Suisse,
Team Leader. Responsible for planning and development
of money-market banking system, Credit risk analysis. Application and
Database design in a Futures and Options trading system. Interaction
with the users.
Wrote design specs. Development Team management in the
implementation of changes and additional features in the application and
databases. Other duties included: Define requirements, analyze existing
system, find a package, conversion and customization mainly in the
Foreign exchange and precious metals modules.