Aaron Shilo
Chief Database Architect
  • Israel
Member Since: 2004/10/18
Industry: Computer & IT
Tech Certifications:
CERTIFIED EXPERT

Provide a quick, creative biography in 140 characters or less.

More bio
Activity
Points this month25
Total points513,633
Questions: 2
Solutions: 378
Articles: 1
Videos:
Tutorials:
Posts:
Professional Background
Chief Database Architect
Almog Software Industry
February 2013 – Present
Database Consultant
Tapuz / Bezeq Int / Nipendo / IBS / Pontis and more ...
March 2010 – Present
Main Duties and Responsibilities:
• Uses SqlServer / Oracle database architecture knowledge to provide database expertise in the design, implementation and integrations of multi-tiered applications residing on relational database management systems (RDBMS). This includes database and table design and creation, stored procedures, triggers and query design and optimization.
• Structured analysis, design, coding, implementation and support for SqlServer / Oracle in house applications.
• Responsible for application testing and support, version control, object management, code and design review, production staging and implementation planning, overseeing development efforts, support and training.
• Performs capacity planning, performance monitoring and tuning, backup/recovery techniques, and problem determination and resolution.
• Create, maintain and refresh required SqlServer / Oracle instances/databases for development, test and production environments.
• Plan, document, coordinate and implement complex vendor upgrades to SqlServer / Oracle applications while protecting integrity of the production environment.
• Establishes physical database parameters, calculates optimum values for database parameters such as amount of computer memory to be used by database.
• Specifies user access levels and identifies which users can access databases and what data can be accessed by them.
• Undertakes complex tasks of analyzing system problems, reviews data, functional requests and production problems and prepares specifications for its solution.
• Produces and maintains documentation and ensures quality assurance objectives are met.
• Provide expert assistance in setting up instances, tablespaces, tables and views.
• Develops and maintains database programming standards and naming conventions to ensure consistency.
CEO & Owner
DBCS LTD
January 2009 – Present
CTO Microsoft Sql Server Technologies/Trainer
John Bryce , Oracle University
2001 – 2008
At johnbryce training I was a trainer consultant and developed to become the CTO.
i gained a lot of experience as a trainer covering topics as simple as BESIC SQL and to advance as PERFORMANCE TUNING AND HIGH AVAILABILITY.
More
Education
John bryce
oca/ocp/mcp/mcts
Databases
2001 – 2009
More
Full Biography

Over 14 years experience as an Database Administrator, and Project Manager in a wide variety of business applications. Particularly interested in client/server and relational database design using Oracle, and MS-SQL Server.
Always interested in projects of any kind Development,Administration,Troubleshooting Etc..

Past experience with small and large scale companies such as: Amdocs, Idf , Comverse , Intel , Pontis etc..

Excellent skills in database performance tuning
Excellent skills in sql statement tuning
Very versatile and agile, great troubleshooting skills

Certifications:
--------------------
Oracle Certified Associate (OCA)
Oracle Certified Professional (OCP)
Microsoft Certified Professional (MCP)
Microsoft Certified Technology Specialist (MCTS)
Microsoft Certified Solution Associate (MSCA)
Microsoft Certified Trainer (MCT)

Specialties: Database Administration
Database Design
Database performance tuning
Sql (pl/sql tsql) performance tuning
Designing High Availability
Development (pl/sql , t-sql)
troubleshooting

More
Languages
English
Native or Bilingual Proficiency
Hebrew
Native or Bilingual Proficiency

Level Progress

Current: Level 16
Aaron needs 64,367 points to level up.
LVL 17
  • Overall
    16
  • Microsoft SQL Server
    13
  • Microsoft SQL Server 2008
    9
  • Microsoft SQL Server 2005
    8
  • Oracle Database
    6
  • Databases
    3
  • SQL
    2
  • Windows Server 2008
    2
  • SSRS
    2
  • .NET Programming
    2
  • SSAS
    2
  • Windows Server 2003
    2
  • Storage Software
    2
  • ASP.NET
    2
  • Linux
    1
  • Microsoft Development
    1
  • SSIS
    1
  • Microsoft SharePoint
    1
  • DB Reporting Tools
    1
  • SBS
    1
  • Microsoft Server Apps
    1
  • MySQL Server
    1
  • Visual Basic.NET
    1
  • Web Servers
    1
  • Visual C++.NET
    1
  • CAD/Architecture Software
    1
  • Microsoft IIS Web Server
    1
  • Unix OS
    1
  • Active Directory
    1
  • Application Servers
    1
  • Azure
    1
  • Disaster Recovery
    1
  • Enterprise Software
    1
  • Internet / Email Software
    1
  • Microsoft Virtual Server
    1
  • Outlook
    1
  • PostgreSQL
    1
  • Server Software
    1
  • Sybase Database
    1
  • System Utilities
    1
  • VB Script
    1
  • Vulnerabilities
    1
  • Windows Networking
    1
  • XML
    1