Ofer Shalom

Ofer Shalom Email and Phone Number

Senior Database Engineer and DBA @ Autism Learning Partners
Los Angeles, CA, US
Ofer Shalom's Location
Los Angeles, California, United States, United States
Ofer Shalom's Contact Details
About Ofer Shalom

I am an experienced senior database engineer who is a strategic thinker that thrives on challenges, takes action, and delivers innovative modern data architectural solutions. Proven ability to identify issues and proactively develop proper resolutions to improve systems quality, performance, and customer experience.KEY SKILLS Compression & Transformation Conversion & Integration  Batch Processing  Importing Systems  SQL Server PostgresSQL  My SQL  Talend Cloud  .Net SaaS Enterprise Data Amazon Relational Database Service Database Monitoring & Application Support  Performance Optimization Disaster Recovery Data Partitioning AlwaysOn, Replication & MirroringTECHNICAL SKILLS Microsoft SQL Servers MS Access Windows NT SharePoint Performance Monitoring LiteSpeed for SQL Backup Utility SQL Profiler  PostgresSQL C#.net  Visual Basic.net  PowerShell Business Intelligent Development Studio Visio 2000 My SQL  C++ VB Script  Java Script Python MS Transaction Server ER/Studio Red Gate Visual Studio MS Source Safe  Active X  IIS  VBScripts  HTML XML ERD Informatica MS Project

Ofer Shalom's Current Company Details
Autism Learning Partners

Autism Learning Partners

View
Senior Database Engineer and DBA
Los Angeles, CA, US
Website:
autismlearningpartners.com
Employees:
1941
Ofer Shalom Work Experience Details
  • Autism Learning Partners
    Senior Database Engineer And Dba
    Autism Learning Partners
    Los Angeles, Ca, Us
    View
  • Autism Learning Partners
    Senior Database Engineer/Dba
    Autism Learning Partners 2020 - Present
    Monrovia, California, Us
     Architected and created data warehouse, collaborated with business groups in determining business requirements, and facilitated the computation of risk weight and segmentation for stress testing and back testing as part of Basel II Accord. Performed requirements analysis, worked closely with business analysts to get functional requirements, interacted with end users to determine reporting needs, and conducted discussions with project team to identify additional requirements. Migrated data from third party servers (CentralReach) into data warehouse using SQL Server Integration Services (SSIS). Created SQL Server Reporting Services (SSRS) and Power BI reports. Developed an alert system, which includes email and text messages based on severity, to ensure ETL Jobs/Reports Subscriptions are running without any problems and data is available to users in real-time.
    View
  • Data Analysis Incorporated
    Senior Database Engineer/Dba
    Data Analysis Incorporated 2018 - 2020
    Los Angeles, California, Us
     Created archive and deletion process that moved data to archive server and deletes it from production, thereby shrinking databases from 4 TB to 200 GB. Developed data collection from over 200 servers that identify long running queries using extended events. Migrated from an on-premises Microsoft SQL Server database to Amazon Relational Database Service (Amazon RDS) for Microsoft SQL Server. Spearheaded project that required high availability, faster data access, large storage of unstructured data, and horizontal scaling using MongoDB. Converted .NET application to Python and MSSQL to PostgreSQL. Created high-performance execution of 2017 SSIS packages by distributing package executions across multiple computers that included master servers and multiple worker servers, which run multiple package parallel executions. Delivered High Availability/Disaster Recovery (HADR) solutions; Failover Clusters and AlwaysOn Availability Groups, Replication, Log Shipping, and Mirroring.
    View
  • Blackline
    Senior Database Engineer
    Blackline 2016 - 2018
    Woodland Hills, Ca, Us
     Developed various custom complex ETL processes using SSIS packages looping through over 2,000 client databases on different servers using Dynamic Connections.  Designed and developed a full-scale reporting solution for a multi-client environment using SSRS. Type of reports created: Parameterized, Linked, Snapshot, Ad hoc, Clickthrough, Drilldown, Drillthrough, Subreports, and Chart reports. Utilized SSIS script task using C# and VB script to create complex logic. Created PowerShell script to deploy packages to source control and also utilized it to customize build process. Built migration script, which included detailed reports and backups that moved objects plus data between environments, thereby allowing them not to be on the same server.
    View
  • American Legal & Financial Network
    Lead Database Engineer/Administration
    American Legal & Financial Network "Alfn" 2014 - 2016
    St. Louis, Mo, Us
     Managed a team of 3 DBA/DBE, and developed SaaS cloud solution database to support multiple clients, including moving from physical server to AWS. Automated processes to make conversions of different systems such as, Juralaw, CompuLaw, MA3000, DM2000, Elite, Rainmaker, ProLaw to American Legal Net eDocket software smooth and accurate. Implemented complex logic to create event data loads originating from various courts, and migrated reporting module from .NET report viewer to SSRS reporting by utilizing Report Builder. Constructed SharePoint websites and customized websites based on customer’s needs while ensuring projects were completed in a timely manner and under budget.
    View
  • Lender Processing Services, Inc. (Lps)
    Database Engineer
    Lender Processing Services, Inc. (Lps) 2012 - 2014
    Jacksonville, Fl, Us
     Designed, developed, and implemented a big data warehouse from scratch using Microsoft SQL Server 2012. Developed SSIS packages, store procedures, configuration files, tables, views, and functions while implementing best practices to maintain optimal performance.  Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 & 2 changes.  Created a system for capturing, reporting, and correcting error data. Developed reports with updating statistics for business and ended users using Report Builder.
    View
  • Interthinx
    Database Engineer/Administrator
    Interthinx 2004 - 2011
    Agoura Hills, Ca, Us
     Led the database engineering team, implemented new enhancement for customers, and ensured security measures are in place and reviewed. Developed, designed, and implemented a new database while adhering to federal & state security regulations that required the protection of financial and personally identifiable data by encrypting drive, tables, indexes, and views. Collaborated with developers on technical issues, database design, and system analysis in a highly technical and fast paced environment. Analyzed performance issues to determine best solutions to increase performance, server configuration changes or index/query changes. Populated over 400 million records into new tables and automated data loads using SSIS packages. Published over 300 SSRS reports, performed ad hoc data analysis and reporting.
    View

Ofer Shalom Skills

Microsoft Sql Server Agile Methodologies Tfs T Sql Wcf Sql Iis Xml Sdlc Asp.net Asp.net Mvc C# .net Visual Studio Web Services Linq Ssrs Database Design Requirements Analysis

Ofer Shalom Education Details

  • Los Angeles Valley College
    Los Angeles Valley College
    .Net & Visual Basic Programming
  • Santa Monica College
    Santa Monica College
    C# & .Net Programming
  • Learning Tree University
    Learning Tree University
    C#
  • Santa Monica College
    Santa Monica College
    Structured Query Language (Sql)

Frequently Asked Questions about Ofer Shalom

What company does Ofer Shalom work for?

Ofer Shalom works for Autism Learning Partners

What is Ofer Shalom's role at the current company?

Ofer Shalom's current role is Senior Database Engineer and DBA.

What is Ofer Shalom's email address?

Ofer Shalom's email address is of****@****ine.com

What schools did Ofer Shalom attend?

Ofer Shalom attended Los Angeles Valley College, Santa Monica College, Learning Tree University, Santa Monica College.

What skills is Ofer Shalom known for?

Ofer Shalom has skills like Microsoft Sql Server, Agile Methodologies, Tfs, T Sql, Wcf, Sql, Iis, Xml, Sdlc, Asp.net, Asp.net Mvc, C#.

Who are Ofer Shalom's colleagues?

Ofer Shalom's colleagues are Korea Tyler, Rebecca Beers, Ruben Martin, Chanelle Williams, Megan Sawa, Jazmine De La Rosa, Justine Jue.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.