Avichen Penker Email & Phone Number

Herzliya, Il

Yaqum, Center District, Israel

- Install, build and configure Oracle Databases (11g-21c), - Install and configure Oracle GoldenGate 12c. - Oracle troubleshooting.- Performance tuning.

Herzliyya, Tel Aviv, Israel

- Overseeing IT, cloud, testing infrastructure setup and management for a newly formed cyber security, medical, and deep learning research center by NEC.- Install, build and configure Oracle Databases (12c) on prem, standalone and a Multi-tenant Architecture.- Backup and Recovary using Veem and RMAN.- Install and configure Oracle GoldenGate 12.- Establishing and managing local networking, computing, and storage systems from scratch.- Provide on-prem docker sevises for developers.

Herzliya Area, Israel

- Implementation of Actimize BI integrated solution for the detection of fraudulent activity. - Database Scripting for Oracle 11g/12c and MSSQL 2012/2016. - Install, build and configure Oracle Databases (12c) for standalone and a Multi-tenant Architecture.- Backup and Recovary using RMAN.- Install and configure Oracle GoldenGate 12 for data replication.- Oracle database performance tuning for Production/NFT environments. - Bash scripting for Linux Red Hat environments. - Product installation and repairs, upgrades, database building and maintenance, activity monitoring and DB performance using AWRs, troubleshooting, and high availability solutions. - Designing Unit Tests for the developer's code Black/White Box . - Work in an Agile-based methodology and Production servers.

Tel Aviv

- Write complex ETL into application while checking data for integrity issues and validity.- Install and configure SQL Databases MySQL, MS-SQL, DB2 BLU on Linux and Windows. - Design and implement databases according to Relational, Dimensional, Column base, and DWH modeling.- Build, configure, and maintain virtual environments based on VMware (ESXi) , AWS EC2, IBM SoftLayer - Install configure and write scripts for Linux based CentOS and Ubuntu servers. - Use Docker to deploy non-production environments. - Work in an Agile-based methodology - Scrum, Kanban, Git, Pivotal Tracker/ Jira, Wiki - Led process to become ISO 9001/ISO 27799 certified

Israel, Petah Tikva

- Design and develop data models and reports over the various databases using SQL.- Data Analyst.- Querying MS-SQL 2005, Stored Procedures, Functions, Indexes, Triggers.- Workflow, process automatization.- SQL Server Configuration and maintenance.

Israel, Tel Aviv

- Implementation of payroll systems and Retirement of Malam Team in Clalit health services.- Writing manuals, QA, design, and setting up financial and management reports. - Users training, mapping problems, and understanding the needs and requirements.- Interact with report owners to establish their requirements and develop report specifications.- Proficiency in MS-Office applications, Excel, and MS Project.- Work measurement and Workload measurement.- Querying MS-SQL, Stored procedures, functions, indexes, Triggers.- Workflow, process automatization.

Israel, Raanana

- Design of Client-Server Systems, improvement, and adaptation of existing systems, identification of needs, including the preparation of specification documents to programmers, QA.- Design and develop data models and reports over the various databases using SQL 2005/8.- SSIS, DML, DDL- Databases maintenance.- Project management for the Tidhar website, working with content providers, designers, programmers and etc.- Implementation of new systems and methods for organizing, training employees, writing guides.

Bachelor'S Degree, Industrial And Organizational Psychology, 2005

Activities and Societies: Magna Cum loudIndustrial organizational psychology is the branch of psychology that applies psychological.

Oracle Database 12C & Microsoft Sql Server 2012, Dba

Activities and Societies: Oracle Database 12c & Microsoft SQL Server 2012Introduction to DB &SQL Fundamentals, Querying MSSQL 2012.

Industrial Engineering And Management - Ergonomics

Activities and Societies: Human factors and ergonomics.Introduction to computer science - Java Engineering Programming - C Databases.

Sap Consultant, Sap, Management & Logistic Application Of Sap System

Activities and Societies: Enterprise Resource Planning (ERP) system by SAPMM- Material Management implementation module.