About

Welcome to DavidYahalom.com - a blog about everything database. I’m a lead architect and Senior Database Project Manager living my passion.

My experience includes leading and directing IT projects and teams, providing end-to-end infrastructure solutions (network, storage, software, database, systems,etc), designing sophisticated architectures, designing and supporting critical 24X7 Oracle and MySQL systems, planning and implementing complex RAC & DRP solutions, extensive architecture-wide, instance level and statement level performance tuning (including one of the world’s largest realtime cellular billing databases), securing and hardening Oracle databases, MSSQL and Linux systems, implementing database firewalls, designing storage, growth and backup strategies, scripting in several languages, building BI frameworks using Business Objects and Cognos and supporting large development teams for schema modeling and PL/SQL code design.
My experience includes:

• Over 7 years of experience as a Senior Oracle Consultant and Senior DBA for Enterprise level organizations in a veraity of large DSS and OLTP environment.
• Over 4 years experience in leading and directing IT projects and teams.
• Over 4 years experience in leading infrastructure design projects and arcitactures.
• CTO of a large database oriented organization. Directing IT in terms of short and long term technological strategy, infrastructure design, vendor choice and partnership, product selection, creating internal technological procedures and managing customer satisfaction levels.
• Re-architecture, overhauling and tuning one of the world’s largest cellular billing databases running on a massively parallel Itanium-based HP Superdome.
• Leading complex and diverse database infrastructure design projects and writing detailed design documents.
• Leading and implementing migration from single instance databases to complex Oracle RAC + DataGuard configurations.
• Extensive experience in designing VMWARE ESX-based database virtualization architectures and projects.
• Researching MPP database solutions such as Hadoop and Greenplum.
• Designing complex MySQL implementations and complete MySQL-based architectures for critical 24X7 operations including DRP and scale-out replication, backup and recovery strategies and performance scaling.
• Designing, managing and supporting critical 24X7 Oracle databases including multi-million user web configurations.
• Experience in Oracle-Kerberos integration for Oracle externally identified users with Microsoft Active Directory.
• Leading Oracle Security projects including: DB Hardening, TDE, Oracle Database Vault, Sentrigo Database Firewall, strong authentication, externally identified users.
• Leading large scale Oracle Grid Control deployments for proactive monitoring of enterprise organizations.
• Cross-platform Oracle performance benchmarking and datacenter migration.
• Writing Custom Grid Control plugins.
• Writing dozens of short tech tips and media published articles.
• Go-to-guy for pre-sales technical discussions.
• Experience with Oracle Advanced Replication.
• Designing Oracle storage frameworks using NetAPP and ASM.
• Writing Custom Grid Control plugins via the extensibility framework.
• From the ground-up designing , implementing and migrating complex Oracle RAC configurations.
• Planning and implementing Oracle DRP with Oracle DataGuard.
• Implementing NETAPP storage fillers and performance tuning in Oracle RAC and single instance configurations.
• Extensive experience with Oracle RAC over NFS.
• Designing and implementing Oracle backup strategies, RMAN scripting and storage snapshots.
• Extensive experience in Linux (RHEL) and UNIX environments.
• Technologies Presenter at IOUG (Israeli Oracle Users Group) & Instructor at John Bryce training.
• Providing performance tuning advice, schema design and modeling and PL/SQL design for various development teams.
• Designing and supporting an ETL data consolidation process from several legacy systems to a central open database.
• Providing ongoing long term database support, tuning and schema design consulting for a large development team.
• Extensive Instance and SQL tunning in VLDB OLTP environments.
• Lead DBA of a VLDB DB2 LUW financial project.
• Designing and modeling Business Objects universes in an HR environment.
• Designing, implementing and supporting a complex ETL process from a legacy IBM MF to an open Oracle database.
• Writing and maintaining PL/SQL stored procedures.
• Writing VB front ends to PL/SQL database logic.
• Writing Perl scripts.
• Leading an ERP project.

You are invited to view my complete profile using LinkedIn.