About

Welcome to AuthorityBase - a blog about everything database by David Yahalom.

I’m a Senior Oracle Database Project Manager living my passion.

I have over six years of experience in database & information systems design as a database Consultant and Senior DBA from which three years in managing and directing IT database projects and leading teams in various complex and diverse enterprise-level environments.

One of my more recent projects included  tuning one of the world’s largest telco billing database running on a massively parallel HP Itanium-based Superdome.

My experience includes leading and directing IT projects and teams, designing and supporting critical 24X7 Oracle 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.

While I’m an Oracle person foremost, I also have considerable experience with IBM DB2 LUW, Microsoft SQL Server and MySQL.

My experience includes:

• Over 3 years experience in leading and directing IT projects and teams.
• Over 6 years of experience as a Senior Oracle Consultant and Senior DBA for Enterprise level organizations in a large DSS and OLTP environment.
• Re-designing, tuning an massively overhulling one of the world’s larget massively parallel HP Superdomes running  critical cellular billing applications for one of the largest cellular opreators in the world.
• Designing, managing and supporting critical 24X7 Oracle databases including multi-million user web configurations.
• Writing dozens of short tech tips and media published articles.
• Go-to-guy for pre-sales technical discussions.
• From the ground-up designing , implementing and migrating complex Oracle RAC configurations.
• Planning and implementing Oracle DRP with Oracle DataGuard.
• Hardening Oracle & implementing DB firewalls inc. Sentrigo Hedgehog.
• Implementing NETAPP storage fillers and performance tuning in Oracle RAC and single instance configurations.
• Extensive experience with Oracle RAC over NFS.
• Installing, configuring and proactive monitoring using Oracle Grid Control.
• 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.
• Cross-platform Oracle performance profiling and benchmarking.
• 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.